Microsoft Excel 2013 Specialization Training
About Course
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 certificate from The Association of Professional Women Engineers of Nigeria to boost their career.
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
-
Awesome Formula Tips
-
Boring Date and Time Stuff
-
Total Row and Sorting Tables
-
Cool Counting Functions
Student Ratings & Reviews
No Review Yet