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
Microsoft Excel - Excel from Beginner to Advanced

Microsoft Excel - Excel from Beginner to Advanced

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

Excel with this A-Z Microsoft Excel Course. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft/Office 365/2023

image
50.000 VND
100 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ả

Microsoft Excel all in One Package

This Microsoft Excel course combines 4 different courses.

  • Microsoft Excel 101 - An Introduction to Excel

  • Microsoft Excel 102 - Intermediate Level Excel

  • Microsoft Excel 103 - Advanced Level Excel

  • Master Microsoft Excel Macros and VBA in 6 Simple Projects

Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)/2023

Recent Student Review

  • "You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don't doubt it, buy it. I've learned so much in this course. Hope more courses are on the way because I'd buy every single one of them. Thanks again bro. God bless you and your family."

  • "Happy to say that I now "know" excel. I realize there is so much more to learn, but it's a start! Thank you for being such a great instructor... now on to the next class."

  • "Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them."

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As a Microsoft Certified Trainer I will use my 20+ years of Excel training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)

  • Create dynamic report with Excel PivotTables

  • Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot

  • Audit Excel Worksheet formulas to ensure clean formulas

  • Automate your day to day Excel tasks by mastering the power of Macros and VBA

What's Included?

  • 18+ Hours of Step by Step Video Lectures by a Microsoft Certified Trainer (MCT)

  • Downloadable Exercise Files to follow along and practice with

  • Additional Exercise Files are provided at the end of each major section (101, 102, 103 and VBA) that you can download and practice the skills you've learned

  • Section Quizzes to Test Your Knowledge on the Lecture Topics

  • QA board where you can post questions, screenshots of your progress and communicate with the instructor and fellow students in the course.

So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!

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

Master Microsoft Excel from Beginner to Advanced

Build a solid understanding on the Basics of Microsoft Excel

Learn the most common Excel functions used in the Office

Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA

Maintain large sets of Excel data in a list or table

Create dynamic reports by mastering one of the most popular tools, PivotTables

Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Access to a Professional Trainer with 10+ years of Excel Training

Yêu cầu

  • No Prior Excel Knowledge Required
  • Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended

Nội dung khoá học

43 sections

Microsoft Excel 101 Course Introduction

3 lectures
Ask Questions
01:42
Course Exercise Files
01:27
Certificate of Completion
01:18

Microsoft Excel Fundamentals

11 lectures
Launching Excel
01:25
Microsoft Excel Startup Screen
04:12
Introduction to the Excel Interface
04:39
TIP - Hide Excel Ribbon
01:55
TIP - Customizing the Excel Quick Access Toolbar
02:31
More on the Excel Interface (Workbook and Status Bar)
03:04
Understanding the Structure of an Excel Workbook
06:17
Saving an Excel Document
06:13
Opening an Existing Excel Document
02:07
Common Excel Shortcut Keys
03:45
Excel Fundamentals Quiz
5 questions

Entering and Editing Text and Formulas

8 lectures
Entering Text to Create Excel Spreadsheet Titles
08:15
Working with Numeric Data in Excel
08:26
Entering Date Values in Excel
08:37
Working with Cell References
06:00
Creating Basic Formulas in Excel
08:32
Relative Versus Absolute Cell References in Formulas
12:33
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
10:36
Entering and Editing Text and Formulas Quiz
4 questions

Working with Basic Excel Functions

10 lectures
The structure of an Excel Function
10:16
Working with the SUM() Function
07:00
Working with the MIN() and MAX() Functions
06:18
Working with the AVERAGE() Function
02:51
Working with the COUNT() Function
02:51
Adjacent Cells Error in Excel Calculations
03:39
Using the AutoSum Command
06:48
Excel's AutoSum Shortcut Key
02:12
Using the AutoFill Command to Copy Formulas
04:24
Basic Excel Functions Quiz
4 questions

Modifying an Excel Worksheet

8 lectures
Moving and Copying Data in an Excel Worksheet
06:33
Inserting and Deleting Rows and Columns
07:13
Changing the Width and Height of Cells
05:17
Hiding and Unhiding Excel Rows and Columns
05:07
Renaming an Excel Worksheet
02:51
Deleting an Excel Worksheet
04:33
Moving and Copying an Excel Worksheet
05:11
Modifying Worksheets Quiz
4 questions

Formatting Data in an Excel Worksheet

12 lectures
Working with Font Formatting Commands
07:20
Changing the Background Color of a Cell
03:09
Adding Borders to Cells
02:24
Excel Cell Borders Continued
03:13
Formatting Data as Currency Values
04:28
Formatting Percentages
02:52
Using Excel's Format Painter
04:01
Creating Styles to Format Data
07:10
Merging and Centering Cells
03:16
Using Conditional Formatting
04:23
Editing Excel Conditional Formatting
02:25
Formatting Data Quiz
4 questions

