Advanced Excel Online Course

(Become a professional in Excel with our self paced online course)

Advanced Excel Online Course

Advanced Excel Online Training

Course Details
Name: Advanced Excel Online Course
Total Videos: 180
Buy Now
Language: English
Skill Level: All Level Advanced Excel Online
Price: Rs.4000

  • Free life time access to the videos
  • 7 days money back guarantee
Rating: 4 stars, based on 120 reviews
Short Description of Course
A comprehensive online course on Advanced Excel. It is covered in 13.5 hours of videos. This course includes detailed knowledge of excel functions and formulas, VBA, charts and Dashboard. This course is very useful for students, entrepreneurs and professionals who use excel.

Want to become real HERO in MS Excel?

Our "Advanced Excel Online Course" is useful for beginners as well as advanced users of Excel. This course is designed to make you real HERO in Excel. This course is basically a comb of 3 different modules.
  • Advanced Excel Online Training (Module 1)
    In this module you will learn excel from scratch. In this part we have covered more than 100 basic and advanced functions and shortcuts of excel with practical examples.
  • Excel VBA Training Videos (Module 2)
    In this module you will learn Excel VBA from scratch. We have covered 50 top used commands.
  • Excel Dashboards Training Videos (Module 3)
    In this module you will learn how to create charts and dashboards in excel.

List of Excel Videos included in this Course

Basic Excel Calculation
1. Define Short Cut Key to Open Excel 2Mins 4Secs
2. Basic Excel Calculations 3Mins 30Secs
3. Define Ranges to perform Calcuations 1Mins 30Secs
4. Absolute and Relative Reference in Excel 2Mins 23Secs
5. Mixed Referencing 3Mins 6Secs
6. Write a 3D Function and How to condolidate 3Mins 40Secs

Useful Quick Excel Shortcuts
1. Shortcut to AutoSum, Copy, Paste 2Mins 50Secs
2. How to repete previous task 2Mins 10Secs
3. Shortcut to Fill Down and Fill Right 1Mins 10Secs
4. How to Insert and Delete Rows & Columns 2Mins 10Secs
5. Show and Hide the ribbon with shortcut keys 1Mins 30Secs
6. Use of ribbon without mouse 2Mins 55Secs
7. How to Customize the shortcuts 4Mins 45Secs
8. How to Customize Ribbon 3Mins 50Secs

Paste Special
1. Paste Value, Format, Formulas, Comment only with Paste Special 3Mins 53Secs
2. Update Value Without Formulas 2Mins 04Secs
3. How to Transpose Data From Column to Row 2Mins 05Secs
4. Link Data with Paste Special 1Mins 50Secs

If Conditional Function
1. Use of IF Function for Single Criteria 2Mins 28Secs
2. Use of IF Function for Multiple Criteria 3Mins 56Secs
3. Use of IF & AND Function For Multiple Criteria 4Mins 18Secs
4. Use of IF & AND Function with OR Function 3Mins 52Secs
5. Nest IF Function for Multiple Grades 5Mins 10Secs

Conditional Formatting
1. Use Conditional Formatting to Colour Cell based on content 4Mins 09Secs
2. Identify Bottom And Top No.s using Conditional Formatting 2Mins 41Secs
3. Display Data with Data Bar 2Mins 13Secs
4. Use a Formulas to Format the Cell 5Mins 00Secs

Rounding Functions
1. Int, Trunc, Odd, Even Functions 5Mins 22Secs
2. Round, RoundUp, RoundDown Functions 2Mins 34Secs
3. Mround, Ceiling, Floor Functions 3Mins 03Secs

Mathematical Functions
1. Max, Min, Median, Average, Sum functions 2Mins 59Secs
2. Count, Counta, Countblank 1Mins 44Secs
3. Rank the list with Rank Function 2Mins 18Secs
4. Large and Small Functions 2Mins 37Secs
5. Introduction to IF related functions 2Mins 40Secs
6. Use of SUMIF Function - Part 1 4Mins 56Secs
7. Use of SUMIF Function - Part 2 3Mins 06Secs
8. Use of Average IF Function 4Mins 19Secs
9. Use of SumIFs and AverageIFs Functions 3Mins 20Secs
10. Use of Count IF Function 4Mins 16Secs
11. Use of CountIFs Function 2Mins 12Secs

Database Functions
1. Introduction of Data Base Functions 2Mins 17Secs
2. Using DSUM Function for AND Criteria 5Mins 40Secs
3. Using DSUM Function for OR Criteria 3Mins 35Secs
4. Using DGET Function to Find Single Record 2Mins 05Secs

Text Functions
1. Use of Right, Left, Mid Functions to Extract Text 5Mins 33Secs
2. Use of Find, Search, Len Function 4Mins 36Secs
3. Use of Trim, Proper, Upper, Lower Function 3Mins 55Secs
4. Use of & and CONCATENATE function 4Mins 16Secs
5. Use of Rept and Len Function to Display Initial Zero 3Mins 57Secs
6. Use of Replace & Substitute Functions 5Mins 32Secs
7. Advanced use of Text Functions with Example 6Mins 50Secs
8. Advance use of Right, Mid, Left Functions 9Mins 08Secs
9. How to Extract Worksheet Name with Text Functions 5Mins 55Secs
10. How to Extract Workbook Name With Text Functions 3Mins 03Secs

Validation and Protections
1. How to prevent from entering incorrect values 3Mins 55Secs
2. How to Validate Huge range of Values 2Mins 35Secs
3. How to Protect the Whole Worksheet with Password 3Mins 00Secs
4. How to keep few cells unprotected while entire worksheet is protected 4Mins 25Secs
5. Document Encryption & Mark as Final 2Mins 40Secs

Is and Lookup Functions
1. Introduction to IsNumber, IsError, IsBlank Functions 5Mins 30Secs
2. Use of IF, Match and IsError & IsNumber functions 5Mins 30Secs
3. Simple Use of Choose Function 3Mins 22Secs
4. Use of Choose Function to make Scenario Analysis 4Mins 15Secs
5. Use of Vlookup to extract Record from Table like Data 4Mins 40Secs
6. Power use of Vlookup, IF, and IsError functions 5Mins 31Secs
7. Use Hlookup function with Match function 3Mins 04Secs
8. Combined Ue of Vlookup and Hlookup with Iferror 6Mins 50Secs
9. How Index Function is much better than Vlookup & Hlookup 5Mins 00Secs
10. Indirect Function- Prepare an Output Sheet 4Mins 40Secs

Financial Functions
1. Use of FV & PV Functions to analyse Investment Returns 4Mins 17Secs
2. Use of FvSchedule function in case of Variable Interest Rates 1Mins 50Secs
3. Effective & Nominal Rates with Effect & Nominal Functions 3Mins 20Secs
4. Use of IPMT, PPMT, PMT functions to Prepare Debt Repayment Schedule 5Mins 17Secs
5. Use of CumIPMT and CumPrince Functions 3Mins 02Secs

Date and Time Functions
1. Introduction of Date & Time Functions and Format Convention 5Mins 35Secs
2. How to change default Date and Time Format 2Mins 22Secs
3. Custom Formatting of Dates 2Mins 58Secs
4. Today & Now Functions to Enter current Date and Time 2Mins 58Secs
5. Weekday Function to Indentify the Day of Week 3Mins 28Secs
6. Weekday and Networkday Functions 2Mins 37Secs
7. How to find Age with DatedIF Function 3Mins 51Secs
8. Edate & Eomonth Functions 3Mins 20Secs
9. How to Extract Year, Month, Day from Given Dates 1Mins 53Secs
10. How to use AutoFill to Write Date Series 3Mins 28Secs

Whatif Analysis and subtotal
1. Use of Goal Seek to get a Particular Result 2Mins 37Secs
2. How to summarize data using Sub Total tool 4Mins 04Secs
3. How to use data table for Senstivity Analysis 4Mins 13Secs
4. Scenario Manager for Different Outcome 4Mins 08Secs

1. Introduction to Chart Elements and Chart Types 5Mins 57Secs
2. How to create first chart and display specific data 2Mins 28Secs
3. Learn to Create Instant Chart , Use Switch & Move Buttons 4Mins 48Secs
4. Learn to Change The Default Chart, Give Title, Save As Template 6Mins 50Secs
5. Understanding the use of Legends, Chart Title, Axis, Data Labels, Gridlines etc. 6Mins 53Secs
6. How to add an Average to the Chart 2Mins 46Secs
7. How to create Double Axis Chart to display values with huge difference 1Mins 21Secs
8. How to create a Pie Chart 3Mins 18Secs
9. Formatting of Pie Chart & Key Features 4Mins 45Secs
10. Pie To Bar and Seperate Peices of Pie Chart 6Mins 42Secs

