
New Perspectives Excel 2019 | Module 3: SAM Project 1b MedSight Instruments
PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS

DEVELOP AN EXCEL APPLICATION

ANALYZE DATA WITH TABLES AND WHAT-IF TOOLS

FORMATTING WORKBOOK TEXT AND DATA

Formatting Workbook Text and Data

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS

Perform Calculations with Formulas and Functions

Formatting, Formulas, and Charts

Enter and update company data

Performing Calculations with Formulas and Functions

DEVELOP AN EXCEL APPLICATION

CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS


SUMMARIZE DATA WITH PIVOTTABLES

GENERATE REPORTS FROM MULTIPLE WORKBOOKS

CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

FORMATTING, FORMULAS, AND CHARTS

SUMMARIZING YOUR DATA WITH PIVOTTABLES

Formatting Workbook Text and Data

Enter and update city data

MANAGING YOUR DATA WITH DATA TOOLS

ANALYZE AND CHART FINANCIAL DATA

FORMAT WORKBOOK TEXT AND DATA

Formatting, Formulas, and Charts

PERFORM FINANCIAL CALCULATIONS

SUMMARIZING YOUR DATA WITH PIVOTTABLES

EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS

EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS

MANAGING YOUR DATA WITH DATA TOOLS

ANALYZE DATA WITH POWER TOOLS

GENERATING REPORTS FROM MULTIPLE WORKBOOKS

Analyze and Chart Financial Data