Duration: 20 Hours (5 Days)

Zero Hour:

• Review of Basics & Intermediate of Microsoft

Advanced Content

Harness the full power of Microsoft Excel by automating your day-to-day tasks through Macros

• Introducing
• Macros
• Invoking
• Relative
• Recalling a
• Macros across
• Managing recorded
• Advanced Security
• Keystrokes
• Working with code

Implementing Advanced Filters

• Create a Criteria
• Implement Criteria
• Display All
• Use Comparison
• Using an Advanced Boolean condition ( AND/OR) .
• Search & Copy with Filtered

Create dynamic reports by mastering one of the most popular tools, PivotTables

• Creating
• Report
• Report Filters Field
• Refresh
• Summary
• Adding & Moving
• Use Expand and Collapse
• Hide/Unhide Report
• Deleting Report
• Report Filter
• Formatting
• PivotChart
• Implementing calculated Fields

Range Names

• Understanding Named
• Assign
• Use Range Names in
• Create & Apply Range Names from
• Modify/Delete
• Dynamic
• Handle #SPILL error

Mastering Indirect References

• What are Indirect
• Compare direct and Indirect
• Reusable
• Dependent drop-down
• Dynamic
• Volatility

Mastering Advanced Formats

• Understanding Custom Number
• Implementing Custom Number Format .
• How to create dynamic & customized
• Understanding color-based
• Understanding TEXT function

Lookup functions

• VLOOKUP and its
• Compare LOOKUP and
• Using HLOOKUP & XLOOKUP
• Understanding the MATCH & XMATCH
• Understanding the INDEX
• Understanding OFFSET and INDEX .

Dynamic Arrays in Excel

• Introduction to Dynamic
• Implementing the Dynamic