Danh mục
Development
Web Development Data Storage Git Automation Database Design Web Scraping
Business
Business Analysis Communication Project Management Sales Forecasting Business Strategy Operations Management Human Resources Oil and Gas Industry
Finance & Accounting
IT & Software
Office Productivity
SAP Word Excel PowerPoint Excel VBA SharePoint
Personal Development
Persuasion Notion Workspace Mind Mapping
Design
Design Sketching Typography Game Design Digital Art zBrush 3D Animation
Marketing
SEO Marketing Strategy YouTube Marketing Digital Marketing Facebook Marketing Growth Hacking Twitter Marketing Instagram Marketing
Lifestyle
Beer Brewing Beauty Home Repair Energy Healing Bartending Leather Crafting Makeup Artistry Hypnotherapy
Music
Piano Guitar Singing Music Production Acoustic Guitar Fingerstyle Guitar Music Theory Bass Guitar
Duocmmo Tedu Tin học văn phòng Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Tin học văn phòng
Excel
The 3-in-1 Excel, VBA & SQL Master Course

The 3-in-1 Excel, VBA & SQL Master Course

Loại khoá học: Tin học văn phòng

Learn valuable Excel, VBA, SQL and Programming Skills! Go from beginner to expert and get a Competitive job!

image
50.000 VND
90 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Hello!

Thank you for visiting our course page.

Do you want to become the go-to person at your company for Microsoft Excel problems? Do you want to nail your next job interview? Or just want a new skill? If yes, then this course is for you.

Watch the FREE video lectures to see how the course is structured and delivered!

Join the course risk-free thanks to the 30-day no questions asked money-back guarantee! If you decide it's not for you, just ask for a refund.

I'm Mark and I will be your instructor. I have worked at companies like IBM, Morgan Stanley, and Siemens, so believe me, I know what skills these companies need! I'm a self-taught software developer, who will teach you how to use Excel like a pro, but we will not stop there! I'll also teach you how to write clean and professional VBA code to automate Excel tasks! And on top of that, you'll also learn the SQL programming language, so by the end of the course, you'll know how to work with an actual database!

This course is made up of 3 different courses, and packed with over 40 hours of video lectures.

*** UPDATE! Google Sheets course is being added to this course! ***


1. EXCEL

The first part is dealing with Excel itself. It takes you from the VERY BASICS to EXPERT level. If you already have some Excel knowledge, you can skip the introductory parts!

By the end of this part you will use Excel confidently, and be able to handle advanced tasks. You will learn the ins and outs of functions, formulas, charts, pivot tables, conditional formatting and a lot more.

At the end of this part we will have a live project also.


2. VBA

The VBA sections of this course will enhance your Microsoft Excel knowledge even further and will introduce you to programming. VBA stands for Visual Basic for Applications. Excel VBA is Microsoft's programming language for Excel. It is used to automate tasks and perform several other functions beyond creating and organizing spreadsheets.

In the VBA sections of this course you will learn for example

  • Subroutines, variables, data types

  • Core VBA programming concepts

  • VBA functions and more challenging concepts

  • Macros, recordings and enhancing them

  • Debugging and error handling

  • Essential VBA operations

  • Events

  • Managing your VBA code

  • Classes and Object-based programming


3. SQL

In this part of the course you will learn how to work with a database and execute SQL statements within Excel.

In the SQL part of the course you will:

  • learn SQL and how to set up your database

  • learn about data types

  • learn basic operations

  • learn how to set up VBA for SQL

  • learn how to query data

  • learn about basic statements

  • learn how to work with a table

  • learn about joins

  • learn about SQL functions and security


So what are you waiting for? Enroll now and become an EXCEL expert!


4. Google Sheets

This part of the course is currently being created! New lessons are added on a weekly basis!

The Google Sheets sections start from the very beginning, assuming that the learner is an absolute beginner. If you have some knowledge of Google Sheets, you can skip the introductory parts.

Bạn sẽ học được gì

Learn Microsoft Excel from Beginner to Advanced

VBA programming

Learn a large number of Excel functions

Master advanced Excel functions

Work with charts and pivot tables

Learn how to execute SQL statements in Excel

Task-based learning

Help from me with real life experience who works with Excel every day

