Microsoft Excel Advanced- Fast Track
Microsoft Excel Advanced is designed for the participant who wants to leverage on the Advanced functions and features to improve productivity and enhance your spreadsheets to simplify your daily work activities.
The course focuses on practical examples that will help users easily transit to using these formulas and functions in real-world scenarios.
Participants will be shown some of the most challenging formulas and functions in Excel and how to put them to their best use.
PREREQUISITES
Intermediate-level Excel skills, such as working with formulas and functions
TARGET GROUP
Who want to enhance their skills to an advanced level
Duration
1 Day (7 hours)
Course Achievement
Certificate of Completion by Training Provider
At the end of the course
In this 1-day workshop, you will be guided to use Lookup formulas, Match and Index formulas, Text & Date formulas and Financial formulas. Besides that, you will learn to analyse data and appreciate the powerful feature in using Pivot Tables. You will have the opportunity to learn simple Macros.
BENEFITS OF Microsoft Microsoft Excel Advanced- Fast Track TRAINING
Increased efficiency and productivity
Enhanced Reporting
Flexibility and Customization
Automation and Macros
View Course Outline
• Displaying and Tracing Formulas
• Using Financial Functions (PMT & FV)
• Using Lookup Functions (VLOOKUP, HLOOKUP)
• Using Lookup & Reference Functions (MATCH & INDEX)
• Using Text Functions (PROPER, CONCATENATE, UPPER, LEFT & etc)
• Using Date & Time Functions
• Creating Scenarios & Report
• Working with Data Tables
• Using Goal Seek
• Using Text to Columns
• Consolidating Data by Position or Category
• Consolidating Data Using Formulas
• Recording a Macro
• Playing and Deleting a Macro
• Adding a Macro to the Quick Access Toolbar
• Creating and Specifying PivotTable Data
• Changing a PivotTable’s Calculation
• Filtering and Sorting a PivotTable
• Working with PivotTable Layout
• Grouping PivotTable Items
• Updating a PivotTable
• Formatting a PivotTable
• Creating a PivotChart
• Creating a Standalone PivotChart
• Use Slicers to Share Slicers Between PivotTables
