Microsoft Excel Crash Course 2023: Masterclass for Weekend | Learnmode

Categories Entrepeneurship

Microsoft Excel Crash Course 2023: Masterclass for Weekend

Course Curriculum

Getting Started

Getting Started

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

Get Data and tools

Pivot Tables

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

No Review Yet

Level

Intermediate
Last Updated

October 23, 2024
Certificate

Certificate of completion

Created by:

HS

0(0 Ratings)

Tiktok Shop & Ecom ULTRA ADD ON

Intermediate

Tiktok Shop & Ecom ULTRA ADD ON

By Learnmode

15 Ready to GO Tiktoks & 1 PROMO FROM BIG ACCOUNT 🚀

Intermediate

15 Ready to GO Tiktoks & 1 PROMO FROM BIG ACCOUNT 🚀

By Learnmode In Entrepeneurship

£99.00

Machine Learning & Data Science Course: Unlocking the Future

All Levels

Machine Learning & Data Science Course: Unlocking the Future

By Adam Almounayar In Development

£39.99

Become a Successful Tiktok Affiliate

Intermediate

Become a Successful Tiktok Affiliate

By Natsmith.uk In Entrepeneurship

£99.00

Build your own successful Ecom & Tiktok Shop Business

Intermediate

Build your own successful Ecom & Tiktok Shop Business

By Learnmode

£799.00

Want to receive push notifications for all major on-site activities?

✕