4.34 out of 5
4.34
945 reviews on Udemy

Microsoft Excel from Zero: Functions, Formulas & Shortcuts

From no background knowledge to data cleaning, data transformation, data consolidation, data analysis, and dashboards
Instructor:
Irfan Sharif
52,375 students enrolled
English [Auto]
Basics like cells, rows, and columns
Adding/deleting rows and columns
Cell formats
Basic Mathematical functions
Keyboard shortcuts
Data cleaning
Data analysis
Learn everything you need to start working on Excel!

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.

Microsoft Excel is one of the most powerful data management and data analysis tool.

This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some advanced and frequently used features.

About this course:

Designed to teach Microsoft Excel to absolute beginners, this course will take you from scratch to a level where you can effectively store, manage, clean, transform, consolidate, analyze, and visualize data.

Prerequisites:

There is absolutely no prerequisite to start this course. Even 8 years old can take this course to learn Excel.

Who should take this course:

First-time learners, who have no idea about Excel and want to start the right way. This includes:

  1. Students

  2. Professionals, especially those who have to work with numbers.

  3. Daydreamers who wish to bring financial sense to their dreams.

  4. Anyone who wants to learn a better way to manage the numbers and calculations.

Software Requirement:

You should have Microsoft Excel installed on your computer. Any version above Excel 2010 will be okay. I will be using Excel 2016 in this course. If you do not have Excel currently, please download Office 365 free trial from the Microsoft website. Just google Office 365 free trial and it will take you to the page.

Money-Back Guarantee: 

Nothing to lose! If you won’t be satisfied with the course, Udemy offers 30 days money-back guarantee!

Introduction to the teacher:

Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty | 4000+ in-class students | 100,000+ Udemy students | In love with Excel for 15 years

Level 1: Getting to know Excel

1
Introduction to Spreadsheet, Cell, Column and Row
2
Learning keyboard shortcuts to navigatge in a sheet, to add columns and rows
3
Understanding cell format
4
Autofill
5
Basic Mathamatical functions
6
Practice on real data

Level 2: Cleaning data

1
Remove duplicates
2
Removing spaces
3
Spell check
4
Find | Find & Replace
5
Replacing blank cells
6
Using proper fonts

Level 3: Transforming Data

1
Merging data in cells
2
Text to Columns
3
Data Sorting
4
Transpose Data
5
Flash Fill

Level 4: Compiling data

1
Vlookup
2
Hlookup
3
Consolidate
4
Append data with Power Query

Level 5: Getting ready for Data Analysis

1
Manipulating dates - Date | Month | Year
2
Manipulate dates - Name of the Day | Name of the Month
3
Manipulating dates - Day of the week | Week of the year
4
Day of the Year
5
Quarter of the Year
6
Dynamic TODAY | Tomorrow | Yesterday
7
Calculating Age
8
Adding conditional columns based on IF
9
NESTED IF
10
IF OR
11
IF OR Multiple Column
12
IF OR OR OR Practice
13
IF AND
14
IF AND AND AND Practice

Level 6: Basic Data Analysis (Ad hoc Data Analysis)

1
Freeze Panes
2
Filters and advance filters
3
Conditional Formatting
4
Subtotals
5
COUNTIF
6
COUNTIFS
7
SUMIF
8
SUMIFS

Data Analysis

1
Introduction to Data Analaysis and Data
2
Summay by a parameter
3
Adding parameters with drill down and drill up
4
Breaking down information by Column
5
Filtering the data in reports
6
Understanding Value Field Settings
7
Working with Dates in rows
8
Grouping example
9
Slicers
10
Timeline

Keyboard Shortcuts Masterclass

1
Shortcuts Masterclass Part 1
2
Shortcuts Masterclass Part 2
You can view and review the lecture materials indefinitely, like an on-demand channel.
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.3
4.3 out of 5
945 Ratings

Detailed Rating

Stars 5
379
Stars 4
390
Stars 3
143
Stars 2
22
Stars 1
11
36e296eecfc9657955e03e7fd01b99fb
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +