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 Interaktive Lektionen Und 60 topics mapped to the official exam objectives
Beginner Selbstgesteuert · 1 Jahr Zugang
01 / Fähigkeiten, die Sie erwerben
What you will be able to do
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 Strukturierte Lektionen Umfassende Abdeckung der zentralen Kursziele
-
1 Jahr voller Zugang Selbstgesteuertes Lernen, jederzeit auf allen Geräten zugänglich
02 / Lektionen & Labore
See exactly what you will learn and practice
Unterrichtsplan
9 Interaktive Lektionen · 60 topics01 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
Fragen, bevor Sie beginnen
Is this course suitable for beginners?+
What version of Excel does this course cover?+
Will this course help with data analysis jobs?+
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.