Excel - Excel Course (Basic and Advanced)

This excel training covers both basic excel and advanced excel tutorial
27 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 110 lectures and 84 quizzes
  • 10+ hours of high quality content
  • A community of 13900+ students learning together!
  • 60+ discussions
SHARE

Excel - Excel Course (Basic and Advanced)

This excel training covers both basic excel and advanced excel tutorial
27 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 amazing Excel course provides you with in depth knowledge of excel and makes you Zero to hero.

This is a comprehensive course on Microsoft Excel 2010. This Excel training program on Microsoft Excel 2010 starts with the basics and on through the advanced features. With over 100 excel video lectures, approximately 11 hours of Videos, 150+ worksheets, quizzes, Subtitles etc. edu CBA helps both the beginner and advanced user visualize what they are learning with step-by-step instruction from a Microsoft Excel Professional. Watch as the instructor performs progressive operations in each video starting with the Basics of Worksheets. Then moving onto Formatting, Formulas, Illustrations and Charts, Printing, HLOOKUP, VLOOKUP, Array, Solver, database, forecast, goal seek and many more advanced functions. We have incorporated years of classroom training experience and teaching techniques to develop an easy-to-use course that you can customize to meet your personal learning needs. Take this course to learn all about Microsoft Excel 2010 and be awesome in Excel 2010.

Microsoft Excel is used in almost all fields like finance, statistics, marketing, engineering, human resources especially for the businesses which deal with large amounts of data (numbers, statistics). What we learn in academics is very theoretical aspects of business, but in practical life we want application based learning. Our Excel course is designed in such manner that it will give you practical approach and any person from any background can go ahead with it. Through this course and the practice material you will gain proficiency in Excel. Thus having detailed knowledge of Excel will be beneficial to you, whether you are a student, fresher or an employee.

Note: Microsoft Excel 2010: A Comprehensive Program Advanced (this course) consists of both Microsoft Excel 2010 Beginner and Microsoft Excel 2010 Advanced. If you have taken this course, No need to take Beginner and Advanced Courses separately.

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.

