Unleash Your Potential with Our Excel Course
Are you ready to supercharge your career and excel in the world of data analysis and spreadsheet mastery? Look no further than our ‘Microsoft Excel 2019 Advanced’ course – your ticket to becoming a spreadsheet wizard.
Elevate Your Skills
Designed for clerks, officers, executives, supervisors, administrators, and managers of all levels, this Excel course is the key to unlocking your full potential. Whether you’re already familiar with the basics or have attended our foundation and intermediate level courses, this program is your next step to mastering Microsoft Excel. With hands-on training, interactive lectures, practical exercises, and engaging discussions, you’ll not only create subtotals and analyze data with pivot tables but also become a pro at VLOOKUP functions, scenario planning, and macro automation.
Transform Your Career
In today’s fast-paced corporate world, Excel proficiency is not just a skill; it’s a competitive advantage. With the ‘Microsoft Excel 2019 Advanced’ course, you’ll not only navigate large workbooks with ease but also protect your workbooks from unauthorized changes. Imagine the doors that will open when you can confidently handle complex data, automate tasks, and present your insights with finesse. Don’t just keep up with the corporate world; lead the way with the Excel skills you’ll gain from this course.
Why Wait?
Your journey to Excel excellence begins here. Enroll today, and discover the endless possibilities this Excel course unlocks for your career. Don’t just settle for ordinary; strive for extraordinary with ‘Microsoft Excel 2019 Advanced.’ Your success story starts with a single click.
Course Details
Course Code: EX19A-2; Instructor-led
Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Prerequisites
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation & Intermediate Level; OR
- Able to switch between task applications
- Able to create simple to complex formulas and functions
- Able to validate data in a Worksheet
- Able to apply Filter data using Auto & Advanced Filters
- Able to clean Duplicate Records
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- Create Subtotal Using the Subtotal Function
- Analyze data Using Pivot Tables
- Perform What If Analysis using:
- Goal Seek
- Solver
- Input Table
- Scenarios
- Use VLOOKUP function to extract data
- Nesting INDEX and MATCH Function
- Combining & Consolidating Data
- Summarizing & Analyzing with Pivot Table and Pivot Charts
- Record and Run a Macro
Outlines
Module 1: Organize Summary and Details on Your Data
Topic A: Outlining and Grouping Data
- Using Automatic Outlining
- Displaying and Collapsing Levels
- Grouping Data Manually
- Creating Subtotals
Module 2: Planning, Forecasting & Projection of Your Data
Topic A: Using Data Analysis Tools
- Using a One or Two Input Data Table
- Using Goal Seek
 Topic B: Exploring Scenarios
- What is a Scenario?
- Creating a Scenario
- Saving Multiple Scenarios
- Creating a Scenario Summary Report
 Topic C: Using Solver
- Understanding Solver
- Generating Reports and Scenarios with Solver
- Changing Solver Values
- Managing Solver Constraints
- Using Solver as a Goal Seek Tool
Module 3: Retrieve, Compare or Compiling Data with Functions
Topic A: Working with Array Formulas
- What are Array Formulas?
- Using Functions within Array Formulas
 Topic B: Using the LOOKUP Function
- Using VLOOKUP to Find Data
- Find Exact Match with VLOOKUP
- Find Closest Match with VLOOKUP
- Find with HLOOKUP
 Topic C: Alternative LOOKUP Function
- Using the INDEX Function
- Using the MATCH Function
- Combining the MATCH and INDEX functions
Topic D: Linking, Consolidating, and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Combining Worksheets
Module 4: Present Data with Visual Report
Topic A: Create Combo Chart
- Comparing 2 Types of Values with high Variance
- Creating Combo Chart
- Editing Combo Chart
Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts
Topic A: Create a PivotTable
- Create PivotTable Dialog Box
- PivotTable Fields Pane
- Summarize Data in a PivotTable
- Show Values as Functionality of a PivotTable
- Personalize the default PivotTable layout
 Topic B: Filter Data by Using Slicer
- Insert Slicers Dialog Box
 Topic C: Analyzing Data with PivotChart
- Creating PivotChart
- Editing a PivotChart
Module 6: Navigating Large Workbooks
Topic A: Customizing Workbooks
- Inserting Hyperlinks
- Editing Hyperlinks
- Formatting Hyperlinks
- Using Hyperlinks in Excel
Module 7: Automate Task with Macros
Topic A: Customizing Workbooks
- Inserting Hyperlinks
- Editing Hyperlinks
- Formatting Hyperlinks
- Using Hyperlinks in Excel
Module 8: Prevent User Changes with Protection
Topic A: Customizing Workbooks
- Inserting Hyperlinks
- Editing Hyperlinks
- Formatting Hyperlinks
- Using Hyperlinks in Excel
