Microsoft Excel 2016 Advanced Training - CPD Certified & IAO Approved
Course
Online
Learn some of the advanced features of the 2016 version of Excel.
-
Type
Course
-
Level
Advanced
-
Methodology
Online
-
Class hours
7h
-
Duration
Flexible
-
Start date
Different dates available
Microsoft Excel is used in businesses throughout, starting from engineering to diverse fields such as medicine. It is one of the top three best known Microsoft Office tools and probably the best spreadsheet program out there. However there is a steep learning curve to its advanced features, which you can now master from this Microsoft Excel 2016 Advanced Training course.
This course will help you learn some of the advanced features of the 2016 version of Excel. As such it starts out with a bang as you learn to automate worksheet functionality, along with how to update worksheet properties, create and edit macros, apply conditional formatting, and add data validation criteria. Next you discover ways to trace cells, troubleshoot invalid data and formula errors, watch and evaluate formulas, and create a data list online. Furthermore, you will learn to analyze and present data through statistical analysis, creating Sparklines and scenarios, and more. You will also learn how to work with multiple workbooks, export excel data, and import and export XML data.
Using this course correctly will lead you to master some of the most advanced features of Excel 2016 and essentially develop key skills that will help you stand out from the crowd.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.
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
- Import and Export
- XML training
- XML
- Microsoft Excel
- Import Export
- Web
- Export
- Import
- Microsoft excel training
- MS Excel
Teachers and trainers (1)
Adams 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 Criteria
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
Microsoft Excel 2016 Advanced Training - CPD Certified & IAO Approved