Pivot Table
1. Introduction to Pivot Table 6Mins 52Secs
2. How to find out values as % of Grand Total and Column/Row Total in Pivot Table 6Mins 46Secs
3. How to Display Revenue By Quarter in Pivot Table 4Mins 00Secs
4. Use of Calculated Field for calculating Commision on revenue 2Mins 45Secs
5. Use of External Data Connections to import data from different file 2Mins 04Secs
6. Condolidate Sheets Thorugh Pivot Wizard 3Mins 45Secs
7. Filter the Pivot Table by Row and Column Label 2Mins 45Secs
8. Adding and Removing Subtotal And Grand Totals 3Mins 25Secs
9. Conditional Formating in the Pivot Table 3Mins 10Secs
10. Create your First Pivot Chart 3Mins 00Secs
11. Change Chart type, Formatting, Filter Column 4Mins 00Secs

Array Function
1. Introduction to Array Functions 6Mins 06Secs
2. Multiple Condition Test with Array Function 2Mins 30Secs
3. How to Count Uniques Enteries in List 4Mins 50Secs
4. How to Transpose Data with Link 3Mins 03Secs
5. How to Combine Multiple Functions With Array 4Mins 25Secs

List of VBA Videos included in this Course

Recording and Basics of Macro VBA
1. How to Record Basic Excel Work and Assign Shortcut 6Mins 24Secs
2. How to Enter Data In Same Worksheet - First Macro 7Mins 22Secs
3. How to Enter Data In Different Worksheet - Second Macro 3Mins 40Secs
4. How to Insert Title or Comment to Macro 2Mins 20Secs
5. How to save a Macro File 1Mins 31Secs
6. Dealing with Macro Security 1Mins 29Secs
7. Use of Input Box and Formula Command 8Mins 10Secs
8. Use of Inputbox, Msgbox, Formula in different way 7Mins 09Secs
9. Inserting Command Button And Assigning Short Cut Key 5Mins 28Secs
10. How to Create Personal Macro 3Mins 8Secs
11. How to delete a Personal macro and Personal Macro Workbook 3Mins 15Secs

Usefull VBA Commands
1. How to write value to a cell using VBA 3Mins 15Secs
2. How to affect all cells in a worksheet using VBA 1Mins 50Secs
3. How to cut and paste data from one sheet to another sheet using macro VBA 5Mins 50Secs
4. Break Points And Call Command in VBA 5Mins 48Secs
5. Select, Add, Rename and Delete Worksheet using VBA 7Mins 16Secs
6. How to add data in another sheet using macro VBA 7Mins 52Secs
7. How to handle the error in macro - Part 1 10Mins 24Secs
8. How to handle the error in macro - Part 2 5Mins 52Secs
9. Use of WITH Command with example 2Mins 56Secs

Use of Excel Formulas and Functions in VBA
1. How to use Offset Function to put variables in excel dynamically 7Mins 27Secs
2. Assign Result based on marks using IF, Offset and For Next Command 6Mins 46Secs
3. Assign Grades based on marks using IF, Offset and For Next Command 5Mins 35Secs
4. Select Case 8Mins 57Secs
5. Use of Do While and Do Until 7Mins 12Secs
6. Use of Vbyesno on Msgbxo to provide flexibility in running macro 5Mins 32Secs
7. Use of Formula Command with For Next command 5Mins 41Secs
8. Use of Do While and For Next command 13Mins 23Secs
9. Recording macros with Relative References 2Mins 47Secs
10. Transpose the Data with Do While Loop - Part 1 9Mins 10Secs
11. Transpose the Data with Do While Loop - Part 2 4Mins 27Secs
12. How to create User Defined Function 8Mins 55Secs

Work Sheet and Wook Book Events
1. Introduction to Events - Activate & Deactivate Events 3Mins 40Secs
2. Autofit Column Width with Change Event 4Mins 10Secs
3. Workbook Opening and Closing Events 2Mins 25Secs

