Microsoft Excel eLearning

Excel Basic, Intermediate, Advanced and Advanced Pro (eLearning)

Basic & Intermediate Option & Formulas

Includes 42 modules with practice material for each modules.

More Info

This session includes Microsoft Excel Basic and Intermediate Options and Functions. It covers Microsoft Excel Overview, Menus, Keyboard Shortcuts, Managing Workbooks, Worksheets, Cells, Formatting Cells, Printing, Copy, Paste, PasteSpecial, Shapes, SmartArt, Basic and Intermediate level (50+) formulas etc.

Advanced & Advanced Pro Options

Includes 33 modules with practice material for each modules.

More Info

This session includes Microsoft Excel Advanced and Advanced Pro Options. It covers how to create Dashboard, MI Reports, Filter, Advanced Filter, Data Validation, Complete PivotTable, PowerPivot, Power Query, Record Macro, Charts, Subtotal, Text to Column, Name Manager, Import data from Access & Web, Goal seek etc.

Advanced and Advanced Pro Formulas

Includes 28 modules with practice material for each modules.

More Info

This session includes Microsoft Excel Advanced and Advanced Pro Formulas. It covers how to work with 10 different types of VLOOKUP, Various use of XLOOKUP, FILTER, IF, Nested IF, INDEX MATCH, Integrate multiple formulas, Multi criteria lookup, how to use Advanced Function with Advanced Options etc.

\

Enroll to get lifetime access to the course

Enroll

Excel eLearning – Become an Excel Expert and increase your career potential

Microsoft Excel has proven to be one of the most important applications for businesses around the world. Excel is the most widely used application in business today, but very few people maximize its potential.

Explore most of the underutilized powerful features in Excel which helps to boost your productivity, improve your speed, save time, eliminate manual and non-value added activities in your day to day process.

In our Excel eLearning we teach Excel Basic, Intermediate and Advanced and Advanced+ Level. The syllabus covers all the required Formulas and Options used by working professionals who has 15+ years of experience, worked in various projects, companies and faced different challenges in their day to day process.

Our session will not just stop with teaching you the Excel Formulas and options, we go beyond to make you an expert in using the various options in real time scenario.

Our Excel Advanced Pro formulas have lot of surprise elements which you have never seen it before also it will make you to feel the power of Excel.

Why we should learn Microsoft Excel?

N

Excel will make you better at your job

N

Create Dashboard for better decision making

N

Makes calculations of complex formulas easy

N

Eliminate manual work through Automating reports

N

Save 1000+ hours through Automating reports

N

Improve your Company productivity

N

It will increase your Salary

N

Sell yourself in the competitive Industries

N

Analyze data and make forecasting predictions

N

Gain practical experience with large spreadsheets

Syllabus – Microsoft Excel eLearning Training (Basic, Intermediate, Advanced and Advanced Pro Level)

Excel Basic and Intermediate Options
  1. Microsoft Excel Overview
  2. Direct Keyboard Shortcut
  3. Indirect and Quick Access Shortcut
  4. Menu Overview
  5. Enter and Edit Data
  6. Cut Copy Paste & Paste Special
  7. Go To
  8. Format Cells
  9. Formula Auditing
  10. Hide, Unhide, Move, Copy, Color Sheet
  11. Hyperlink
  12. Comments and Note
  13. Insert Shapes, Art, Smart Art, 3D Art, Screenshot
  14. Printing Techniques
  15. Window Features
  16. Calculation
  17. Absolute Cell References
Excel Basic and Intermediate Formulas
  1. SUM
  2. AVERAGE
  3. COUNT
  4. COUNTA
  5. COUNTBLANK
  6. EXACT
  7. CONCATE
  8. RIGHT, LEFT & MID Function
  9. LEN & TRIM Function
  10. LOWER, UPPER, PROPER
  11. MAX, MIN, LARGE, SMALL
  12. DATE, DAY, MONTH, YEAR, NOW, TODAY
  13. ROUND AND ROUNDDOWN
  14. SUBTOTAL
  15. FIND AND SEARCH
  16. REPLACE AND SUBSTITUTE
  17. DATEDIF
  18. TEXT and VALUE
  19. COLUMN, COLUMNS, ROW, ROWS, ADDRESS
  20. ISBLANK, ISTEXT, ISNONTEXT, ISERROR, IFERROR
  21. INDIRECT
  22. HYPERLINK
  23. WEEKNUM & NETWORKDAYS
  24. UNIQUE
  25. TEXTJOIN
