Microsoft Excel 2019 (365): Crash Course
Master Excel 2019 (365) in under 7 hours!
4.30 (127 reviews)
10,796
students
6.5 hours
content
Aug 2020
last update
$34.99
regular price
What you will learn
This is a crash course in Excel 2019 to take you from Beginner To Advanced level in under 7 hours
You will learn introductory topics such as the Excel interface, sheets, rows, columns and data types
Get comfortable with Functions (Basic, Copying Functions, Named Ranges)
Formatting (Format the Sheet, Format Numbers and Conditional Formatting)
Data Analysis with Sorting, Filtering and Validation
Advanced Functions such VLOOKUPS, INDEX, MATCH, IF, Nested IFs, Text Formulas and SUMIFS/COUNTIFS
Data Consolidating with Power Query
Advanced Data Analysis with Pivot Tables
Visualise your Data with key Excel Charts and Dashboards
Speed up your work by recording and tweaking Macros
Automate with VBA (Object Model, Logic Programming and Managing Errors)
Screenshots
Related Topics
3342738
udemy ID
7/18/2020
course created date
8/19/2020
course indexed date
Bot
course submited by