Master Microsoft Excel: From Beginner to Pro!

سرفصل های دوره

Unlock the full potential of Microsoft Excel and become a valuable asset in any data-driven environment today!

1. Introduction

1. Introduction

2. Covering the basics of Excel

1. Excel Home screen

2. The interface inside of Excel

3. Excel workbook and status bar

4.1 Shortcuts Mac.pdf

4.2 Shortcuts Windows.pdf

4. Excel shortcuts and how to use them

5. Excel Basics Quiz.html

3. Formulas and Text editing

1. Working with Excel spredsheet titles

2. Numberic data and how we can work with it in Excel

3. Working with Date values and date formating in Excel

4. Cell references and how they work in Excel

5. How to work with formulas

6. Absolute and relative references in Excel

7. Formulas Quiz.html

4. Basic functions in Excel

1. The SUM() function

2. How MIN(), MAX() and AVARAGE() functions works

3. What is the Adjacent error in Excel

4.1 Top-30-useful-excel-functions.pdf

4. Lets learn the CEILING(), FLOOR() and COUNT() functions

5. Auto sum in Excel

6. Excel AutoFill

7. Excel Functions Quiz.html

5. Excel data formatting

1. Formatting our fonts

2. Working with background colors

3. Adding borders and border-styles

4. Adding our currency

5. Formatting percentage in Excel

6. Excels format painter

7. Creating custom styles in Excel

8. Creating some formatting based on conditions

9. Merging cells together

10. Excel Formatting Quiz.html

6. Tweak an worksheet in Excel

1. Moving data inside an worksheet or between workbooks

2. Editing the width and height of cells

3. Adding Removing rows and columns

4. Hiding and showing rows or columns

5. Copying or moving an Excel worksheet

6. Removing a worksheet or changing a name of a worksheet

7. Worksheet Tweaks Quiz.html

7. Working with Charts, Images and Shapes in Excel

1. Adding Excel shapes to our worksheet

2. Adding images into our worksheet

3. How we can work with Excel smartArt in our worksheet

4. Creating an line chart in excel and playing around with the chart ribbon

5. Changing the data in our line-chart and moving the line chart

6. Changing the chart type and adding a bit of formating

7. Chart, Images and Shapes Quiz.html

8. Excel templates and how to work with them

1. Excel template into

2. Working with and creating templates

3. Excel Templates Quiz.html

9. Great job! You now have a Microsoft Excel Foundation!

1. Lets do a recap on what we have done

10. Working with lists inside of Excel

1.1 Employment.xlsx

1. The structure of an Excel list

2. Multi-Level and Single-Level list sorting

3. Custom sort and filtering a list in Excel

4. Finding and removing duplicates

5. Convert a list to a table

6. Excel List Quiz.html

11. List functions in Excel

1.1 division sales new 200.xlsx

1. The DSUM() function

2.1 division sales new 200.xlsx

2. DSUM() With AND-statements or OR-statements

3. The DCOUNT() function

4. The DAVERAGE() function

5. List Functions Quiz.html

12. Import Export Data

1.1 names data.xlsx

1. Export data to a text file in Excel

2. Import data from a text file in Excel

3. Import Export Quiz.html

13. Data validation in Excel

1.1 Leads.xlsx

1. Data validation List

2.1 Excel email validation formula.txt

2. Excel Email validation

3. Excel date validation

4. Excel Text validation

5. Data Validation Quiz.html

14. Working with large sets of data

1. Grouping column and rows together

2. Freeze Panes

3. Working with printing options for large sets of data

15. PivotTables

1.1 perfume sales.xlsx

1. The power of PivotTables

2. Building our first PivotTable

3. Grouping and Formatting Data in our PivotTable

4. PivotCharts

5. Filtering data in our PivotTable

6. Styling our slicer

7. Modifying sourceData for our PivotTable

8. PivotTable Quiz.html

16. WOW! You are now a midpro in excel!

1. Lets do a small recap on what we have done

17. Protecting out workbook or worksheet

1. Protecting cells in our worksheet

2. Adding a password to our workbook and protecting the workbook structure

3. Excel Protection Quiz.html

18. Conditional functions in Excel

1.1 Sales competition 2024.xlsx

1. Excels name ranges

2. The IF() function

3. Nesting functions inside of Excel

4. The COUNTIFS() function

5. The SUMIFS() function

6. Conditional Functions Quiz.html

19. Textbased functions in Excel

1.1 products.xlsx

1. The Left(), Right(), Mid() and Len() functions

2. Using IF(), LEN() and RIGHT() functions together

3. Using the SEARCH() and CONCATENATE() functions

4. Textbased Functions Quiz.html

20. Lookup functions in Excel

1.1 employee sheet vlookup.xlsx

1. The VLOOKUP() function

2. IFERROR() function

3. Working with absolute values in our lookup functions

4. The HLOOKUP() function

5. The MATCH() and INDEX() functions

6. Using MATCH() AND INDEX() together

21. Excel Automations with Macros

1. Introduction into Excel macros

2. Creating our first macro

3. Saving our workbook with our macro

4.1 Macro.xlsx

4. How to edit our macro with VBA

22. Becoming a master in the What if tools inside of Excel

1.1 CarLoan.xlsx

1. Working with the PMT() function and Goalseek tool

2.1 shipping cost.xlsx

2. The solver tool

3. Data Tables

4.1 Scenarios.xlsx

4. Creating Scenarios

23. Excel Auditing

1. Dependents and Precendents tracing in Excel

2. Show Formulas and Evaluate Formulas

3. Error Checking

4. Watch Windows in Excel

24. Wrapping up the course

1. Congratulations! Youre now a master in Excel!

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy