You know how to use MS Excel and you’re pretty good at creating spreadsheets. But pretty good isn’t good enough. If you want to join the big leagues, then you’ll need professional skills and this Microsoft Office 2016 Excel Intermediate course is just the thing you need.
This course was specially designed for individuals like you, who have some skills in MS Excel and want to take it to the next level.
Learn how to work with advanced formulas, lists, and illustrations. Also work with charts and advanced formatting, including styles and many more. This is the course that’ll give you the skills that’ll make you stand out from other people.
So if all this sounds interesting to you and you want to join the big boys then take this course and we’ll begin your training.
Course Curriculum
-
Work with Ranges
00:18:00 -
Use Specialized Functions
00:11:00
-
Work with Logical Functions
00:23:00
-
Work with Date & Time Functions
00:08:00
-
Work with Text Functions
00:11:00
-
Sort Data
00:10:00
-
Filter Data
00:10:00
-
Query Data with Database Functions
00:09:00
-
Outline and Subtotal Data
00:09:00
-
Create and Modify Tables
00:15:00
-
Apply Intermediate Conditional Formatting
00:07:00
-
Apply Advanced Conditional Formatting
00:05:00
-
Create Charts
00:13:00
-
Modify and Format Charts
00:12:00
-
Use Advanced Chart Features
00:12:00
-
Create a PivotTable
00:13:00
-
Analyze PivotTable Data
00:12:00
-
Present Data with PivotCharts
00:07:00
-
Filter Data by Using Timelines and Slicers
00:11:00
-
Mock Exam- Microsoft Office 2016 Excel Intermediate – Complete Video Course
00:20:00
-
Final Exam- Microsoft Office 2016 Excel Intermediate – Complete Video Course
00:20:00
-
Duration:4 hours, 16 minutes
-
Access:1 Year
-
Units:21
Want to get everything for £149
Take Lifetime Pack
