Excel 2021/365 Starter Pack: Beginner to Intermediate Course
Master Excel spreadsheets with this beginner to intermediate training course!
4.67 (73 reviews)
235
students
22.5 hours
content
Mar 2024
last update
$79.99
regular price
What you will learn
What’s new in Excel 2021
Navigating the Excel 2021 interface
Utilizing useful keyboard shortcuts to increase productivity
Using basic and intermediate Excel formulas and functions
Effectively applying formatting to cells and using conditional formatting
Linking to other worksheets and workbooks
Protecting and sharing workbooks
Saving your workbook in different file formats
Designing better spreadsheets and controlling user input
How to use logical functions to make better business decisions
How to use Excel tables to structure data and make it easy to update
Sorting and filtering data using advanced features and new Excel formulas
Working with date and time functions and extracting data using text functions
How to control user input with data validation
Importing data and cleaning it up before analysis
Using WhatIf analysis tools to see how changing inputs affect outcomes.
Analyzing data using PivotTables and representing data visually with charts and PivotCharts
Adding interactions to PivotTables and PivotCharts
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
Related Topics
4556096
udemy ID
2/17/2022
course created date
3/16/2022
course indexed date
ANUBHAV JAIN
course submited by