Главная
Study mode:
on
1
- Course Introduction
2
- Exercise 01
3
- Design Better Spreadsheet
4
- Improve Readability with Cell Styles
5
- Control Data Input: Data Validation
6
- Add Navigation to a Workbook
7
- Create a Summary Sheet
8
- Use Forms to Input Data Quickly
9
- Exercise 02
10
- Logical Functions: Basic Recap
11
- Logical Functions: AND and OR
12
- Nested IF Statements
13
- The IFS Function
14
- Conditional IF: COUNTIFS and SUMIFS
15
- Error Handling with IFERROR and IFNA
16
- Use Logical Functions with Conditional Formatting
17
- Exercise 03
18
- VLOOKUP: Exact vs Approx Match
19
- HLOOKUP
20
- Flexible Lookups: INDEX and MATCH
21
- Modern Lookups: XLOOKUP and XMATCH
22
- Lookups with Duplicates
23
- Lookups with the CHOOSE Function
24
- The SWITCH Function
25
- Exercise 04
26
- Sort on Multiple Columns
27
- Sort with a Custom List
28
- The SORT and SORTBY Functions
29
- The FILTER Function
30
- Extract and Sort Unique Values
31
- Exercise 05
32
- Find Duplicates with Conditional Formatting
33
- Find Duplicates with Formulas
34
- Exercise 06
35
- Use Mean, Median and Mode
36
- The LARGE and SMALL Functions
37
- RANK and RANK Average
38
- The SUBTOTAL and AGGREGATE Functions
39
- Exercise 07
40
- ROUND Values
41
- Special Rounding
42
- Exercise 08
43
- Custom Formatting Explained
44
- Practical Uses of Custom Formatting
45
- Advanced Conditional Formatting
46
- Exercise 09
47
- Conclusion
Description:
Embark on a comprehensive 4-hour Excel tutorial designed to elevate your spreadsheet skills to an intermediate level. Master essential techniques for better spreadsheet design, improved readability, and efficient data input control. Learn to create summary sheets, implement logical functions, and utilize advanced lookup methods like VLOOKUP, INDEX and MATCH, and XLOOKUP. Explore data manipulation techniques including sorting, filtering, and handling duplicates. Dive into statistical analysis with functions such as MEAN, MEDIAN, and MODE. Enhance your Excel proficiency with custom formatting, advanced conditional formatting, and practical exercises throughout the course. Perfect for those looking to refine their Excel skills and boost productivity in spreadsheet management.

Microsoft Excel 365 Intermediate Training - 4-Hour Tutorial

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Computer Science #Algorithms #Data Sorting #Data Processing #Data Filtering #Mathematics #Statistics & Probability #Statistical Analysis #Information Technology #Data Management #Data Validation
0:00 / 0:00
1 of 47

- Course Introduction