Advanced Excel Training - Learn Advanced Excel 2010

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?
  • Basic Excel Knowledge
• 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

SECTION 1: Introduction to the Course

Introduction to the Course MS Excel 2010 Advanced

SECTION 2: Key Difference MS Excel 2007 vs 2010

Working Files All - Download These First

Office Button and Paste Function

Office Button and Paste Function

Sparklines, Custom Ribbons and Screenshots

Sparklines, Custom Ribbons and Screenshots

Conditional Formatting and Equation Editor

Conditional Formatting and Equation Editor

SECTION 3: Useful Excel Functions

Paste Special

Paste Special

Logical functions - IF AND OR

Logical functions - IF AND OR

Logical functions - IF AND OR

Arithmetic functions MAX MIN ABS etc

Arithmetic functions MAX MIN ABS etc

Arithmetic functions MAX MIN ABS etc

COUNT COUNTIF COUNTA COUNTBLANK

COUNT COUNTIF COUNTA COUNTBLANK

COUNT COUNTIF COUNTA COUNTBLANK

Cell Information - ISERROR ISBLANK etc

Cell Information - ISERROR ISBLANK etc

SECTION 4: Data Functions

CHOOSE Function

CHOOSE Function

CHOOSE Function

VLOOKUP Function

VLOOKUP Function

VLOOKUP Function

HLOOKUP Function

HLOOKUP Function

HLOOKUP Function

MATCH & INDEX

MATCH & INDEX

MATCH & INDEX

Database functions - DSUM DAVERAGE DCOUNT

Database functions - DSUM DAVERAGE DCOUNT

Database functions - DSUM DAVERAGE DCOUNT

OFFSET Function - Part 1

OFFSET Function - Part 2

FORECAST Function

FORECAST Function

SECTION 5: WhatIf Analysis

One Dimensional Data Tables

One Dimensional Data Tables

One Dimensional Data Tables

Two dimensional Data Tables

Two dimensional Data Tables

Solver

Solver

Goal Seek

Goal Seek

Goal Seek

SECTION 6: Arrays

Array Function - Introduction

Array Function - Row and Columns

Array Function - Row and Columns

Array Function - TRANSPOSE

Array Function - TRANSPOSE

Array Function - FREQUENCY

Array Function - FREQUENCY

SECTION 7: Functions for working with Text

PROPER UPPER LOWER LEFT RIGHT MID

PROPER UPPER LOWER LEFT RIGHT MID

FIND CLEAN REPT CONCATENATE

FIND CLEAN REPT CONCATENATE

SECTION 8: Pivot Tables

Pivot Tables

Pivot Tables

Pivot Table Filter - Slicer

Pivot Table Filter - Slicer

Pivot Charts

Pivot Charts

Naming a Cell and a Range

Naming a Cell and a Range

Naming Dynamic Ranges

Naming Dynamic Ranges

SECTION 9: Auditing and Trouble Shooting formulas

Auditing Toolbar

Auditing Toolbar

Watch Window

Watch Window

SECTION 10: Form Controls

Group Boxes and Options Button

Group Boxes and Options Button

Check Boxes

Check Boxes

List Boxes and Combo Boxes

List Boxes and Combo Boxes

Scroll Bar and Spinners

Scroll Bar and Spinners

SECTION 11: Important Excel Tools

Text to Columns

Text to Columns

Grouping Tabs

Grouping Tabs

SUBTOTAL Function

SUBTOTAL Function

Hyperlinks

Hyperlinks

Data Validation

Data Validation

Random Numbers

Random Numbers

Custom View

Custom View

Protecting - Worksheet and Workbook

Protecting - Worksheet and Workbook

SECTION 12: Advanced Charts

Excel 2010 Sparklines

Excel 2010 Sparklines

Range Charts

Range Charts - Type 1 Part a

Range Charts - Type 1 Part a

Range Charts - Type 1 Part b

Range Charts - Type 1 Part b

Range Charts - Area

Range Charts - Area - Type 2 Part a

Range Charts - Area - Type 2 Part a

Range Charts - Area - Type 2 Part b

Range Charts - Area - Type 2 Part b

Funding Graph

Funding Graph

Funding Graph

Two Axis Graphs

Two Axis Graphs

Two Axis Graphs

Scenario Graphs

Scenario Graphs Part 1

Scenario Graphs Part 2

Scenario Graphs Part 2

Average Line

Average Line

Bar to Pie Chart

Bar to Pie Chart

Combo Charts

Combo Charts

Creating Histograms

Creating Histograms

Invert Negatives

Invert Negatives

Scrolling Chart Part 1

Scrolling Chart Part 1

Scrolling Chart Part 2

Scrolling Chart Part 2

SECTION 13: CONCLUSION

Conclusion