Error Page
MS EXCEL (BASIC - ADVANCE)
- Data
Types, Tabs & Complete Ribbon
- Basic
Formatting (Data Validations, Conditional Formatting, Filters, FIND
& REPLACE, Sorting etc.)
- Basic
to Intermediary Calculations (SUM, SUMIF, COUNTIF, COUNTIFS, MAX, MIN,
MAXIFS, MINIFS, etc.)
- Basic
to Intermediary Lookup Functions (LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, etc.)
- #ERRORS
in EXCEL & Validations for them
- Basic
to Advanced Charts & Graphs (PLOTS, COMBI CHARTS, BAR CHARTS, etc.)
- Advanced
Formulas & Functions (DATE/TIME Functions, NESTED FUNCTIONS, ARRAY
FUNCTIONS, FINANCIAL FUNCTIONS, REAL WORLD CALCULATIONS)
MS POWERPOINT (BASIC - ADVANCE)
- PowerPoint
Options, Tabs, Complete Ribbon
- PowerPoint
Aesthetics, Layouts, Charts, Shapes & Gradients
- Intermediary to Advanced: Attachments (Audio & Videos), Hyperlinking, Custom Buttons, Macros for PPTs, recording PPTs, etc.
Visual Basic (VBA)
- Introduction to VBA: Macro Recorder, Macro Security, Naming Macros, Recording Macros, Executing Macros, Saving & Editing Macros
- Formulas: Basic Formulas, Complex Formulas, Logical Formulas, Lookup Formulas, Freezing Formulas in VBA
- Working with VBA Editor: All tabs in VBA Editor, Project Explorer, Object Browser, Standard & Sheet Modules
REAL-WORLD CALCULATIONS & TOPICS (MORE in our Syllabus Attachment)
REAL-WORLD DASHBOARDS (BASIC - ADVANCE)
Please feel free to go through our curriculum & decide. Once you do,
we're here to help you throughout the journey. Looking forward to seeing you in
our sessions!
Thank you!
From TEAM EXCELZONE
