Microsoft Excel Essentials for the Real Time World

Name: Microsoft Excel Essentials for the Real Time World
Rating: 4.0 (14 reviews)

Microsoft Excel Beginner to Professional. Includes New Formulas

Created byRemy Lien

Last updated 1/2025

English

What you'll learn

Excel Terminology
Data Navigation
Data Selection
Formula
Functions
VLOOKUP
Data Ranking
Fixing Text Cases

Course content

2 sections • 44 lectures • 2h 56m total length

Introduction1:38

Excel Terminology (Part .1)4:19
Excel Terminology (Part .2)3:35
Data Navigation3:48
Data Selection4:38
Data Entry _ Editing6:29
Formula vs Functions4:46
Formula Application (Part .1)4:22
Formula Application (Part .2)4:02
Sum _ Auto Sum3:09
Average Min _ Max3:47
Absolute vs Relative4:31
Master absolute and relative references in Excel to lock fixed values with the dollar sign in a commission table.
Allignment5:25
Fonts _ Borders5:25
Format Painter3:14
Use the format painter from the home tab to copy font color, bold, and italic formatting to names, and create banded rows and design format tables.
Number Formats3:14
Apply currency, accounting, percentage, and date formats in Microsoft Excel using the home tab and number tool. Adjust decimals and symbols to clearly present figures and dates.
Styles _ Themes2:47
Rows _ Columns5:11
Find _ Select3:01
Data Filtering3:31
Learn to use data filtering in excel with the filter tool and data tab. Isolate orders by account manager and ship mode, and apply top ten and greater than filters.
Data Sorting3:37
Conditional Formatting4:04
Basic Charts5:28
Editing Charts (Part .1)2:38
Editing Charts (Part .2)2:37
Move _ Resize Charts4:09
Move and resize charts in Excel by selecting data, inserting line, column, or pie charts, then use move tools or corner handles to place or resize charts.
Count Functions3:42
Data Ranking3:22
Combining Texts3:45
Fixing Text Cases2:13
Learn to clean and standardize text in Excel by using the upper, lower, and proper functions to fix mixed case data from forms and surveys.
Extracting Texts3:31
Find Function2:40
Learn how the find function in Excel searches for substrings within a string, demonstrating case sensitivity, start position options, and how it returns the first match position.
Introduction to IF5:32
Nested IF4:14
COUNTIFS4:19
VLOOKUP4:25
VLOOKUP (Approximate Match)3:30
Naming Ranges3:13
discover how to create, rename, and delete name ranges in Microsoft Excel using the name manager.
Drop Down Lists6:31
Printing in Excel5:07
AND()4:44
Cell5:30
Master the Excel cell function in Microsoft Excel Essentials for the Real Time World to retrieve a cell's address, color, content, formatting, and references for dynamic data analysis.
MID4:03
NOT3:00
Discover how the not function in Excel flips true to false for single cells, and why it errors with words, while numbers like zero are treated differently.

Requirements

No Experience Needed

Description

Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?

OR, you've been using Microsoft Excel for a while but don't feel 100% confident?

There is so much information out there. What do you need to succeed at work?

I’ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.

In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.

These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time. Learn Excel now.

Who this course is for:

Beginner who want to learn Excel

Microsoft Excel Essentials for the Real Time World

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Fundaments43 lectures • 2hr 55min

Requirements

Description

Who this course is for: