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

“Unreal Engine 5 Blueprint: Make your own 3D Platformer!” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

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

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

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

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