Elevate Your Expertise with Advanced Excel Training
Looking to supercharge your Microsoft Excel skills? Our ‘Microsoft Excel 2021 Advanced’ course is your ticket to unlocking the full potential of this powerful tool. Whether you’re a clerk, executive, manager, or just someone passionate about mastering Excel, this course is tailor-made for you. We’ve designed it to take your existing Excel knowledge to the next level, helping you excel in your professional endeavors.
What You'll Learn
In this hands-on, instructor-led program, you’ll dive into the intricacies of Excel. From creating subtotals using the Subtotal function to analyzing data with Pivot Tables, this course covers it all. You’ll discover how to perform What If Analysis, utilize the XLOOKUP function, nest INDEX and MATCH functions, and more. We’ll even teach you how to protect your worksheets and workbooks like a pro. Our interactive lectures, PowerPoint presentations, discussions, and practical exercises ensure you not only learn but also retain and apply your newfound knowledge effectively.
Excel Training That Sets You Apart
At Info Trek, we don’t just provide Excel training; we empower you to excel in your professional journey. With a focus on practical, real-world applications, we equip you with the skills to tackle complex data tasks and make informed decisions. Join us and take a giant leap forward in your Excel proficiency. Your advanced Excel skills are just a course away from transforming your career.
Course Details
Course Code: EX21A-1; 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 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 XLOOKUP function to extract data
- Nesting INDEX and MATCH Function
- Combining & Consolidating Data
- Summarizing & Analyzing with Pivot Table and Pivot Charts
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: Retrieve, Compare or Compiling Data with Functions
Topic A: Using the XLOOKUP Function
- Using XLOOKUP to Find Data
- Find Exact Match with XLOOKUP
- Find Closest Match with XLOOKUP
Topic B: Linking, Consolidating, and Combining Data
- Linking Workbooks
- Consolidating Workbooks
- Combining Worksheets
Module 3: 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 & Timeline
- Insert Slicers Dialog Box
- Insert Timeline
Topic C: Analyzing Data with PivotChart
- Creating PivotChart
- Editing a PivotChart
Module 4: Prevent User Changes with Protection
Topic A: Protecting Worksheet and Workbook
- Lock & Unlock Cells
- Protecting the Current Sheet
- Protecting an Entire Workbook
