Microsoft Office 2016 Excel Advanced

Excelin IT training Career Academy is a online course provider in IT and Project Management. Our aim is to offer online Professional training courses in IT, Project Management, IT service Management, Cyber Security, Business and Office skills to assist you in keeping you up to date with the fast-changing technology and current requirement of the industry. Our courses are online and are cost effective to suit your busy work schedule and are self-pace and can be studied at any time and place.

We offer a complete solution for Professional development for the beginners as well as for the experienced professional individuals. We offer the range of Professional Certification courses such as MCSA, MCSE, CompTIA A+, CompTIA Network +, CompTIA Security +, CCNA, CCNP, VMware, ITIL, COBIT, PNP, Prince 2 and many more. Please check on the website to find many exciting courses to assist you to take that first step into IT industry with one of our courses for beginners and experienced ones can always upgrade their skills with professional certification online courses and develop further into their career.

This series will teach students advanced concepts and formulas in Microsoft Excel 2016. This series is designed for students to gain the skills necessary to use pivot tables, audit and analyse 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.

Series Taught By: Patrick Loner

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:

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.

Access Training Courses Below

Click any of the titles below to launch your videos:

Chapter 01 – Working with Multiple Worksheets and Workbooks — 23 m

Chapter 02 – Using Lookup Functions and Formula Auditing — 27m

Chapter 03 – Sharing and Protecting Workbooks — 25m

Chapter 04 – Automating Workbook Functionality — 32m

Chapter 05 – Creating Spark lines and Mapping Data — 12m

Chapter 06 – Forecasting Data 23m

Training Final Exam

Currently there are no Q&As for this course. Be the first to ask a question.

Certificate of completion

Digital certificate - Included