MS Excel Advance Training: Solve Difficult Problems

Name: MS Excel Advance Training: Solve Difficult Problems
Rating: 4.3 (105 reviews)

Advance Excel 2007 and 2010 features: Do Advance Excel Training and use Excel like a Pro: Charts, Pivot Table & Array,

Last updated 9/2016

English

What you'll learn

If you want to learn Excel 2007 from basic and reach to very advanced level of Excel usage, then you are at the right place.
Adv. tools like Vlookup, Hlookup, text, Financial Functions, Array Function, Pivot Table and scenario & Sensitivity analysis.
Over 6 Hours of Video content with more then 100 videos
Learn Excel Short Cut keys, over 100 Excel Functions
Become more creative, efficient and accurate & Fast in Excel

20 sections • 133 lectures • 9h 35m total length

Define Short Cut key to Open Excel2:04
Learn how you can define a short cut key to Open Excel
Basic Excel Calculations3:55
Learn why using sum function is better instead of adding every cell one by one.
Define Name Ranges to Perform Calculations1:28
Relative Referencing2:23
Use of Relative lining vs Absolute referencing.
Mixed Referencing3:05
When you link in cell with single $ , it is called Mixed Linking. Write a universal formula.
Write 3D Formula and Learn to Use Condolidate3:38
How to refer to the same cell address in multiple sheets with 3D formulas in Excel.

Short Cut to AutoSum, Copy, Paste2:49
Quick short cut key Alt + = , Ctrl C & Ctrl V to copy and paste fast.
Repete Privious Task2:09
Repeat previous task with Ctrl Y and F4
Short Cut to Fill Down , Fill Right1:10
Fill down with Ctrl + D and Fill right with Ctrl + R
Insert and Delete Row & Columns1:56
Learn how to insert and Delete multiple rows and columns.
Hide and Unhide the Ribbon with Short Cut Key1:29
Hide and collapse Ribbon with Quick Short Cut Keys
Use Ribben with Quick Short cut, Remove Gridlines2:55
Learn to access Ribbon without Mouse. and remove gridlines with Key tips.
Customize the Short Cuts from Ribbon with Quick Access Toolbar4:47
Customize and access the tools on Ribbon more quickly.
Customize Ribbon: New 2010 Feature3:50
We can add , remove, change any tab in ribbon with this new feature in 2010

IF for Single Criteria2:28
If Function is used when the output is based on any criteria or condition.
IF for Multiple Criterias Using and Function3:55
IF for Multiple Criterias Using And & Sum Functions4:17
Lets see how to join multiple functions (IF, And, Sum) within one Formula.
IF for Multiple Criterias Using And, Or & Sum Functions3:52
Lets see how to join multiple functions (IF, And, Or, Sum) within one Formula.
Nested if For Multiple Grades and Outcomes5:08
Learn how to use IF within IF function to provide different grades.

Paste Value, Format, Formulas, Comment only with Paste Special3:53
Paste special: The most used tool in Excel to exploit copied data. Learn how to paste values, format, comment or formulas only.
Update Value Without Formulas2:04
How to double or half the values in single step using Paste Special.
Transpose The From Col To Row2:04
Transpose the data from Row to Column and from column to Row quickly.
Paste Link1:49
Here is a great tool of paste special that is Paste Link.

Use CF to Colour cell based on content4:09
Conditional Formatting based on the data in the cell. Color the cell if it is greater or less than 50.
Identify Bottom And Top No's Using Conditional Formatting2:41
Format top and bottom nos with Conditional Formatting.
Display data with Bar, Color Scales and Icon sets2:12
Magical display of values.
Use of Formulas To Format The Cell4:58
Instead of using the defined rules of Conditional Formatting, you can make your own rule to format the cell.

Max, Min, Median, Average, Sum2:59
Simple excel functions: Max, Min, Median, Average, Sum. You can skip them if already aware of them.
Count, Counta, Countblank1:43
Learn how to count cells with numerical values, blank cells and cells with text.
Rank Function2:18
Learn how to assign rank based on descending or ascending nos.
Large & Small Functions2:37
Find a certain largest or smallest no in range.
Inroducing Sumif, Sumifs, Averagif, Averageifs functions2:40
SumIF and AverageIF4:56
How to sum or average the nos based on a certain criteria or condition.
SumIF continued3:06
AverageIF continued4:18
CountIF Function to count Cells with Conditions4:15
Count no of cells that meet a specified criteria or condition
SumIFs and AverageIFs for Multiple Conditions3:20
How to use Sumifs and Averageifs for multiple conditions.
CountIFs Function to count Cells with Multiple Conditions2:12
Count cells that meet multiple conditions.

Students dont need any prior knowledge for doing this course. They just need desire to advance thier Excel skills

Updated on 18 August, 2015
"Advanced Excel 2007 for Professionals" is a comprehensive online training program. It is covered in 6 hours of videos and covers exhaustive list of topics. There are so many features available in excel that can save a lot of time & can make your work presentable.

We are specialists in offering expert level training courses and other great features of Excel. As part of our Advanced Excel training you will gain the necessary knowledge required for the efficient use of the tools and other exciting features which this outstanding software has to offer.

Categories of all Functions Covered:

Tools and Commands:

Much more to explore in the videos.

Formulas & Function course is for everyone. If you are basic user or expert still you will find many important tools to advance your knowledge and skills for more efficiency and productivity. We are taking some basic concepts of Excel and taking it to Advanced Excel training with Practical Examples. By the end of this training, you will have mastered the advanced features and functions of this supreme software.