Advance Excel Classes Training Institute In Charkop, Kandivali West, Mira Road Mumbai
Duration : 2 Month
Practical
Advance Excel
Level 1
Excel Introduction: Duration 5 hours
Excel Overview
- A overview of the screen , navigation and basic spreadsheet concepts
- Understanding workbooks , worksheets , rows , columns , cells
Entering Data
- Entering , Editing and Deleting Text , Numbers Dates
- Using Auto Lists
- Moving and Copying data
- Inserting , Deleting and Hiding Rows & Columns
- Inserting , Deleting , Moving and Copying Sheets
- Using navigation techniques
Creating and Editing Formulae
- Concept of Formulae
- Creating Formulae , Editing Formulae
- Copying Formulae
- Using Functions – Sum , Average , Max , Min , Count , Counta
- Applying Absolute ( Fixed ) Referencing
Formatting and Proofing
- Formatting Cells with Number formats , Font Formats Alignment , Borders , etc
- Basic conditional formatting
- Copying and Clearing Formats
- Working with Styles
- Spell Check , Finds & Replace and AutoCorrect
Advance Excel
Level 2
Excel Intermediate Training: Duration 5 hours
Range Names
- Concept and Purpose
- Naming individual or range cells
- Deleting and amending named ranges
- Using named cells / ranges in formulae
Conditional Functions & Formats and Date Calculations
- Benefits and purpose
- If statements , Nested If
- And , Or , Not
- Combining If , And , Or , Not
- Sumif , Countif
- Conditional Formatting
- Entering Dates and Times
- Different date/ time formats
- How dates are stored
- Calculating working days
- Using the DAY () , MONTH () , YEAR () function
Formula Auditing
- Formula Auditing Tools
- Revealing Formulae
- Tracing Precedents / Dependents
- Goto Special
Basic List Management
- Sorting Data
- Adding Subtotals
- Autofilter
- Freeze Panes
- Group and Outline
- Data Form
Worksheet Management & Linking
- Linking sheets in the same file
- Linking different Excel files
- Using Edit , Links
- Viewing different files at once
- Saving a workspace
- Viewing different sheets at once
- Window Split
- Data consolidation
Excel Charts / Graphs
- Using the Chart Wizard
- Editing and Formatting charts
- Saving custom chart types
Setting a default chart type
Advance Excel
Level 3
Lookup & Information Functions
- Vertical Lookup ( Vlookup )
- Horizontal Lookup ( Hlookup )
- Match and Index
- IsText , IsValuse , IsDate , IsNull , IsErr , Is Error, IsNa
Advanced List Management
- Advanced Filter
- Using List Features
- Dynamic Lists
Protecting & Sharing Files
- Sharing a file
- Tracking changes
- Accepting or rejecting changes
- Applying Data validation rules
- Inserting comment
Pivot Tables
- Using the Pivot Table Wizard
- Changing the pivot table layout
- Formatting
- Grouping items
- Inserting calculated fields
- Pivot Table Options
- Display and hide data in fields
- Lay out reports directly on worksheet
- Pivot Chart
Introduction to Macros
- Purpose of Macros
- Recording macro
- Where to save macros
- Running macros
- Custom buttons , menu items , ( keyboard shortcut )
What If Analyasis
- Scenarios
- Goal Seek
- Solver
