Excel - Advanced Excel Course

This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas
33 reviews
TAUGHT BY
  • edu CBA Global Online Training Experts

    eduCBA is globally recognized training firm, providing blend of instructor-led and online financial training programs in Excel, Advanced Excel, VBAs, Macros, Equity Research, Wealth Management, Technical Analysis Investment banking, Private Equity, Fundamental Analysis, Investment Research, Credit Research etc and preparatory courses like CFA Level I & II and FRM Level I & II, Campus Placement Trainings etc.

    eduCBA Online training Learning Management System provides access to high end excel videos, valuation tutorials, online tests, downloadable templates and models that are prepared by Research Analysts & Investment Bankers.

    </p>

WHAT'S INSIDE
  • Lifetime access to 79 lectures and 57 quizzes
  • 6+ hours of high quality content
  • A community of 10100+ students learning together!
SHARE

Excel - Advanced Excel Course

This Advanced Excel Training (MS Excel 2010) covers concepts like Pivot Tables, Dynamic Graphs, Advanced Excel Formulas
33 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

Learn and practice real-world skills and achieve your goals.

COURSE DESCRIPTION

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

    • Basic Excel Knowledge
    • Over 79 lectures and 6.5 hours of content!
    • The objective of this online program is to make you awesome in Advanced Excel 2010.
    • Students and Professionals

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction to the Course
  • 1
    Introduction to the Course MS Excel 2010 Advanced
    02:54
    This introduction lecture to the course gives you the details to be covered in the course.
  • SECTION 2:
    Key Difference MS Excel 2007 vs 2010
  • 2
    Working Files All - Download These First
    Text
    All the working Files are in this Lecture. Please download these first. Please note that In most of the lectures, you have working files with solution and without solution. Download these files and do as the trainer does in the without solution files for a better understanding.
  • 3
    Office Button and Paste Function
    08:18

    The video explains about what are the differences in excel sheet of 2010 and 2007:- 1. Office and file button 2. Paste function

  • 4
    Office Button and Paste Function
    1 question
  • 5
    Sparklines, Custom Ribbons and Screenshots
    06:43

    The video explains about what are the new options available in excel sheet of 2007 and excel sheet 2010:- 1. Sparkline 2.Custom Ribbon 3. Screenshot

  • 6
    Sparklines, Custom Ribbons and Screenshots
    3 questions
  • 7
    Conditional Formatting and Equation Editor
    05:54

    The video explains about the differences in excel sheet of 2007 and 2010:-

    1. Conditional formatting 2. Equation editor

  • 8
    Conditional Formatting and Equation Editor
    1 question
  • SECTION 3:
    Useful Excel Functions
  • 9
    Paste Special
    02:08
    This Video Explain about following :
    1. What is Paste Special Function?
    2. Feature of Paste Special Function
    3. How to Use Paste Special Function?
  • 10
    Paste Special
    1 question
  • 11
    Logical functions - IF AND OR
    2 pages

    This category contains Logical functions like: AND , FALSE , IF , NOT , OR , TRUE .

  • 12
    Logical functions - IF AND OR
    05:21

    The video explains the following:- 1. If function 2. AND function 3.OR function

  • 13
    Logical functions - IF AND OR
    2 questions
  • 14
    Arithmetic functions MAX MIN ABS etc
    4 pages

    In this document various arithmetic function have been explained such as ABS, INT, Large, Small, Max, Min, Etc

  • 15
    Arithmetic functions MAX MIN ABS etc
    08:28

    This Video Explain about following Arithmetic Functions like : 1. ABS 2. INT 3. LARGE 4. MAX 5. MIN 6. SMALL 7. TRUNC

  • 16
    Arithmetic functions MAX MIN ABS etc
    2 questions
  • 17
    COUNT COUNTIF COUNTA COUNTBLANK
    3 pages

    This Function Counts the number of numeric entries in a list. It will ignore blanks, text and errors.

  • 18
    COUNT COUNTIF COUNTA COUNTBLANK
    05:57

    This video explain the following functions:

    1. COUNT

    2. COUNTIF

    3. COUNTA

    4. COUNTBLANK

  • 19
    COUNT COUNTIF COUNTA COUNTBLANK
    2 questions
  • 20
    Cell Information - ISERROR ISBLANK etc
    08:42
    The video explains about various cell information functions like :-
    1. ISBLANK
    2. ISERROR
    3. ISNONTEXT
    4. ISNUMBER
    5. ISTEXT
    6. ISNA
    7. ISREF
  • 21
    Cell Information - ISERROR ISBLANK etc
    1 question
  • SECTION 4:
    Data Functions
  • 22
    CHOOSE Function
    1 page

    Choose function picks from a list of options based upon an Index value given to by the user.

  • 23
    CHOOSE Function
    03:21
    Through this video we are going to learn the following -
    1. What is a CHOOSE Function?
    2. How can one put condition and make proper use of Choose Function!
  • 24
    CHOOSE Function
    1 question
  • 25
    VLOOKUP Function
    1 page

    VLOOKUP Function: Looks in the first column of an array and moves across the row to return the value of a cell

  • 26
    VLOOKUP Function
    08:31

    The video explains the following -

    1. What is VLOOKUP Function?

    2. How VLOOKUP is used to find the data from a large database?

  • 27
    VLOOKUP Function
    2 questions
  • 28
    HLOOKUP Function
    1 page

    Hlookup function scans across the column headings at the top of a table to find a specified item. When the item is found, it then scans down the column to pick a cell entry.

  • 29
    HLOOKUP Function
    03:24
    This Video explains the following -
    1. What is HLOOKUP Function ?
    2. What are its functionalities ?
  • 30
    HLOOKUP Function
    1 question
  • 31
    MATCH & INDEX
    2 pages

    This function looks up for the values in a reference or array. It can be used with text and numbers. It can look for an exact match or an approximate match.

  • 32
    MATCH & INDEX
    04:16
    This Video Explains the following -
    1. What is MATCH Function in Excel ?
    2. What is INDEX Function in Excel ?
  • 33
    MATCH & INDEX
    1 question
  • 34
    Database functions - DSUM DAVERAGE DCOUNT
    3 pages

    This Win Zip file contains all With and Without Solution files for practice. Please download them.

  • 35
    Database functions - DSUM DAVERAGE DCOUNT
    07:42
    This video explain Database functions like :
    1. DAVERAGE
    2. DSUM
    3. DCOUNT
  • 36
    Database functions - DSUM DAVERAGE DCOUNT
    1 question
  • 37
    OFFSET Function- Understanding basics
    06:14

    We will learn about:-

    1. What is offset function?

    2. Features of offset function?

  • 38
    OFFSET Function - Dynamic nature
    04:45

    We will learn about:- How can we use offset function and sum function together?

  • 39
    FORECAST Function
    04:41
    The video explains the following :-
    1. How to do the forecasting using a mathematical formula through excel?
    2. How to do the forecasting using the FORECAST function?
  • 40
    FORECAST Function
    2 questions
  • SECTION 5:
    WhatIf Analysis
  • 41
    One Dimensional Data Tables
    2 pages

    To create a one-variable data table to perform what-if analysis in Excel 2010, you enter a series of input values either across columns of a single row or down the rows of a single column. The formulas in a one-variable data table refer to only one input cell: a row input cell for input values entered across a row or a column input cell for input values entered down a column.

  • 42
    One Dimensional Data Tables
    05:42
    This Video Explain about What IF Analysis i.e. Data Tables. We are going to look at:
    1. One Dimensional Data Tables
    2. Usage of Dimensional Data Tables
  • 43
    One Dimensional Data Tables
    3 questions
  • 44
    Two dimensional Data Tables
    03:39

    The video explains of the following :-

    1. What is two dimensional data table?

    2. How do we prepare two dimensional sensitivity analysis table?

  • 45
    Two dimensional Data Tables
    1 question
  • 46
    Solver
    06:17
    The video explains of the following :-
    1. What is a Solver?
    2. How can we use solver option to make calculations easy?
  • 47
    Solver
    3 questions
  • 48
    Goal Seek
    2 pages
    Excel's Goal Seek feature allows you to alter the data used in a formula in order to find out what the results will be. The different results can then be compared to find out which one best suits your requirements.
  • 49
    Goal Seek
    06:03

    The Video explains the following:

    1. What is Goal Seek Function?

    2. Use of Goal Seek Function?

    3. How to find the value of one cell by adjusting another cell using Goal Seek?

  • 50
    Goal Seek
    1 question
  • SECTION 6:
    Arrays
  • 51
    Array Function - Introduction
    05:56
    The Video Explains of the Following -
    1. What is an Array Function?
    2. How to use and apply Array Function in Excel?
    3. What are the benefit of using Array Function In Excel?
  • 52
    Array Function - Row and Columns
    03:40

    The Video Explains the following -

    1. How array function which will help us to save time?

    2. Difference between selecting Row Arrays, Column Arrays and Table Arrays.

  • 53
    Array Function - Row and Columns
    1 question
  • 54
    Array Function - TRANSPOSE
    10:15
    The video explains the following -
    1. What is TRANSPOSE Function?
    2. How to use and apply TRANSPOSE function in Excel?
    3. What are shortcut keys to use Transpose Function In Excel?
  • 55
    Array Function - TRANSPOSE
    1 question
  • 56
    Array Function - FREQUENCY
    07:47

    The Video explains the following -

    1. What is FREQUENCY function?

    2. How to use and apply frequency function in excel?

  • 57
    Array Function - FREQUENCY
    2 questions
  • SECTION 7:
    Functions for working with Text
  • 58
    PROPER UPPER LOWER LEFT RIGHT MID
    05:23
    The video explains how can we use different text & string functions like :-
    1. Proper
    2. Upper
    3. Lower
    4. Left
    5. Right
    6. Mid
  • 59
    PROPER UPPER LOWER LEFT RIGHT MID
    1 question
  • 60
    FIND CLEAN REPT CONCATENATE
    09:12
    The video explains how we use text & string functions like :-
    1. Find
    2. Clean
    3. Rept
    4. Concatenate
  • 61
    FIND CLEAN REPT CONCATENATE
    1 question
  • SECTION 8:
    Pivot Tables
  • 62
    Pivot Tables
    11:53

    The video explains the following in detail :-
    1. What is pivot table?

    2. Features of the pivot table is explained in detail.

    3. Uses of those features to make data presentation more effectively.

  • 63
    Pivot Tables
    4 questions
  • 64
    Pivot Table Filter - Slicer
    03:06
    The video explains the following :
    1. How to create a pivot chart based on an existing pivot table in a worksheet?
    2. How to navigate different option of pivot chart in excel.
    3. Different formatting Styles of Pivot Chart in Excel.
  • 65
    Pivot Table Filter - Slicer
    2 questions
  • 66
    Pivot Charts
    05:53
    The video explains the following:
    1. How to create a Pivot chart based on an existing pivot table in a worksheet?
    2. How to navigate different options of Pivot chart in excel?
    3. Different Formatting style of Pivot chart in excel.
  • 67
    Pivot Charts
    2 questions
  • 68
    Naming Dynamic Ranges
    04:57
    The video explains the following :
    1. What is Name Range?
    2. Feature of Name range to cell
  • 69
    Naming a Cell and a Range
    1 question
  • 70
    Naming a Cell and a Range
    05:25
    The video explain followings :
    1. How to give names to dynamic ranges?
    2. Purpose of dynamic ranges
    3. How to use offset function in excel?
  • 71
    Naming Dynamic Ranges
    1 question
  • SECTION 9:
    Auditing and Trouble Shooting formulas
  • 72
    Auditing Toolbar
    07:58

    The video explains how can do an audit your worksheet formulas using -

    1. Trace Precedents.

    2. Trace Dependents.

    3. Remove Arrows.

  • 73
    Auditing Toolbar
    2 questions
  • 74
    Watch Window
    05:01

    This video explains the following :

    1. What is Watch Window?

    2. How to use Watch Window in excel?

  • 75
    Watch Window
    1 question
  • SECTION 10:
    Form Controls
  • 76
    Group Boxes and Options Button
    05:08
    The video explains the following :-
    1. What is Group Boxes and Options Button?
    2. How can one insert a Group Box and Options Button in an excel sheet?
    3. Use of Group Box and Options Button.
  • 77
    Group Boxes and Options Button
    1 question
  • 78
    Check Boxes
    03:06
    The video explains the following :-
    1. What is check box?
    2. How to insert a check box in an excel sheet?
    3. How to put conditions and make proper use of check box?
  • 79
    Check Boxes
    2 questions
  • 80
    List Boxes and Combo Boxes
    04:10

    This video explains the following :-

    1. What is list and combo box?

    2. How can one insert a list and combo box in an excel sheet?

    3. Use of list and combo box.

  • 81
    List Boxes and Combo Boxes
    2 questions
  • 82
    Scroll Bar and Spinners
    02:56
    This video explains the following :-
    1. What is Scroll Bar and Spinner?
    2. How can one insert a Scroll Bar and Spinner in an excel sheet?
    3. How can one put condition and make proper use of Scroll Bar and Spinners?
  • 83
    Scroll Bar and Spinners
    2 questions
  • SECTION 11:
    Important Excel Tools
  • 84
    Text to Columns
    08:18
    The Video explains the following:
    1. What is text to Column Function?
    2. How to use Text to Column Function?
  • 85
    Text to Columns
    2 questions
  • 86
    Grouping Tabs
    06:56
    The video explains the following:-
    1. What is grouping tab?
    2. How can we group tabs?
    3. What are the effects of grouping tabs?
    4. How can we ungroup the tab?
  • 87
    Grouping Tabs
    1 question
  • 88
    SUBTOTAL Function
    09:31

    This video explains the following:

    1) SUBTOTAL function

    2) Why SUBTOTAL function is useful?

  • 89
    SUBTOTAL Function
    1 question
  • 90
    Hyperlinks
    04:30

    This video explains the following:

    1) What are Hyperlinks?

    2) How to insert Hyperlinks?

  • 91
    Hyperlinks
    2 questions
  • 92
    Data Validation
    07:27
    This video explains about :-
    1. What is data validation?
    2. What are the different features of data validation?
    3. How can you use data validation function in large data?
  • 93
    Data Validation
    1 question
  • 94
    Random Numbers
    05:47

    The video explains the following :-
    1. RAND() function.
    2. RANDBETWEEN function

  • 95
    Random Numbers
    1 question
  • 96
    Custom View
    04:40

    The video explains about :-1.How can one make changes and add different views

  • 97
    Custom View
    1 question
  • 98
    Protecting - Worksheet and Workbook
    08:13
    The video explains the following:-
    1. What is the use of protecting a worksheet?
    2. What are the different things that we can protect?
    3. What are the effects of protecting a worksheet?
    4. How can we unprotect the sheet?
  • 99
    Protecting - Worksheet and Workbook
    3 questions
  • SECTION 12:
    Advanced Charts
  • 100
    Excel 2010 Sparklines
    08:16

    The Video explains following:

    1. What is Excel Sparkline?

    2. How it is use of Sparkline function in Excel 2010?

    3.What is the advantage of Sparkline function in Excel?

  • 101
    Excel 2010 Sparklines
    1 question
  • 102
    Range Charts
    1 page

    This Document explains Advance Charting for Business analysts - Range Charts

  • 103
    Range Charts Type 1
    04:42
    This Video Explains the following :
    1. Data table
    2. Which is the most appropriate graph to show the data?
    3. Overview of Range Chart.
  • 104
    Range Charts Type 1
    1 question
  • 105
    Range Charts Type 1- Continued
    04:32
    This video explains the following :
    1. How to Create Range Chart?
    2. Interpretation of Range Chart
    3. Formatting of Range Chart.
  • 106
    Range Charts Type 1- Continued
    1 question
  • 107
    Range Charts - Area
    1 page

    This Document explains Advance Charting for Business analysts - Area Range Charts

  • 108
    Range Charts Area Type 2
    04:42
    The video explains the following :-
    1. How can we prepare the range chart?
    2. How can we analyse the graph?
  • 109
    Range Charts Area Type 2
    2 questions
  • 110
    Range Charts Area Type 2- Continued
    06:30

    The video explains the following :-1. How can we prepare the range chart 2. How can we analyse the graph?

  • 111
    Range Charts Area Type 2- Continued
    1 question
  • 112
    Funding Graph
    1 page

    Learn how to implement Funding Graph chart in Excel

  • 113
    Funding Graph
    04:18
    The video explains about :-
    1. What is funding graph?
    2. How do we prepare funding graphs?
    3. How can we analyse the funding graph?
  • 114
    Funding Graph
    1 question
  • 115
    Two Axis Graphs
    1 page

    This Document explains Advance Charting for Business analysts - Two Axis Graph

  • 116
    Two Axis Graphs
    06:33
    The video explains about :-
    1. What is two axis graph?
    2. How do we prepare two axis graphs?
    3. How can we analyse the two axis graph?
  • 117
    Two Axis Graphs
    1 question
  • 118
    Scenario Graphs
    1 page
    To set up a chart that is automatically updated as you add new information to an existing chart range in Microsoft Excel, create defined names that dynamically change as you add or remove data.
  • 119
    Scenario Graphs
    03:40
    The video explains the following:-
    1. What is scenario graph ?
    2. What are the uses of scenario graph?
  • 120
    Scenario Graphs Continued
    06:28
    The video explains the following:-
    1. How do we prepare scenario graph?
    2. How do we analyse this kind of graph?
  • 121
    Scenario Graphs Continued
    1 question
  • 122
    Average Line
    03:54
    This Video explains:-
    1. How to add average line to column chart or bar chart?
    2. How to draw average line in excel 2010?
  • 123
    Average Line
    1 question
  • 124
    Bar to Pie Chart
    05:20
    This video explains:-
    1. Steps to create bar to pie chart
    2. Requirements of these charts while presenting cases and its use.
  • 125
    Bar to Pie Chart
    1 question
  • 126
    Combo Charts
    03:02
    This explains all about combo charts, how to create combo charts, use of various types of charts in combo charts.e.g.Area charts.
  • 127
    Combo Charts
    1 question
  • 128
    Creating Histograms
    07:55
    The video explains the following:-
    1. What are Histograms?
    2. How to install Data Analysis Tool pack?
    3. How to create Histograms?
  • 129
    Creating Histograms
    2 questions
  • 130
    Invert Negatives
    06:37
    The video explains about -
    1. How to create invert negative chart?
    2.How can one make the changes in color of invert negative chart?
  • 131
    Invert Negatives
    1 question
  • 132
    Scrolling Chart
    05:45
    The video explains the following:-
    1.What are Scrollbars?
    2. Why they are required?
    3.How Scrolling charts can be made?
  • 133
    Scrolling Chart
    2 questions
  • 134
    Scrolling Chart Continued
    07:30
    The video explains the following:-
    1. Making X-axis and Y-axis using the OFFSET function.
    2.Use of Name Function.
    3. Inserting the line chart using the Name range
  • 135
    Scrolling Chart Continued
    1 question
  • SECTION 13:
    CONCLUSION
  • 136
    Conclusion
    03:00
    The conclusion video summarizes the learning we had from this course.

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,700,000
Students

RATING

  • 22
  • 8
  • 1
  • 1
  • 1
AVERAGE RATING
NUMBER OF RATINGS
33

REVIEWS

  • Jason Bouligny
    Good Overall Course - Good for Database functions

    The course was good but could have gone into more detail surrounding Macros

  • Ralph M

    This course on advanced excel made me confident in excel. Now, I have started working efficiently in excel related office job. Thanks

  • B Kraemer

    It has been great learning experience by means of huge number of interesting videos. i like the way different functions are being explained. Overall a nice course

  • Dharmakrishnan
    great lectures

    the teaching is so good and easy to follow..thanks a lot

  • JT
    finally know how to fully use Excel after 15 yrs..

    many new-found tricks that i'll be able to implement immediately.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
STUDENTS WHO VIEWED THIS COURSE ALSO VIEWED: