Microsoft Excel: from ZERO to ADVANCED

What you'll learn
Getting Started with Excel
Working with Formulas and Functions
Creating Charts and Other Visualizations
Managing and Analyzing Data
Understanding Power Pivot and Power Query
Automating Excel with Macros on VBA

Requirements
No previous Excel experience is required

Description
Microsoft Excel is one of the most advanced spreadsheet software and one with a high demand on the market. Whether it is for data science, finance and accounting or administration, Microsoft Excel has the tools and libraries that will make your project come to life.

If you have no knowledge whatsoever in this software, this course is for you! You will be gaining all the required skills to be a complete professional in no time.

This course is divided into 6 sections, and made up of 42 chapters. All the exercise files are provided with the videos so you can follow along with the instructor.

The course is divided into the following sections and chapters

Getting Started with Excel

Introducing Excel

Entering and Editing Worksheet Data

Performing Basic Worksheet Operations

Working with Excel Ranges and Tables

Formatting Worksheets

Understanding Excel Files and Templates

Printing Your Work

Customizing the Excel User Interface

Working with Formulas and Functions

Introducing Formulas and Functions

Using Formulas for Common Mathematical Operations

Using Formulas to Manipulate Text

Using Formulas with Dates and Times

Using Formulas for Conditional Analysis

Using Formulas for Matching and Lookups

Using Formulas for Financial Analysis

Using Formulas for Statistical Analysis

Understanding and Using Array Formulas

Making Your Formulas Error-Free

Creating Charts and Other Visualizations

Getting Started with Excel Charts

Using Advanced Charting Techniques

Creating Sparkline Graphics

Visualizing with Custom Number Formats and Shapes

Implementing Excel Dashboarding Best Practices

Managing and Analyzing Data

Importing and Cleaning Data

Using Data Validation

Creating and Using Worksheet Outlines

Linking and Consolidating Worksheets

Introduction to PivotTables and Data Analysis

Performing Spreadsheet What-If Analysis

Analyzing Data Using Goal Seeking and Solver

Analyzing Data with the Analysis ToolPak

Protecting Your Work

Understanding Power Pivot and Power Query

Introducing Power Pivot

Working Directly with the Internal Data Model

Adding Formulas to Power Pivot

Power Query

Automating Excel

Introducing Visual Basic for Applications

Creating Custom Worksheet Functions

Creating UserForms

Using UserForm Controls in a Worksheet through an Example

Working with Excel Events

Creating Custom Excel Add-Ins

Who this course is for
Beginners in Microsoft Excel who want a complete course to gain all the required skills!

Welcome to My Blog - Check it Every Days
If you have any troubles with downloading, PM me
Please Buy Premium Account from my links to get high download speed and support me
Happy Learning!!