Microsoft

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.

(EXCEL-2019.AW1) / ISBN : 978-1-64459-655-5
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

About This Course

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. 

Skills You’ll Get

  • 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.
Download Course Outline

1

Introduction

2

What’s New in Excel 2019/Office 365

  • 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
3

Entering Data in Excel

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

Transforming and Managing Data

  • Summary
5

Formulas and Functions

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

Data Analysis

  • 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
7

Data Visualization

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

Data Extraction

  • 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
9

Automation in Excel through Macros

  • 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

Any questions?
Check out the FAQs

  Want to Learn More?

Contact Us Now

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. 

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

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

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.

Related Courses

All Course