Microsoft Excel Essentials for the Real Time World

Microsoft Excel Essentials for the Real Time World, available at $44.99, has an average rating of 4.38, with 44 lectures, based on 8 reviews, and has 31 subscribers.

You will learn about Excel Terminology Data Navigation Data Selection Formula Functions VLOOKUP Data Ranking Fixing Text Cases This course is ideal for individuals who are Beginner who want to learn Excel It is particularly useful for Beginner who want to learn Excel.

Enroll now: Microsoft Excel Essentials for the Real Time World

Summary

Title: Microsoft Excel Essentials for the Real Time World

Price: $44.99

Average Rating: 4.38

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Beginner who want to learn Excel

Target Audiences

Beginner who want to learn Excel

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 needsand 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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Fundaments

Lecture 1: Excel Terminology (Part .1)

Lecture 2: Excel Terminology (Part .2)

Lecture 3: Data Navigation

Lecture 4: Data Selection

Lecture 5: Data Entry _ Editing

Lecture 6: Formula vs Functions

Lecture 7: Formula Application (Part .1)

Lecture 8: Formula Application (Part .2)

Lecture 9: Sum _ Auto Sum

Lecture 10: Average Min _ Max

Lecture 11: Absolute vs Relative

Lecture 12: Allignment

Lecture 13: Fonts _ Borders

Lecture 14: Format Painter

Lecture 15: Number Formats

Lecture 16: Styles _ Themes

Lecture 17: Rows _ Columns

Lecture 18: Find _ Select

Lecture 19: Data Filtering

Lecture 20: Data Sorting

Lecture 21: Conditional Formatting

Lecture 22: Basic Charts

Lecture 23: Editing Charts (Part .1)

Lecture 24: Editing Charts (Part .2)

Lecture 25: Move _ Resize Charts

Lecture 26: Count Functions

Lecture 27: Data Ranking

Lecture 28: Combining Texts

Lecture 29: Fixing Text Cases

Lecture 30: Extracting Texts

Lecture 31: Find Function

Lecture 32: Introduction to IF

Lecture 33: Nested IF

Lecture 34: COUNTIFS

Lecture 35: VLOOKUP

Lecture 36: VLOOKUP (Approximate Match)

Lecture 37: Naming Ranges

Lecture 38: Drop Down Lists

Lecture 39: Printing in Excel

Lecture 40: AND()

Lecture 41: Cell

Lecture 42: MID

Lecture 43: NOT

Instructors

Remy Lien
Microsoft Office Expert

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 3 votes
5 stars: 3 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu