Work with multiple worksheets and workbooks Use Lookup functions and formula auditing Share and protect workbooks Automate workbook functionality Create sparklines and map data Forecast data

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upon successful completion of this course, students will be able to work multiple worksheets and workbooks, use Lookup functions and formula auditing, forecast data and map data

1

  • Ensuring Data and Formula Integrity

  • SETTING UP DATA VALIDATION USE DATA VALIDATION WITH LOOKUPS
    TROUBLESHOOTING FORMULAS ADDING WATCHES
2

  • Using Formulas Across files

  • ARRANGING FILES
    BUILDING FORMULAS ACROSS FILES
    CONSOLIDATING DATA
    LINKING CELLS ACROSS FILES
3

  • Working with Text Functions

  • COMBINING DATA FROM CELLS
    SEPARATING DATA INTO CELLS
    CHANGING CASE USING FUNCTIONS
    CUSTOM DATA SEPARATIONS
    UTILIZE DIFFERENT WAYS TO PASTE DATA
4

  • Using What-IF Scenarios

  • USING GOAL SEEK USING SOLVER
    CREATING A DATA TABLE USING SCENARIOS
5

  • Collaberation in Excel

  • SHARING WORKBOOKS
    TRACKING CHANGES
    REVIEWING CHANGE MERGING WORKBOOKS
6

  • Macros

  • RECORDING A MACRO RUNNING A MACRO
    SAVING A MACRO-ENABLED FILE
    FIXING A MACRO BY EDITING THE VBA CODE

Audience

This course builds off the knowledge presented in the Microsoft® Office Excel® 2016: Parts 1 & 2 courses to help you get the most of your Excel experience. This course covers Microsoft Office Specialist exam objectives to help students prep for the exam.

Language

English

Prerequisites

There are no stated prerequisites for this course. Please check with your representative for details.

$185

Length: 1.0 day (8 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...