Microsoft Office 2016 Excel - Advanced Series

Price: $99 ~~$199~~

Format: On Demand

Duration: 3 Hours

Course Overview

This course teaches students about working with multiple worksheets and workbooks, using lookup functions and formula auditing, sharing, and protecting workbooks, automating workbook functionality, creating Sparklines and mapping data, and forecasting data. Many of the powerful functions and capabilities of Excel go beyond what is intuitive and require expert skills. This course enables you to master advanced tools and features of MS Excel 2013 MS Excel certification is a smart investment in building expertise in finance or business.

Course 01 – Working with Multiple Worksheets and Workbooks
Course 02 – Using Lookup Functions and Formula Auditing
Course 03 – Sharing and Protecting Workbooks
Course 04 – Automating Workbook Functionality
Course 05 – Creating Sparklines and Mapping Data
Course 06 – Forecasting Data

Audience

This series is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

Career Path

In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.

Available CEUs for Course Series Completion: 8
Students can earn up to 8 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.

Download Course Description (PDF)

Certification Details

Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2016. Candidates will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

Certification Exam Details
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to Click here for certification details.

Additional Information about Continuing Education Units (CEUs)

Continuing Education Units (CEU's) are required by some certifying organizations to measure your current and continuing learning. Organizations may require you to meet a given number of education units in a specific period of time in order for your certification to be considered valid.
By completing a TechTrainingAcademy.com course series, you will be rewarded with a certificate of completion. This certificate will show how many CEU's that particular course series was worth. Students may provide this certificate to their certifying organization to provide proof of participation and completion of a Tech Training Academy.com training course series.

Please Note: The acceptance of CEU credits through completion of a Tech Training Academy training course series is solely the decision of the certifying organization. Please reach out to your certifying organization for further details and confirmation of acceptance of Tech Training Academy CEUs.

Our Online On Demand Training Courses give YOU the ability to train wherever, whenever you want! Our courses include the following training features:

- Expert Lectures
  - Learn on-demand from top instructors who are industry subject matter experts. Our highly certified expert instructors possess a superior understanding of the subject matter in their fields and have the ability to convey this knowledge in an effective, engaging, and professional manner to a wide audience.

- Certificates of Completion
  - Upon completion of a series of courses you can earn a certificate of completion. Certificates of Completion will display your full name, course completed, as well as the date of completion. Students have the ability to print this out or save it digitally to showcase your accomplishment.

- Keynote Visuals
  - Many of the in-depth theories and processes discussed in our courses can be learned most efficiently through the detailed Keynote slides presented. These visuals are accompanied by an instructor voice-over to provide our students with a clear, efficient, and complete presentation of concepts.

- Demonstrations
  - The immersive demonstrations in our training are a way for the instructor to present how to perform a task on-screen in front of the student. This feature gives the student the power to see tasks performed by a professional in the intended environment as many times as they would like, without purchasing expensive software.

- Review Quizzes
  - Once a course is completed, test your knowledge by taking our course review quiz! Students have the ability to retake any review quizzes as many times as they wish to ensure they understand the material or to improve upon their scores.

- Final Exams
  - Upon full completion of a training series, students can take a Series Final Exam, these exams are designed to test the students knowledge on all material trained within a series of courses. Students have the ability to retake any final exam as many times as they wish to ensure they understand the material or to improve upon their score.

- Mobile Access
  - With our universal course player, you can learn from your computer, tablet as well as mobile devices. Keep up with your training on the go!

- Workbooks
  - Each course comes with a printable workbook that makes it easy to take notes as you learn. They also include a review quiz answer key, complete with answer explanations.

These features are provided with all 1,500+ IT, Cyber Security, Project Management, Software Development, and Business Skills training courses in our on-demand course catalog.

Office Productivity Continuing Education Units (CEU)

Course Name	CEU Credits
Microsoft Office 2019: New Features	5
Microsoft Office 2016: Access 2016 Advanced	5
Microsoft Office 2016: Access 2016 Intermediate	5
Microsoft Office 2016: Access 2016 Basic	5
Microsoft Office 2016: PowerPoint 2016 Basic	7
Microsoft Office 2016: PowerPoint 2016 Advanced	5
Microsoft Office 2016: New Features	4
Microsoft Office 2016 Excel Basic	8
Microsoft Office 2016 Excel Intermediate	8
Microsoft Office 2016 Excel Advanced	8
Microsoft Office 2016 Word Basic	5
Microsoft Office 2016 Word Intermediate	5
Microsoft Office 2016 Word Advanced	4
Microsoft Office 2013 Access Basic	6
Microsoft Office 2013 Access Intermediate	5
Microsoft Office 2013 Access Advanced	5
Microsoft Office 2013 Excel Basic	8
Microsoft Office 2013 Excel Intermediate	7
Microsoft Office 2013 Excel Advanced	6
Microsoft Office 2013 Lync Essentials	4
Microsoft Office 2013 Outlook Basic	5
Microsoft Office 2013 Outlook Advanced	5
Microsoft Office 2013 PowerPoint Basic	7
Microsoft Office 2013 PowerPoint Advanced	5
Microsoft 2013 Project Basic	6
Microsoft 2013 Project Advanced	6
Microsoft Office 2013 Word Basic	6
Microsoft Office 2013 Word Intermediate	6
Microsoft Office 2013 Word Advanced	6
Microsoft Office Transition to Office 2013 from Office 2007/2010	5
Microsoft Office 2010 Access Basic	6
Microsoft Office 2010 Access Intermediate	6
Microsoft Office 2010 Access Advanced	6
Microsoft Office 2010 Excel Basic	7
Microsoft Office 2010 Excel Intermediate	7
Microsoft Office 2010 Excel Advanced	6
Microsoft Office 2010 New Features	5
Microsoft Office 2010 Outlook Basic	6
Microsoft Office 2010 Outlook Intermediate	6
Microsoft Office 2010 Outlook Advanced	5
Microsoft Office 2010 PowerPoint Basic	6
Microsoft Office 2010 PowerPoint Advanced	6
Microsoft 2010 Project Basic	5
Microsoft 2010 Project Advanced	5
Microsoft Office 2010 Word Basic	6
Microsoft Office 2010 Word Intermediate	6
Microsoft Office 2010 Word Advanced	6
Microsoft Office 2007 Access Basic	6
Microsoft Office 2007 Access Intermediate	6
Microsoft Office 2007 Access Advanced	5
Microsoft Office 2007 Excel Basic	6
Microsoft Office 2007 Excel Intermediate	7
Microsoft Office 2007 Excel Advanced	6
Microsoft Office 2007 Outlook Basic	6
Microsoft Office 2007 Outlook Intermediate	5
Microsoft Office 2007 Outlook Advanced	5
Microsoft Office 2007 PowerPoint Basic	6
Microsoft Office 2007 PowerPoint Advanced	5
Microsoft 2007 Project Basic	5
Microsoft 2007 Project Advanced	5
Microsoft Office 2007 Word Basic	6
Microsoft Office 2007 Word Intermediate	8
Microsoft Office 2007 Word Advanced	6
Microsoft Office 365 - Administration Basics	5
Microsoft Office 365 - For End Users	5
Microsoft Office 365 - SharePoint for End Users	4
Microsoft Office 365 - Web Apps	5

Microsoft Office 2016 Excel – Advanced Series

Microsoft Office 2016 Edition

Course Overview

Certification Details

Additional Information about Continuing Education Units (CEUs)

Office Productivity Continuing Education Units (CEU)

Microsoft Office 2016 Excel – Advanced Series

Microsoft Office 2016 Edition

Course Overview

Certification Details

Additional Information about Continuing Education Units (CEUs)

Office Productivity Continuing Education Units (CEU)

Subscribe for promotions and discounts!