Microsoft Excel - Beginner to Advanced Users in 2024

Focused View

Mahammad Mansoor

7:48:44

0 View

1. Introduction

1. Excel Introduction.mp4

05:05

2. Lecture 2 Save Options in MS Excel

1. Saving an Excel File.mp4

03:08

3. Entering Data in Excel File

1. Entering Data in Excel File.mp4

01:49

4. WorkBook and Sheets

1. Workbooks and Sheets in Excel.mp4

02:39

5. Copy and Paste Special

1. Copy and Paste Special.mp4

07:59

6. Relative and Absolute References

1. Relative Vs Absolute Reference.mp4

05:53

7. Formatting in Excel

1. Formatting in Excel Part 1.mp4

05:42

2. Formatting in Excel Part 2.mp4

06:24

3. Formatting in Excel Part 3.mp4

09:26

8. Conditional Formatting

1. Conditional Formatting Part 1.mp4

13:41

2. Conditional Formatting Part 2.mp4

06:42

3. Conditional Formatting Part 3.mp4

12:09

9. Freeze Panes in Excel

1. Freeze Panes In excel.mp4

05:08

10. Sorting & Filtering Data in Excel

1. Basic Sort in Excel.mp4

04:12

2. Advanced Sort in Excel.mp4

07:28

3. Filter in Excel Part 1.mp4

12:48

4. Filters in Excel Part 2.mp4

04:16

5. Advanced Filter in Excel.mp4

12:09

11. Basic Functions

1. Basic Functions in Excel.mp4

03:45

2. FLASH FILL Filling Data at once.mp4

02:32

12. Data Handling in Excel

1. Text to Columns.mp4

08:51

2. Data Validation in Excel Part 1.mp4

13:24

3. Data Validation in Excel Part 2.mp4

10:07

4. Consolidate Data from Multiple Sheets.mp4

05:49

13. Logical Test

1. Logical Test.mp4

02:46

14. Text Function in Excel

1. Text Functions Part 1.mp4

05:28

2. Text Functions Part 2.mp4

06:48

3. Text Functions Part 3.mp4

07:53

4. Text Functions Part 4.mp4

05:57

15. Logical Functions of Excel

1. IF Function in Excel.mp4

03:53

2. Nested IF Part 1.mp4

06:16

3. Nested IF Part 2.mp4

07:11

4. SUMIF, SUMIFS, COUNTIF, COUNTIFS.mp4

12:53

5. AND Function.mp4

04:11

6. OR Function.mp4

05:27

7. NOT Function.mp4

01:09

8. IFERROR Function.mp4

05:12

9. IFS Function.mp4

05:48

16. Mathematical Functions in Excel

1. SUMPRODUCT Function.mp4

03:05

2. SUBTOTAL Function.mp4

06:02

17. Date And Time Functions in Excel

1. Date and Time Functions Part 1.mp4

08:34

2. Date and Time Functions Part 2.mp4

05:23

3. Date and Time Functions Part 3.mp4

07:23

4. Date and Time Functions Part 4.mp4

06:27

18. Tables in Excel

1. Basic Table.mp4

05:19

2. Advanced Table.mp4

06:00

19. PIVOT TABLES & LOOKUP FUNCTIONALITY

1. Pivot Tables Part 1.mp4

12:59

2. Pivot Table Part 2.mp4

07:14

3. Pivot Table Part 3.mp4

10:54

4. VLOOKUP.mp4

05:57

5. HLOOKUP.mp4

03:07

6. XLOOKUP.mp4

09:27

7. INDEX FUNCTION.mp4

06:45

8. MATCH FUNCTION.mp4

03:44

9. INDEX & MATCH.mp4

12:23

20. What-If Analysis in Excel

1. Scenario manager and Goal Seek.mp4

09:56

2. Data table.mp4

10:40

21. Charts in MS EXcel

1. Basics of Charts.mp4

04:59

2. Formatting Chart Elements Part 1.mp4

09:08

3. Formatting Chart Elements Part 2.mp4

15:12

4. Sparkline Charts.mp4

08:07

5. Bar Chart.mp4

03:14

6. Column Chart.mp4

04:04

7. Line Chart.mp4

03:08

8. Pie Chart.mp4

08:04

9. Area Chart.mp4

03:51

10. Scatter Chart.mp4

07:52

11. Bubble Chart.mp4

07:48

Description

Microsoft Excel Essentials, Spreadsheet Application in real world for Beginners to Advanced Users

What You'll Learn?

Learn Excel in an Easy and Effective way without getting bored
Learn VLOOKUP, XLOOKUP, INDEX & MATCH, Conditional Formatting and many more functions
Learn Basic to Advanced Topics like Pivot tables
Be able to Create Various Charts in Excel

Who is this for?

This is course is for all who want to learn Microsoft Excel and improve their knowledge and Skillset.

What You Need to Know?

No Prior experience required

More details

Description
This Course will teach one and all interested in knowing the best software invented till date which is none other than Microsoft Excel.
You will learn Look-up Functionality, Pivot tables & Formatting, Basic functions in Excel, Flash Fill and much more.
Learning this will help you excel in your career and boost your skills.
Getting started with Excel.
In this Excel course, youâ€™ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. Youâ€™ll learn how to manage tables and apply calculations to your data to provide new insights.
Working with Functions
Youâ€™ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. Weâ€™ll start your journey into understanding the full potential of Excels functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.
Excel is a spreadsheet software that allows you to organize, analyze, and visualize data. An Excel course would teach you how to use various features and functions of Excel, such as:
How to create, save, and open workbooks
How to enter, edit, and format data in cells and ranges
How to use formulas and functions to perform calculations and analysis
How to create and customize charts, tables, and pivot tables
How to apply filters, sorting, and conditional formatting to the data
Who this course is for:
This is course is for all who want to learn Microsoft Excel and improve their knowledge and Skillset.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Mahammad Mansoor

Instructor's Courses

I am a Mechanical Engineer with 17 years of experience spanning across industries in the Aerospace, Automotive, Heavy Machinery, Oil and gas industry. All the projects I have worked on i have used Microsoft Office specially Excel.I hope my courses will help you excel in your career and life in general.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.