Yêu cầu

  • A PC
  • Microsoft Excel installed. Preferably Office 365, but we'll give explanations regarding older versions if necessary
  • No prior knowledge of Excel required
  • Basic computer and Internet skills

Nội dung khoá học

52 sections

Introduction

5 lectures
Introduction
02:31
How to Use The Course
03:34
Select the appropriate plan for you
04:25
Install Office on Windows
03:39
Install Office on a Mac
03:27

EXCEL: Introduction to Excel

7 lectures
What is Excel
02:10
Overview of the worksheet
08:35
Overview of the ribbon
06:51
Overview of the top area
13:30
The file tab
07:03
Basic data organisation
21:51
Self check
7 questions

EXCEL: Basics of formulas, functions and formatting

21 lectures
The SUM function - Part I
07:25
The SUM function - Part II
10:48
The SUM function - Part III
06:34
Addition
03:34
Subtraction
03:06
Multiplication - Part I.
05:13
Multiplication - Part II.
05:58
Division
02:51
Self check
5 questions
Dynamic cell References - Part I.
05:15
Dynamic Cell References - Part II.
05:35
Basic Formatting - Part I.
06:57
Basic Formatting - Part II.
06:48
Basic Formatting - Part III.
04:24
Basic Formatting - Part IV.
03:44
Formulas Bar - Part I.
05:57
Formulas Bar - Part II.
04:50
Formula Auditing
06:37
Error Checking and the Watch Window - Part I.
04:22
Error Checking and the Watch Window - Part II.
04:33
Self check
6 questions

EXCEL: Some important math functions

5 lectures
AVERAGE
02:17
MIN
01:25
MAX
01:26
COUNT
02:16
Self check
4 questions

EXCEL: Data types and formatting

33 lectures
Number Formatting - Part I.
03:28
Number Formatting - Part II.
05:27
Number Formatting - Part III.
03:21
Number Formatting - Part IV.
03:34
Date Formatting - Part I.
05:20
Date Formatting - Part II.
06:13
Epoch
03:18
Percentages
08:03
Currencies - Part I.
05:41
Currencies - Part II.
05:50
Fractions
04:12
Self check
3 questions
Text - Part I.
05:06
Text - Part II - Character set
01:15
Text - Part III - Numbers formatted as text
05:40
Formatting The Table - Part I - Text Filters I
04:48
Formatting The Table - Part II - Text Filters II
05:24
Formatting The Table - Part III - Text Filters III
06:11
Formatting The Table - Part IV - Number Filters I
04:23
Formatting The Table - Part V - Number Filters II
02:29
Formatting The Table - Part VI - Color filters
04:41
Formatting The Table - Part VII - Date Filters
04:32
Formatting The Table - Part VIII - Sorting
06:00
Formatting The Table - Part IX - Multi-level sorting
07:03
Formatting The Table - Part X - Autofitting
06:29
Formatting The Table - Part XI - Wrapping text
06:28
Formatting The Table - Part XII - Freeze Panes
04:41
Formatting The Table - Part XIII - Cut-copy rows and columns
02:39
Named Ranges - Part I
07:21
Named Ranges - Part II
06:59
Inserted Tables - Part I
07:35
Inserted Tables - Part II
10:35
Self check
6 questions

EXCEL: More challenging formulas

12 lectures
The INDEX Function - Part I
07:41
The INDEX Function - Part II
05:32
The INDEX Function - Part III
04:53
The SUM Function Combined With the INDEX Function
05:51
The VLOOKUP Function - Part I
10:27
A Quick Detour: The Search Functionality
02:08
The VLOOKUP Function - Part II
06:47
The VLOOKUP Function - Part III
03:35
The VLOOKUP Function - Part IV
05:17
The VLOOKUP Function - Part V
06:10
The VLOOKUP Function - Part VI
03:23
Self check
3 questions

EXCEL: Handling Errors

9 lectures
The IFERROR function - Part I
06:59
The IFERROR function - Part II
02:52
The NAME Error
01:47
The VALUE Error
03:39
The REF Error
04:06
The NUM Error
01:34
The DIV0 Error
00:58
The NULL Error
01:48
Self check
7 questions

EXCEL: Sanitizing your data

9 lectures
TRIM - Part I
04:47
TRIM - Part II - LEN
05:59
TRIM - Part III - Checking for equality
06:32
Removing Blank Rows
02:24
Hiding and Unhiding Rows and Columns
05:14
Dropdown Lists - Part I
06:40
Dropdown Lists - Part II
04:46
Dropdown Lists - Part III
06:15
Self check
4 questions

EXCEL: Conditional Functions and Formatting

23 lectures
IF - Part I
04:39
IF - Part II
05:07
The IFS - Part I
05:30
The IFS - Part II
05:23
The IFS - Part III
04:49
AND - Part I
05:16
AND - Part II
04:18
OR - Part I
04:24
OR - Part II
02:15
Self check
4 questions
COUNTIF - Part I
04:46
COUNTIF - Part II
02:32
COUNTIFS
04:59
SUMIF - Part I
04:19
SUMIF - Part II
01:56
SUMIFS
03:39
Conditional Formatting - Part I
06:01
Conditional Formatting - Part II
04:41
Conditional Formatting - Part III
07:46
Conditional Formatting - Part IV
07:25
Conditional Formatting - Part V
06:38
Conditional Formatting - Part VI
03:50
Self check
5 questions

EXCEL: Cells and References

9 lectures
Cell References - Part I
04:24
Cell References - Part II
06:52
Cell References - Part III
08:34
Cell References - Part IV
08:02
Cell References - Part V
10:17
Referencing Other Worksheets - Part I
04:22
Referencing Other Worksheets - Part II
03:32
Referencing Other Workbooks - Part I
05:30
Referencing Other Workbooks - Part II
04:22

EXCEL: Advanced Lookup Formulas

4 lectures
MATCH
07:21
INDEX Recap
04:59
INDEX MATCH
06:24
INDEX MATCH MATCH
04:18

EXCEL: Array formulas

13 lectures
Working With Multiple Values - Part I
07:04
Working With Multiple Values - Part II
05:25
Working With Multiple Values - Part III
06:33
Basic Array Formula Example
08:36
Conditional Array Formula
06:58
Single Result Array Formula
07:02
The UNIQUE Function
04:10
Array Formula for Finding Unique Values - Part I
05:37
Array Formula for Finding Unique Values - Part II
04:56
Array Formula for Finding Unique Values - Part III
05:50
Array Formula for Finding Unique Values - Part IV
10:01
Returning First Distinct Value
01:42
Returning Non-duplicates
03:31

EXCEL: Charts

25 lectures
Introduction to Charts
07:00
Bar Chart - Part I
05:45
Bar Chart - Part II
06:56
Bar Chart - Part III
08:41
Bar Chart - Part IV
11:13
Bar Chart - Part V
08:52
Column Chart - Part I
07:03
Column Chart - Part II
04:40
Column Chart - Part III
00:27
Column Chart - Part IV
06:26
Column Chart - Part V
05:01
Pie Chart - Part I
08:31
Pie Chart - Part II
06:37
Pie Chart - Part III
06:26
Pie Chart - Part IV
07:12
Line Chart - Part I
07:53
Line Chart - Part II
08:56
Combo Chart
10:43
Moving and Copying Charts
12:37
Sparklines - Part I
10:57
Sparklines - Part II
08:45
Sparklines - Part III
07:46
Sparklines - Part IV
06:50
Sparklines - Part V
06:26
People Graph
11:16

EXCEL: Pivot tables and charts

25 lectures
Pivot Table - Part I
12:04
Pivot Table - Part II
04:14
Pivot Table - Part III
10:24
Pivot Table - Part IV
05:29
Pivot Table - Part V
06:56
Pivot Table - Part VI
11:50
Pivot Table - Part VII
10:48
Pivot Table - Part VIII
13:05
Pivot Table - Part IX
04:10
Pivot Table - Part X
13:20
Pivot Table - Part XI
06:26
Pivot Table - Part XII
08:25
Pivot Table - Part XIII
07:18
Pivot Table - Part XIV
02:50
Pivot Table - Part XVa
06:19
Pivot Table - Part XVb
10:46
Pivot Table - Part XVI
08:50
Pivot Table - Part XVII
07:33
Pivot Table - Part XVIII
06:53
Pivot Table - Part XIX
05:48
Pivot Table - Part XX - Pivot cache I
06:13
Pivot Table - Part XX - Pivot cache II
10:32
Pivot Table - Part XX - Pivot cache III
05:14
Pivot Table with Dates
09:54
Pivot Charts
19:28