Inserting Images and Shapes into an Excel Worksheet

4 lectures
Inserting Images
04:01
Inserting Excel Shapes
02:29
Formatting Excel Shapes
03:38
Working with Excel SmartArt
08:24

Creating Basic Charts in Excel

8 lectures
Creating an Excel Column Chart
03:22
Working with the Excel Chart Ribbon
02:42
Adding and Modifying Data on an Excel Chart
05:21
Formatting an Excel Chart
06:36
Moving a Chart to another Worksheet
03:34
Working with Excel Pie Charts
07:08
Microsoft Excel Charts Quick Guide (DOWNLOAD)
00:09
Working with Excel Charts Quiz
3 questions

Printing an Excel Worksheet

7 lectures
Viewing your Document in Print Preview
03:51
Changing the Margins, Scaling and Orientation
08:12
Excel Worksheet Margins
03:02
Working with Page Layout View
03:23
Adding Header and Footer Content
05:38
Printing a Specific Range of Cells
03:01
Printing an Excel Worksheet Quiz
4 questions

Working with Excel Templates

4 lectures
Intro to Excel Templates
03:13
Opening an Existing Template
08:43
Creating a Custom Template
06:18
Excel Templates Quiz
1 question

Excel 101 - Practice What You've Learned (DOWNLOAD)

1 lectures
Excel 101 - Practice What You've Learned (DOWNLOAD)
00:09

Congratulations! You've Built a Solid Microsoft Excel Foundation

1 lectures
Congratulations!
01:55

Microsoft Excel 102 Course Introduction

1 lectures
Excel 102 Course Exercise Files -- DOWNLOAD
01:15

Working with an Excel List

10 lectures
Understanding Excel List Structure
05:39
Sorting a List Using Single Level Sort
03:47
Sorting a List Using Multi-Level Sorts
03:46
Using Custom Sorts in an Excel List
04:33
Filter an Excel List Using the AutoFilter Tool
04:56
Creating Subtotals in a List
06:36
Format a List as a Table
07:30
Using Conditional Formatting to Find Duplicates
03:53
Removing Duplicates
04:10
Excel List Quiz
4 questions

Excel List Functions

8 lectures
Introduction to Excels Function: DSUM()
05:30
Excel DSUM Function Single Criteria Continued
04:47
Excel DSUM Function with OR Criteria
02:33
Excel DSUM Function with AND Criteria
05:34
Excel Function: DAVERAGE()
04:55
Excel Function: DCOUNT()
06:29
Excel Function: SUBTOTAL()
07:45
List Functions :Quiz
2 questions

Excel Data Validation

6 lectures
Understanding the Need for Excel Data Validation
05:00
Creating an Excel Data Validation List
05:24
Excel Decimal Data Validation
04:15
Adding a Custom Excel Data Validation Error
04:51
Dynamic Formulas by Using Excel Data Validation Techniques
04:43
Data Validation Quiz
2 questions

Importing and Exporting Data

8 lectures
Importing Data Into Microsoft Excel
01:42
Importing Data from Text Files
05:34
Importing Data from Microsoft Access
04:14
NEW VERSION -- Import Data From Text Files into Excel
07:55
NEW VERSION -- Import Data From a Database into Excel
06:19
Microsoft Excel Legacy Import Options for New Excel Versions
01:59
Exporting Data to a Text File
06:24
Importing and Exporting Data Quiz
2 questions

Excel PivotTables

10 lectures
Understanding Excel PivotTables
03:52
Creating an Excel PivotTable
06:31
Modifying Excel PivotTable Calculations
05:35
Grouping PivotTable Data
07:49
Formatting PivotTable Data
04:09
Modifying PivotTable Calculations
09:00
Drilling Down into PivotTable Data
04:11
Creating PivotCharts
04:02
Filtering PivotTable Data
02:56
Filtering with the Slicer Tool
02:58

Working with Excel's PowerPivot Tools

7 lectures
Introduction to Excel Power Pivot
04:36
Why PowerPivot?
07:47
Activating the Excel PowerPivot AddIn
03:18
Creating Data Models with PowerPivot
04:54
Excel Power Pivot Data Model Relationships
04:46
Creating PivotTables based on Data Models
05:58
Excel Power Pivot KPIs
11:00

Working with Large Sets of Excel Data

6 lectures
Using the Freeze Panes Tool
03:39
Grouping Data (Columns and/or Rows)
04:17
Print Options for Large Sets of Data
07:32
Linking Worksheets (3D Formulas)
04:08
Consolidating Data from Multiple Worksheets
05:30
Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD)
00:11

Excel 102 Additional Practice Exercises

1 lectures
Excel 102 - Practice What You've Learned (DOWNLOAD)
00:09

Congratulations! You're an Intermediate Excel User

1 lectures
Congratulations!
01:32

Microsoft Excel 103 Course Introduction

1 lectures
Excel 103 Course Exercise Files -- DOWNLOAD
01:23

Working with Excel's Conditional Functions

10 lectures
Working with Excel Name Ranges
04:22
Advantages and Disadvantages of Excel Name Ranges
05:34
Editing an Excel Name Range
02:33
Using Excel's IF() Function
05:09
Excel's IF() Function with a Name Range
05:23
Nesting Functions with Excel
08:57
Nesting Excels AND() Function within the IF() Function
04:38
Using Excel's COUNTIF() Function
02:30
Using Excel's SUMIF() Function
06:44
Using Excel's IFERROR() Function
05:08

Working with Excel's Lookup Functions

7 lectures
Microsoft Excel VLOOKUP() Function
09:36
Microsoft Excel HLOOKUP() Function
05:25
Microsoft Excel INDEX() Function
09:25
Microsoft Excel MATCH() Function
04:40
Microsoft Excel INDEX() and MATCH() Function Combined
06:41
Microsoft Excel INDEX() and MATCH() Function Combined Continued
08:44
Creating a Dynamic HLOOKUP() with the MATCH() Function
07:16

Working with Excel's Text Based Functions

5 lectures
Using Excel's LEFT(), RIGHT() and MID() Functions
06:18
Using Excel's LEN() Function
06:15
Using Excel's SEARCH() Function
12:19
Using Excel's CONCATENATE() Function
03:10
Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD)
00:09

Auditing an Excel Worksheet

4 lectures
Tracing Precedents in Excel Formulas
04:01
Tracing Dependents in Excel Formulas
02:52
Working with the Watch Window
04:19
Showing Formulas
02:46

Protecting Excel Worksheets and Workbooks

3 lectures
Protecting Specific Cells in a Worksheet
08:05
Protecting the Structure of a Workbook
04:13
Adding a Workbook Password
03:15

Mastering Excel's "What If?" Tools

4 lectures
Working with Excel's Goal Seek Tool
07:41
Working with Excel's Solver Tool
10:45
Building Effective Data Tables in Excel
06:17
Creating Scenarios in Excel
07:51

Automating Repetitive Tasks in Excel with Macros

5 lectures
Understanding Excel Macros
03:50
Activating the Developer Tab in Excel
01:42
Creating a Macro with the Macro Recorder
07:39
Editing a Macro with VBA
05:16
Creating Buttons to Run Macros
03:11

Excel 103 Additional Practice Exercises

1 lectures
Excel 103 - Practice What You've Learned (DOWNLOAD)
00:09

Congratulations!

1 lectures
Congratulations on Completing the Microsoft Excel 103
01:39

Microsoft Excel Macros and VBA Course Introduction

2 lectures
Welcome to the Course
05:50
Understanding the Why and How Behind Excel Macros
05:15

Project #1: Using Excel's Macro Recorder Tool

11 lectures
Introduction to Project #1: Inserting and Formatting Text
03:36
Project #1: Section Exercise Files (DOWNLOAD)
00:16
Activating the Excel Developer Tab
02:20
Project #1: Start Recording!
11:16
Running a Microsoft Excel Macro
04:15
Project #1: Running an Excel Macro with a Button
05:52
BONUS - Create a Custom Button Using Excel Shapes
04:04
Adding the Excel Macro to the Quick Access Toolbar
04:03
Project #1: Editing the VBA Recorded by the Macro Recorder
11:59
Save a Workbook with a Macro/VBA Code
02:34
Practical Uses of Excel Macros
02:21

Excel VBA Concepts

13 lectures
Intro to Excel VBA Concepts
07:02
Intro to Excel VBA Object Oriented Programming Concepts
04:58
Intro to Excel VBA Exercise Files (DOWNLOAD)
00:17
The Visual Basic Editor (VBE)
05:07
Introduction to the Excel VBA Immediate Window
12:34
Excel VBA Modules
03:45
Creating an Excel VBA Procedure
06:22
Adding Code to a VBA Procedure
04:44
Including Excel VBA Comments
02:46
Excel VBA MSGBOX Function
07:27
Excel VBA MsgBox Microsoft Help Information
02:08
Understanding and Working with Excel VBA Variables
16:28
REMINDER: Saving an Excel Workbook with VBA Code
02:29

