Sparen Sie 89%
Sparen Sie 89%
Adams Academy

Microsoft Excel 2016 Advanced Training - CPD Certified & IAO Approved

Adams Academy
Online
  • Adams Academy
Emagister-Preis

474 € 51 
*Orientierungspreis
Originalpreis in GBP:
£ 401  £ 43
PREMIUM-KURS

Wichtige informationen

Tipologie Kurs
Niveau Advanced
Methodologie Online
Unterrichtsstunden 7h
Beginn nach Wahl
  • Kurs
  • Advanced
  • Online
  • 7h
  • Beginn:
    nach Wahl
Beschreibung

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.

Wichtige informationen
Ist dieser Kurs für mich?

There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.

Wie geht es nach der Info-Anfrage weiter?

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

Preis für Emagister-Nutzer:

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Was lernen Sie in diesem Kurs?

Excel
Import and Export
XML training
XML
Microsoft Excel
Import Export
Web
Export
Import
Microsoft excel training
MS Excel
MS Excel
Microsoft excel training

Themenkreis

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