The Dynamics of Microsoft Excel Workbook, Charts, PivotTable

[LeeAndro]

Published 08/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 139 lectures (18h 29m) | Size: 8.2 GB

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)

Excel 2013, Excel 2016, Excel 2019, Office Excel 365 software
A computer and the zeal to learn at your pace

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

In this course you will

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

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

Be able to create a Macro button

Automating Charts with Macros

Create Header and Footer within your Excel Worksheet

Learn how to use printing setup and page setup in Excel

Be able to use the conditional formatting tool to present data

Maximize the customization of 2D and 3D charts

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

Formatting 3D Bar Chart, 3D pie Chart elements

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

Learn how to use printing setup and page setup in Excel

Be able to Freeze and unfreeze panes

Explore the dynamics of Pivot Table and Pivot Chart

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

Understand how to use the slicer tools and line filter tools

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

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

Create 3D Map with Line

Learn how to create a Funnel Chart, Combo Chart, Pareto chart, Histogram, Treemap, Box and Whisker Charts, Sunburst charts and more

Automate data entry 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

This course is for absolute bners. 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

HomePage:

https://anonymz.com/https://www.udemy.com/course/the-dynamics-of-microsoft-excel-workbook-charts-pivottable/

DOWNLOAD

https://1dl.net/d1k42r2juf7f/9Vq4XE00__The_Dynami.part01.rar.html
https://1dl.net/tum0k9miuzwc/9Vq4XE00__The_Dynami.part02.rar.html
https://1dl.net/juk8np8wzkfa/9Vq4XE00__The_Dynami.part03.rar.html
https://1dl.net/xhazmu7nlhqs/9Vq4XE00__The_Dynami.part04.rar.html
https://1dl.net/iecewsqz3orb/9Vq4XE00__The_Dynami.part05.rar.html
https://1dl.net/hpyhb2tlczu9/9Vq4XE00__The_Dynami.part06.rar.html
https://1dl.net/8d84dvlmdvhc/9Vq4XE00__The_Dynami.part07.rar.html
https://1dl.net/7jpzbzkydwuz/9Vq4XE00__The_Dynami.part08.rar.html
https://1dl.net/hh2nun6mrgwz/9Vq4XE00__The_Dynami.part09.rar.html