Master Excel and Solve 500 Problems (Beginner - Advanced)
Loại khoá học: Tin học văn phòng
Learning MS Excel Functions, Tools, Dashboards, Power Pivot, Power Query and VBA with Practice.
Mô tả
This MS Excel course covers all levels - from beginner to advanced. The course includes 500 chronologically structured video tutorials in which student can learn how different complexity level problems can be solved using various functions and tools. Every video tutorial has its own worksheet where problem definition is explained in detail.
The main point the course covers are:
Formulas and functions - the course is highly concentrated on formulas and functions. We start from the most basic mathematical formulas, like how to write 2+2=4 in a cell. In later video tutorials, as the problems become more and more complex, students will learn how to write nested functions and some of the solutions even require nesting up to 10 different functions inside each other;
Tools - covered up to 20 different excel tools that help to clean and arrange the data, create user templates, visualize the data, etc.;
Charts and Dashboards - the course includes creating different types of charts and building dashboards to visualize the data using Power Query, Power Pivot and Pivot Tables;
VBA Macros - included videos on how to record macros, write VBA codes manually, build user forms, build codes that run on specific triggers and creating user defined functions using VBA.
In addition to the points listed above, the course includes some of the most commonly used shortcuts, using $ signs in functions, working with different worksheets at the same time and much more.
As an additional material, glossary supporting file is provided where students can find the list of all 500 videos with the indication of:
Problem complexity;
Functions/tools to be used to solve the problem;
Suggestion on every video whether the problem should be solved independently (Do it yourself) or should the user watch the video and solve the problem along with instructor (Watch video).
This file makes it easy for the users to navigate through the course and find the videos they are interested in.
Let the practice begin!
Bạn sẽ học được gì
Solve easy, medium and difficult problems using functions;
Use various tools to clean and arrange the data;
Build automated dashboards using Power Pivot, Power Query and Pivot Tables;
Record and write VBA codes to automate operations;
Master shortcuts.
Yêu cầu
- No technical experience needed. You will learn everything you need in this course.
Nội dung khoá học
17 sections
Tips for Using Course
04:52
Section 1 Introduction
00:39
S01P01 - General overview
07:45
S01P02 - Freeze Panes, Gridlines, Formula Bar, Headings, Split Window, Comments
20:07
S01P03 - Freeze Panes, Gridlines, Headings, Split Window, Comments
09:03
S01P04 - Sort
02:58
S01P05 - Sort
07:59
S01P06 - Sort
06:05
S01P07 - Sort
05:04
S01P08 - Filter
05:21
S01P09 - Filter
06:13
S01P10 - Filter, Add current selection to filter, * symbol
06:47
S01P11 - Filter
02:12
S01P12 - Filter
03:16
S01P13 - Remove Duplicates
06:21
S01P14 - Remove Duplicates, Sort
07:11
S01P15 - Hide, Unhide
08:49
S01P16 - Filter, Unhide
08:52
S01P17 - Insert Row, Delete Row
10:00
S01P18 - Delete Row, Sort
02:35
S01P19 - Group
08:20
S01P20 - Group, Freeze Panes
09:42
S01P21 - Find, Replace
09:21
S01P22 - Replace, * symbol
07:59
S01P23 - Replace, Format cells
04:25
S01P24 - Replace, Format Cells, Find in comments
12:26
S01P25 - Delete Comments, Go to Special, Filter
09:46
S01P26 - Delete Row, Filter, Go to Special
06:01
S01P27 - Sort, Remove Duplicates
08:13
S01P28 - Sort, Remove Duplicates
17:42
S01P29 - Horizontal Sort
08:14
S01P30 - Hyperlink
07:14
Section 2 Introduction
01:28
C02P01 - Introduction to formulas: mathematical calculation
15:50
C02P02 - Mathematical calculation
04:34
C02P03 - Mathematical calculation
03:13
C02P04 - Mathematical calculation
03:09
C02P05 - Mathematical calculation
03:57
C02P06 - Mathematical calculation
03:35
C02P07 - Mathematical calculation
05:26
C02P08 - Mathematical calculation
06:19
C02P09 - Introduction to Absolute and Relative references, $ signs
08:59
C02P10 - Absolute and Relative references, $ signs
04:49
C02P11 - Absolute and Relative references, $ signs
08:44
C02P12 - Absolute and Relative references, $ signs
07:52
C02P13 - Absolute and Relative references, $ signs
05:00
C02P14 - Absolute and Relative references, $ signs
06:30
C02P15 - Absolute and Relative references, $ signs
05:37
C02P16 - Absolute and Relative references, $ signs
08:48
C02P17 - Absolute and Relative references, $ signs
08:04
C02P18 - Copy + Paste special
06:55
C02P19 - Copy + Paste special
07:43
C02P20 - Copy + Paste special
08:12
C02P21 - Copy + Paste special
07:39
C02P22 - Copy + Paste special
06:16
C02P23 - Copy + Paste special
10:20
C02P24 - Copy + Paste special
05:39
C02P25 - Copy + Paste special
04:46
C02P26 - Copy + Paste special
05:09
C02P27 - Copy + Paste special
04:09
C02P28 - Copy + Paste special
03:19
C02P29 - Copy + Paste special
06:53
C02P30 - Copy + Paste special
04:49
Section 3 Introduction
00:37
C03P01 - SUM
12:37
C03P02 - SUM, AVERAGE
13:12
C03P03 - SUM, AVERAGE
06:24
C03P04 - SUM, AVERAGE, $ signs
05:44
C03P05 - SUM, AVERAGE, $ signs
13:06
C03P06 - SUM, reference cells from other worksheets
12:34
C03P07 - SUM, reference cells from other worksheets
09:44
C03P08 - SUM, working on multiple worksheets at the same time
06:59
C03P09 - AVERAGE, working on multiple worksheets at the same time
04:39
C03P10 - working on multiple worksheets at the same time
09:28
C03P11 - SUM, reference cells from other worksheets
06:22
C03P12 - COUNT
05:25
C03P13 - COUNT, COUNTA, COUNTBLANK
09:35
C03P14 - COUNT, SUM
06:57
C03P15 - COUNT, reference cells from other worksheets
08:35
C03P16 - COUNT, reference cells from other worksheets
08:02
C03P17 - COUNT
03:43
C03P18 - COUNTBLANK
02:40
C03P19 - SUM, COUNT, COUNTA
06:20
C03P20 - SUM, COUNT, COUNTA, filter
09:52
C03P21 - SUM, COUNT, COUNTA, sort
08:51
C03P22 - MIN, MAX, SUM AVERAGE
10:35
C03P23 - MIN, MAX
07:52
C03P24 - MIN, MAX, reference cells from other worksheets
07:00
C03P25 - MIN, MAX, reference cells from other worksheets
09:56
C03P26 - SUM, ABS
07:46
C03P27 - ABS, Paste Special
05:12
C03P28 - PRODUCT
06:09
C03P29 - PRODUCT, $ signs
07:41
C03P30 - AVERAGE, reference cells from other worksheets, power operator ^
09:22
Section 4 Introduction
00:34
C04P01 - & symbol
05:31
C04P02 - CONCATENATE
03:45
C04P03 - CONCATENATE / & symbol
06:39
C04P04 - SUM, AVERAGE, CONCATENATE / & symbol
14:17
C04P05 - LEFT, RIGHT
06:26
C04P06 - LEFT, RIGHT
09:50
C04P07 - LEFT, CONCATENATE / & symbol
04:42
C04P08 - FIND / SEARCH
11:14
C04P09 - FIND
05:44
C04P10 - MID
03:18
C04P11 - LEN
03:35
C04P12 - LEN, SUM
04:11
C04P13 - RIGHT, LEN
06:24
C04P14 - LEFT, RIGHT, LEN, FIND
14:02
C04P15 - MID, FIND
15:23
C04P16 - LEFT, MID, FIND, CONCATENATE / & symbol
10:24
C04P17 - REPLACE
04:02
C04P18 - REPLACE, RIGHT
05:44
C04P19 - REPLACE, RIGHT, FIND
12:52
C04P20 - SUBSTITUTE
05:38
C04P21 - SUBSTITUTE
07:42
C04P22 - LEN, SUBSTITUTE
07:36
C04P23 - LEN, SUBSTITUTE, LEFT, FIND
12:11
C04P24 - LEN, SUBSTITUTE, SUM
05:57
C04P25 - LEN, SUBSTITUTE
09:08
C04P26 - TRIM
02:52
C04P27 - SUBSTITUTE, TRIM
08:16
C04P28 - SUBSTITUTE, TRIM, CONCATENATE / & symbol
05:01
C04P29 - SUBSTITUTE, TRIM
11:19
C04P30 - SUBSTITUTE, FIND
07:15
C04P31 - SUBSTITUTE, FIND, MID
08:38
Section 5 Introduction
00:43
C05P01 - UPPER, LOWER, PROPER
04:37
C05P02 - PROPER, TRIM
03:49
C05P03 - LEFT, FIND, UPPER, MID, SUBSTITUTE
11:24
C05P04 - REPT
03:22
C05P05 - REPT, COUNT
03:18
C05P06 - REPT
05:24
C05P07 - REPT, CONCATENATE / & symbol
11:42
C05P08 - N, T
03:15
C05P09 - CONCAT
04:19
C05P10 - TEXTJOIN
04:42
C05P11 - TEXTJOIN
04:03
C05P12 - Text to Columns
04:47
C05P13 - Text to Columns
03:40
C05P14 - Text to Columns
12:55
C05P15 - Text to Columns
05:29
C05P16 - Text to Columns
04:54
C05P17 - Text to Columns
04:41
C05P18 - Text to Columns
03:08
C05P19 - Text to Columns
04:54
C05P20 - Text to Columns
04:16
C05P21 - Flash Fill
03:26
C05P22 - Flash Fill
02:23
C05P23 - Flash Fill
05:49
C05P24 - Convert to Number, SUM
04:44
C05P25 - VALUE, SUM
03:08
C05P26 - VALUE, MID, FIND, SUM
06:21
C05P27 - VALUE, MID, FIND, SUM, Filter, Select Visible Cells
10:34
C05P28 - FORMULATEXT
04:26
C05P29 - FORMULATEXT, VALUE, MID, FIND, SUM
06:42
C05P30 - FORMULATEXT, VALUE, MID, FIND, SUM
11:53
Section 6 Introduction
00:58
C06P01 - Mathematical calculation
10:05
C06P02 - Mathematical calculation
04:12
C06P03 - Mathematical calculation
01:40
C06P04 - DATE
05:17
C06P05 - DATE
04:58
C06P06 - DATE
06:25
C06P07 - DAY, MONTH, YEAR
02:56
C06P08 - DATE, MONTH, DAY
04:11
C06P09 - DAY, MONTH, YEAR, DATE, EDATE
06:16
C06P10 - EOMONTH
04:13
C06P11 - EOMONTH
03:25
C06P12 - TODAY
05:07
C06P13 - TODAY, Filter, Select Visible Cells
07:22
C06P14 - TODAY, EOMONTH, EDATE, $ signs
05:54
C06P15 - TEXT
03:49
C06P16 - TEXT
11:48
C06P17 - TEXT, CONCATENATE / & symbol
06:36
C06P18 - WEEKDAY
04:08
C06P19 - WEEKDAY
07:30
C06P20 - WORKDAY.INTL
05:05
C06P21 - WORKDAY.INTL
05:12
C06P22 - WORKDAY.INTL
03:59
C06P23 - WORKDAY.INTL, CONCAT
04:31
C06P24 - NETWORKDAYS.INTL
07:10
C06P25 - NETWORKDAYS.INTL
06:29
C06P26 - NETWORKDAYS.INTL
06:26
C06P27 - NETWORKDAYS.INTL, TODAY
05:27
C06P28 - TIME
04:54
C06P29 - TIME
05:02
C06P30 - HOUR, MINUTE, SECOND
02:47
C06P31 - Mathematical calculation
03:49
Section 7 Introduction
00:48
C07P01 - Comparison operators
07:39
C07P02 - IF
06:20
C07P03 - IF
06:41
C07P04 - Comparison operators, SUM
06:47
C07P05 - IF
04:36
C07P06 - Double IF
09:26
C07P07 - Double IF
07:05
C07P08 - Double IF
10:49
C07P09 - OR
05:55
C07P10 - OR
04:31
C07P11 - IF, OR
06:55
C07P12 - IF, OR
09:00
C07P13 - Double IF, OR
10:41
C07P14 - IF, OR, YEAR
08:05
C07P15 - Double IF, OR, YEAR
08:44
C07P16 - Double IF, OR
10:57
C07P17 - AND
03:30
C07P18 - AND
05:40
C07P19 - AND, OR
05:49
C07P20 - IF, AND
05:22
C07P21 - IF, AND
08:30
C07P22 - IF, AND
08:54
C07P23 - IF, AND, OR, YEAR, MONTH
08:27
C07P24 - Double IF, AND
08:32
C07P25 - Double IF, AND
14:27
C07P26 - Double IF, AND, OR
14:43
C07P27 - Double IF, AND, OR, YEAR
14:43
C07P28 - Double IF, AND, OR, YEAR
14:35
C07P29 - Double IF, AND, OR, YEAR
06:53
Section 8 Introduction
01:00
C08P01 - LARGE, SMALL
06:44
C08P02 - RANK.AVG, RANK.EQ
08:54
C08P03 - SUBTOTAL, AGGREGATE
12:09
C08P04 - SUBTOTAL, AGGREGATE, Filter
12:43
C08P05 - SUBTOTAL, AGGREGATE, Filter, Group
13:28
C08P06 - SUBTOTAL, AGGREGATE, Filter
07:01
C08P07 - ROUND, ROUNDUP, ROUNDDOWN
11:54
C08P08 - SUMIFS
06:03
C08P09 - SUMIFS
11:50
C08P10 - SUMIFS
08:42
C08P11 - SUMIFS
11:50
C08P12 - SUMIFS with reference on different worksheet
10:12
C08P13 - SUMIFS horizontal
10:03
C08P14 - Name Manager
07:37
C08P15 - Name Manager, SUM, AVERAGE
06:50
C08P16 - Name Manager, SUMIFS
08:50
C08P17 - Name Manager, SUMIFS with * symbol
06:19
C08P18 - Name Manager, AVERAGEIFS
03:56
C08P19 - Name Manager, AVERAGEIFS, YEAR
04:05
C08P20 - Name Manager, AVERAGEIFS with > & < symbols
09:41
C08P21 - Name Manager, COUNTIFS
05:24
C08P22 - Name Manager, COUNTIFS with > & < symbols
04:03
C08P23 - Name Manager, MINIFS, MAXIFS
04:18
C08P24 - Name Manager, MINIFS with > & < symbols
05:11
C08P25 - Name Manager, MAXIFS with * symbol
04:07
C08P26 - Name Manager, SUMIFS, MAXIFS
06:40
C08P27 - SUMPRODUCT
06:42
C08P28 - SUMPRODUCT
04:41
C08P29 - SUMPRODUCT
12:39
C08P30 - SUMPRODUCT
08:00
C08P31 - Name Manager, SUMPRODUCT with * symbol
05:12
C08P32 - Name Manager, SUMPRODUCT with * symbol
05:19
C08P33 - Name Manager, SUMPRODUCT with * symbol
04:53
Section 9 Introduction
00:33
C09P01 - EXACT, PROPER
04:21
C09P02 - EXACT, SUMPRODUCT
11:16
C09P03 - IFERROR
03:34
C09P04 - IFERROR
02:15
C09P05 - IFS, IFERROR
07:56
C09P06 - IFS, IFERROR, AND
07:54
C09P07 - IFS, IFERROR, OR
04:56
C09P08 - IFS, IFERROR, OR, AND, MONTH
10:37
C09P09 - SWITCH
07:42
C09P10 - SWITCH, AND
05:49
C09P11 - SWITCH, OR
04:37
C09P12 - SWITCH, OR, AND
09:37
C09P13 - LAMBDA
09:36
C09P14 - LAMBDA
04:20
C09P15 - LAMBDA
05:04
C09P16 - LAMBDA, IF
09:12
C09P17 - LAMBDA, IFERROR, IFS
13:38
C09P18 - SCAN, LAMBDA
12:14
C09P19 - SCAN, LAMBDA, IF
04:51
C09P20 - SCAN, LAMBDA, IF, SUM
05:07
C09P21 - REDUCE, SCAN, LAMBDA
06:56
C09P22 - REDUCE, LAMBDA, SEQUENCE, TRIM, SUBSTITUTE
09:32
C09P23 - REDUCE, LAMBDA, SEQUENCE, TRIM, SUBSTITUTE, CHAR
12:32
C09P24 - REDUCE, LAMBDA, SUBSTITUTE, CHAR
04:59
C09P25 - LET, IF
07:11
C09P26 - LET, SUMIFS, IFS
09:24
C09P27 - LET, SUMIFS, IFS, IFERROR
11:17
C09P28 - Form Control, IF
10:01
C09P29 - Form Control, IF
10:39
C09P30 - Form Control, LET, SUMIFS, IF, IFS
12:17
Section 10 Introduction
00:46
C10P01 - VLOOKUP, HLOOKUP
11:04
C10P02 - VLOOKUP, HLOOKUP
08:16
C10P03 - LOOKUP
05:04
C10P04 - LOOKUP
04:56
C10P05 - LET, SUMIFS, IFERROR, LOOKUP
09:39
C10P06 - LOOKUP
10:09
C10P07 - LOOKUP
05:45
C10P08 - MATCH, VLOOKUP
06:26
C10P09 - MATCH
04:18
C10P10 - INDEX
08:27
C10P11 - INDEX, MATCH
13:41
C10P12 - INDEX, MATCH
06:45
C10P13 - INDEX, MATCH
09:15
C10P14 - XLOOKUP
07:23
C10P15 - XLOOKUP
06:26
C10P16 - XLOOKUP
10:49
C10P17 - XLOOKUP
05:36
C10P18 - XLOOKUP
12:48
C10P19 - XLOOKUP
05:53
C10P20 - INDIRECT, ADDRESS
07:11
C10P21 - INDIRECT, ADDRESS
06:15
C10P22 - INDIRECT, ADDRESS, ROW
08:28
C10P23 - INDIRECT, ADDRESS, ROW
07:09
C10P24 - INDIRECT, ADDRESS, ROW, COLUMN, Combo Box
13:28
C10P25 - INDIRECT, ADDRESS, MATCH
09:29
C10P26 - OFFSET
05:40
C10P27 - SUM, OFFSET
05:34
C10P28 - SUM, OFFSET
07:07
C10P29 - INDEX, MATCH, XLOOKUP, OFFSET
11:10
C10P30 - SUM, OFFSET, MATCH
09:12
C10P31 - SUM, OFFSET
10:03
Section 11 Introduction
00:47
C11P01 - Data Validation whole number
05:24
C11P02 - Data Validation whole number, date, decimal
05:34
C11P03 - Data Validation text length
03:03
C11P04 - Data Validation text length, IF
05:46
C11P05 - Data Validation text length, VLOOKUP
13:10
C11P06 - Data Validation list
02:47
C11P07 - Data Validation list, Remove Duplicates
07:02
C11P08 - Data Validation list, OFFSET, MATCH
12:23
C11P09 - Data Validation list, OFFSET, MATCH, COUNTA
13:22
C11P10 - Data Validation list, OFFSET, MATCH, COUNTA
12:03
C11P11 - Data Validation error text
03:06
C11P12 - Data Validation error types
03:48
C11P13 - Data Validation, AND
10:50
C11P14 - Data Validation, MIN, MAX, XLOOKUP
09:48
C11P15 - Conditional Formatting cells values
05:27
C11P16 - Conditional Formatting cells values
06:20
C11P17 - Conditional Formatting cells values
03:52
C11P18 - Conditional Formatting duplicate and unique values
04:12
C11P19 - Conditional Formatting color scale
03:34
C11P20 - Conditional Formatting data bar
05:14
C11P21 - Conditional Formatting icon set
07:32
C11P22 - Conditional Formatting, comparison operator
08:08
C11P23 - Conditional Formatting, comparison operator
05:54
C11P24 - Conditional Formatting, comparison operator, Data Validation
08:28
C11P25 - Conditional Formatting, comparison operator, Data Validation, AND
06:22
C11P26 - Conditional Formatting, comparison operator, MAX
05:41
C11P27 - Conditional Formatting, comparison operator, MAX
05:49
C11P28 - Conditional Formatting, comparison operator, MAX, AND
05:26
C11P29 - Conditional Formatting, comparison operator, WEEKDAY
06:48
C11P30 - Conditional Formatting, comparison operator, WEEKDAY, Check Box
08:06
Section 12 Introduction
00:49
C12P01 - DSUM
07:02
C12P02 - DSUM
05:27
C12P03 - DSUM
09:08
C12P04 - DSUM
06:01
C12P05 - DSUM
06:40
C12P06 - DSUM
08:54
C12P07 - DCOUNTA
10:04
C12P08 - DCOUNTA
09:10
C12P09 - DSUM, DAVERAGE
07:29
C12P10 - Advanced Filter
05:45
C12P11 - Advanced Filter
04:42
C12P12 - Advanced Filter
03:22
C12P13 - Advanced Filter
02:42
C12P14 - Advanced Filter
03:42
C12P15 - Array functions: SUM
08:07
C12P16 - Array functions: SUM
03:30
C12P17 - Array functions: SUM
05:05
C12P18 - Array functions: SUM
06:46
C12P19 - Array functions: SUM
08:06
C12P20 - Array functions: MAX
08:26
C12P21 - Array functions: SUM
05:50
C12P22 - Array functions: SUM
06:38
C12P23 - Array functions: SUM, SUMIFS
07:15
C12P24 - Array functions: SUM, SUMIFS, YEAR
06:39
C12P25 - UNIQUE
05:04
C12P26 - UNIQUE, TRANSPOSE, SUMIFS
05:11
C12P27 - FILTER
03:44
C12P28 - FILTER
14:17
C12P29 - FILTER
08:26
C12P30 - FILTER, YEAR
10:44
C12P31 - SORT
04:23
C12P32 - SORT, UNIQUE, FILTER
04:37
Section 13 Introduction
00:38
C13P01 - Column chart
04:30
C13P02 - Column chart
05:07
C13P03 - Pie chart
04:31
C13P04 - Pie chart, UNIQUE, SUMIFS
04:43
C13P05 - Column chart
03:17
C13P06 - Column chart, Data Validation
18:51
C13P07 - Line chart
03:41
C13P08 - Line chart, TRANSPOSE, UNIQUE, SORT, Array SUM, YEAR, VALUE
11:53
C13P09 - Combo chart
04:18
C13P10 - Combo chart, secondary axis
04:42
C13P11 - Waterfall chart
07:29
C13P12 - Waterfall chart
10:55
C13P13 - Sparkline
03:17
C13P14 - SmartArt product list
04:25
C13P15 - SmartArt process
08:31
C13P16 - SmartArt organizational structure
05:53
C13P17 - Pivot Table
09:16
C13P18 - Pivot Table
07:50
C13P19 - Pivot Table
05:14
C13P20 - Pivot Table, Slicer
08:08
C13P21 - Pivot Table, Timeline
04:01
C13P22 - Pivot Table, Slicer, Timeline
13:07
C13P23 - Pivot Table
04:41
C13P24 - Pivot Table % values
03:45
C13P25 - Pivot Table % values
03:55
C13P26 - Pivot Chart
04:51
C13P27 - Pivot Chart, Slicer
04:26
C13P28 - Pivot Chart, Pivot Table, Slicer, Timeline, Dashboard
01:03:08
C13P29 - Pivot Chart, Pivot Table, Slicer, Timeline, Dashboard
47:00
Section 14 Introduction
00:32
C14P01 - SUMIFS
06:17
C14P02 - SUMIFS, &
06:08
C14P03 - SUMIFS, VLOOKUP
05:54
C14P04 - SUMIFS, INDEX, MATCH
07:34
C14P05 - SUM, SUBTOTAL, OFFSET, IF, ROW
14:03
C14P06 - SUMIFS, Check Box, Conditional Formatting, Sparklines
13:52
C14P07 - CONCAT, COUNTIFS, MATCH, Filter
16:41
C14P08 - CONCAT, COUNTIFS, INDEX, MATCH, LARGE
11:09
C14P09 - SUM, OFFSET
08:57
C14P10 - SUMIFS, OFFSET, MATCH
13:16
C14P11 - SUMIFS, OFFSET, MATCH
16:45
C14P12 - SUMIFS, OFFSET, MATCH
17:06
C14P13 - SUMIFS, OFFSET, INDIRECT, ADDRESS
12:30
C14P14 - SORT, UNIQUE, FILTER, OFFSET, INDIRECT, ADDRESS
15:19
C14P15 - UNIQUE, TRANSPOSE, LET, SUMIFS, IF, OFFSET, MATCH
24:01
C14P16 - OFFSET, MATCH, Name Manager, Geography
12:39
Section 15 Introduction
00:44
C15P01 - Power Query, Change Type, Merge Columns, Add Index Column, Reorder Col.
30:19
C15P02 - Power Query, Split Columns, Merge Columns, Add Suffix, etc.
12:21
C15P03 - Power Query, Add Custom Column
06:03
C15P04 - Power Query, Remove Columns, working on dates
09:00
C15P05 - Power Query, Remove Columns, working on dates, Merge Columns, etc.
08:28
C15P06 - Power Query, Merge Queries, Close and Load To
15:23
C15P07 - Power Query, Append Queries, Close and Load To
10:51
C15P08 - Power Query, Append Queries, Close and Load To
10:42
C15P09 - Power Query, Merge Queries, Split, Add Custom Column, date format, etc.
20:49
C15P10 - Power Query, Group By, Sort, Close and Load To
09:20
C15P11 - Power Query, Group By, Sort, Pivot, Close and Load To
08:21
C15P12 - Power Query, Append Queries, Pivot Table, Close and Load To
09:36
C15P13 - Power Query, Sort, Merge Queries, Close and Load To, Split, etc.
19:28
C15P14 - Power Query, Duplicate query, Delete Columns, Remove Duplicates, etc.
18:20
C15P15 - Power Pivot, Create Relationship, Pivot Table
20:22
C15P16 - Power Query, Duplicate query, Delete Columns, Remove Duplicates, etc.
17:44
C15P17 - Power Query, Duplicate query, Delete Columns, Remove Duplicates, etc.
12:18
C15P18 - Power Query, Unpivot, Pivot Table, Close and Load To
17:11
C15P19 - Power Query, Duplicate query, Delete Columns, Remove Duplicates, etc.
12:57
C15P20 - Power Pivot, Measures: SUM, AVERAGE, Pivot Table
14:40
C15P21 - Power Pivot, Measures: SUM, CALCULATE, Pivot Table, Slicer
17:15
C15P22 - Power Pivot, Measures: SUM, CALCULATE, ALL, Pivot Table
08:18
C15P23 - Power Pivot, Measures: SUM, AVERAGE, CALCULATE, Pivot Table, Slicer
08:59
C15P24 - Power Pivot, Power Query, Merge Queries, Measures: SUM, CALCULATE, etc.
14:57
C15P25 - Power Pivot, Measures: SUMX, Pivot Table
05:37
C15P26 - Power Pivot, Measures: SUM, CALCULATE, DATESYTD, Pivot Table, Slicer
15:56
C15P27 - Power Pivot, Measures: SUM, CALCULATE, DATEADD, Pivot Table, Slicer
16:35
C15P28 - Power Pivot, Measures: SUM, CALCULATE, DATEADD, DATESYTD, etc.
23:02
C15P29 - Dashboard
01:10:26
Section 16 Introduction
00:38
C16P01 - Record Macro
15:38
C16P02 - Record Macro
13:36
C16P03 - Record Macro, Remove Duplicates, SUM, SUMIFS, Paste Special
08:29
C16P04 - Write VBA Code Sub, MsgBox
08:11
C16P05 - Write VBA Code Sub, MsgBox
05:09
C16P06 - Write VBA Code Sub, MsgBox, Cells
06:27
C16P07 - Write VBA Code Sub, MsgBox, Worksheets, Cells
04:54
C16P08 - Write VBA Code Sub, Cells
02:57
C16P09 - Write VBA Code Sub, Activecell
04:31
C16P10 - Write VBA Code Sub, Cells, InputBox
05:48
C16P11 - Write VBA Code Sub, Activecell, InputBox
04:09
C16P12 - Write VBA Code Sub, InputBox, Worksheets, Cells
05:59
C16P13 - Write VBA Code Sub, Range
04:21
C16P14 - Write VBA Code Sub, Application, Selection
03:43
C16P15 - Write VBA Code Sub, Range, Copy
04:11
C16P16 - Write VBA Code Sub, Selection, Range, Copy
03:49
C16P17 - Write VBA Code Sub, Variable Declaration, Cells, MsgBox
15:17
C16P18 - Write VBA Code Sub, Variable Declaration, Cells, MsgBox
07:44
C16P19 - Write VBA Code Sub, Variable Declaration, Set, Range, Rows
08:03
C16P20 - Write VBA Code Sub, Variable Declaration, Set, Range, Columns, etc.
07:24
C16P21 - Write VBA Code Sub, Variable Declaration, Set, Range, Cells, Inputbox
04:48
C16P22 - Write VBA Code Sub, For…Next, Cells
11:32
C16P23 - Write VBA Code Sub, For…Next, Step, Cells
06:35
C16P24 - Write VBA Code Sub, Cells, Comparison operators, MsgBox
03:38
C16P25 - Write VBA Code Sub, Cells, If…End If, MsgBox
04:25
C16P26 - Write VBA Code Sub, Cells, If…End If, And, For…Next
19:11
C16P27 - Write VBA Code Sub, Cells, If…End If, And, For…Next, Step
12:54
C16P28 - Write VBA Code Sub, Variable Declaration, Cells, If…End If, And, etc.
14:48
C16P29 - Write VBA Code Sub, Variable Declaration, Cells, If…End If, And, etc.
17:05
C16P30 - Write VBA Code Sub, Variable Declaration, Cells, If…End If, And, etc.
14:08
Section 17 Introduction
00:29
C17P01 - Write VBA Code Function, Application.Volatile, Cells
12:23
C17P02 - Write VBA Code Function, Application.Volatile, Variable Declaration
05:26
C17P03 - Write VBA Code Function, Variable Declaration, For Each…Next
12:04
C17P04 - Write VBA Code Function, Variable Declaration, For Each…Next, IsNumeric
12:26
C17P05 - Variable Declaration, For Each…Next, IsNumeric, If…End If, Mid, Not
12:56
C17P06 - Write VBA Code Function, Variable Declaration, If…End If
11:18
C17P07 - Variable Declaration, For Each…Next, If…End If
07:48
C17P08 - Variable Declaration, For Each…Next, If…End If, Cells.Count
16:39
C17P09 - Variable Declaration, For Each…Next, If…End If, Cells.Count
14:29
C17P10 - Variable Declaration, For Each…Next, If…End If, And, Or, Cells.Count
14:33
C17P11 - Variable Declaration, For Each…Next, If…End If, And, Cells.Count
10:44
C17P12 - Variable Declaration, Application.WorksheetFunction, EoMonth
08:33
C17P13 - Variable Declaration, Application.WorksheetFunction, EoMonth, etc.
11:31
C17P14 - Variable Declaration, Application.WorksheetFunction, Count, CountA
06:38
C17P15 - Variable Declaration, Application.WorksheetFunction, etc.
15:33
C17P16 - Variable Declaration, Selection.Row, MsgBox, If…End If, etc.
13:43
C17P17 - Write VBA Code Sub, Create User Form, Variable Declaration, etc.
15:35
C17P18 - Write VBA Code Sub, Create User Form, Cells, Userform.Show, Unload Me
09:09
C17P19 - Create User Form, Variable Declaration, Cells, Date, etc.
15:53
C17P20 - Create User Form, Variable Declaration, Cells, Date, If…End IF, etc.
17:32
C17P21 - Create User Form, Variable Declaration, Cells, If…End IF, etc.
22:26
C17P22 - Create User Form, Variable Declaration, Cells, If…End IF, Or, etc.
30:43
C17P23 - Write VBA Code Sub on Trigger, MsgBox
05:20
C17P24 - Write VBA Code Sub on Trigger, MsgBox
03:25
C17P25 - Write VBA Code Sub on Trigger, Selection, InputBox
05:21
C17P26 - Write VBA Code Sub on Trigger, InputBox, Application.ActiveSheet.Name
03:56
C17P27 - Write VBA Code Sub on Trigger, Cells, Date, Time, &
05:16
C17P28 - Write VBA Code Sub, MsgBox, changes in menu
05:28
C17P29 - MsgBox, If…End If, Rows.EntireRow.Hidden, etc.
21:24
Viết Bình Luận
Khoá học liên quan
_m_1623212344.jpg)
Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!
Get khoá học giá rẻ ngay trước khi bị fix.
Đánh giá của học viên
Bình luận khách hàng