Microsoft Excel Crash Course 2023: Masterclass for Weekend
By hari systems
Categories: Entrepeneurship
About Course
Â
Course Content
Getting Started
Getting Started
-
Introduction
-
Getting started on Windows, macOS, Android, and IOS
-
How to ask great questions
-
FAQ
-
Start Excel
Top 10 Excel Tips to Save You Time
Top 10 Excel Tips to Save You Time
-
Overview of top Excel tips
-
Add numbers like a pro
-
Save time by filling cells automatically
-
Did data enter into one column? Split it
-
Switch data around by transposing it
-
Sort and filter for quick results
-
Create a data table for tasks to make it easy
-
Make drop-down list
-
Quick Data Analysis
-
Great charts for your visualization
-
Pivot Tables for Data Analytics
Excel essential functions
-
Introduction
-
Basic formula operations
-
Mathematical functions level1
-
Mathematical functions level2
-
Text functions level1
-
Text functions level2
-
Logical functions
-
Date time functions
-
V Lookup formula
-
HLookup formula
-
HLookup + Match formula
-
Match + Index formula
XLookup only for Excel 2021 and Office 365
-
Introduction
-
XLookup
-
Handling #NA and Approximates match in XLookup
-
Wildcard matching in XLookup
Get Data and tools
-
Introduction
-
Split Text into columns
-
Flash Fill
-
Remove Duplicates
-
Data Validation
-
Get – import Data from Text
-
Get – import Data from CSV
Pivot Tables
-
Introduction
-
Creating Pivot Table
-
Value field settings
-
Number format
-
Pivot Table Design
-
Excel Exercise
-
Solution for Excel Exercise
Excel Charts
-
Introduction
-
 Excel Charts – Categories
-
 Elements of a chart
-
Easy way to create charts
-
Column or Bar charts
-
Formatting charts
-
Line charts
-
Area charts
-
Pie and Doughnut charts
-
Format Area Plot or XY chart
-
Scatter or bubble charts
Student Ratings & Reviews
No Review Yet