Build a strong understanding of Microsoft Excel basics
Know the MS Excel most popular functions
Using Microsoft Excel full power by automating your daily tasks via Macros
Keep large Excel data sets in a list or table
Build interactive reports by mastering Pivot Tables, one of the most common tools
Learn complex formulas such as IF, VLOOKUP, INDEX, MATCH functions and many more You will be groomed by Instructor who holds 14+ years of experience in corporate.

PREREQUISITE FROM CANDIDATE FULL DETAIL OF COURSE
Candidate should have Basic Knowledge of Excel to enroll for this course

1. EXCEL ADVANCE COURSE CONTENT
   
   • Working with an Excel List
   • Data Validation
   • Importing and Exporting Data
   • PivotTables
   • PowerPivot Tools
   • Operating with large Excel data sets
   • Excels Conditional Functions
   • Excels Lookup Functions (VLOOKUP, HLOOKUP, INDEX & MATCH)
   • Excels Text Based Functions
   • Auditing an Excel File
   • Protecting Excel Specific area, Worksheets and Workbooks
   • Macros Introduction (Basic)
   • Automating your daily repetitive Tasks in Excel with Macros
   • How to use Macro Recorder Tool
   • Excel VBA Concepts (Overview)
   • Preparing and Cleaning Up Data with a Little VBA (Assignment)
   • Importing Data from Text Files (CSV files)
2. Important Topic: CHARTS
   
   • Column Chart Type
   • Bar Chart Type
   • Line Chart Type
   • Pie Chart Type
   • Area Chart Type
   • XY (scatter) Chart Type
   • Stock Chart
   • Surface Chart Type
   • Doughnut Chart Type
   • Bubble Chart Type
   • Radar Chart Type
3. Course Wrap Up (Assignment & Projects)
   

   The course is designed by keeping the requirement from corporates. The contents updated on the websites are high level, but during the course time you will learn more on it.

   Additionally, we will also give you overview of Microsoft PowerPoint and Microsoft Power BI (Business Intelligence)

   Note: After every lecture, the student has to go under a Objective type question test on the topics covered during the lecture. Such tests boost the morale of the student and make them experts after the course is completed.

   We also assist in Placement services*.