Excel your knowledge with MS Excel

Focused View

Sumit Dwivedi

4:48:31

62 View

1 - Formatting in Excel

1 - 1.Basic-Formatting.xlsx

1 - Basic Formatting.mp4

13:51

2 - 2.Conditional-Formatting.xlsx

2 - Conditional Formatting.mp4

13:07

2 - Mathematical Functions

3 - Mathematical Functions Part1.mp4

06:44

3 - Mathematical-Functions-Part-1.xlsx

4 - Mathematical Functions Part2.mp4

04:38

4 - Mathematical-Functions-Part-2.xlsx

5 - Mathematical Functions Part3.mp4

06:51

5 - Mathematical-Functions-Part-3.xlsx

6 - Mathematical Functions Part4.mp4

05:22

6 - Mathematical-Functions-Part-4.xlsx

3 - Statistical Functions

7 - Statistical Functions Part1.mp4

10:55

7 - Statistical-Functions-Part-1.xlsx

8 - Statistical Functions Part2.mp4

09:00

8 - Statistical-Functions-Part-2.xlsx

9 - Statistical Functions Part3.mp4

08:29

9 - Statistical-Functions-Part-3.xlsx

10 - Statistical Functions Part4.mp4

08:08

10 - Statistical-Functions-Part-4.xlsx

4 - Text Functions

11 - Text Functions Part1.mp4

02:34

11 - Text-Functions-Part-1.xlsx

12 - Text Functions Part2.mp4

05:32

12 - Text-Functions-Part-2.xlsx

13 - Text Functions Part3.mp4

03:06

13 - Text-Functions-Part-3.xlsx

14 - Text Functions Part4.mp4

10:08

14 - Text-Functions-Part-4.xlsx

5 - Date and Time Function

15 - Date and Time Functions Part1.mp4

06:03

15 - Date-and-Time-Functions.xlsx

16 - Date and Time Functions Part2.mp4

07:27

6 - Lookup Functions Vlookup Hlookup Lookup Index and Match Function

17 - Lookup Functions Part1.mp4

09:33

17 - Vlookup-Hlookup-and-Lookup.xlsx

18 - Lookup Functions Part2.mp4

03:32

19 - Lookup Functions Part3.mp4

09:17

20 - Index-and-Match.xlsx

20 - Lookup Functions Part4.mp4

07:38

7 - Logical Functions

21 - 1.Logical-Function-Part-1.xlsx

21 - Logical Function Part1.mp4

06:25

22 - Logical Function Part2.mp4

10:41

23 - 2.Logical-Function-Part-2-and-3.xlsx

23 - Logical Function Part3.mp4

03:36

8 - Data analysis using Pivot Table

24 - Pivot Table Part1.mp4

14:42

24 - Pivot-Table.xlsx

25 - Pivot Table Part2.mp4

07:00

26 - Pivot Table Part3.mp4

10:15

9 - Data Cleaning and Analyzing Data in Excel

27 - 1.Sort-Filter-Find-and-Replace.xlsx

27 - Sort.mp4

04:33

28 - Filter Find and Replace.mp4

11:34

29 - 2.Text-to-column.xlsx

29 - Text to column.mp4

07:46

30 - 3.Flashfill.xlsx

30 - Flashfill.mp4

06:04

31 - 4.Remove-Duplicate.xlsx

31 - Remove Duplicate.mp4

02:39

32 - 5.Data-Validation.xlsx

32 - Data Validation.mp4

08:44

33 - 6.Advanced-Worksheet-Protection.xlsx

33 - Advanced Worksheet Protection.mp4

07:32

34 - 7.Consolidation.xlsx

34 - Consolidate.mp4

04:09

35 - 8.What-if-Analysis.xlsx

35 - What if Analysis.mp4

14:50

36 - 9.Forecast-Sheet.xlsx

36 - Forecast Sheet.mp4

05:54

37 - 10.Group-Ungroup-and-Subtotal.xlsx

37 - Group Ungroup and Subtotal.mp4

04:56

10 - Various types of Errors in Excel

38 - Common Errors in Excel.mp4

05:16

38 - Various-types-of-Errors-in-Excel.xlsx

Description

Mastering Excel: From Basics to Advanced Techniques

What You'll Learn?

Creating, formatting, and navigating Excel worksheets.
Building formulas, using functions, and understanding cell references.
Analyzing data with tools like sorting, filtering, and PivotTables.
Applying advanced functions like VLOOKUP, IF statements, and complex logical formulas.
Implementing data validation rules and ensuring data integrity.
Using goal seek and scenario analysis for decision-making.
Cleaning and transforming data for better insights.
Developing proficiency in Excel for various personal and professional tasks.
Building PivotTables for summarizing and analyzing large datasets.
Applying conditional formatting to highlight data patterns.
Entering and editing data efficiently.

Who is this for?

Business Professionals to enhance data analysis and reporting skills for better decision-making.

Administrative Assistants to manage data, schedules, and tasks efficiently.

Students to support academic work, assignments, and research projects.

Data Entry Personnel to improve accuracy and efficiency in data management.

Job Seekers to add a valuable skill to their resume for various industries.

What You Need to Know?

Basic computer literacy and familiarity with Microsoft Office suite.

A computer with Microsoft Excel installed.

Comfort with basic mathematical and data concepts.

Understanding of fundamental spreadsheet concepts.

Knowledge of Windows or Mac operating system basics.

Proficiency in using a keyboard and mouse.

Understanding of basic terminology like cells, rows, and columns.

Willingness to learn and practice new software skills.

More details

Description
Unlock the true potential of Microsoft Excel with our comprehensive Excel Mastery course. Whether you're an aspiring data analyst, a business professional, a student, or someone looking to enhance their spreadsheet skills, this course is designed to equip you with the tools and knowledge needed to navigate Excel's vast capabilities.
Starting with the fundamentals, you'll learn how to create, format, and manage worksheets and workbooks. You'll become adept at entering, editing, and organizing data efficiently. Discover the power of Excel's built-in functions and learn how to construct complex formulas, leveraging relative and absolute references to perform calculations with precision.
As you progress, you'll delve into the art of data visualization, creating various charts and graphs to bring your data to life. Learn the nuances of conditional formatting to highlight critical insights, and explore advanced techniques for sorting, filtering, and PivotTables that allow you to analyze large datasets effortlessly.
Our course doesn't stop at data analysisâ€”it empowers you to Collaborate effectively on shared workbooks, implement data validation to maintain accuracy, and delve into scenario analysis for strategic decision-making.
Whether you're aiming to enhance your professional skills or bolster your academic performance, this Excel Mastery course offers a comprehensive journey from foundational concepts to advanced strategies. By the end of the course, you'll have gained the confidence to tackle intricate data challenges, harnessing Excel as a powerful tool for data management, analysis, and informed decision-making.
Join us on this learning adventure and become a proficient Excel user, capable of transforming data into actionable insights. Enroll today and embark on your journey towards Excel mastery.
Who this course is for:
Business Professionals to enhance data analysis and reporting skills for better decision-making.
Administrative Assistants to manage data, schedules, and tasks efficiently.
Students to support academic work, assignments, and research projects.
Data Entry Personnel to improve accuracy and efficiency in data management.
Job Seekers to add a valuable skill to their resume for various industries.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Sumit Dwivedi

Instructor's Courses

I am currently working as an Assistant Professor at SGSITS, Indore (M.P.). I have more than 4 years of teaching experience. My field of expertise is Manufacturing Engineering, Material Science, and Statistical Quality Control. I am currently teaching engineering students. I am also involved in various research projects. I am still learning new things daily and keep myself updated.

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.