Download Microsoft Excel training course from Beginner to Advanced
Link download Microsoft Excel 2013 – 2019 course for you
Download Microsoft Excel 2013 – 2019 course
Learning Microsoft Excel 2013 – 2019 course
Duration: 21h
Handout type: Video tutorial
English language
Descriptions: 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)
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.
Contents
01 – Microsoft Excel 101 Course Introduction
02 – Microsoft Excel Fundamentals
03 – Entering and Editing Text and Formulas
04 – Working with Basic Excel Functions
05 – Modifying an Excel Worksheet
06 – Formatting Data in an Excel Worksheet
07 – Inserting Images and Shapes into an Excel Worksheet
08 – Creating Basic Charts in Excel
09 – Printing an Excel Worksheet
10 – Working with Excel Templates
11 – Excel 101 – Practice What You’ve Learned (DOWNLOAD)
12 – Congratulations! You’ve Built a Solid Microsoft Excel Foundation
13 – Microsoft Excel 102 Course Introduction
14 – Working with an Excel List
15 – Excel List Functions
16 – Excel Data Validation
17 – Importing and Exporting Data
18 – Excel PivotTables
19 – Working with Excel’s PowerPivot Tools
20 – Working with Large Sets of Excel Data
21 – Excel 102 Additional Practice Exercises
22 – Congratulations! You’re an Intermediate Excel User
23 – Microsoft Excel 103 Course Introduction
24 – Working with Excel’s Conditional Functions
25 – Working with Excel’s Lookup Functions
26 – Working with Excel’s Text Based Functions
27 – Auditing an Excel Worksheet
28 – Protecting Excel Worksheets and Workbooks
29 – Mastering Excel’s What If Tools
30 – Automating Repetitive Tasks in Excel with Macros
31 – Excel 103 Additional Practice Exercises
32 – Congratulations!
33 – Microsoft Excel Macros and VBA Course Introduction
34 – Project #1 Using Excel’s Macro Recorder Tool
35 – Excel VBA Concepts
36 – Project #2 Moving Beyond the Basics and into VBA
37 – Project #3 Preparing and Cleaning Up Data with a Little VBA
38 – Project #4 Using VBA to Automate Excel Formulas
39 – Project #5 Bringing it All Together and a Weekly Report
40 – Project #6 Working with Excel VBA User Forms
41 – Project #7 Importing Data from Text Files
42 – Course Wrap Up
For download this video training course (Microsoft Excel 2013-2019) videos), please click to download sysmbol and complete your checkout to support a little bit to help my website is maintained. The download link will be appeared automatically after you complete your payment.
After you receive *.zip file, open it and open *.txt instruction’s file to see video for download instruction if you don’t know how to download.
All make sure you’ll get best services and we’ll help you any time when you get any problems. Don’t mind to contact admin: [email protected].
p/s: You also can request somethings which don’t have inside this website, we’ll try our best to them it for you.
Thank you.
