Microsoft Office Specialist: Excel Associate (Excel and Excel 2019)

Excel 2019: Level 3

Virtual Instructor-Led Training

Onsite Training

Business Applications

Microsoft Excel

Microsoft

<ul><li>Use Links and External References</li><li>Use 3-D References</li><li>Consolidate Data</li></ul>

Working with Multiple Worksheets and Workbooks

<ul><li>Collaborate on a Workbook</li><li>Protect Worksheets and Workbooks</li></ul>

Sharing and Protecting Workbooks

<ul><li>Apply Data Validation</li><li>Search for Invalid Data and Formulas with Errors</li><li>Work with Macros</li></ul>

Automating Workbook Functionality

<ul><li>Use Lookup Functions</li><li>Trace Cells</li><li>Watch and Evaluate Formulas</li></ul>

Using Lookup Functions and Formula Auditing

<ul><li>Determine Potential Outcomes Using Data Tables</li><li>Determine Potential Outcomes Using Scenarios</li><li>Use the Goal Seek Feature</li><li>Forecast Data Trends</li></ul>

Forecasting Data

<ul><li>Create Sparklines</li><li>Map Data</li></ul>

Creating Sparklines and Mapping Data

Microsoft Dynamics 365

courseBanner

Course Banner

courseOverview

Course Overview section

courseDetails

What you will learn

targetAudience

Who should attend

courseOutline

Course Outline

courseFAQ

Coursepromobanner

Course Promobanner Section

courseRelatedTargets

Course Related Targets

courseTicker

Course Ticker

preRequisites

Prerequisites

courseLocations

Find More Locations by NetCom Learning For This Training

For Your convenience we are offering This course at more locations. Expand your training options and accelerate your learning journey with NetCom.

Microsoft Excel 2019 training helps you to learn data analysis & presentation to make informed, intelligent organizational decisions.