Advanced Excel Online Training

(Become a professional with our self paced online course)

Advanced Excel Online Training


Advanced Excel Online Training

Course Details
Name: Advanced Excel Online Training
Total Videos: 117
Buy Now
Language: English
Skill Level: All Level Advanced Excel Online
Price: Rs.2200

Includes:
  • Free life time access to the videos
  • 7 days money back guarantee
Rating: 4.4 stars, based on 89 reviews
Short Description of Course
This course is a comprehensive online training program. It is covered in 6.5 hours of videos and covers exhaustive list of topics. This course will help to improve your work in excel as you cover the topics with real life examples.

Categories of functions covered in this course:

  1. Basic Excel Calculation & Function
  2. Excel Short Cuts
  3. Conditional Functions
  4. Text and Lookup Function
  5. Finance, Database Functions
  6. Maths & Stats
  7. Date & Time
  8. What IF analysis
  9. Array Functions
  10. Additional Features in 2010
  11. Spinner, Scroll Bar, List Box, Combo Box

Tools and Commands covered in this course:

  1. Conditional Formatting
  2. Paste Special
  3. Go To Special, Sorting, Adv Filter
  4. Error Tracking, Evaluate Formula
  5. Name Manager, Import from web
  6. Text to Column, Data Validation
  7. Consolidate, Goal Seek, SubTotal
  8. What IF Analysis, Scenario Analysis
  9. Workbook & WorkSheet Protection
  10. Pivot tables, Analysis Tool Pack


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

Charts
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


Free Financial Modelling Videos
Name:
Mobile:
E-mail:
Course:

Links of videos will be sent to your email

Live Weekend Courses

16 Sessions
4 hrs/session
Rs. 22,500
4.6 Stars

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

24 Sessions
4 hrs/session
Rs. 25,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
1hr
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
IBinstitute
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:09312222566, 09896999313, 011-45092926

Follow




Page Tags

Advanced Excel Training

Advanced Excel Training in Delhi

Advanced Excel Training Institutes in Delhi

Advanced Excel Training Institute

Advanced Excel Online Training

Excel Training Courses

Advanced excel online tutorial

Microsoft excel online tutorial

Excel institute in delhi

Certification in excel

Certification course in excel

Rating from our Students

IBinstitute
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