Description
This practical, 4 day Advanced Excel Training Masterclass focuses on the MS Excel skills that the typical business user would require.
This Online Advanced Excel Training Course is Instructor-led live, interactive online training with certificate of completion.
Course Content
Module 1: Customizing Excel
- Customizing the Ribbon
- Changing defaults
Module 2: Database Essentials
- What is a Database
- Correct Data Input
- Using the Get and Transform Data
- Sorting a list
- Filtering a list
- Data Forms
- Setting Data Validation
- Custom Number formats
Module 3: Excel tools
- Linking Worksheets
- Data Consolidation
- Using hyperlinks
- Protecting Worksheets, Workbooks and Files
Module 4: Advanced functions
- Creating and using Range Names
- =And, =Or
- =If and Nested IF statements
- =iferror
- =Sumif and =Countif
- =Sumifs and =Countifs
- =Vlookup among other functions
Module 5: Pivot Table Reports
- Creating a pivot table
- Filter/Show and Hide Pivot Table data
- Using slicers
- Rearranging Pivot Tables:
- Grouping fields
- Moving fields
- Collapsing and Expanding fields
- Refreshing data
- Using Show Value As
- Adding Subtotals and Grand Totals
- Formatting field settings
- Applying a Pivot Table Style
- Creating a new custom Pivot table style
- Creating a PivotChart
Module 6: Macros
- Recording a macro
- Relative and Absolute References
- Editing and Deleting macros
- Running a macro
- Assigning macros to objects
- Assigning macros to a toolbar
Enroll now for a discounted price Advanced Excel Masterclass
Email: info@launchhub.africa
Call us – +254 707 260 205
Advanced Excel Classroom Training, Live Online Training and Weekend special classes are also offered,
To know about the dates, prices, and offers, chat with us now or send a query
Other Trainings offered include: Advanced Excel Training Masterclass Course; Ms. Project Masterclass; Project Management Professional; Product Management Masterclass; Ultimate Startup Guide for successful Startups.