Udemy – Microsoft Excel – Excel from Beginner to Advanced 2020-5

Description

Microsoft Excel - Excel from Beginner to Advanced, is the name of the video tutorial suite of Microsoft Excel software. This tutorial is known as the Excel alphabet. You will start learning from the most basic level. This training package has been prepared in such a way that it seems that you do not know anything about Excel software, and all the tutorials have been provided accurately and basically.

The training package in front of you includes Microsoft Office training for 2010, 2013 and 2016. At the end of this training course you will become a professional. Do all the things you need to do and learn them are contained in this tutorial. This tutorial prepares you for endless use of Microsoft Excel software.

Microsoft Excel - Excel from Beginner to Advanced course feature:

With this video tutorial, you will transform from a beginner to an advanced person working with Microsoft Excel software. In this training package, which is about 15 hours of video training, you will understand and learn the concepts and basics of working with this widely used software. Also, this training package has been prepared by a person who has more than 10 years of professional experience with this software. This training package will be very useful for you if you want to become a professional in using Excel software.

Course specifications

Publisher: Udemy

Instructor: Kyle Pew

Level: Basic to Advanced

Duration: 17:24:14

Number of lessons: 211 lessons

English language

Microsoft Excel - Excel from Beginner to Advanced:

Course content 211 lectures 17:24:14

Microsoft Excel 101 Course Introduction 3 lectures 04:28

Microsoft Excel Fundamentals 9 lectures 30:57

Entering and Editing Text and Formulas 7 lectures 01:02:59

Working with Basic Excel Functions 9 lectures 46:19

Modifying an Excel Worksheet 7 lectures 36:45

Formatting Data in an Excel Worksheet 9 lectures 36:18

Inserting Images and Shapes into an Excel Worksheet 4 lectures 19:29

Creating Basic Charts in Excel 6 lectures 25:42

Printing an Excel Worksheet 5 lectures 21:39

Working with Excel Templates 3 lectures 11:40

Congratulations! You’ve Built a Solid Microsoft Excel Foundation 1 lecture 01:55

Microsoft Excel 102 Course Introduction 1 lecture 01:15

Working with an Excel List 9 lectures 44:50

Excel List Functions 7 lectures 37:33

Excel Data Validation 5 lectures 24:13

Importing and Exporting Data 7 lectures 34:08

Excel PivotTables 9 lectures 41:30

Working with Excel’s PowerPivot Tools 6 lectures 28:41

Working with Large Sets of Excel Data 5 lectures 25:06

Congratulations! You’re an Intermediate Excel User 1 lecture 01:32

Microsoft Excel 103 Course Introduction 1 lecture 01:23

Working with Excel’s Conditional Functions 10 lectures 50:58

Working with Excel’s Lookup Functions 7 lectures 51:47

Working with Excel’s Text Based Functions 4 lectures 28:02

Auditing an Excel Worksheet 4 lectures 13:58

Protecting Excel Worksheets and Workbooks 3 lectures 15:33

Mastering Excel’s “What If?” Tools 4 lectures 32:34

Automating Repetitive Tasks in Excel with Macros 5 lectures 21:38

Congratulations! 1 lecture 01:39

Microsoft Excel Macros and VBA Course Introduction 3 lectures 11:21

Project #1: Using Excel’s Macro Recorder Tool 6 lectures 22:42

Excel VBA Concepts 8 lectures 44:20

Project #2: Moving Beyond the Basics and into VBA 7 lectures 39:01

Project #3: Preparing and Cleaning Up Data with a Little VBA 6 lectures 25:28

Project #4: Using VBA to Automate Excel Formulas 5 lectures 26:41

Project #5: Bringing it All Together and a Weekly Report 4 lectures 23:24

Project #6: Working with Excel VBA User Forms 9 lectures 45:48

Project #7: Importing Data from Text Files 9 lectures 49:09

Course Wrap Up 2 lectures 01:50

Prerequisites

This course was created with Excel 2013. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.

Installation

After Extract, watch with your favorite Player.

English subtitle

The quality of the videos is 720p.

Changes:

The 2019/10 version has increased by 6 lessons and about 1 hour compared to 2018/12.

Version 2020/5 has increased by 16 lessons and about 1.5 hours compared to 2019/10. The volume has almost doubled.

Version 2020/7 compared to 2020/5 has not changed in the number of courses and total time and has not been updated.