Working with Excel VBA Logic Statements

9 lectures
Working with Excel VBA Logic Exercise Files (DOWNLOAD)
00:16
Building Logic with an Excel VBA IF Statement
08:46
Including an Else Statement in the VBA IF Statement
01:43
Expanding the IF Logic with Multiple ElseIf Statements
03:12
Working with Excel VBA Select Case Statements
05:15
Working with an Excel VBA Do While Loop
12:26
Excel VBA Do While Loop Dynamic Condition
06:13
Working with an Excel VBA For Each Loop
06:31
Working with an Excel VBA For Next Loop
08:07

Project #2: Moving Beyond the Basics and into VBA

10 lectures
Introduction to Project #2: Interacting with the User
01:56
Beyond the Basics Sort Project Exercise Files (DOWNLOAD)
00:16
Project #2: Introduction to the Excel VBA Range.Sort Method
04:47
Creating the Excel VBA Sort Procedures for this Project
09:29
Project #2: Prompting the User for Information
09:44
Continue Excel VBA InputBox
09:17
Project #2: Building Logic into Your Macros
04:15
Project #2: Alerting the User of Errors
10:03
Using Excel VBA Error Control Statements
04:39
Create a Button to Run the Sort Procedure and Save
02:14

Project #3: Preparing and Cleaning Up Data with Excel VBA

9 lectures
Introduction to Project #3: Cleaning Up and Formatting Data
02:31
Project #3: Exercise Files (DOWNLOAD)
00:15
Project #3: Preparing to the Use the Macro Recorder
03:16
Project #3: Inserting the Headers
04:57
Project #3: Formatting the Headers
04:23
Project #3: Testing the Macros
02:35
Project #3: Using an Excel VBA Loop to Loop through all Worksheets
10:04
Project #3: Testing the Excel VBA Loop
03:09
Project #3: Adding Logic to an Excel VBA Loop
07:29

Project #4: Using VBA to Automate Excel Formulas

7 lectures
Introduction to Project #4: Automate Excel Formulas
01:50
Project #4: Automate Sum Function Exercise Files (DOWNLOAD)
00:15
Project #4: Start the Procedure to Automate the SUM Function
06:49
Working with the Range Address Property
05:25
Creating the SUM Function in VBA
06:15
Run the Excel VBA Procedure to SUM Records
02:56
Project #4: Loop the SUM() Function Over Multiple Worksheets
05:25

Project #5: Bringing it All Together and a Weekly Report

8 lectures
Introduction to Project #5: Creating the Final Report
02:09
Project #5: Final Report Loop Exercise Files (DOWNLOAD)
00:15
Project #5: Creating the Final Report Excel VBA Loop
05:02
Project #5 - Copying Content with Excel VBA
05:45
Project #5 - Pasting Content with Excel VBA
04:53
Cleaning Up the Final Report VBA Loop Code
05:22
Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet
05:47
Project #5 - Running the Final Report Procedure
02:03

Project #6: Working with Excel VBA User Forms

15 lectures
Introduction to Project #6: Working with Excel VBA User Forms
03:01
Project #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)
00:15
Project #6: Creating an Excel User Form
05:29
Project #6: Working with Form and Control Properties
06:36
Project #6: Formatting Excel VBA User Form Controls
03:21
Project #6: Adding VBA Code to the Initialize Event
09:27
Project #6: Using the AddItem Method within a Loop
10:00
Project #6: Adding VBA Code to the ComboBox Change Event
03:53
Project #6: Adding VBA Code to the Add Worksheet Button
03:51
Project #6: Change Worksheet Name
03:21
Project #6: Catch Errors When Adding a Worksheet
02:48
Add Sheet Procedure Catch Errors
00:36
Project #6: Additional Conditions on the Loop
05:57
Project #6: Running the Final Report Procedure
02:54
Project #6: Showing the VBA User Form On Workbook Open
03:47

Project #7: Importing Data from Text Files

9 lectures
Project #7: Opening a Text File for Import
02:42
Project #7: Opening a Text File for Import
06:45
Project #7: Get Data from Text File
05:30
Project #7: Importing Multiple Text Files with the GetOpenFilename Method
09:32
Project #7: Creating a Loop to Read Each File
07:26
Project #7: Adding a New Sheet for Imported Data
02:36
Project #7: Clear the Clipboard
03:38
Project #7: Working with the ScreenUpdating Property
03:16
Project #7: Creating Reusable Code with a VBA Function
07:44

Course Wrap Up

1 lectures
Congratulations! You're an Excel Macro/VBA Master
01:02

Đá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

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
SharePoint Content Management and Content Organizer

SharePoint Content Management and Content Organizer

399.000 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