Главная
Study mode:
on
1
- Introduction
2
- Exercise 01
3
- Dynamic Arrays
4
- Spill and Arrays
5
- Extract and Count Unique Entries
6
- Unique vs. Distinct
7
- Unique with Multiple Criteria
8
- Unique Values by Column
9
- SORT Function
10
- Horizontal Sort
11
- SORTBY Function
12
- Horizontal SORTBY
13
- Sequence and Unstacking Records
14
- Filter Function
15
- Using Filter with Logic Plus Operator
16
- Using Filter with Logic Asterisk Operator
17
- Using Filter with Logic Equals Operator
18
- Using Filter with Logic Minus Operator
19
- RANDARRAY and RANDBETWEEN
20
- XLookUp
21
- XMatch
22
- Exercise 02
23
- Two-way Lookups
24
- CHOOSE Function
25
- SWITCH Function
26
- Exercise 03
27
- Median and Mode
28
- Using LARGE and SMALL
29
- Ranking Data
30
- COUNTBLANK Function
31
- Exercise 04
32
- Rounding Values
33
- Specialized Rounding
34
- Aggregate Function
35
- Exercise 05
Description:
Elevate your Microsoft Excel 2021/365 skills to an advanced level with this comprehensive 3.5-hour tutorial. Master dynamic array functions, spill handling, and advanced formulas like XLOOKUP and XMATCH. Learn to differentiate between Unique and Distinct, utilize various sort functions, and implement advanced filtering techniques. Explore creating flexible lookup formulas, employing statistical functions for data ranking, and calculating MEDIAN and MODE. Practice with downloadable exercise files to reinforce your learning. Navigate through topics such as array manipulation, advanced sorting and filtering, lookup functions, data analysis, and specialized rounding techniques. Perfect for those seeking to enhance their Excel proficiency and streamline complex data management tasks.

Microsoft Excel Advanced Excel Training Course

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #XLOOKUP
0:00 / 0:00
1 of 35

- Introduction