This Excel course provides in depth knowledge about following:

  • Key Difference MS Excel 2007 vs 2010 - This video discuss about Office Button, Paste Function, Sparkline Custom Ribbons, Screenshots and more.
  • Useful Excel Functions - This Module includes Paste Special, Logical functions IF AND OR, Arithmetic functions like MAX MIN ABS, COUNT functions and many more.
  • Data Excel Functions - This module includes CHOOSE Function, VLOOKUP Function, OFFSET Function and many more functions.
  • WhatIf Analysis - This Module includes oneand two Dimensional Data Tables, solver, goal seek function.
  • Arrays - Learn how to use array and transpose function.
  • Excel Functions for working with Text - This module includes simple functions like use of PROPER UPPER LOWER LEFT RIGHT MID etc.
  • Pivot Tables - Learn about pivot table in more details; also learn about Pivot Table Filter Slicer, Pivot Charts.
  • Names and Dynamic Range - Learn how to name a particular range.
  • Excel Charts & Graphs
    • This Excel Course has NO prerequisite. As this Excel course starts from scratch, we will make you awesome in Excel from the very start
    • Over 110 lectures and 10 hours of content!
    • Learn Excel basics from Scratch using an Excel Case Study Approach
    • Learn Advanced Excel once you have mastered Basic Excel
    • Get solid understanding of the more powerful features and functions in Excel
    • Learn to Use Excel in a Professional Environment
    • Become Awesome in Excel
    • Users with no knowledge of Excel can also take this course
    • 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
  • 1
    Introduction
    05:50
    This video lecture gives you the details of the skill sets we would be covering during this whole course.
  • SECTION 2:
    EXCEL 2010: GETTING STARTED
  • 2
    All Working Files Basic Excel - Download These First
    Text
    All the downloadable files, excel templates for Basic Excel can be found in this lecture. Please download all of them and start doing in excel sheet along with the trainer.
  • 3
    All Working Files Advanced Excel - Download These First
    Text

    All the downloadable files, excel templates for Advanced Excel can be found in this lecture. Please download all of them and start doing in excel sheet along with the trainer.

  • 4
    Getting Started - Ribbons & Quick Access Toolbar
    10:12

    The video explains 1.Surfing an excel worksheet 2.How to use HELP in MS Excel
  • 5
    Getting Started - Ribbons & Quick Access Toolbar
    2 questions
  • 6
    Getting Started - Surfing Excel & HELP Function
    11:08

    The video explains :-1.Starting excel software. 2. Familiarity with excel interface. 3.Ribbons 4.Quick Access toolbar. 5.Surfing an excel worksheet 6.Help
  • 7
    Getting Started - Surfing Excel & HELP Function
    1 question
  • SECTION 3:
    CASE STUDY
  • 8
    XYZ Company Basic Excel Case Study
    1 page

    XYZ Company Basic Excel Case Study

  • 9
    Excel Case Study
    02:00
    This video builds on a case which will help you to learn data entry in excel in an easy manner
  • 10
    Excel Case Study
    1 question
  • 11
    Data Entry in Excel
    08:56

    This video explains : 1. How to write data in excel. 2. What are the different shortcuts in excel which will help to enter data easily. 3. The different number formating available in excel

  • 12
    Data Entry in Excel
    3 questions
  • 13
    Populating the Case Study in Excel
    07:42

    The video shows different ways of poulating the large data in excel from a word document

  • 14
    Populating the Case Study in Excel
    1 question
  • SECTION 4:
    CALCULATIONS
  • 15
    Calculations - Addition Subtract Multiply Division
    07:29

    The video explains how to carry out calculations in excel.

  • 16
    Calculations - Addition Subtract Multiply Division
    2 questions
  • SECTION 5:
    FORMULAS
  • 17
    Formulas - SUM MAX MIN AVERAGE
    09:58

    The video shows how can one calculate sum function, maximum function, minmum function and average function using different excel function

  • 18
    Formulas - SUM MAX MIN AVERAGE
    3 questions
  • SECTION 6:
    FORMATTING
  • 19
    Formatting - Number Formats
    08:30

    This video explains :-1. How to use different formatting? 2. How can one copy paste the format of one cell to other?

  • 20
    Formatting - Number Formats
    3 questions
  • 21
    Formatting - Table Formats
    07:37

    This video explains us: 1) How to format tables? 2) Formatting text using excel tools
  • 22
    Formatting - Table Formats
    2 questions
  • SECTION 7:
    UPDATING A CALCULATION
  • 23
    Updating a Calculation
    02:41

    This video shows 1 .how can one add one more detail in the existing data 2. the effects of it on the calculation

  • 24
    Updating a Calculation
    2 questions
  • SECTION 8:
    PERCENTAGES & ABSOLUTE REFERENCES
  • 25
    Percentages and Absolute References
    09:19

    The video explains:1. Normal referencing and absolute referencing 2.Its use in excel

  • 26
    Percentages and Absolute References
    1 question
  • SECTION 9:
    CONDITIONAL FORMATTING
  • 27
    Conditional Formatting
    08:28

    The video explains in detail of the following:-1. About Conditional formatting. 2. Different ways to do conditional formatting on a given set of data 3.how can one give different colors to highlight the data required.
  • 28
    Conditional Formatting
    2 questions
  • SECTION 10:
    IF FUNCTION
  • 29
    IF Function
    09:58

    The video explains in detail of the following :-1. How can one use if function? 2. What data actually needs to be inserted in IF function to get the right calculation? 3. How IF function has made the calculation easy?
  • 30
    IF Function
    1 question
  • SECTION 11:
    COUNTIF AND SUMIF
  • 31
    COUNTIF Function
    04:18

    This video explains of the following 1. COUNTIF Function 2. When to use COUNTIF Function ?
  • 32
    COUNTIF Function
    2 questions
  • 33
    SUMIF Function
    08:22
    This video explains the following 1. SUMIF Function 2. When to use SUMIF Function ?
  • 34
    SUMIF Function
    2 questions
  • SECTION 12:
    CHARTS AND GRAPHS
  • 35
    Creating Charts and Graphs
    08:32

    The video explains :-1. How to Create Charts and Graphs in Excel? 2. How to do Formatting of those Charts and Graph?

  • 36
    Creating Charts and Graphs
    2 questions
  • 37
    Create Pie Charts
    11:24

    The Video Explains :- 1. How to Create Pie Charts? 2. How to do Formatting to Pie Charts? 3. What are the different type of Charts?

  • 38
    Create Pie Charts
    2 questions
  • SECTION 13:
    SORTS AND FILTERS
  • 39
    Sorts
    04:54

    This video explains of the following 1. What is sort option? 2. How to insert the sort option? 3. In large data how can one make work easy by using sort option?

  • 40
    Sorts
    1 question
  • 41
    Filter
    04:50

    This video explains of the following 1. What is filter option? 2. How to insert the filter option? 3. In large data how can one make work easy by using filter option?
  • 42
    Filter
    1 question
  • SECTION 14:
    FREEZE AND SPLIT
  • 43
    Freeze and Split
    06:21

    The video explains of the following:-1. How can one freeze the rows and columns? 2.How can one split the rows and columns?

  • SECTION 15:
    PRESENTATION
  • 44
    Presentation - Table Formats
    05:42

    We will learn the following through this tutorial :

    1. How to use Table formats?
    2. Different ways to Present the data
    2) Wrap text format.
  • 45
    Presentation - Table Formats
    2 questions
  • 46
    Presentation - Indents and Formatting Charts
    05:40

    The video explains the following :- 1. Concept of Increase Indent function. 2. Different ways of formatting Charts and Graphs.
  • 47
    Presentation - Indents and Formatting Charts
    3 questions
  • SECTION 16:
    PRINT
  • 48
    Printing the Worksheet
    07:29

    This video explains the following:-1. Print option.2. Features of Print option

  • 49
    Printing the Worksheet
    2 questions
  • 50
    Printing - Headers and Titles
    06:53

    This video explains the following:- 1.How to fit the entire data in a worksheet for print? 2. How to insert header and footer in an excel worksheet?

  • 51
    Printing - Headers and Titles
    1 question
  • SECTION 17:
    SHORTCUTS
  • 52
    Shortcuts - Formatting and Navigation
    14:48

    The video explains :- 1.How to Use Formatting Shortcut? 2.How to Navigate Excel worksheet? 3. How to use Workbook basic shortcut?

  • 53
    Shortcuts - Formatting and Navigation
    1 question
  • 54
    Shortcuts - Selection, Data and Formula
    10:46

    The video explains the following shortcuts:- 1.Selection 2.Working with Data 3.Formula shortcuts

  • 55
    Shortcuts - Selection, Data and Formula
    1 question
  • SECTION 18:
    COMMON ERRORS
  • 56
    Common Errors
    04:47

    The video explains: 1.Why does the error occur in excel? 2 . Which error occurs in respect to a specific mistake?

  • 57
    Common Errors
    2 questions
  • SECTION 19:
    KEY DIFFERENCE MS EXCEL 2007 VS 2010
  • 58
    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
  • 59
    Office Button and Paste Function
    1 question
  • 60
    Sparklines, Custom Ribbons and Screenshots
    06:43

    The video explains about what are the new options available in excel sheet of 2007 and not available in excel sheet 2010:- 1. Sparkline 2.Custom Ribbon 3. Screenshot
  • 61
    Sparklines, Custom Ribbons and Screenshots
    3 questions
  • 62
    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
  • 63
    Conditional Formatting and Equation Editor
    1 question
  • SECTION 20:
    USEFUL EXCEL FUNCTIONS
  • 64
    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?
  • 65
    Paste Special
    1 question
  • 66
    Logical functions IF AND OR
    2 pages

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

  • 67
    Logical functions IF AND OR
    05:21

    The video explains the following Logical functions :- 1. If function 2. AND function 3.OR function
  • 68
    Logical Functions Quiz - without solutions
    Text

    Logical Functions Quiz - without solutions

  • 69
    Logical Functions Quiz - with solutions
    Text

    Logical Functions Quiz - with solutions

  • 70
    Logical functions IF AND OR
    1 question
  • 71
    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

  • 72
    Arithmetic functions MAX MIN ABS etc
    08:28

    This Video Explain about following Arithmatic Functions like : 1. ABS 2. INT 3. LARGE 4. MAX 5. MIN 6. SMALL 7. TRUNC
  • 73
    Arithmetic functions MAX MIN ABS etc
    2 questions
  • 74
    COUNT COUNTIF COUNTA COUNTBLANK
    3 pages

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

  • 75
    COUNT COUNTIF COUNTA COUNTBLANK
    05:57

    This video explains the following functions:
    1. COUNT
    2. COUNTIF
    3. COUNTA
    4. COUNTBLANK
  • 76
    COUNT COUNTIF COUNTA COUNTBLANK
    2 questions
  • 77
    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
  • 78
    Cell Information ISERROR ISBLANK etc
    1 question
  • SECTION 21:
    DATA FUNCTIONS
  • 79
    CHOOSE Function
    1 page

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

  • 80
    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!
  • 81
    CHOOSE Function
    1 question
  • 82
    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

  • 83
    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?

  • 84
    VLOOKUP Function
    2 questions
  • 85
    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.

  • 86
    HLOOKUP Function
    03:24

    This Video explains the following -
    1. What is HLOOKUP Function ?
    2. What are its functionalities ?
  • 87
    HLOOKUP Function
    1 question
  • 88
    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.

  • 89
    MATCH INDEX
    04:16

    This Video Explains the following -
    1. What is MATCH Function in Excel ?
    2. What is INDEX Function in Excel ?
  • 90
    MATCH INDEX
    1 question
  • 91
    Database functions DSUM DAVERAGE DCOUNT
    3 pages

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

  • 92
    Database functions DSUM DAVERAGE DCOUNT
    07:42

    This video explain Database functions like :
    1. DAVERAGE
    2. DSUM
    3. DCOUNT
  • 93
    Database functions DSUM DAVERAGE DCOUNT
    1 question
  • 94
    OFFSET Function- Understanding basics
    06:14

    We will learn about:-

    1. What is offset function?

    2. Features of offset function?

  • 95
    OFFSET Function - Dynamic nature
    04:45

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

  • 96
    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?
  • 97
    FORECAST Function
    2 questions
  • SECTION 22:
    WHATIF ANALYSIS
  • 98
    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.

  • 99
    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
  • 100
    One Dimensional Data Tables
    3 questions
  • 101
    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?
  • 102
    Two dimensional Data Tables
    1 question
  • 103
    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?
  • 104
    Solver
    3 questions
  • 105
    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.

  • 106
    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?

  • 107
    Goal Seek
    1 question
  • SECTION 23:
    ARRAYS
  • 108
    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?
  • 109
    Array Function Introduction
    1 question
  • 110
    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.

  • 111
    Array Function Row and Columns
    1 question
  • 112
    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?
  • 113
    Array Function TRANSPOSE
    1 question
  • 114
    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?

  • 115
    Array Function FREQUENCY
    1 question
  • SECTION 24:
    FUNCTIONS FOR WORKING WITH TEXT
  • 116
    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
  • 117
    PROPER UPPER LOWER LEFT RIGHT MID
    1 question
  • 118
    FIND CLEAN REPT CONCATENATE
    09:12

    The video explains how we use text & string functions like :-
    1. Find
    2. Clean
    3. Rept
    4. Concatenate
  • 119
    FIND CLEAN REPT CONCATENATE
    1 question
  • SECTION 25:
    PIVOT TABLES IN DEPTH
  • 120
    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.


  • 121
    Pivot Tables
    4 questions
  • 122
    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.
  • 123
    Pivot Table Filter Slicer
    2 questions
  • 124
    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.
  • 125
    Pivot Charts
    2 questions
  • 126
    Naming Dynamic Ranges
    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?
  • 127
    Naming Dynamic Ranges
    1 question
  • 128
    Naming a Cell and a Range
    04:57

    The video explains the following :
    1. What is Name Range?
    2. Feature of Name range to cell
  • 129
    Naming a Cell and a Range
    1 question
  • SECTION 26:
    AUDITING AND TROUBLE SHOOTING FORMULAS
  • 130
    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.

  • 131
    Auditing Toolbar
    2 questions
  • 132
    Watch Window
    05:01

    This video explains the following :

    1. What is Watch Window?

    2. How to use Watch Window in excel?

  • 133
    Watch Window
    1 question
  • SECTION 27:
    FORM CONTROLS
  • 134
    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.
  • 135
    Group Boxes and Options Button
    1 question
  • 136
    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?
  • 137
    Check Boxes
    2 questions
  • 138
    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.

  • 139
    List Boxes and Combo Boxes
    2 questions
  • 140
    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?
  • 141
    Scroll Bar and Spinners
    1 question
  • SECTION 28:
    IMPORTANT EXCEL TOOLS
  • 142
    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?
  • 143
    Text to Columns
    1 question
  • 144
    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?
  • 145
    Grouping Tabs
    1 question
  • 146
    SUBTOTAL Function
    09:31

    This video explains the following:

    1) SUBTOTAL function

    2) Why SUBTOTAL function is useful?

  • 147
    SUBTOTAL Function
    2 questions
  • 148
    Hyperlinks
    04:30

    This video explains the following:

    1) What are Hyperlinks?

    2) How to insert Hyperlinks?

  • 149
    Hyperlinks
    1 question
  • 150
    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?
  • 151
    Data Validation
    1 question
  • 152
    Random Numbers
    05:47

    The video explains the following :-
    1. RAND() function.
    2. RANDBETWEEN function
  • 153
    Random Numbers
    1 question
  • 154
    Custom View
    04:40

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

  • 155
    Custom View
    1 question
  • 156
    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?
  • 157
    Protecting Worksheet and Workbook
    3 questions
  • SECTION 29:
    ADVANCED CHARTS
  • 158
    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?

  • 159
    Excel 2010 Sparklines
    1 question
  • 160
    Range Charts
    1 page

    This Document explains Advance Charting for Business analysts - Range Charts

  • 161
    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.
  • 162
    Range Charts Type 1
    1 question
  • 163
    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.
  • 164
    Range Charts Type 1- Continued
    1 question
  • 165
    Range Charts Area
    1 page

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

  • 166
    Range Charts Area Type 2
    04:40

    The video explains the following
    1) What are the different charts and graphs through which we can show large tabular data?
    2). Which is the most appropriate Range Chart to show the data?
  • 167
    Range Charts Area Type 2
    1 question
  • 168
    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?
  • 169
    Range Charts Area Type 2- Continued
    1 question
  • 170
    Funding Graph
    1 page

    Learn how to implement Funding Graph chart in Excel

  • 171
    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?
  • 172
    Funding Graph
    1 question
  • 173
    Two Axis Graphs
    1 page

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

  • 174
    Two Axis Graphs
    06:30

    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?
  • 175
    Two Axis Graphs
    1 question
  • 176
    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.

  • 177
    Scenario Graphs Continued
    1 question
  • 178
    Average Line
    1 question
  • 179
    Bar to Pie chart
    1 question
  • 180
    Combo Charts
    1 question
  • 181
    Creating Histogram
    1 question
  • 182
    Invert Negatives
    1 question
  • 183
    Scrolling Chart
    2 questions
  • 184
    Scrolling Chart Continued
    1 question

