Главная
Study mode:
on
1
- Introduction
2
- Improve Readability with Cell Styles
3
- Controlling Data Input
4
- Adding Navigation Buttons
5
- Logical Functions
6
- The IF Function
7
- Nested IFs
8
- The IFs Function
9
- Conditional IFs
10
- Multiple Criteria
11
- Error Handling
12
- Exercise 01
13
- VLOOKUP Exact Match
14
- VLOOKUP Approximate Match
15
- HLOOKUP Function
16
- INDEX and MATCH
17
- XLookup and XMatch
18
- OFFSET Function
19
- INDIRECT Function
20
- Exercise 02
21
- Sorting on Multiple Columns
22
- Sorting Using a Custom List
23
- SORT and SORTBY Functions
24
- Advanced Filter
25
- UNIQUE Function
26
- FILTER Function
27
- Exercise 03
28
- How Dates and Times are Stored
29
- Custom Date and Time Formats
30
- Time and Date Functions
31
- WORKDAY and WORKDAY.INT Functions
32
- NETWORKDAYS and NETWORKDAYS.INT Functions
33
- DATEDIF Function
34
- EDATE and EOMONTH Functions
35
- Exercise 04
36
- Importing Data into Excel
37
- Removing Blank Rows, Cells, and Duplicate Entries
38
- Changing Case and Removing Spaces
39
- Splitting Up Data Using Text to Columns
40
- Splitting Up Data Using Text Functions
41
- Using Flash Fill
42
- CONCAT Function
43
- Formatting Data as Table
Description:
Expand your Excel skills in this comprehensive 5-hour tutorial for intermediate users. Learn to utilize logical functions like IF, COUNTIF, and SUMIF, as well as lookup functions such as VLOOKUP, HLOOKUP, INDEX, and MATCH. Master advanced filtering techniques, custom date formats, and data manipulation tools. Explore new functions like UNIQUE, CONCAT, and XLOOKUP. Practice with downloadable exercise files to reinforce your learning. Discover how to improve spreadsheet readability, control data input, and add navigation buttons. Dive into topics such as nested IFs, error handling, sorting methods, and working with dates and times. Learn to import, clean, and format data efficiently. By the end of this tutorial, gain a solid foundation in Excel 2021/365, enhancing your ability to analyze and present data effectively.

Microsoft Excel Intermediate Training - Excel Tutorial Class

Simon Sez IT
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Computer Science #Algorithms #Data Sorting #Data Science #Data Processing #Data Filtering #Data Manipulation
0:00 / 0:00
1 of 43

- Introduction