EXCEL-2019.AW1

EXCEL 2019 ALL-IN-ONE

Learning Excel 2019 for the first time or reskilling isn’t a terrible idea. And this course will make you the smartest person in the (spreadsheet) room.

9 Interactive Lessons and 60 topics mapped to the official exam objectives

Beginner Self-paced · 1 year access

9Interactive Lessons

60Topics

01 / Skills you'll get

What you will be able to do

Try Free → No credit card required

Enroll in our Excel 2019 course, own your spreadsheets, and casually drop “Let me automate that for you” in meetings.

In this course, master everything from basic data entry to advanced automation. Learn new Excel 2019 functions, crush pivot tables, and make data visualization look easy. Get hands-on with real-world exercises, you can stop Googling fixes and start solving problems like an expert.

From simple calculations to Power Query and Macros, you’ll walk away faster, sharper, and dangerously good at Excel.

Navigate the Excel 2019/Office 365 interface efficiently.
Enter and import data accurately.
Clean and transform raw data for data analysis.
Use logical functions (IF, COUNTIFS, etc.) for conditional calculations.
Master text functions for data manipulation.
Create and customize pivot tables for dynamic reporting.
Perform advanced data analysis with Power Pivot and Power Query.
Run What-If Analysis for scenario planning.
Generate forecasts based on historical data.
Design professional charts and visualizations.
Use sparklines and conditional formatting for quick insights.
Build interactive dashboards with slicers and timelines.
Explore geographic data visualization with Power Map.
Automate repetitive tasks using Macros.
Understand Macro security and best practices.
Import and consolidate data from various sources.
Apply data validation to maintain accuracy.
Optimize workbook structure for better performance.
Utilize new Excel 2019 features (MAXIFS, funnel charts, etc.).
Enhance collaboration with easier file-sharing options.

Course Highlights

9 Structured Lessons Comprehensive coverage of core course objectives
1 Year Full Access Self-paced learning accessible anytime on all devices

02 / Lessons & labs

See exactly what you will learn and practice

Download outline (PDF)

Lessons

9 Interactive Lessons · 60 topics

01 Introduction

02 What’s New in Excel 2019/Office 365 11 topics

Why use Excel
New interface of Excel 2019/Office 365
Workbooks and Worksheets
New Functions in Excel 2019/Office 365
MAXIFS
New charts in Excel 2019/Office 365
Funnel chart
Easier sharing in Excel 2019/Office 365
New features in Excel 2019/Office 365
Enhancements in pivot table
Summary

03 Entering Data in Excel 4 topics

Entering data manually
Importing Data using Get & Transform data
Applying data validation
Summary

04 Transforming and Managing Data 1 topics

Summary

05 Formulas and Functions 9 topics

Writing Excel formulas and functions
Functions
Basic calculations
COUNT functions (COUNT, CountA, CountBlank)
Conditional calculation
Logical functions
IF
Text functions
Summary

06 Data Analysis 9 topics

Pivot tables
Calculation and grouping options
Power Pivot and Power Query
Loading connection through Power Query
Creating calculated columns in Power Pivot
What-If Analysis
Analysis ToolPak
Forecast Sheet
Summary

07 Data Visualization 8 topics

Charts
Pivot Charts
Slicer
Timeline
Sparklines
Conditional Formatting (CF)
Power Map
Summary

08 Data Extraction 8 topics

Print Excel Files
Understanding page view
Understanding page setup options
Page orientation
Export or Upload to Power BI
Share files via Email
Export data in different file formats
Summary

09 Automation in Excel through Macros 10 topics

Macros
Difference between Macros and VBA
Record a macro
Save a Macro
Run a Macro
Assign Macro to an Object
Check the VBA Code
Edit or delete a Macro
Macro security settings
Summary

03 / FAQs

Questions before you start

Is this course suitable for beginners?

Yes, whether you’re new to Excel or use it daily, this course starts with the basics and gradually progresses to advanced features like Power Map, Macros, and Power Query.

What version of Excel does this course cover?

This course focuses on Excel 2019 but also highlights key differences and features in Office 365.

Will this course help with data analysis jobs?

Absolutely! You’ll learn pivot tables, Power Query, forecasting, and data visualization which are essential for data-driven roles.

Can I learn Excel 2019 in a week?

You can learn the basics (formulas, data entry, simple charts) in a week with focused practice.

However, mastering advanced features (Power Query, Macros, complex analysis) takes longer; around 4-6 weeks with consistent effort. This course is structured to help you progress quickly, but true expertise comes from hands-on application in real-world scenarios.

Learn Excel, Automate Your Sheets, Save Hours

Excel isn’t hard. Learn it quick, enjoy it, and make your data work for you.

1 year of full access
Certificate of completion

Buy Now — $199.99 Try Free

No credit card required