TARGET AUDIENCE
Designed for anyone with minimal or no prior knowledge of Microsoft Excel 365 and looking to acquire solid foundational skills to perform calculation and table in a spreadsheet.
PRE-REQUISITE
Basic knowledge of computers, using the keyboard, mouse and Windows and Excel intermediate skills is required.
LEARNING OUTCOME
In this course, participants will:
Understand on data management in a spreadsheet.
Learn on Subtotal to summarize and group data as participant need.
Create and manage advanced chart to create statistical data visualizations.
Working with data analyzing tools to create information and precise report with Excel spreadsheet.
Understand PivotTable and PivotChart tools to generate advanced reporting with summarize and visualization tools.
Simplify long or large data with PivotTable.
Visualize better with PivotCharts.
Course Outline ::EXC365A::
Module 1: Managing Data
Consolidating Information
Configuring Data Validation
Converting Text to Columns
Using Flash Fill
Module 2: Outlining and Grouping Data
Outlining Data
Showing and Hiding Outline Details
Grouping Data
Creating Subtotals
Removing Outlining and Grouping
Module 3: Data Visualization
Understand Types of Charts
Creating Treemap Chart
Creating Waterfall Chart
Creating Map Chart
Creating Funnel Chart
Module 4: Analyzing Data Part 1
Using Goal Seek
Using Data Tables
Using Solver
Module 5: Analyzing Data Part 2
Analysis on Stocks Data Type
Analysis on Geography Data Types
Using Ideas
Module 6: PivotTable Features
Creating a Basic PivotTable
Creating a Basic PivotChart
Using the PivotTable Fields Pane
Adding Calculated Fields
Sorting Pivoted Data
Filtering Pivoted Data
Using Slicers
Creating Timelines
Programme scope, delivery arrangements and suitability are confirmed during enquiry.