User Form in Excel
1. Understanding first basic Userform 1Mins 13Secs
2. Basic example on how to create Userform - Part 1 5Mins 40Secs
3. Basic example on how to create Userform - Part 2 3Mins 20Secs
4. Use of Userform without defining Variables 1Mins 43Secs
5. Use of Combobox to provide defined list 3Mins 45Secs

Case Studies on VBA
1. How to transfer data to another work book automatically with VBA 11Mins 05Secs
2. How to transfer data to another work book based on criterias with VBA 12Mins 09Secs

List of Dashboard Videos included in this Course

Introduction to Basic Charts in Excel
1. Introduction to Chart Elements & Chart Types 5Mins 57Secs
2. Create your first basic chart and display specific details 2Mins 28Secs
3. How to create Instant Chart, Use of Switch & Move Buttons 4Mins 48Secs
4. How to change the default chart, give title, save as template 6Mins 54Secs
5. Understand the use of Legends, Chart Title, Axis, Data Labels, Gridlines etc. 6Mins 46Secs
6. How to add average to the Charts 2Mins 46Secs
7. How to create Double Axis Chart to display values with huge difference 1Mins 21Secs
8. Create Simple Pie Chart 3Mins 18Secs
9. Formatting of Pie Chart & Key Features 4Mins 45Secs
10. Advanced knowledge of Pie Chart 6Mins 42Secs

Basic Excel Dashboard
1. How to create Scrolling Table with scroll bar and Vlookup 8Mins 28Secs
2. How to prepare a Scrolloling Chart 13Mins 06Secs

Chart Based Comparing Dashboards
1. Sample Comparative Dashboard 5Mins 51Secs
2. Comparative Dynamic Chart with two Combo Box 8Mins 16Secs
3. Dynamic Dashboard with Multiple Check Boxes 12Mins 08Secs

Use of Conditional Formatting in Dashboard
1. Roll Over Dashboard 12Mins 34Secs
2. How to highlight Row and Column 7Mins 41Secs
3. How to display values with Colour 9Mins 41Secs
4. Static Dashboard To Analyse Huge Raw Data 12Mins 08Secs
5. How to prepare Performance Indicator with Chart 9Mins 19Secs

Free Financial Modelling Videos

Links of videos will be sent to your email

Live Weekend Courses

16 Sessions
4 hrs/session
Rs. 20,000
4.6 Stars

12 Sessions
4 hrs/session
Rs. 12,000
4 Stars

24 Sessions
4 hrs/session
Rs. 20,000
4 Stars
Online Courses - Our Packages

250 Videos
19 hrs
Rs. 6000
4.4 Stars
(3 in 1)
180 Videos
13.5 hrs
Rs. 4000
4 Stars
Individual Online Courses

117 Videos
6.5 hrs
Rs. 2200
4.4 Stars

44 Videos
4 hrs
Rs. 2500
4.5 Stars

20 Videos
2.5 hrs
Rs. 2000
4.2 Stars

18 Videos
1hr 45mins
Rs. 2000
4.1 Stars

24 Videos
1hr 40mins
Rs. 2000
4.4 Stars

16 Videos
1hr 20mins
Rs. 2000
4.2 Stars

12 Videos
Rs. 2000
3.9 Stars
Corporate Training
At Investment Banking Institute, we understand that different Individuals have their own set of requirements and we work closely with our corporate clients to understand and define requirements of the participants and create a customized program that addresses stated goals..
Rating from our Students
Well designed courses, great content, superb trainer, excellent support
Aggregate Rating: 4.5 out of 5 with 200 ratings

Know Your Course and Trainer

Contact Us
IBI- Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:08814846868, 09896999313, 011-45092926


Page Tags

Advanced Excel Course

Advanced Excel Course in Delhi

Advanced Excel Course Fees

Advanced Excel Course Syllabus

Advanced Excel Online Training

Advanced Excel Course Content

Advanced Excel Course Details

Institute for advanced excel in delhi

Best Institute for Advanced Excel in Delhi

Certification in excel

Certification course in excel

Rating from our Students

Aggregate Rating:
4.5 out of 5 with 200 ratings
Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:9312222566, 011-45092926

Copyrights © 2011-2018 All Rights Reserved. Designed by Deepak Suhag