Module 1:
  • Introduction to Excel, Cell, Column, Rows and Sheets.
  • Introduction to Ribbon and Quick Access.
  • Cut, Copy, Paste, Hide and Unhide of columns and Sheets
  • Basic Introduction to Ribbon components.
  • Shortcuts
Module 2:
  • Formatting, Sorting, filters
  • Introduction to Paste Special
  • Printer Properties and Page Setup
  • Introduction to Freeze Panes.
  • Shortcuts
  • Project

Module 3:
  • Basic Functions- Sum, Count, If, OR, AND, AVG, SUBTOTAL, RIGHT, LEFT, MID etc.
  • Advance Functions- SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTA, COUNTBLANK etc.
  • Advance lookup Functions- Vlookup, Hlookup etc and their limitations.
  • Pivot Table
  • Calculation in Pivot Table
  • Shortcuts
  • Project

Request Callback

Module 4:
  • Text to Column
  • Removing Duplicates
  • Data Validation and Consolidation.
  • Advanced Functions and nested Formulas- Name Ranges
  • Advanced Lookup Functions- Index Match, Indirect, offset etc.
  • Project
Module 5:
  • Discussion on Arrays
  • Array Formulas
  • Data Grouping, Ungrouping and Subtotal
  • Conditional Formatting and Working with charts and Sparklines
  • Project
Module 6:
  • What if Analysis
  • Goal Seek
  • Pivot Table and Chart: Slicer
  • Dynamic Range – Using Offset
  • Project

Module 7:
  • Form Control and Activex Contols
  • Dynamic Charts
  • Dashboard
  • Charts- Gant Chart, Waterflow Chart etc.
  • Project
Module 8:
  • Dashboard continues
  • Project

Request Callback

Module 9:
  • Introduction to VBA and Macros
  • VBA Macro Programming : Programming Writing Concepts
  • VBA Macro Programming : Working With Loops and Worksheet Ranges
  • VBA Macro Programming : Writing of Formula in VBA and Error Handling
  • Introduction of programming concepts for writing the Excel Formulas in to the Program
  • Project
Module 10:
  • Difference between the A1 and R1C1 style of writing formula in VBA.
  • User Define Function (UDF): Detailed discussion on User Defined Function
  • VBA User Forms
  • With VBA Events
  • Project

Request Callback

Course Details

Data Visualization with Excel
Basic Excel
Advance Excel
Macros and VBA

Request Callback

Important Dates

12
Aug

Online Instructor Led + Classroom (at Gurgaon) program

3:00pm to 6:00pm

12
Aug

Online Instructor Led + Classroom (at Gurgaon) program

3:00pm to 6:00pm

12
Aug

Online Instructor Led + Classroom (at Gurgaon) program

3:00pm to 6:00pm

12
Aug

Online Instructor Led + Classroom (at Gurgaon) program

3:00pm to 6:00pm

Copyright © 2013 - 2018 Dataperts Technologies Technologies, All Rights Reserved