Microsoft Excel 2013 Specialization Training
About Course
Course Introduction
What you’ll learn
-
Master Microsoft Excel from Beginner to Advanced
-
Build a solid understanding on the Basics of Microsoft Excel
-
Learn the most common Excel functions used in the Office
-
Maintain large sets of Excel data in a list or table
-
Create dynamic reports by mastering one of the most popular tools, PivotTables
-
Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
-
Access to a Professional Trainer with 10+ years of Excel Training
Certification
Upon completing this course, students will receive a verified certificate to boost their career. (See sample certificate below)
Requirements
-
This course was created with Excel 2013. But all features will work in Excel 2010, 2013, 2016 and most will work in 2007.
***** Recent Student Review *****
Doran Isaac, Lagos State
“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.”
Yes! Oh my gosh. I need this. We are using excel for school now and I was completely lost with it. You are amazing Bucky. Great timing, thank you!
***** “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.“
Course Content
Basic
-
Introduction to Microsoft Excel 2013
-
Making Data Beautiful
-
Working with Cells
-
Formatting Numbers
-
Inserting Rows and Columns
-
Copy and Move Ranges
-
Worksheet Tips
-
Tables
-
Working with Tables
-
Formatting Your Worksheet
-
Fitting Text and Merging Cells
-
Formatting Cells
-
Format Painter and Protecting Workbooks
-
Templates and Printing
-
Formulas and Functions
-
PEMDAS and Naming Ranges
-
Referencing Cells Properly
-
Using Formulas in Tables
-
String Functions
-
More Cool String Functions
-
Boring Date and Time Stuff
-
Happy Election Day!
-
Cool Counting Functions