Microsoft Excel 365 Advanced

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

Unlock the power of advanced Excel 365 features and boost your data analysis and productivity skills.

1 - Introduction

1 - Course Introduction

2 - WATCH ME Essential Information for a Successful Training Experience

3 - Course-Files.zip

4 - Exercise-Files.zip

5 - Exercise 01

2 - Dynamic Array Formulas

6 - What are Dynamic Array Functions

7 - Introduction to Spills and Arrays

8 - Extract and Count Unique Entries

9 - Unique vs Distinct

10 - Extract Multiple Unique Columns

11 - Extract Unique Values by Column

12 - The SORT Function

13 - The SORT Function Horizontal Sort

14 - The SORTBY Function

15 - The SORTBY Function Horizontal SORTBY

16 - The SEQUENCE Function

17 - The FILTER Function

18 - FILTER with Logic Operator OR

19 - FILTER with Logic Operator AND

20 - FILTER with Logic Operator Both or Neither Criteria

21 - FILTER with Logic Operator One or the Other but Not Both

22 - RANDARRAY and RANDBETWEEN

23 - Use XLOOKUP to Perform Complex Lookups

24 - The XMATCH Function

25 - Exercise 02

3 - Advanced Lookup and Reference Functions

26 - Lookups with Multiple Criteria

27 - Lookups with Duplicate Values

28 - Exercise 03

4 - Create Your Own Functions

29 - The LET Function

30 - Create Your Own Formulas with LAMBDA

31 - Exercise 04

5 - Power Pivot

32 - Create a Data Model in Power Pivot

33 - Create Relationships Between Tables

34 - Add Calculated Columns

35 - Build a PivotTable from Multiple Sources

36 - Exercise 05

6 - Working with Power Query

37 - Import Data Using Power Query

38 - Clean Data with Power Query

39 - Combine Files from a Folder

40 - Add More Files to the Data Model and Refresh

41 - Exercise 06

7 - Advanced PivotTables and Pivot Charts

42 - Create a Custom PivotTable Style

43 - Apply Custom Number Formatting

44 - Sorting Using a Custom Lists

45 - Create Report Filter Pages

46 - Adjust Slicer Settings

47 - Lock Workbooks but not Slicers

48 - Add a Calculated Field

49 - Create a Calculated Item

50 - Use GETPIVOTDATA with Data Validation

51 - Create Dynamic Pivot Chart Labels

52 - Exercise 07

8 - Form Controls and Checkboxes

53 - Introduction to Form Controls

54 - Combo Box Select from a List

55 - Check Box CheckUncheck Option

56 - NEW Checkboxes

57 - Option Button Choose an Option

58 - Spin Button Move Up and Down a List

59 - List Box Select from a List of Items

60 - Scroll Bar Scroll Through a List

61 - Exercise 08

9 - Macros and VBA

62 - Use Macros to Automate Tasks

63 - Record Save and Run Macros

64 - Record Macros with Relative Referencing

65 - MultiStep Macros

66 - The VBA Editor

67 - Assign Macros to Buttons

68 - Create a Custom Macro Ribbon

69 - Generate VBA Code with Copilot

70 - Exercise 09

10 - AI Tools Microsoft Copilot and ChatGPT

71 - Introduction to Copilot

72 - Generate Sample Excel Datasets with AI

73 - Ask Questions and Get Help

74 - Copilot for Excel 365 requires licence

75 - Exercise 10

11 - Course Close

76 - Course Close

235,000 تومان

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

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

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

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