CourseVania > Office Productivity > Microsoft > Essential Microsoft Excel For Beginner to Advanced

4.36 out of 5

31 reviews on Udemy

Essential Microsoft Excel For Beginner to Advanced

Learn Microsoft Excel from Novice to Expert & learn the art of creating quick Reports

Instructor:

Austin Morris

4,152 students enrolled

English [Auto]

Excel Terminology

Data Selection

Functions

Data Ranking

Data Navigation

Formula

VLOOKUP

Fixing Text Cases

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.

Some reviews from actual course students

Vishal Brijesh KanojiyaUpdated 21 days ago

Rating: 5.0 out of 5

nice video tutorial and i have learned lot’s of thing and now i feel like i know excel very well

Introduction

WHY USE EXCEL

Where is excel used

Getting started

Creating a new worksheet

Open and create a workbook

Save data

Save data on pc

Save data in one drive

Value error

#DIV0 ERRor

#NAME error

#REF! ERROR

### ERROR

#NULL ERROR

#NUM ERROR

And function-

Or function

Not function pt2

Xor function

Switch function

Cell function

Row function

If function

IFS function

Nested if function

Use IF function to calculate letter grades in Excel

How to use Filter Function in Excel

Date function

Datedif function

Edate function

Eomonth function

DateValue Function

Today now functions

How to Convert Time Hours, Minutes, Seconds _ TIMEVALUE Functions PART 2

Count function

Round function

SUM function

AVERAGE functionpls skip ending explanation

SUBTOTAL function

Power function

MAX and MIN function

LEN function

MID function

REPT function

Split in ms excel

TRIM function

Hyperlink

How to import html-

Drop Down List pt2

Dynamic drop down list

Dependent drop down list

Charts and graphs------

Pivot Tables_1

Data filtering and sorting

Sort function

Filter function

Flash fill

Lookup function

Index function

Match function

Exact function

VLOOKUP function

Normal VLOOKUP

Vlookup function

Use IFS function to calculate letter grades in Excel

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!

4.4

4.4 out of 5

31 Ratings

Detailed Rating

Stars 5		11
Stars 4		14
Stars 3		5
Stars 2		1
Stars 1		0

Login/Sign Up

Search

Menu

Essential Microsoft Excel For Beginner to Advanced

Introduction

How long do I have access to the course materials?

Can I take my courses with me wherever I go?

Detailed Rating

Includes