Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course
Become a Microsoft Excel 2021/365 expert with this three-course bundle
4.48 (152 reviews)
724
students
33.5 hours
content
Mar 2024
last update
$79.99
regular price
What you will learn
Become familiar with what’s new in Excel 2021 and navigate the Excel 2021 interface
Create your first Excel spreadsheet and use basic and intermediate Excel formulas and functions
Utilize useful keyboard shortcuts to increase productivity
Effectively applying formatting to cells and using conditional formatting
Linking to other worksheets & workbooks and protecting & sharing workbooks
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
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
Creating an interactive dashboard to present high-level metrics
Auditing formulas and troubleshooting common Excel errors
Using the NEW dynamic array functions to perform tasks
Using statistical functions to rank data and to calculate the MEDIAN and MODE
Importing and cleaning data using Power Query
Recording and running macros to automate repetitive tasks
Understanding and making minor edits to VBA code
Predicting future values using forecast functions and forecast sheets
Related Topics
4796914
udemy ID
7/24/2022
course created date
9/6/2022
course indexed date
ANUBHAV JAIN
course submited by