• Post category:StudyBullet-12
  • Reading time:5 mins read


Microsoft Excel Beginner to Professional. Includes Pivot Tables, Power Query, NEW Formulas

What you will learn

Excel formulas and features

Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports

Data Selection

Data Navigation

Description

Looking to learn Microsoft Excel and improve your data analysis skills but don’t know where to start?

OR, you’ve been using Microsoft Excel for a while but don’t feel 100% confident?

There is so much information out there. What do you need to succeed at work?

I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.


Get Instant Notification of New Courses on our Telegram channel.


In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years’ experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.

These practical, real-world examples help you understand the full potential of each feature. You’ll learn how to use Excel for quick and painless data analysis.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don’t use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

English
language

Content

Introduction

Introduction
Getting Started With Excel
Create and open Workbook
Create New Worksheets
Tabs and Ribbon
Data Formats
Data Handling Basics – Cut, Copy and Paste
Saving and Printing in Excel
Basic Formula Operations
Mathematical Functions – 1
Mathematical Functions – 2
Difference between RANK, RANKAVG and RANKEO
Textual Functions – Part
Textual Functions
Logical Functions
Date-Time Functions
XLookup as a replacement of Vlookup
Handling #NA and Approximates match in Xlookup
Search modes in XLookup
Pivot table
Excel Charts – Categories of messages that can be conveyed
Elements of charts
Bar and column charts
Formatting charts
Line Charts
Area Charts
Pie and Doughnut Charts
Why we should avoid Pie charts
Scatter plot or XY chart
Frequency Distribution and Histograms
Waterfall Charts
Hierarchy Charts- Sunburst and Treemap
Combination charts
Sparkline
Piviot Chart
Maps Chart
Stock charts
Shorrtcuts
Concluation