Excel: Master Microsoft Excel do Basic to Advanced Excel

Focused View

Excel Zero To Hero (from basic to advanced microsoft excel)

12:59:54

198 View

1 - Before You Start

1 - All files that will be used in training.html

1 - All files that will be used in training.txt

1 - Basic-presentation.pptx

1 - Countries-by-GDP.pdf

1 - Feb-2008.csv

1 - IT-Spend-Analysis-Sample-no-PV.xlsx

1 - Inventory.v2.xlsx

1 - Inventory.v3.xlsx

1 - Jan-2008.csv

1 - Mar-2008.csv

1 - Retail-Analysis-Sample-no-PV.xlsx

1 - Service-price-list1.pdf

1 - Simple-Gantt-chart1.v2.xlsx

1 - Simple-Gantt-chart1.xlsx

1 - UnPivot.xlsx

1 - data.csv

2 - Enter the arena Introduction to Excel

2 - Introduction to Excel.mp4

06:33

3 - Excel Interface Navigation.mp4

14:32

4 - Working with Workbooks.mp4

10:22

5 - Basic Data Entry.mp4

11:08

6 - Customizing Quick Access Toolbar.mp4

06:37

7 - Basic Formulas and Functions.mp4

14:33

8 - Cell Referencing.mp4

20:54

9 - Formatting Cells.mp4

13:48

3 - Goose egg Excel Basics

10 - Managing Worksheets.mp4

05:35

11 - Copying and Moving Data.mp4

11:23

12 - Using Find and Replace.mp4

11:27

13 - Printing and Page Layout.mp4

07:01

14 - How Functions Work.mp4

11:19

15 - Functions and Formulas.mp4

09:40

16 - Data Sorting and Filtering.mp4

12:08

17 - Working with Tables.mp4

13:51

18 - Cell Styles and Themes.mp4

05:34

4 - Unsong Hero Intermediate Excel

19 - Conditional Formatting.mp4

16:57

20 - Charts and Graphs.mp4

20:45

21 - Freeze Panes and Split View.mp4

07:19

22 - Removing Duplicates.mp4

03:57

23 - Creating Data Validation Lists.mp4

07:14

24 - Flash Fill.mp4

03:30

25 - Day to Day functions.mp4

18:28

26 - Nested Functions.mp4

13:21

27 - Text Functions.mp4

06:56

28 - Date and Time Functions.mp4

11:23

29 - Lookup and Reference Functions.mp4

15:51

30 - Protecting and Sharing Workbooks.mp4

08:16

31 - Evaluate formula.mp4

07:04

5 - Dashing Hero Advanced Excel Topics

32 - Subtotals and Outlines.mp4

04:01

33 - Using PivotTables.mp4

11:45

34 - PivotCharts.mp4

06:18

35 - PivotTable Excel Data Model.mp4

09:12

36 - Data Validation.mp4

20:06

37 - Data Cleaning Techniques.mp4

20:09

38 - Sorting with Multiple Criteria.mp4

05:27

39 - Using Filters and Slicers in PivotTables.mp4

06:46

40 - Advanced Charting.mp4

13:42

41 - LAMBDA Function.mp4

06:44

42 - The magic LET function.mp4

09:57

43 - Sparklines.mp4

07:25

44 - Data Analysis Tools.mp4

08:10

45 - Advanced Conditional Formatting.mp4

06:29

46 - Dynamic Arrays and New Functions.mp4

13:33

47 - Dynamic Arrays and New Functions.mp4

11:09

6 - Veteran Hero Expert Excel Topics

48 - Using Named Ranges.mp4

12:22

49 - Data types.mp4

08:15

50 - Using Form Controls.mp4

13:52

51 - Importing Data.mp4

10:33

52 - Using the Watch Window.mp4

04:16

53 - Linking and Embedding.mp4

12:53

54 - Automate Office Scripts.mp4

10:36

55 - Statistical Functions.mp4

07:12

56 - Creating and Using Data Models.mp4

14:24

57 - Using Power Query for Data Transformation.mp4

21:08

58 - Power Pivot Basics.mp4

16:48

59 - Creating PivotTable Calculated Fields.mp4

09:39

60 - Creating Heat Maps and Data Bars.mp4

14:36

61 - Array Formulas.mp4

08:39

62 - Consolidating Data.mp4

15:23

63 - Creating Dashboards.mp4

27:09

64 - Automating Tasks with Macros.mp4

12:19

7 - Tools of the trade Excel Tips and Tricks

65 - Excel Integration with Other Apps.mp4

08:22

66 - Keyboard Shortcuts.mp4

10:06

67 - Selection Pane.mp4

08:06

68 - Troubleshooting Common Issues.mp4

19:17

69 - Excel AddIns.mp4

08:56

70 - Check accessibility.mp4

07:37

8 - Course WrapUp

71 - Review and Practice.mp4

09:07

Description

Master microsoft excel from Basic to Super Advanced with practical lessons and real projects in just 13 hours.