EXCEL: Useful Worksheet Operations

1 lectures
Useful Worksheet Operations
11:35

EXCEL: Useful Excel Features

16 lectures
Comments and Notes
07:19
Copy & Paste - Part I
07:36
Copy & Paste - Part II
07:13
Copy & Paste - Part III
07:06
Copy & Paste - Part IV
06:17
Copy & Paste - Part V
03:56
Filling Cells
02:47
Find and Replace - Part I
08:06
Find and Replace - Part II
03:28
Find and Replace - Part III
07:41
Find and Replace - Part IV
02:43
Grouping
07:31
Importing External Data
08:15
Merging Cells
04:16
Opening Multiple Excel Files
00:55
Printing
13:04

EXCEL: A Challenging Job Interview Question - Text Manipulation

5 lectures
Swap Names - Part I
06:26
Swap Names - Part II
06:30
Swap Names - Part III
04:11
Swap Names - Part IV
05:08
Swap Names - Part V
05:39

EXCEL: A Simplified Live Project

7 lectures
Seat Planning - Part I
09:27
Seat Planning - Part II
05:44
Seat Planning - Part III
12:01
Seat Planning - Part IV
09:29
Seat Planning - Part V
04:33
Seat Planning - Part VI
10:05
Seat Planning - Part VII
04:53

VBA: Intro and basic interface

2 lectures
Intro
04:43
Visual Basic Editor
07:43

VBA: Subroutines, variables, data types

16 lectures
Our First Subroutine
07:46
Compiling
04:42
Saving a Macro Enabled Workbook
01:49
UPDATE 2023.02.02: Unblocking a macro-enabled Workbook
03:09
Enabling Macros
01:24
Integer Variables - Part I
07:38
Integer Variables - Part II
10:18
String Variables - Part I
05:26
String Variables - Part II
09:01
Cells and Ranges
08:03
Working With Numbers - Part I
07:17
Working With Numbers - Part II
13:23
Working With Numbers - Part III
06:55
Working With Numbers - Part IV
04:18
Working With Numbers - Part V
01:29
About Bits and Bytes
10:00

VBA: Core programming concepts

26 lectures
Modules
05:17
IF - Part I
06:16
IF - Part II
02:39
IF - Part III
07:22
IF - Part IV
07:16
Select Case - Part I
05:28
Select Case - Part II
04:30
Select Case - Part III
04:37
Arrays - Part I
05:36
Arrays - Part II
03:38
Dynamic Arrays
08:22
Range to Array - Part I
08:15
Range to Array - Part II
06:12
The FOR Loop - Part I
09:16
The FOR Loop - Part II
02:09
The FOR Loop - Part III
05:41
The FOR Loop - Part IV
02:11
The FOR Loop - Part V
09:30
The FOR Loop - Part VI
08:46
The FOR EACH Loop
04:26
The DO LOOP - Part I
08:18
The DO LOOP - Part II
03:17
The DO LOOP - Part III
09:22
The DO LOOP - Part IV
03:30
The DO LOOP - Part V
02:34
The WHILE WEND Loop
15:08

VBA: Intro To Objects

17 lectures
Collections - Part I
08:28
Collections - Part II
08:14
Collections - Part III
06:11
Collections - Part IV
05:14
The ActiveSheet Object
07:44
Range Object - Part I
07:03
Range Object - Part II
06:25
Range Object - Part III
08:05
Range Object - Part IV
13:09
Worksheet Object - Part I
08:33
Worksheet Object - Part II
06:10
Worksheet Object - Part III
04:31
Workbook Object - Part I
06:04
Workbook Object - Part II
08:32
The NOTHING Keyword
07:56
Object and Non-object Variables - Part I
09:25
Object and Non-object Variables - Part II
04:58

VBA: Ways of Running Your Code

3 lectures
Part I
05:58
Part II
05:41
Part III
03:33

VBA: Functions and More Challenging Concepts

21 lectures
Application Object
10:57
Functions
08:07
Option Explicit
03:54
Arguments
08:29
ByVal and ByRef - Part I
06:44
ByVal and ByRef - Part II
04:32
GetLastRow - Part I
09:04
GetLastRow - Part II
05:47
GetLastColumn
08:23
GetColumnLetterPerIndex
07:26
Calling With Named Arguments
04:53
Declaring Arguments
04:25
Optional Arguments
05:12
Ways of Calling Functions and Subs
03:11
Data Type Conversion - Part I
08:30
Data Type Conversion - Part II
06:19
Worksheet Functions
05:53
VarType
04:18
Constants
07:27
Module Level Variables and Constants
07:19
Global Variables and Constants
03:37

VBA: Macros, Recordings and Enhancing Them

5 lectures
Recording Macro with Absolute Reference - Part I
07:40
Recording Macro with Absolute Reference - Part II
09:08
Running a Macro with Relative References
02:43
Copy Paste Macros - Part I
07:37
Copy Paste Macros - Part II
08:41

VBA: Debugging and Error Handling

4 lectures
Part 1
06:38
Part 2
07:25
Part 3
09:12
Part 4
08:36

VBA: Essential Operations

6 lectures
Getting User Input - InputBox
02:56
Getting User Input - MsgBox
03:13
Opening a New Workbook
03:29
Opening an Existing Workbook
03:41
Closing a Workbook
06:14
Saving a Workbook
07:06

VBA: Events

3 lectures
Workbook Events - Part I
05:51
Workbook Events - Part II
07:45
Worksheet Events
04:15

VBA: Managing Your Code

3 lectures
Exporting and Importing Modules
02:25
Calling a Function or Sub of Another Workbook
05:07
Personal Macro Workbook
08:54

VBA: Classes and Object-based Programming

11 lectures
Intro to Object-based Programming - Part I
05:46
Intro to Object-based Programming - Part II
02:33
Class Modules
08:17
Private Member Variables
10:19
Properties
10:37
Init
02:40
Order Object
03:55
Car Object
10:39
Associate an Order With a Car
06:44
Calculating the Order Price
05:54
Private and Public keywords in Subs and Functions
02:33

VBA: Simplified Live Project Automation

10 lectures
Seat Planning Overview
04:21
Check Worksheets
08:35
DeleteWs
04:19
Delete Data
01:19
Add Employee Data
10:50
Copy Employee Data
01:20
Add Location Formula
06:04
Add Free Seats Formulas
03:26
Create Pivot Table Macro - Part I
08:42
Create Pivot Table Macro - Part II
05:26

SQL: Intro to SQL

4 lectures
What are SQL and Databases
06:35
Installing Xampp
03:42
Setting Database Password
06:10
Stopping MariaDB
00:43

SQL: First Steps

3 lectures
Creating a Database and a Database Table
05:30
Adding Rows to Tables
03:06
Our First Query
04:03

SQL: Using VBA with SQL

4 lectures
Installing OBDC Driver
03:43
Setting Up VBA for SQL - Part I
05:05
Setting Up VBA for SQL - Part II
00:58
Setting Up VBA for SQL - Part III
06:27

SQL: Querying Data

14 lectures
WHERE
06:03
Adding More data
02:58
ORDER BY
04:28
AND
04:16
OR
03:37
Combining AND and OR
04:14
NOT
02:36
WHERE field is NOT NULL
04:00
AS
03:06
No Records Returned
03:18
BETWEEN
03:54
LIKE
05:12
IN
02:18
SELECT DISTINCT
02:17

SQL: Important Basic Statements

5 lectures
Changing The Table
07:59
Insert Ignore Into - Part I
05:59
Insert Ignore Into - Part II
06:41
UPDATE
04:55
DELETE
04:17

SQL: Working with a Table

9 lectures
Reinserting The Data
01:07
Exporting a Database
04:52
SQL for Creating a Table
08:21
Create a Table Using SQL
07:51
ALTER TABLE ADD Column
04:41
ALTER TABLE MODIFY Column
03:37
ALTER TABLE DROP Column
02:37
DROP TABLE
02:12
UNIQUE
09:46

SQL: Limit

1 lectures
LIMIT
03:28

SQL: Joins

3 lectures
Inner Join - Part I
12:26
Inner Join - Part II
05:30
Left Join
03:58

SQL: Functions

8 lectures
The MIN Function
03:32
The MAX Function
02:37
The COUNT Function
05:19
The GROUP BY Function
03:12
The AVG Function - Part I
01:58
The AVG Function - Part II
07:25
The SUM Function
01:28
The HAVING Keyword
08:21

SQL: Adding SQL to the Live Project

1 lectures
Seat Planning Automation VBA and SQL
06:49

Google Sheets: Introduction

25 lectures
Important Notice
00:54
What is Google Sheets?
03:52
Registering a Google account
01:21
Google Sheets and other software
02:05
Creating a new Spreadsheet
02:21
A brief intro to the Worksheet
06:15
Renaming the Spreadsheet
01:55
Brief discussion of some features
03:15
A brief overview of the File menu
03:55
A brief overview of the Edit menu
01:32
The Undo and Redo commands
02:53
A brief overview of the View menu
03:32
A brief overview of the Insert menu
01:08
A brief overview of the Format menu
02:21
A brief overview of the Data menu
01:40
A brief overview of the Tools menu
00:49
A brief overview of the Extensions menu
01:51
A brief overview of the Help menu
01:32
A brief overview of the Toolbar or Command Strip
01:41
Saving your work
00:54
Adding more data
02:49
The problem with one dimensional data
03:21
Tabular Data
05:11
Adding a header
03:52
End of introduction
00:39

Google Sheets: Basic Formatting

5 lectures
How to use the resource files
02:44
Column widths and autofitting
06:16
Overflowing cell contents
06:57
Row heights and autofitting
02:51
Adding borders and fill to cells
10:19

Google Sheets: Basics of formulas and functions

17 lectures
Intro to formulas
03:12
Addition
01:48
Referring to cells
04:41
Subtraction
01:25
Multiplication
01:03
Operator precedence
02:20
Division
02:39
The SUM function
05:57
The importance of the locale
03:21
The importance of the display language
02:45
The formula help
05:20
Range
06:21
Dynamic cell references - Part 1
04:27
Dynamic cell references - Part 2
04:05
Sometimes we don't even need a formula
01:46
Formula Suggestions
02:36
Where to find more functions
02:03

Google Sheets: Dashboard

4 lectures
Overview of the dashboard
05:09
Moving spreadsheets
02:56
Starring spreadsheets
01:36
Opening a spreadsheet from Google drive
01:31

Google Sheets: Handling Data

24 lectures
CTRL SHIFT RIGHT or LEFT ARROW
03:50
CTRL SHIFT UP or DOWN ARROW
01:32
CTRL A
02:08
SHIFT and cursor
00:34
CTRL cursor
01:55
Named ranges
06:21
Changing a named range
01:04
Deleting a named range
02:51
Number format 1
09:10
Number format 2
06:13
Scientific notation
10:23
Accounting format
02:23
Financial format
01:06
Currency format
03:05
Changing the currency - Part 1
03:40
Changing the currency - Part 2
03:58
Custom number format
08:22
Percent
02:13
Text
03:06
Dates
05:07
Custom date format
04:53
Date Time
02:35
Time
01:50
Duration
01:21

Google Sheets: Basic Math Functions

4 lectures
Average
03:27
Min
00:40
Max
00:46
Count
03:09

Google Sheets: Functions For Text Manipulation

16 lectures
UPPER
01:46
LOWER
01:43
CONCATENATE
02:04
LEN
01:02
FIND and SEARCH
03:25
LEFT
05:16
RIGHT
04:36
MID
05:13
Swapping names 1
03:17
Swapping names 2
02:35
Improving the readability of long formulas
01:58
Avoiding repetition with LET
08:34
TRIM
02:12
REPLACE
03:27
SUBSTITUTE
02:33
SPLIT
03:02

Google Sheets: Functions For Working With Dates

7 lectures
DATE
02:03
DATEDIF
03:10
TODAY
00:51
NOW
00:45
Calculation Settings
05:14
Changing the timezone
02:04
Version history
03:07

Google Sheets: Functions with conditional logic

11 lectures
Conditional logic
07:22
IF
03:43
IFS - Part 1
04:55
IFS - Part 2
02:09
OR
01:41
IF combined with OR
02:19
AND
02:10
IF combined with AND
01:50
A challenge with IF OR AND
03:55
SUMIF and SUMIFS
06:09
COUNTIF and COUNTIFS
04:09

Google Sheets: Sorting and Filters

