Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

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

Become a Microsoft Excel 2021/365 expert with this three-course bundle

1. Excel 2021 Beginner Introduction

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Excel 2021 Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Course Files.zip

4. DOWNLOAD ME Course Instructor Files.html

5. Excel 2021 vs Excel for Microsoft 365

6. Section Quiz.html

2. Beginner Getting Started in Excel 2021

1. Launching Excel

2. The Start Screen

3. Exploring the Interface

4. Understanding Ribbons, Tabs and Menus

5. The Backstage Area

6. Customizing the Quick Access Toolbar

7. Useful Keyboard Shortcuts

8. Getting Help

9. Exercise 01

10. Section Quiz.html

3. Beginner Creating You First Excel Spreadsheet

1. Working with Excel Templates

2. Working with Workbooks and Worksheets

3. Saving Workbooks and Worksheets

4. Entering and Editing Data

5. Navigating and Selecting Cells, Rows and Columns

6. Exercise 02

7. Section Quiz.html

4. Beginner Introduction to Excel Formulas and Functions

1. Formulas and Functions Explained

2. Performing Calculations with the SUM Function

3. Counting Values and Blanks

4. Finding the Average with the AVERAGE Function

5. Working with the MIN and MAX Functions

6. Handling Errors in Formulas

7. Absolute vs Relative Referencing

8. Autosum and AutoFill

9. Flash Fill

10. Exercise 03

11. Section Quiz.html

5. Beginner Using Named Ranges

1. What are Named Ranges

2. Creating Named Ranges

3. Managing Named Ranges

4. Using Named Ranges in Calculations

5. Exercise 04

6. Section Quiz.html

6. Beginner Formatting Numbers and Cells

1. Applying Number Formats

2. Applying Date and Time Formats

3. Formatting Cells, Rows and Columns

4. Using Format Painter

5. Exercise 05

6. Section Quiz.html

7. Beginner Formatting Worksheets

1. Working with Rows and Columns

2. Deleting and Clearing Cells

3. Aligning Text and Numbers

4. Applying Themes and Styles

5. Exercise 06

6. Section Quiz.html

8. Beginner Working with Excel Lists

1. How to Structure a List

2. Sorting a List (Single-Level Sort)

3. Sorting a List (Multi-Level Sort)

4. Sorting Using a Custom List (Custom Sort)

5. Using Autofilter to Filter a List

6. Format as a Table

7. Creating Subtotals in a List

8. Exercise 07

9. Section Quiz.html

9. Beginner Moving and Linking to Data

1. Using Cut and Copy

2. Paste Options

3. Pasting from the Clipboard

4. Linking to Other Worksheets and Workbooks

5. 3D Referencing

6. Inserting Hyperlinks to Worksheets

7. Exercise 08

8. Section Quiz.html

10. Beginner An Introduction to Intermediate Formulas

1. Looking up Information with VLOOKUP

2. VLOOKUP Approximate Match

3. Error Handling Functions

4. Basic Logical Functions (IF, AND, OR)

5. Making Decisions with IF Statements

6. Cleaning Data using Text Functions

7. Working with Time and Date Functions

8. Exercise 09

9. Section Quiz.html

11. Beginner Analyzing Data with Charts

1. Choosing the Correct Chart Type

2. Presenting Data with Charts

3. Formatting Charts

4. Exercise 10

5. Section Quiz.html

12. Beginner Conditional Formatting

1. Highlighting Cell Values

2. Data Bars

3. Color Scales

4. Icon Sets

5. Exercise 11

6. Section Quiz.html

13. Beginner Inserting Items into a Spreadsheet

1. Inserting Pictures

2. Inserting Shapes and Text Boxes

3. Inserting Icons and 3D Models

4. Creating Diagrams using SmartArt

5. Inserting Screenshots

6. Inserting Comments

7. Exercise 12

8. Section Quiz.html

14. Beginner Working with Views and Zoom

1. Workbook Views

2. Using Zoom in a Worksheet

3. Arranging Workbooks and Worksheets

4. Freezing Panes

5. Exercise 13

6. Section Quiz.html

15. Beginner Page Layout and Print Options

1. Setting Margins and Orientation

2. Setting and Clearing the Print Area

3. Inserting Page Breaks

4. Setting Print Titles and a Background

5. Inserting Headers and Footers

6. Printing a Workbook

7. Exercise 14

8. Section Quiz.html

16. Beginner Finalizing the Spreadsheet

1. Protecting Workbooks and Worksheets

