Microsoft Excel Tutorial - from Beginner to Advanced

Focused View

Programming Knowledge

10:19:59

112 View

1. Introduction to MS Excel.mp4

11:09

2. Organizing Data.mp4

11:25

3. Basic Excel Formulas Important Formulas for Beginners.mp4

10:39

4. How to use the Excel IF function.mp4

11:08

5. Pivot Tables in Excel How to Create a Pivot Table in Excel.mp4

10:13

6. Text Functions in Excel Excel TEXT Function - Formula and Examples.mp4

10:20

7. Cell Reference in Excel with Examples.mp4

11:08

8. Text to Columns in Excel How to Use Text-to-Columns in Excel.mp4

09:32

9. How to Use Paste Special + How to Use Speak Cells Feature in Excel.mp4

11:06

10. Custom List in Excel + Using Advanced Fill in Excel.mp4

10:23

11. Flash Fill in Excel + Series features.mp4

10:17

12. Nested IF, AND, IF ERROR Function ( Logical Functions in Excel).mp4

12:06

13. Comments and Custom Views.mp4

10:20

14. How to Make Charts and Graphs in Excel.mp4

10:58

15. Excel DATE function with examples + Mathematical Functions.mp4

11:38

16. How to Rotate Text in Cells in Excel + How to Print in Excel.mp4

10:35

17. How to use Header and Footer in MS Excel.mp4

10:28

18. Data validation in Excel.mp4

10:28

19. How to Record a Macro in Excel.mp4

11:22

20. Relative References in Excel.mp4

11:17

21. How to Make a Macro in Excel Write Macros in Excel.mp4

11:42

22. Name Array in MS Excel.mp4

10:33

23. How To Use VLOOKUP in Excel.mp4

09:58

24. Approximate Match and VLOOKUP rules.mp4

11:10

25. Consolidate Data in Excel Excel Consolidate Function.mp4

10:47

26. Count Functions in MS Excel.mp4

10:59

27. Single Criteria Statistical functions.mp4

10:44

28. Multiple Criteria Statistical Functions in Excel.mp4

10:48

29. How to use Index, Match, Lookup and HLookup in Excel.mp4

11:57

30. Protection Rules in MS Excel Protecting a Worksheets Format Excel.mp4

10:40

31. Create Hyperlinks in Excel Links in MS Excel.mp4

10:44

32. Data Sorting In MS Excel How to Sort Lists in Excel.mp4

10:26

33. Filtering Data How to Filter in Excel.mp4

10:45

34. Advanced Filters in MS Excel.mp4

10:28

35. Chart Shortcuts in MS Excel Create Excel Chart With Shortcut Keys.mp4

10:26

36. Combo Charts and Pie Charts in MS Excel.mp4

11:33

37. Spark Line Charts in MS Excel.mp4

10:23

38. Pivot Chart in MS Excel.mp4

11:01

39. Conditional Formatting in Excel Part 1.mp4

10:32

40. Conditional Formatting in Excel Part 2.mp4

10:26

41. Conditional Formatting for Icon Sets - How to use Icon Sets.mp4

08:43

42. Advanced Conditional Formatting Formulas in MS Excel.mp4

11:27

43. Customizing Pivot Tables Part 1.mp4

10:21

44. Customizing Pivot Tables Part 2.mp4

11:01

45. Pivot Table Item Slicers Excel Pivot Table Slicers.mp4

10:13

46. Slicer and Timeline over Pivot Table in MS Excel.mp4

10:39

47. Dependent Dropdown Lists in MS Excel.mp4

10:02

48. Summary Report in MS Excel How to Create an Excel Summary Report.mp4

10:29

49. Objects In Ms Excel Excel Worksheet Objects.mp4

10:12

50. Table vs Cell Range in MS Excel.mp4

10:33

51. Slicers on Charts in MS Excel Slicer Controlled Interactive Charts.mp4

10:11

52. How to Create a Linked Object in Microsoft Excel.mp4

10:24

53. Ctrl Shortcuts in MS Excel.mp4

10:19

54. Function Keys Shortcut In Microsoft Excel.mp4

09:33

55. Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel).mp4

11:03

56. Shift + Function Key shortcuts in MS Excel.mp4

10:32

57. Ctrl + Function Key Shortcuts In Ms Excel.mp4

11:10

58. Alt And Shift With Special Keys Shortcuts In Ms Excel.mp4

10:33

Description

"Master Microsoft Excel with Comprehensive Tutorials from Beginner to Advanced Level"

What You'll Learn?

Basic and advanced functions of Excel, including data entry, formatting, calculations, and formulas.
PivotTables, PivotCharts, and other advanced data analysis tools.
Automation techniques, such as Macros.
Tips and tricks for working with Excel more efficiently.

Who is this for?

Students, job seekers, and business professionals who want to improve their Excel skills.

Anyone who wants to learn Excel from scratch and build a strong foundation for future learning.

Those who want to learn advanced features of Excel and apply them to their work or personal projects.

More details

Description
This comprehensive Excel tutorial is designed to take you from a beginner to an advanced user. You'll start by learning the basics of Excel, including navigating the interface, creating and formatting spreadsheets, and using basic functions and formulas. As you progress through the course, you'll explore more advanced features, such as conditional formatting, data analysis, pivot tables, and macros.
Throughout the course, you'll have hands-on practice with real-world examples and exercises, which will help you build your skills and confidence. You'll also receive expert tips and tricks for optimizing your Excel workflow and streamlining your work.
By the end of the course, you'll be able to use Excel with ease and confidence, creating professional-grade spreadsheets and analyzing data with speed and accuracy. Whether you're a business professional, student, or just looking to expand your skillset, this Excel tutorial is the perfect way to take your abilities to the next level.

This comprehensive course takes you from beginner to advanced in Microsoft Excel. With over 10 hours of content, you'll learn how to organize data, use basic and advanced formulas, create pivot tables and charts, use text functions, and more. You'll also learn about conditional formatting, data validation, and protection rules, as well as how to create macros and use shortcuts to save time. With step-by-step instructions and real-world examples, this course will help you master Excel and improve your productivity. Whether you're a student, business professional, or anyone who works with data, this course is for you. Enroll now and start mastering Excel!
Who this course is for:
Students, job seekers, and business professionals who want to improve their Excel skills.
Anyone who wants to learn Excel from scratch and build a strong foundation for future learning.
Those who want to learn advanced features of Excel and apply them to their work or personal projects.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Programming Knowledge

Instructor's Courses

ProgrammingKnowledge YouTube channel is currently the fastest-growing programming channel on YouTube with more than 1 million subscribers. The video tutorials cover a range of different programming topics. ProgrammingKnowledge offers tons of video tutorials on top programming languages.If you find these tutorials useful, please share with your friends on Facebook twitter and Google plus. Let's make these videos help as many students as possible.

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.