UDEMY BY THE NUMBERS

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

RATING

  • 22
  • 2
  • 1
  • 0
  • 2
AVERAGE RATING
NUMBER OF RATINGS
27

REVIEWS

  • Prashant Chatterjee
    Superb course on Excel..

    The course is very detailed and explains many different features using very good examples. It Includes basic excel function at the beginning of the course and then gradually moving towards the advance excel functions. After finishing the course i knew that I have gained allot regarding different excel functions. Thank you...five stars from my side:)

  • Ayham Hamada
    Best Excel course ever

    It explains everything about Excel in an easy to digest way. Very impressive.

  • Carlton James Muldrow
    Excel Couse (Basic and Advannced)

    As a basic/-Intermediate excel user for many years, this course provided an excellent refresher that also broadened my exposure to several helpful excel advance techniques, in a relatively short period of time enabling me to take my use of excel to a new level.

  • Kal
    Cannot get answers to queries

    UDEMY Support page does not load. I have the same questions re how to import pdf to excel (which is not covered in the course although case study is sent in pdf format) This is the start of the course and it sucks!

  • J Rae
    Brilliantly structured and awesome explanation

    I am quite impressed with this course. Brilliantly structured and awesome way to explain concepts. Just a few hours/days to this course and a novice can be good in excel. It’s a fine course in Excel

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