This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas
This advanced online course on Microsoft Excel 2010 is not for beginners. This awesome course is ideal for those seeking to enhance their Excel 2010 knowledge, it even goes deeper into the features and functions of the powerful excel spreadsheet. The course is perfect for those already having a good knowledge of Microsoft Excel 2010 basics. In this online course, you will learn advanced features. You will learn about performing lookups with HLOOKUP and VLOOKUP. By the conclusion of this advanced computer software tutorial for Microsoft Excel 2010, you will have mastered the advanced features and functions of this software. Working files are included to allow you to follow along with the author. The course starts with an explanation to show the differences between excel 2007 and excel 2010. It begins with useful functions like Paste Special, Logical, countif goes on to explain advanced features like HLOOKUP, VLOOKUP, Match, Offset, Forecast etc. What-if-analysis in one dimension, two dimension table, solver, Goal seek have been done beautifully taking examples. Pivot Tables in details, range, excel tools, advanced charts have been dealt beautifully in details. The objective of this online program is to make you awesome in Advanced Excel 2010.
This course is best viewed on HD 720p. The same option is given in Udemy Video Screen Bottom Right.
Note: Microsoft Excel 2010 Advanced (this course) is also a part of Excel - Excel Course (Basic and Advanced). If you are looking for both Beginner and Advanced Excel 2010, Please go for Comprehensive program.
Instructor: Mr. Dheeraj V. (CFA, FRM, IIML, IITD)
Dheeraj, A financial wizard, His relentless pursuit of knowledge and financial acumen has made him one of the most sought after individual in the training circles. He was associated with J.P Morgan Chase Equity Research Group as an analyst and later moved to CLSA India (Asia’s #1 Broking Firm) in the field of Equity Research and Investment Banking domain.
Website: - edu CBA
Course Page – excel training 2010 advanced
Be a part of the learning community onFacebook orTwitter
You may also find awesome resources at our Excel blog
What are the requirements?
What am I going to get from this course?
- Over 79 lectures and 6.5 hours of content!
- The objective of this online program is to make you awesome in Advanced Excel 2010.
What is the target audience?
- Students and Professionals
Introduction to the Course
Introduction to the Course MS Excel 2010 Advanced
Key Difference MS Excel 2007 vs 2010
Working Files All - Download These FirstOffice Button and Paste FunctionOffice Button and Paste FunctionSparklines, Custom Ribbons and ScreenshotsSparklines, Custom Ribbons and ScreenshotsConditional Formatting and Equation EditorConditional Formatting and Equation Editor
Useful Excel Functions
Paste SpecialPaste SpecialLogical functions - IF AND ORLogical functions - IF AND ORLogical functions - IF AND ORArithmetic functions MAX MIN ABS etcArithmetic functions MAX MIN ABS etcArithmetic functions MAX MIN ABS etcCOUNT COUNTIF COUNTA COUNTBLANKCOUNT COUNTIF COUNTA COUNTBLANKCOUNT COUNTIF COUNTA COUNTBLANKCell Information - ISERROR ISBLANK etcCell Information - ISERROR ISBLANK etc
CHOOSE FunctionCHOOSE FunctionCHOOSE FunctionVLOOKUP FunctionVLOOKUP FunctionVLOOKUP FunctionHLOOKUP FunctionHLOOKUP FunctionHLOOKUP FunctionMATCH & INDEXMATCH & INDEXMATCH & INDEXDatabase functions - DSUM DAVERAGE DCOUNTDatabase functions - DSUM DAVERAGE DCOUNTDatabase functions - DSUM DAVERAGE DCOUNTOFFSET Function - Part 1OFFSET Function - Part 2FORECAST FunctionFORECAST Function
One Dimensional Data TablesOne Dimensional Data TablesOne Dimensional Data TablesTwo dimensional Data TablesTwo dimensional Data TablesSolverSolverGoal SeekGoal SeekGoal Seek
Array Function - IntroductionArray Function - Row and ColumnsArray Function - Row and ColumnsArray Function - TRANSPOSEArray Function - TRANSPOSEArray Function - FREQUENCYArray Function - FREQUENCY
Functions for working with Text
PROPER UPPER LOWER LEFT RIGHT MIDPROPER UPPER LOWER LEFT RIGHT MIDFIND CLEAN REPT CONCATENATEFIND CLEAN REPT CONCATENATE
Pivot TablesPivot TablesPivot Table Filter - SlicerPivot Table Filter - SlicerPivot ChartsPivot ChartsNaming a Cell and a RangeNaming a Cell and a RangeNaming Dynamic RangesNaming Dynamic Ranges
Auditing and Trouble Shooting formulas
Auditing ToolbarAuditing ToolbarWatch WindowWatch Window
Group Boxes and Options ButtonGroup Boxes and Options ButtonCheck BoxesCheck BoxesList Boxes and Combo BoxesList Boxes and Combo BoxesScroll Bar and SpinnersScroll Bar and Spinners
Important Excel Tools
Text to ColumnsText to ColumnsGrouping TabsGrouping TabsSUBTOTAL FunctionSUBTOTAL FunctionHyperlinksHyperlinksData ValidationData ValidationRandom NumbersRandom NumbersCustom ViewCustom ViewProtecting - Worksheet and WorkbookProtecting - Worksheet and Workbook
Excel 2010 SparklinesExcel 2010 SparklinesRange ChartsRange Charts - Type 1 Part aRange Charts - Type 1 Part aRange Charts - Type 1 Part bRange Charts - Type 1 Part bRange Charts - AreaRange Charts - Area - Type 2 Part aRange Charts - Area - Type 2 Part aRange Charts - Area - Type 2 Part bRange Charts - Area - Type 2 Part bFunding GraphFunding GraphFunding GraphTwo Axis GraphsTwo Axis GraphsTwo Axis GraphsScenario GraphsScenario Graphs Part 1Scenario Graphs Part 2Scenario Graphs Part 2Average LineAverage LineBar to Pie ChartBar to Pie ChartCombo ChartsCombo ChartsCreating HistogramsCreating HistogramsInvert NegativesInvert NegativesScrolling Chart Part 1Scrolling Chart Part 1Scrolling Chart Part 2Scrolling Chart Part 2