Excel Advanced and Advanced Pro Formulas

 

  1. VLOOKUP Exact Match
  2. VLOOKUP approximate Match
  3. VLOOKUP with LEFT Search
  4. VLOOKUP with Column
  5. VLOOKUP with Define Name
  6. VLOOKUP with VALUE and TEXT
  7. VLOOKUP Beginning Search
  8. VLOOKUP with End Search
  9. VLOOKUP with Whole Cell Search
  10. VLOOKUP IF Condition
  11. VLOOKUP with MATCH Function
  12. HLOOKUP
  13. XLOOKUP
  14. XLOOKUP Multiple Lookup Value
  15. INDEX with Match
  16. SUMIF
  17. SUMIFS
  18. COUNTIF and COUNTIFS
  19. AVERAGEIF and AVERAGEIFS
  20. IF Condition
  21. Nested IF using OR and AND Function
  22. IF Condition with Multiple Condition
  23. IFERROR
  24. OFFSET Function
  25. CHOOSE
  26. FILTER Function
  27. SORT and SORTBY
  28. Dropdown based on Selection
Excel Advanced and Advanced Pro Options
  1. Define Name
  2. Subtotal
  3. Sort
  4. Data Validation
  5. Filter Options
  6. Advanced Filter
  7. Edit Links
  8. Text to Column
  9. Data Protection
  10. Consolidation Options
  11. Grouping and Ungrouping
  12. Import Data from Access and Web
  13. Conditional Formatting
  14. Goal Seek
  15. Scenarios Manager
  16. Chart
  17. Record Macro
  18. Data Validation with INDIRECT Function
  19. Data Validation Dropdown Search
  20. Data Validation with FILTER, OFFSET, INDEX, SUMIFS
  21. How to prepare MI report?
Excel PivotTable

 

  1. PivotTable Basic
  2. PivotTable Options, Grouping, Expand and Collapse
  3. PivotTable Slicer
  4. PivotTable Refresh, Change Source, Action and Calculation
  5. PivotTable Chart and Dashboard
  6. PivotTable Options
  7. PivotTable Other options
  8. PivotTable Dashboard Using Slicer New
Excel Power Query and PowerPivot
  1. Power Query – Consolidation Data from multiple sheets
  2. Power Query – Consolidation Multiple Workbook – Table
  3. Power Query Consolidation Multiple Workbook – Data
  4. Power Pivot
Excel Bonus Session
  • Introducing the above mentioned Options
  • Data Validation Search Dropdown
  • PivotTable will cover entire options and features
  • Multi criteria lookup
  • How to create Dashboard
  • How to Create MI (Management Information) report
  • Using Power Query how to consolidate data from multiple Worksheet and Workbook
  • How to work with huge volume of data using Power Pivot
  • Data Cleansing using Power Pivot and Power Query
  • How to use DAX function in Power Pivot

The Most Important Benefits Of eLearning

 Today’s learners want relevant, mobile, self-paced, and personalized content. This need is fulfilled with the online mode of learning; here, students can learn at their own comfort and requirement. Depending on their availability and comfort, many people choose to learn at weekends or evenings. Major advantages of eLearning:

 

  • Online Learning Accommodates Everyone’s Needs
  • Lectures Can Be Taken Any Number of Times
  • Learners can define their own speed of learning instead of following the speed of the whole group.
  • Saves time as a person does not need to travel to the training venue. You can learn at the comfort of your own place.
  • Students can choose to study specific and relevant areas of the learning material without focusing on each and every area also they can skip certain areas they do not want to learn.
  • This ensures that all learners receive the same type of training with this learning mode.
  • eLearning is cost effective as compared to traditional forms of learning.
  • It’s available in multiple language

Sign Up Today - 100% Satisfaction Guaranteed

Lifetime Free

Affordable Price

Free Training Materials

Certification Post Assessment

 

Enroll