Duration
Microsoft Excel (Advanced)
1 day
Course Overview
This one-day Microsoft Excel Advanced course builds upon basic Excel skills, focusing on data management, visualization, and analysis. Participants will learn to consolidate data, use advanced charting tools, analyze data effectively, and customize the Excel interface for better workflow efficiency.
Target Audience
Ideal for professionals, analysts, students, and anyone who wants to enhance their Excel skills for better data management, visualization, and analysis.
Learning Outcomes
Participants will be able to:
Consolidate, clean, and validate data.
Use grouping and outlining for better data organization.
Create advanced charts like Treemap, Waterfall, and Funnel charts.
Apply data analysis tools for forecasting and insights.
Build and manipulate PivotTables for reporting.
Optimize Excel’s interface to enhance workflow efficiency.
Outline
9:00am-10:30am
Module 1: Managing Data
Consolidating Information
Removing Duplicates
Configuring Data Validation
Using FlashFill
10:30am-10:45pm Morning Break
10:45pm-12:30pm
Microsoft Excel (Advanced)
Module 2: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 3: Data Visualization
Understand Types of Charts
Creating Treemap Chart
Creating Waterfall Chart
Creating Funnel Chart
Creating Map Chart
Module 4: Analyzing Data (I)
Using Goal Seek
Using Data Tables
Module 5: Analyzing Data(II) (Office365)
Analysis on Stock Data Type
Analysis on Geography Data Types
Using Ideas
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
Module 6: PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Microsoft Excel (Advanced)
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Using Slicers
Creating Timelines
Changing Text Direction
Changing Number Format
Module 7: Charting Data
Creating Sparklines
Inserting Charts
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
Module 8: Viewing, Printing, and Sharing Your Workbook
Using Views
Saving a Workbook as PDF or XPS
Printing a Workbook
Module 9: Customizing the Interface
Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes
Programme scope, delivery arrangements and suitability are confirmed during enquiry.