Course Details
Image

Advance Excel

We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit.

We also know how difficult it is to find quality instruction that is:

  • Easy to follow
  • Gets you the results you want
  • Teaches you advanced methods that you can quickly put into practice

That’s why we developed our online Excel course.

Apply For This Course Now

Total Course Duration: 1.5 Months

  • Multiple-level Sub Total Reports
  • Filtering database & Sorting data
  • Securing & Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Dynamic Linking Word/Excel/Powerpoint
  • Functions : LOOKUP, VLOOKUP, HLOOKUP
  • COUNTIF, SUMIF
  • What-if-analysis
  • Goal Seek Pivot Tables & Pivot Charts
  • Reporting
  • Character Functions
  • Scenario Manager
  • Date Functions
  • NESTED IF
  • Consolidation of Data
  • Data Validation
  • Logical function
  • Macro: Definition & Concepts
  • Record, Run & Store a macro
  • Introduction to VBA Prog
  • 30 Projects of Practical Training Electronic Spreadsheet basics
  • Formatting Fonts, Numbers
  • Relative & Absolute Reference
  • Date & Currency Formatting
  • Formula charts & Graphs
  • 2D/3D Graphs, Pie, Line Cone
  • Formatting Charts
  • Data Values

Total Course Duration: 2 Months

  • Performing complex calculations more efficiently
  • Using various Excel functions and executing in Dynamic projects
  • Organizing and analysing large volumes of data
  • Creating MIS reports
  • Designing and using templates
  • Consolidating and managing data from multiple workbooks
  • Writing conditional expressions (using IF)
  • Using logical function (AND, OR, NOT)
  • Using lookup and reference functions (VlookUP, HLOOKUP, MATCH, INDEX)
  • VlookUp with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets
  • Advanced Formatting : Using conditional formatting option for rows, columns and cells Formatting & customizing Pivot tables
  • Using advanced options of Pivot tables, Pivot charts
  • Consolidating data from multiple sheets
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As (% Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • Advanced Date & Time Functions
  • Data Validation in financial functions
  • Advanced Shortcut Keyboard Commands
  • Create Forms with Radio Buttons, Selection tools, other programming tools.
  • Creating Slicer (2013 Version)

Total Course Duration: 3 Months

  1. Module 1:
    • Basic
    • Create Functions & Procedures
    • Design & Create Reports
    • Underst&ing Security Levels
    • Security levels & its meaning
  2. Module 2:
    • Functions
    • What is Function & Subroutine
    • Writing Functions using VBA Editor
    • Calling Functions other workbook
    • Relative & Absolute Macros
  3. Module 3:
    • Recording Macros
    • Recording & running macro
    • Storing macro in different books
    • Creating buttons & assigning macros
    • Creating My Menu
  4. Module 4:
    • The Visual Basic Editior
    • Editing macros using VBA Editor
    • Underst&ing the project explorer
    • Exploring windows properties
    • Modifying code & Debugging code
  5. Module 5 :
    • Programming Fundamentals
    • Variables, Data types & Constants
    • Arrays, Object Variables
    • Conditional structures (If Then, Select Case)
    • Logical Operators / Looping constructs (For loops, Do loops, While)
    • Buit-in functions, Creating Subroutines
  6. Module 6:
    • User Forms
    • Creating forms, Form events
    • Creating custom menus & toolbars
    • Creating Add-ins
Certification in Advance Excel
Excel Expert