Udemy – Microsoft Excel – Excel from Beginner to Advanced & VBA 2019-1

Description

Microsoft Excel - Excel from Beginner to Advanced & VBA, is the name of a video tutorial on working with written documents and Microsoft Excel software. In this training course, you will be taught how and skills to work with this very practical software at different levels. By watching this training course, you will first learn how to work with this Microsoft product from the introductory level. After that, you will learn intermediate and advanced level. And finally you will learn advanced work with Excel (VBA) software. In this way, you will become an Excel software expert by observing this course in full.

By watching this video course, you will learn the latest and most efficient techniques and skills in using Microsoft Excel. You will learn the formulas that can be used in Excel as a beginner and advanced. On the other hand, by watching this training course, you will be able to prepare the best reports and use the tables and tools available in Excel.

Features of Microsoft Excel - Excel from Beginner to Advanced & VBA training course:

Learn the applications and tasks that can be performed with Excel software

Learn how to work with Microsoft Excel software from basic to advanced level

Learn VBA level by working with Microsoft Excel software in a very advanced way

Learn formulas applicable in Excel software environment from basic to advanced level

Learn how to prepare dynamic and accurate reports from your tables and document information

Microsoft Excel - Excel from Beginner to Advanced & VBA course specifications:

Publisher: Udemy

Instructor: Brian Wells

Level: Basic to Advanced

Duration: 09:46:22

Number of lessons: 140 lessons

English language

Microsoft Excel - Excel from Beginner to Advanced & VBA course titles:

Course content 140 lectures 09:46:22

Welcome To Your Excel Course! 1 lecture 02:04

Microsoft Excel 101 – Course Exercise Files 1 lecture 01:01

Setting Up Your System – Microsoft Excel 1 lecture 06:08

Microsoft Excel Beginner Introduction 11 lectures 51:25

84 Microsoft Excel Keyboard Shortcuts 8 lectures 33:26

Modifying an Excel Worksheet 6 lectures 18:30

TEST #1 – Excel Beginner Level 0 lectures 00:00

Formatting Data in an Excel Worksheet 8 lectures 23:23

Excel Templates 3 lectures 10:49

Printing an Excel Worksheet 6 lectures 20:43

Microsoft Excel Charts 5 lectures 24:42

Beginner to Intermediate Formula Knowledge 10 lectures 52:18

TEST #2 – Excel Intermediate Level 0 lectures 00:00

Congratulations! You’ve Mastered Beginner to Intermediate Microsoft Excel. 1 lecture 00:22

Advanced Formula Knowledge – Importing Data, VLOOKUP & More! 6 lectures 32:47

CONCAT & CONCATENATE Functions 3 lectures 09:51

ADDRESS & INDIRECT Functions 4 lectures 16:11

INDEX & MATCH Functions 6 lectures 25:44

Sorting, Filtering, Tables, Ranges & More! 5 lectures 21:00

Master Excel’s Advanced Filtering Tool 7 lectures 20:45

Pivot Tables – Beginner to Intermediate 5 lectures 26:45

Pivot Tables – Advanced Level 6 lectures 23:05

Presenting, Evaluating, Cell Formatting, Conditional Formatting & More! 6 lectures 23:03

Validating & Updating Microsoft Excel Data 5 lectures 23:33

Project #1: Using Excel’s Macro Recording Tool 7 lectures 21:52

VBA Concepts 8 lectures 38:51

Project #2 Moving into Excel VBA 6 lectures 42:32

Final Preparation Measures: IMPORTANT 4 lectures 14:14

Congratulations Your Done! 1 lecture 01:18

Requirements

No prior knowledge of Microsoft Excel is needed! This course is designed to teach you every aspect that you need to graduate from a beginner to advanced user of Excel.

Installation

After Extract, watch with your favorite Player.

This tutorial has English subtitles.

The training date is valid as 2019/1.

The quality of the videos is 720p.