ZPDI1299 - Microsoft Excel 2016 (Online)

Course Description

Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels.  

Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively at home and in the workplace. Understand how to manipulate data within a spreadsheet and validate and present information using the built-in structure and functions of Microsoft Excel.

This course includes:

• Visual Demonstrations and Multimedia Presentations
• Quizzes and Exam Simulators
• Social Learning and Networking
• Flash Cards and Educational Games
• Enhanced Navigation and Controls

Course Outline

Excel Beginner

• 1.1 Tabs And Ribbons Part 1
• 1.2 Tabs And Ribbons Part 2
• 1.3 Cells Part 1
• 1.4 Cells Part 2
• 1.5 Cells Part 3
• 1.6 Cells Part 4
• 1.7 Calculations Part 1
• 1.8 Calculations Part 2
• 1.9 Calculations Part 3
• 1.10 Printing Part 1
• 1.11 Printing Part 2

Excel Intermediate

• 1.1 Menus And Keyboard Shortcuts Part 1
• 1.2 Menus And Keyboard Shortcuts Part 2
• 1.3 Menus And Keyboard Shortcuts Part 3
• 1.4 Tabs Part 1
• 1.5 Tabs Part 2
• 1.6 Formulas And Calculations Part 1
• 1.7 Formulas And Calculations Part 2
• 1.8 Formulas And Calculations Part 3
• 1.9 Formulas And Calculations Part 4
• 1.10 Importing Data Part 1
• 1.11 Importing Data Part 2
• 1.12 Invoices

Excel Advanced

• 1.1 Advanced Invoice Part 1
• 1.2 Advanced Invoice Part 2
• 1.3 Advanced Invoice Part 3
• 1.4 Advanced Invoice Part 4
• 1.5 Number Crunching
• 1.6 Creating A Pivot Table From Scratch
• 1.7 Smaller Excel Components Part 1
• 1.8 Smaller Excel Components Part 2
• 1.9 Smaller Excel Components Part 3

Notes

Participants will have 12 months to complete this self-paced online course.

All necessary materials are included.

Certification(s):

This course prepares students to take the Microsoft Office Specialist: Excel Associate certification exam.

System Requirements:

Internet Connectivity Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online-based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla Firefox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite (Microsoft Office, OpenOffice or LibreOffice)
• PDF reader program (Adobe Reader, Foxit)
• Courses may require other software that is denoted in the above course outline.