What You'll Learn?

PAY ONLY 9.99: Enter the Code EXCEL-HERO and get the course for a much lower price.
EXCEL INTERFACE NAVIGATION: Understand and explore all components of Excel's interface, including tabs, menus, and toolbars.
WORKING WITH WORKBOOKS: Learn to efficiently create, save, open, and manage multiple workbooks to organize your data and projects effectively.
DATA ENTRY: Master basic and advanced techniques for data input and manipulation, including quick entry methods and quality control.
FORMULAS AND FUNCTIONS: Explore from simple formulas to advanced functions like LAMBDA and LET, empowering you to automate complex calculations.
WORKSHEET MANAGEMENT: Learn how to add, move, copy, and organize worksheets to structure your data and analysis efficiently.
CHARTS AND PIVOTTABLES: Create and customize charts and PivotTables to visualize data effectively, aiding in clear and insightful analysis.
CHARTS AND PIVOTTABLES: Create and customize charts and PivotTables to visualize and analyze your data clearly and effectively.

Who is this for?

This course is ideal for beginners looking to learn Excel from basic to advanced techniques.

It is also recommended for intermediate users seeking to enhance their skills in the tool.

Professionals aiming to increase their efficiency using Excel in daily work will find significant benefits.

Students and data analysts can leverage this course to develop essential data analysis and automation skills.

What You Need to Know?

There are no prerequisites for this course. All are welcome

More details

Description
The "Excel - Zero to Hero" course is a comprehensive and detailed program designed to transform anyone from an absolute beginner in Excel to an advanced and confident user. With 71 lessons spread across 8 sections, totaling 13 hours of intensive content, this course covers all essential and advanced areas of Excel, providing students with a solid foundation and practical skills to tackle any challenge using this powerful tool.
What You Will Learn
Excel Interface Navigation: Understand all components of the Excel interface, including toolbars, menus, and customization options.
Working with Workbooks: Learn how to create, save, open, and manage workbooks efficiently.
Data Entry: Basic and advanced data entry techniques, including cell formatting and cell referencing.
Basic and Advanced Formulas and Functions: From simple formulas to complex functions like LAMBDA and LET, this course covers everything you need to know to calculate and analyze data.
Managing Worksheets: How to add, move, copy, and organize worksheets within a workbook.
Conditional Formatting and Cell Styles: Apply conditional formatting and styles to highlight important data and improve visualization.
Charts and PivotTables: Creating and customizing charts, as well as using PivotTables to analyze large datasets.
Data Validation and Cleaning: Techniques to ensure data accuracy and methods for cleaning data to prepare it for analysis.
Data Analysis Tools: Using advanced analysis tools like Power Query, Power Pivot, and Excel data models.
Automating Tasks with Macros: Learn to automate repetitive tasks in Excel using macros.
Excel Integration with Other Applications: Explore how Excel integrates with other Microsoft Office applications and external tools.
Keyboard Shortcuts and Productivity Tips: Practical tips to improve your efficiency when using Excel.
Course Benefits
Comprehensive Content: Covers everything from basics to advanced functionalities of Excel.
Hands-on Training: Practical lessons with downloadable example files, allowing you to follow along and practice what you are learning.
Lifetime Access: Once enrolled, you have lifetime access to the course content, allowing you to revisit the lessons whenever needed.
Certificate of Completion: Upon finishing the course, you will receive a certificate of completion that can be added to your resume or LinkedIn profile.
Student Support: Access to an active student community and instructor support to answer questions and share knowledge.
Target Audience
This course is ideal for:
Excel Beginners: People who have never used Excel before and want to start from scratch.
Intermediate Users: Those who already have some experience with Excel and want to enhance their skills.
Business Professionals: Anyone who uses Excel at work and wants to increase their efficiency and productivity.
Students: Students who need Excel for their studies and academic projects.
Data Analysts: Professionals who work with data analysis and need advanced Excel skills.
Enroll now and transform your Excel skills from "Zero to Hero"!
Who this course is for:
This course is ideal for beginners looking to learn Excel from basic to advanced techniques.
It is also recommended for intermediate users seeking to enhance their skills in the tool.
Professionals aiming to increase their efficiency using Excel in daily work will find significant benefits.
Students and data analysts can leverage this course to develop essential data analysis and automation skills.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Zero To Hero (from basic to advanced microsoft excel)

Instructor's Courses

Excel Master is a company dedicated to teaching and consulting in the field of data analysis and spreadsheet automation, specializing in making Excel learning an accessible and practical experience for all knowledge levels.With a solid background and years of market experience, the instructor at Excel Master is known for the ability to simplify advanced concepts and a commitment to providing high-quality content. The classes are recognized for being clear, objective, and filled with practical examples, making it easier for students to understand and apply Excel tools in their daily work.On the Udemy platform, Excel Master offers a comprehensive and detailed course that equips students to master Excel, from basic to advanced levels, with automation and data analysis techniques that enhance productivity and efficiency in the workplace.

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.