10 lectures
Sorting data - Part 1
03:41
Sorting data - Part 2
04:34
Sorting data - Part 3
04:57
Filters - Part 1
03:01
Filters - Part 2
03:12
Filters - Part 3
05:12
Filters - Part 4
01:48
Filters - Part 5
02:03
Filter Views
03:24
Slicers
02:51

** Bonus Lectures & Student Requests **

22 lectures
Useful Excel Shortcuts
06:09
Copy only visible cells - Part 1 of 2
11:23
Copy only visible cells - Part 2 of 2
06:28
Iterative calculation - Part 1 of 14 - Circular references
04:12
Iterative calculation - Part 2 of 14 - Enabling iterative calculation
02:42
Iterative calculation - Part 3 of 14 - Formulas without circular references
01:08
Iterative calculation - Part 4 of 14 - Looking at each iteration
03:06
Iterative calculation - Part 5 of 14 - The problem with Automatic calculations
02:36
Iterative calculation - Part 6 of 14 - Switching to Manual calculation
02:52
Iterative calculation - Part 7 of 14 - A more meaningful example
02:02
Iterative calculation - Part 8 of 14 - Calculating interest without circular ref
01:45
Iterative calculation - Part 9 of 14 - Calculating interest with circular ref
04:43
Iterative calculation - Part 10 of 14 - The Kryptonite example
02:06
Iterative calculation - 11 of 14 - Calculating amortization without circular ref
01:06
Iterative calculation - 12 of 14 - Calculating amortization with circular ref
03:19
Iterative calculation - 13 of 14 - The Maximum Change condition
03:13
Iterative calculation - 14 of 14 - Is iterative calculation useful
02:18
Will chatGPT take our Excel jobs?
09:59
XLOOKUP Vertical Lookup
08:23
XLOOKUP combined with EXACT
07:41
XLOOKUP Horizontal Lookup
03:21
XLOOKUP Right-to-Left Lookup
02:41

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Oracle Data Integrator (ODI) 12c Developer Course

Oracle Data Integrator (ODI) 12c Developer Course

25 VND
50.000 VND
Microsoft Excel - Excel from Beginner to Advanced

Microsoft Excel - Excel from Beginner to Advanced

100 VND
50.000 VND
VBA Excel toàn tập từ cơ bản đến nâng cao

VBA Excel toàn tập từ cơ bản đến nâng cao

599.000 VND
99.000 VND
Tạo ứng dụng quản lý kho cơ bản với Appsheet

Tạo ứng dụng quản lý kho cơ bản với Appsheet

1.900.000 VND
50.000 VND
Trở thành chuyên gia kế toán tổng hợp trên Excel

Trở thành chuyên gia kế toán tổng hợp trên Excel

299.000 VND
99.000 VND
Microsoft Project for Project Manager & Civil Engineers -MSP

Microsoft Project for Project Manager & Civil Engineers -MSP

55 VND
50.000 VND
Quantity Surveying Building Estimation,Cad Excel & Planswift

Quantity Surveying Building Estimation,Cad Excel & Planswift

1.399.000 VND
50.000 VND
Microsoft Power BI for Construction Management

Microsoft Power BI for Construction Management

55 VND
50.000 VND
SAP ABAP Programming For Beginners - Online Training

SAP ABAP Programming For Beginners - Online Training

90 VND
50.000 VND
SharePoint 2013 Complete Training

SharePoint 2013 Complete Training

1.049.000 VND
50.000 VND
The Complete Google Drive Course - Mastering Google Drive

The Complete Google Drive Course - Mastering Google Drive

1.399.000 VND
50.000 VND
SAP ABAP : Enhancement & Modification to SAP Standard

SAP ABAP : Enhancement & Modification to SAP Standard

25 VND
50.000 VND
EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng

EXG02 - Thủ thuật Excel cập nhật hàng tuần cho dân văn phòng

199.000 VND
50.000 VND
SharePoint - Complete Guide to Microsoft SharePoint Online

SharePoint - Complete Guide to Microsoft SharePoint Online

95 VND
50.000 VND
Administration and Automation with Windows PowerShell

Administration and Automation with Windows PowerShell

1.499.000 VND
50.000 VND
Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

Microsoft Project ALL: BEGINNER to EXPERT 10 Projects 9 PDU

99 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi