The description
Microsoft Excel – Beginner to Advanced Excel and VBA is the name of a video tutorial on using text documents and Microsoft Excel software. This course will teach you how and how to work with this highly functional software at different levels. By watching this course, you will first learn how to use this product from Microsoft’s introductory level. You will then learn the intermediate and advanced levels. And finally you will learn advanced work with Excel software (VBA). By doing this, you will become an Excel software expert.
By watching this video course, you will learn the latest and most effective techniques and skills for using Microsoft Excel. You will learn beginner and advanced formulas that can be used in Excel. On the other hand, by watching this course, you will be able to create and use the best reports and tables in Excel.
Microsoft Excel Course Features – Beginner to Advanced Excel and VBA:
- Discover the applications and tasks that run with Excel software
- Learn to work with Microsoft Excel software from beginner to advanced level
- Advanced VBA level learning by working with Microsoft Excel
- Learn the formulas applicable in the Excel software environment from basic to advanced level
- Learn how to create and deliver dynamic and accurate reports from your document tables and information
- And…
Microsoft Excel Course Specifications – Beginner to Advanced Excel and VBA:
- Publisher: Udemy
- Instructor: Brian Wells
- Level: Basic to Advanced
- Duration: 09:46:22
- Number of lessons: 140 lessons
- English language
Microsoft Excel Course – Beginner to Advanced Excel and VBA:
Course content
140 lectures 09:46:22
Welcome to your Excel course!
1 conference 02:04
Microsoft Excel 101 – Lesson Exercise Files
1 conference 01:01
Configuring Your System – Microsoft Excel
1 conference 06:08
Introduction to Microsoft Excel for beginners
11 lessons 51:25
84 Microsoft Excel Keyboard Shortcuts
8 lessons 33:26
Edit an Excel spreadsheet
6 lessons 6:30 p.m.
TEST # 1 – Excel beginner level
0 lesson 00:00
Format data in an Excel spreadsheet
8 sessions 23:23
Excel Templates
3 lessons 10:49
Print an Excel spreadsheet
6 lessons 20:43
Microsoft Excel charts
5 lectures 24:42
Knowledge of formulas from beginner to intermediate level
10 lessons 52:18
TEST # 2 – Excel intermediate level
0 lesson 00:00
Congratulations! You have mastered Microsoft Excel from beginner to intermediate level.
1 lecture 00:22
Advanced knowledge of formulas – Data import, VLOOKUP and more!
6 lessons 32:47
CONCAT & CONCATENATE functions
3 lessons 09:51
ADDRESS & INDIRECT functions
4 lessons 16:11
INDEX & MATCH functions
6 lessons 25:44
Sorting, filtering, tables, ranges and more!
5 lectures 21:00
Master Excel advanced filter tool
7 lectures 20:45
Pivot Tables – Beginner to Intermediate
5 lessons 26:45
Pivot Tables – Advanced Level
6 lessons 23:05
Presentation, rating, cell formatting, conditional formatting and more!
6 lessons 23:03
Validating and updating Microsoft Excel data
5 lessons 23:33
Project #1: Using Excel’s Macro Recording Tool
7 lessons 21:52
VBA concepts
8 lessons 38:51
Project #2 Switch to Excel VBA
6 lessons 42:32
Final Preparedness Measures: IMPORTANT
4 lessons 14:14
Congratulations, you are done!
1 conference 01:18
Terms
- No previous knowledge of Microsoft Excel is necessary! This course is designed to teach you all the aspects you need to go from a beginner to an advanced user of Excel.
Pictures
sample movie
Installation guide
View with your favorite player after ripping.
This tutorial has English subtitles.
The formation date is correct as of 2019/1.
The video quality is 720p.
Download link
File password(s): ngaur.com
Cut
5.44 GB