The Dynamics of Microsoft Excel Workbook, Charts, PivotTable

The Dynamics of Microsoft Excel Workbook, Charts, PivotTable

You are welcome to this Excel course. You will be guided step by step on how to be confident with Microsoft Excel.

In this course you will:

Learn how to work with Excel Workbook from scratch (absolute beginner) to a comfortable user

Be able to use the conditional formatting tool to present data and create your own custom formatting

Explore the dynamics of Pivot Table and Pivot Chart

Learn how to create Excel Macro - Absolute referencing vs Relative referencing

Be able to create a Macro button

Understand how Pareto Chart works and gain apt understanding of the Pareto line

Understand how Histogram works and be able to manipulate the grouped data in bins

Be able to create a Map Chart with multiple levels of geographic details

Understand how Bubble Chart works and be able to interpret the data

Create 3D Map with Time Line

Learn how to create a Funnel Chart, Combo Chart, Tree map, Box and Whisker Chart, Sunburst chart and more

Automating Charts with Macros

Create Header and Footer within your Excel Worksheet

Learn how to use printing setup and page setup in Excel

Maximize the customization of 2D and 3D charts

Formatting 3D Bar Chart, 3D pie Chart elements

Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc)

Use slicer tools to makes charts operate in a dynamic way

Use the Analyze Data Tool  in Office 365

Converting table to range and removing duplicates

Be able to Freeze and unfreeze panes

Explore the dynamics of Excel Table and applying sorting and filtering tools

Understand how to use the slicer tools and timeline filter tools

Understand the dynamics of Sparklines - columns, win/loss, Line

Be able to enter data with Auto-Fill and Flash-fill.

Be able to work with smart art, take screenshots and manipulate shapes and edit images

Learn how to transpose data - that is switching the columns and rows in Excel

The Practical Guide to EXCEL (2021, 2016, 2013) - PivotTable, Analyze Data, 2D/3D Charts, Maps, Conditional Formatting

Url: View Details

What you will learn

• Learn Excel from scratch to a comfortable professional
• Harness the power of Macros to automate your tasks
• You'll learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more

Rating: 0

Level: Beginner Level

Duration: 22.5 hours

Instructor: Pamch Tutor