2. Spell Checking

3. Inspecting the Workbook

4. Saving the Workbook in Different Formats

5. Sharing a Workbook

6. Exercise 15

7. Section Quiz.html

17. Excel 2021 Beginner Course Close

1. Course Close

18. Excel 2021 Intermediate Introduction

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Excel 2021 Intermediate Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Intermediate Course Files.zip

4. DOWNLOAD ME Course Instructor Files.html

5. Section Quiz.html

19. Intermediate Designing Better Spreadsheets

1. The Golden Rules of Spreadsheet Design

2. Improving Readability with Cell Styles

3. Controlling Data Input

4. Adding Navigation Buttons

5. Section Quiz.html

20. Intermediate Making Decisions with Logical Functions

1. Logical Functions (AND, OR, IF)

2. The IF Function

3. Nested IFs

4. The IFS Function

5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)

6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)

7. Error Handling with IFERROR and IFNA

8. Exercise 01

9. Section Quiz.html

21. Intermediate Looking Up Information

1. Looking Up Information using VLOOKUP (Exact Match)

2. Looking Up Information using VLOOKUP (Approx Match)

3. Looking Up Information Horizontally Using HLOOKUP

4. Performing Flexible Lookups With INDEX And MATCH

5. Using XLOOKUP and XMATCH

6. The OFFSET Function

7. The INDIRECT Function

8. Exercise 02

9. Section Quiz.html

22. Intermediate Advanced Sorting and Filtering

1. Performing Sorts on Multiple Columns

2. Sorting Using a Custom List

3. The SORT and SORTBY Functions

4. Using the Advanced Filter

5. Extracting Unique Values - The UNIQUE Function

6. The FILTER Function

7. Exercise 03

8. Section Quiz.html

23. Intermediate Working with Date and Time

1. Understanding How Dates are Stored in Excel

2. Applying Custom Date Formats

3. Using Date and Time Functions

4. Using the WORKDAY and WORKDAY.INT Functions

5. Using the NETWORKDAYS and NETWORKDAYS.INT Function

6. Tabulate Date Differences with the DATEDIF Function

7. Calculate Dates with EDATE and EOMONTH

8. Exercise 04

9. Section Quiz.html

24. Intermediate Preparing Data for Analysis

1. Importing Data into Excel

2. Removing Blank Rows, Cells and Duplicates

3. Changing Case and Removing Spaces

4. Splitting Data using Text to Columns

5. Splitting Data using Text Functions

6. Splitting or Combining Cell Data Using Flash fill

7. Joining Data using CONCAT

8. Formatting Data as a Table

9. Exercise 05

10. Section Quiz.html

25. Intermediate PivotTables

1. PivotTables Explained

2. Creating a PivotTable from Scratch

3. Pivoting the PivotTable Fields

4. Applying Subtotals and Grand Totals

5. Applying Number Formatting to PivotTable Data

6. Show Values As and Summarize Values By

7. Grouping PivotTable Data

8. Formatting Error Values and Empty Cells

9. Choosing a Report Layout

10. Applying PivotTable Styles

11. Exercise 06

12. Section Quiz.html

26. Intermediate Pivot Charts

1. Creating a Pivot Chart

2. Formatting a Pivot Chart - Part 1

3. Formatting a Pivot Chart - Part 2

4. Using Map Charts

5. Exercise 07

6. Section Quiz.html

27. Intermediate Adding Interaction to PivotTables and Charts

1. Inserting and Formatting Slicers

2. Inserting Timeline Slicers

3. Connecting Slicers to Pivot Charts

4. Updating PivotTable Data

5. Exercise 08

6. Section Quiz.html

28. Intermediate Interactive Dashboards

1. What is a Dashboard

2. Assembling a Dashboard - Part 1

3. Assembling a Dashboard - Part 2

4. Assembling a Dashboard - Part 3

5. Exercise 09

6. Section Quiz.html

29. Intermediate Formula Auditing

1. Troubleshooting Common Errors

2. Tracing Precedents and Formula Auditing

3. Exercise 10

4. Section Quiz.html

30. Intermediate Data Validation

1. Creating Dynamic Drop-down Lists

2. Other Types of Data Validation

3. Custom Data Validation

4. Exercise 11

5. Section Quiz.html

31. Intermediate WhatIf Analysis Tools

1. Goal Seek and the PMT Function

2. Using Scenario Manager

3. Data Tables One Variable

4. Data Tables Two Variables

5. Exercise 12

