Главная
Study mode:
on
1
- Introduction
2
- Course Intro
3
- Excel 2021 vs Excel 365
4
- Launching Excel
5
- The Start Screen
6
- Exploring the Interface
7
- Ribbons, Tabs and Menus
8
- Backstage Area
9
- Quick Access Toolbar
10
- Useful Keyboard Shortcuts
11
- Getting Help
12
- Exercise 01
13
- Working with Templates
14
- Workbooks and Worksheets
15
- Saving Workbooks
16
- Entering and Editing Data
17
- Navigating and Selecting Cells, Rows and Columns
18
- Exercise 02
19
- Formulas and Functions Explained
20
- SUM Function
21
- COUNT Function
22
- AVERAGE Function
23
- MIN and MAX Function
24
- Handling Errors in Calculations
25
- Absolute vs Relative Referencing
26
- Autosum and Autofill Options
27
- Flash Fill
28
- Exercise 03
29
- What are Named Ranges
30
- Managing Named Ranges
31
- Using Named Ranges
32
- Exercise 04
33
- Applying Number Formats
34
- Applying Date and Time Formats
35
- Formatting Cells, Rows and Columns
36
- Format Painter
37
- Exercise 05
38
- Intermediate Course Introduction
39
- Improve Readability with Cell Styles
40
- Controlling Data Input
41
- Adding Navigation Buttons
42
- Logical Functions
43
- The IF Function
44
- Nested IFs
45
- The IFs Function
46
- Conditional IFs
47
- Multiple Criteria
48
- Error Handling
49
- Exercise 01
50
- VLookup Exact Match
51
- VLookup Approximate Match
52
- HLookup
53
- INDEX and MATCH
54
- XLookup and XMatch
55
- OFFSET Function
56
- INDIRECT Function
57
- Exercise 02
58
- Sorting on Multiple Columns
59
- Soring Using a Custom List
60
- SORT and SORTBY Functions
61
- Advanced Filter
62
- UNIQUE Function
63
- FILTER Function
64
- Exercise 03
65
- How Date and Times are Stored
66
- Custom Data and Time Formats
67
- Time and Date Functions
68
- WORKDAY and WORKDAY.INTL Functions
69
- NETWORKDAYS and NETWORKDAYS.INTL Functions
70
- DATEDIF
71
- EDATE and EOMONTH
72
- Advanced Course Introduction
73
- Exercise 01
74
- Dynamic Arrays
75
- Spill and Arrays
76
- Extract and Count Unique Entries
77
- Unique vs. Distinct
78
- Unique with Multiple Criteria
79
- Unique Values by Column
80
- SORT Function
81
- Horizontal Sort
82
- SORTBY Function
83
- Horizontal SORTBY
84
- Sequence and Unstacking Records
85
- Filter Function
86
- Using Filter with Logic Plus Operator
87
- Using Filter with Logic Asterisk Operator
88
- Using Filter with Logic Equals Operator
89
- Using Filter with Logic Minus Operator
90
- RANDARRAY and RANDBETWEEN
91
- XLookUp
92
- XMatch
93
- Exercise 02
94
- Two-way Lookups
95
- CHOOSE Function
96
- SWITCH Function
97
- Exercise 03
98
- Median and Mode
99
- Using LARGE and SMALL
100
- Ranking Data
101
- COUNTBLANK Function
102
- Exercise 04
103
- Rounding Values
104
- Specialized Rounding
105
- Aggregate Function
106
- Exercise 05
Description:
Master Microsoft Excel 2021 from beginner to advanced level in this comprehensive 12-hour course. Learn essential skills including launching Excel, exploring the interface, using ribbons and menus, and utilizing the Quick Access Toolbar. Progress through intermediate topics such as cell styles, data input, and navigation buttons. Dive into advanced concepts like dynamic arrays, two-way lookups, and specialized functions. Practice with included exercise files, covering a wide range of topics from basic formulas to complex data analysis techniques. Gain proficiency in logical functions, lookup functions, formatting, statistical analysis, and error handling. Follow along with timestamps to navigate different sections and tailor your learning experience to your skill level.

Excel Tutorial - Beginner to Advanced

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Computer Science #Information Technology #Data Management #Data Formatting
0:00 / 0:00
1 of 106

- Introduction