Microsoft Excel 2016 Advanced Level - CPD Accredited - Best Seller
Course
Online
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
7h
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Having basic knowledge of Excel 2016 is helpful for users who want to use basic features of the program. But if you want to improve your experience with Excel 2016 then this course is designed for you to fully utilize it.
Excel 2016 features pivot tables, input tables, and different type of charts which this Microsoft Excel 2016 Advanced Level will teach you how to create. This course will also teach how you can create password-protected worksheets in the application to ensure security.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods
Reviews
Subjects
- Excel
- XML training
- XML
- Microsoft Excel
- Web
- Accredited
- Export
- Import
- Microsoft excel training
- MS Excel
Teachers and trainers (1)
Alpha Academy
Instructor
Course programme
COURSE CURRICULUM
Automating Worksheet Functionality
- Update Workbook Properties
- Activity-Update Workbook Properties
- Create and Edit a Macro
- Activity-Create and Edit a Macro
- Apply Conditional Formatting
- Activity-Apply Conditional Formatting
- Add Data Validation Criteria
- Activity-Add Data Validation Criteriaty
Auditing Worksheets
- Trace Cells
- Activity-Trace Cells
- Troubleshoot Invalid Data and Formula Errors
- Activity-Troubleshoot Invalid Data and Formula Errors
- Watch and Evaluate Formulas
- Activity-Watch and Evaluate Formulas
- Create a Data List Outline
- Activity-Create a Data List Outline
Analyzing and Presenting Data
- Create Sparklines
- Activity_Create Sparklines
- Create Scenarios
- Activity-Create Scenarios
- Perform a What-If Analysis
- Activity-Perform a What-If Analysis
- Perform a Statistical Analysis with the Analysis ToolPak
- Activity-Perform a Statistical Analysis with the Analysis ToolPak
- Create Interactive Data with Power View
- Activity-Create Interactive Data with Power View
Working with Multiple Workbooks
- Consolidate Data
- Activity-Consolidate Data
- Link Cells in Different Workbooks
- Activity-Link Cells in Different Workbooks
- Merge Workbooks
- Activity-Merge Workbooks
Exporting Excel Data
- Export Excel Data
- Activity-Export Excel Data
- Import a Delimited Text File
- Activity- Import a Delimited Text File
- Integrate Excel Data with the Web
- Activity-Integrate Excel Data with the Web
- Create a Web Query
- Activity-Create a Web Query
Importing and Exporting XML Data
- Import and Export XML Data
- Activity-Import and Export XML Data
- Activities – Microsoft Excel 2016 Advanced
- Activities and Exercise Files – Microsoft Excel 2016 Advanced
- Mock Exam – Microsoft Excel 2016 Advanced Level
- Final Exam – Microsoft Excel 2016 Advanced Level
Assessment and Certification
At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39.
Microsoft Excel 2016 Advanced Level - CPD Accredited - Best Seller