6. Section Quiz.html

32. Excel 2021 Intermediate Course Close

1. Course Close

33. Excel 2021 Advanced Introduction

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Excel 2021 Advanced Exercise Files.zip

3. DOWNLOAD ME Course Exercise Files.html

4.1 Excel 2021 Advanced Course Files.zip

4. DOWNLOAD ME Course Files.html

5. Exercise 01

6. Section Quiz.html

34. Advanced Dynamic Arrays

1. What are Dynamic Arrays

2. Introduction to Spills and Arrays

3. Extract and Count Unique Entries

4. Unique vs Distinct

5. Extract Unique Values with Multiple Criteria

6. Extract Unique Values by Column

7. The SORT Function

8. The SORT Function - Horizontal SORT

9. The SORTBY Function

10. The SORTBY Function - Horizontal SORT

11. Simple SEQUENCE and Unstacking Records

12. The FILTER Function

13. FILTER with Logic + Operator (OR)

14. FILTER with Logic Operator (AND)

15. FILTER with Logic = Operator (Both or Neither)

16. FILTER with Logic - Operator (One or the Other)

17. Using RANDARRAY and RANDBETWEEN to Randomize Data

18. Using XLOOKUP to Perform Complex Lookups

19. Using XMATCH

20. Exercise 02

21. Section Quiz.html

35. Advanced Advanced Lookup and Reference Functions

1. Performing 2-Way Lookups

2. Using the CHOOSE Function

3. Using the SWITCH Function

4. Exercise 03

5. Section Quiz.html

36. Advanced Statistical Functions

1. Using MEDIAN, MODE.SNGL and MODE.MULT

2. Using LARGE and SMALL

3. Ranking Data with Sorting using RANK.EQ and RANK.AVG

4. The COUNTBLANK Function

5. Exercise 04

6. Section Quiz.html

37. Advanced Math Functions

1. Rounding Values using ROUND, ROUNDUP and ROUNDDOWN

2. Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH)

3. Using the AGGREGATE Function

4. Exercise 05

5. Section Quiz.html

38. Advanced New Functions - LET and LAMBDA

1. The LET Function

2. The LAMBDA Function

3. Exercise 06

4. Section Quiz.html

39. Advanced Advanced PivotTables and Pivot Charts

1. Creating a Custom PivotTable Style

2. Applying Custom Number Formatting

3. Sorting Using Custom Lists

4. Applying Multiple Filters to Data

5. Adjusting Slicer Settings

6. Locking Workbooks but not Slicers

7. Creating a Calculated Field

8. Creating a Calculated Item

9. Solve Order

10. GETPIVOTDATA

11. Using GETPIVOTDATA - Dependent Data Validation Lists

12. Creating a Dynamic Pivot Chart Title

13. Adding a Dynamic Series to a Pivot Chart

14. Adding Totals to a Stacked Column Chart

15. Exercise 07

16. Section Quiz.html

40. Advanced Form Controls

1. Introduction to Form Controls

2. Combo Box - Select from a List

3. Check Box - CheckUncheck Option

4. Option Button - Choose an Option

5. Spin Button - Move Up and Down a List

6. List Box - Select from a List of Items

7. Scroll Bar - Scroll Through a List

8. Exercise 08

9. Section Quiz.html

41. Advanced Working with Power Query

1. Power Query Overview

2. Importing Data Using Get and Transform

3. The Power Query Editor

4. Combining Files

5. Transforming Files

6. Loading Files into Excel

7. Exercise 09

8. Section Quiz.html

42. Advanced Forecasting

1. Getting Forecast Data with FRED

2. Creating a Linear Sales Forecast

3. Creating a Sales Forecast with Seasonality

4. Adding Confidence Levels

5. Using Forecast Sheets

6. Exercise 10

7. Section Quiz.html

43. Advanced Macros and VBA

1. Using Macros to Automate Tasks

2. Recording, Saving and Running Macros

3. Recording a Macro with Relative Referencing

4. Multi-step Macros

5. The VBA Editor

6. Assigning Macros to Buttons

7. Creating a Custom Macro Ribbon

8. Exercise 11

9. Section Quiz.html

44. Advanced Practical Excel - Advanced Formulas

1. Finding the Last Occurrence of a Value

2. Finding the Closest Value

3. Extract Data from the Middle of a String

4. Exercise 12

5. Section Quiz.html

45. Excel 2021 Advanced Course Close

1. Course Close

139,000 تومان

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

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

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

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