The Dynamics of Microsoft Excel Workbook, Charts, PivotTable
Learn Excel from scratch and harness the power of Macros to automate tasks. Explore various charts, Pivot Tables, and data analysis techniques. Protect your files, automate data entry, and organize data easily. This course is suitable for beginners and intermediate users looking to enhance their Excel skills for potential Data Analyst job opportunities.
What you’ll 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
- Explore the dynamics of Pivot Table and Pivot Chart
- Maximize the customization of 3D and 2D charts
- How to Protect your Excel files and worksheets properly.
- Automate data entry with Auto-Fill and Flash-fill.
- Organize and structure data for easy analysis (Find through wildcard, Sort, Filter, Search & Replace, etc)
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
Who this course is for:
- This course is for absolute beginners. Intermediate Excel users are not exempted.
- Understanding the dynamics of Excel Charts, Pivot Table, Maps can land you a Data Analyst job. So if you want to go that route, this Excel course is for you
User Reviews
Be the first to review “The Dynamics of Microsoft Excel Workbook, Charts, PivotTable”
You must be logged in to post a review.
There are no reviews yet.