Master Excel 2024: Complete Beginner to Pro Course
Focused View
5:59:49
1 - Create and open Workbook.mp4
04:24
2 - Tabs and Ribbon.mp4
09:14
3 - Errors Function.mp4
12:10
4 - AND and OR Function.mp4
04:25
5 - NOT Function.mp4
02:43
6 - XOR Function.mp4
04:59
7 - SWITCH Function.mp4
04:35
8 - CELL Function.mp4
03:55
9 - IFS Functions.mp4
05:06
10 - Nesting IF Functions.mp4
03:47
11 - Use IF function to calculate letter grades in Excel.mp4
03:23
12 - Use IFS function to calculate letter grades in Excel.mp4
03:47
13 - Use Filter Function in Excel.mp4
02:09
14 - DATE Function.mp4
05:02
15 - DATEIF Function.mp4
05:19
16 - EDATE Function.mp4
03:20
17 - EOMONTH Function.mp4
01:49
18 - DateValue Function.mp4
03:57
19 - TODAY and NOW Function.mp4
02:56
20 - Convert Time Hours Minutes and Seconds.mp4
04:31
21 - Count Function.mp4
09:27
22 - Round Function.mp4
08:56
23 - Sum Function SUM SUMIF SUMIFS SUMPRODUCT.mp4
11:09
24 - Average Function.mp4
07:58
25 - Subtotal Function.mp4
10:51
26 - Power Function.mp4
03:30
27 - Mod Function.mp4
02:52
28 - INT TRUNC Function.mp4
06:09
29 - MAX MIN MAXA and MINA Function.mp4
05:33
30 - Find and Replace.mp4
06:58
31 - LEN Formulas.mp4
05:10
32 - MID Formulas.mp4
05:03
33 - Rept Formulas.mp4
10:21
34 - Split Formulas.mp4
05:05
35 - Text Formulas.mp4
04:56
36 - Trim Formulas.mp4
03:58
37 - Show Gridlines.mp4
02:16
38 - INDEX Function.mp4
08:13
39 - MATCH Function.mp4
09:38
40 - EXACT Function.mp4
05:40
41 - VLOOKUP APPROXIMATE MATCH Function.mp4
08:02
42 - VLOOKUP Function.mp4
05:12
43 - HLOOKUP Function.mp4
06:42
44 - XLOOKUP Function.mp4
04:52
45 - Exact match vs Approximate match.mp4
08:04
46 - Hyperlink.mp4
04:52
47 - How to import data web to excel.mp4
02:42
48 - Use DETECTLANGUAGE formula in google spread sheets.mp4
01:37
49 - How to convert number to word.mp4
04:17
50 - Dynamic Drop Down List.mp4
05:09
51 - Dependent dropdown List.mp4
05:42
52 - Charts Graphs.mp4
10:51
53 - How to Use Pivot Tables.mp4
06:01
54 - Sort Function.mp4
03:48
55 - Filter Function.mp4
02:17
56 - Merge and Separate data using flash fill.mp4
07:02
57 - Freeze panes.mp4
02:34
58 - Split panes.mp4
01:58
59 - Rename and Color Worksheets.mp4
02:01
60 - Add and Delete Worksheets.mp4
02:57
61 - Hide and Unhide Worksheets.mp4
02:35
62 - Move and Copy Worksheets.mp4
02:32
63 - Worksheet Groups.mp4
01:51
64 - Proetect Worksheet.mp4
05:04
65 - Protect Workbook.mp4
02:48
66 - Lock Individual Cells and Protect Sheets In Excel.mp4
02:00
67 - Sharing Excel Workbook with Multiple Users.mp4
05:03
68 - Headers and footers.mp4
04:35
69 - Page settings.mp4
02:42
70 - Page break view.mp4
02:19
71 - Print selection.mp4
03:28
72 - Set print area.mp4
02:58
More details
Course Overview
This comprehensive Excel course takes you from absolute beginner to advanced user, covering essential functions, data management, and productivity-boosting techniques to master spreadsheet tasks efficiently.
What You'll Learn
- Master core functions like VLOOKUP, XLOOKUP, and nested IF statements
- Create dynamic dropdown lists and professional charts
- Automate data processing with advanced Excel tools
Who This Is For
- Beginners wanting to build strong Excel foundations
- Professionals seeking to enhance their data skills
- Anyone needing to streamline spreadsheet workflows
Key Benefits
- No prior experience required - start from scratch
- Learn time-saving tricks used by Excel experts
- Gain practical skills for real-world applications
Curriculum Highlights
- Essential functions (SUM, COUNT, AVERAGE)
- Advanced lookup and data management
- Data visualization and worksheet protection
Focused display
Category
- language english
- Training sessions 72
- duration 5:59:49
- Release Date 2025/05/25
