Description
Microsoft Excel – Excel from Beginner to Advanced & VBA , is the name of the video training series in the field of working with written documents and Microsoft Excel software. In this training course, you will be taught how to work with this very useful software at different levels. By watching this training course, you will 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 software (VBA). In this way, you will become an Excel software expert by watching this course completely.
By watching this video course, you will learn the latest and most efficient techniques and skills in using Microsoft Excel. You will learn formulas that can be used in Excel in a beginner and advanced way. On the other hand, by watching this training course, you will be able to prepare and use the best reports from the tables and tools available in Excel.
Features of the Microsoft Excel training course – Excel from Beginner to Advanced & VBA:
- Learning applications and tasks that can be implemented with Excel software
- Learning how to work with Microsoft Excel software from an introductory level to an advanced level
- Learning VBA level in working with Microsoft Excel software in a very advanced way
- Learning formulas that can be used in the Excel software environment from introductory to advanced level
- Learn how to prepare and present dynamic and detailed reports from your tables and document information
- And…
Specifications of the Microsoft Excel course – Excel from Beginner to Advanced & VBA:
- Publisher: Udemy
- Instructor: Brian Wells
- Level: Introductory to Advanced
- Duration: 09:46:22
- Number of lessons: 140 lessons
- English language
Headlines of the Microsoft Excel course – Excel from Beginner to Advanced & VBA:
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
Required conditions
- 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 an advanced user of Excel.
Pictures
Sample video
Installation guide
After extracting, watch with your favorite player.
This tutorial has English subtitles.
The training date is correct as 1/2019.
The quality of the videos is 720p.
download link
Password file(s): www.downloadly.ir
Size
5.44 GB
Be the first to comment