Excel (2021) Advanced

4.14 GB | 00:05:55 | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
1 - Introduction (17.11 MB)
55 - What are Macros (23.63 MB)
56 - Displaying the Developer Tab (14.83 MB)
57 - Creating a Basic Formatting Macro (109.1 MB)
58 - Running a Macro (66.32 MB)
59 - Assigning a Macro to a Button (68.84 MB)
60 - Creating Complex Macros (90.78 MB)
61 - Viewing and Editing the VBA Code (66.78 MB)
62 - What are Form Controls (15.63 MB)
63 - Adding Spinners and Check Boxes (29.89 MB)
64 - Adding a Combo Box (13.94 MB)
65 - What is Data Validation (20.99 MB)
66 - Restricting Data Entry to Whole Numbers (25.83 MB)
67 - Restricting Data Entry to a List (30.35 MB)
68 - Restricting Data Entry to a Date (28.5 MB)
69 - Restricting Data Entry to Specific Text Lengths (16.89 MB)
70 - Finding Invalid Data (13.61 MB)
71 - Editing and Deleting Data Validation Rules (28.21 MB)
72 - Working with Comments (38.55 MB)
73 - Printing Comments and Errors (49.75 MB)
74 - Sharing a Workbook (113.59 MB)
75 - Tracking Changes in a Workbook (85.34 MB)
76 - Working with Versions (94.61 MB)
77 - Sharing Files Via Email (29.53 MB)
78 - Importing and Exporting to a Text File (138.29 MB)
79 - Course Recap (39.98 MB)
2 - Customizing the Ribbon (64.72 MB)
3 - Customizing the Quick Access Toolbar (43.11 MB)
4 - Customizing the General and Formula Options (58.09 MB)
5 - Customizing the AutoCorrect Options (50.89 MB)
6 - Customizing the Save Defaults (26.07 MB)
7 - Customizing Advanced Excel Options (46.28 MB)
10 - Summarizing Data with AVERAGEIF (38.66 MB)
11 - Summarizing Data with COUNTIF (32.89 MB)
12 - Understanding the IF Function (67.75 MB)
13 - Evaluating Data with the AND Function (28.73 MB)
14 - Evaluating Data with the OR Function (74.86 MB)
15 - Creating a Nested IF Formula (177.59 MB)
16 - Using the IFS Function (69.35 MB)
17 - Nesting AND and OR Inside an IF Function (71.64 MB)
18 - Summarizing Data with MAXIFS and MINIFS (59.08 MB)
19 - Using the IFERROR Function (73.36 MB)
8 - Working with the Most Common Logical Functions (14.81 MB)
9 - Summarizing Data with SUMIF (159.5 MB)
20 - What are Lookup Functions (18.89 MB)
21 - Using VLOOKUP (103.32 MB)
22 - Using HLOOKUP (35.56 MB)
23 - Using VLOOKUP with TRUE (53.1 MB)
24 - Using HLOOKUP with TRUE (22.8 MB)
25 - Using the INDEX Function (74.65 MB)
26 - Using the MATCH Function (101.28 MB)
27 - Combining INDEX and MATCH (181.91 MB)
28 - Comparing Two Lists with VLOOKUP (43.16 MB)
29 - Comparing Two Lists with VLOOKUP and ISNA (76.26 MB)
30 - What are Text Functions (6.21 MB)
31 - Using CONCAT CONCATENATE and TEXTJOIN (99.06 MB)
32 - Using Text to Columns (26.87 MB)
33 - Using LEFT RIGHT and MID Functions (46.08 MB)
34 - Using UPPER LOWER and PROPER Functions (32.84 MB)
35 - Using the LEN Function (29.26 MB)
36 - Using the TRIM Function (40.27 MB)
37 - Using the SUBSTITUTE Function (27.96 MB)
38 - What are Date and Time Functions (9.86 MB)
39 - Using TODAY NOW and DAY Functions (27.25 MB)
40 - Using NETWORKDAYS and YEARFRAC Functions (53.04 MB)
41 - Using the DATEVALUE Function to Convert Text Dates (33.85 MB)
42 - Showing Formulas (35.12 MB)
43 - Tracing Precedents and Dependents (62.09 MB)
44 - Adding a Watch Window (66.79 MB)
45 - Error Checking (72.37 MB)
46 - Using the Scenario Manager (77.71 MB)
47 - Using Goal Seek (40.03 MB)
48 - Analyzing with Data Tables (24.08 MB)
49 - Understanding Protection (12.27 MB)
50 - Encrypting Files with Passwords (39.47 MB)
51 - Allowing Specific Worksheet Changes (33.53 MB)
52 - Adding Protection to Selected Cells (79.12 MB)
53 - Additional Protection Features (97.57 MB)
54 - Protecting the Structure of an Entire Workbook (29.4 MB)]
Screenshot