
New Perspectives Excel 365/2021 | Module 11: End of Module Project 1 Qualey Consulting
CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

FORMATTING, FORMULAS, AND CHARTS

PERFORM WHAT-IF ANALYSES

GENERATING REPORTS FROM MULTIPLE WORKBOOKS

CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

MANAGE YOUR DATA WITH DATA TOOLS

PERFORM FINANCIAL CALCULATIONS

Formatting Workbook Text and Data

EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS

Perform Calculations with Formulas and Functions

Formatting, Formulas, and Charts

Performing Calculations with Formulas and Functions

MANAGING YOUR DATA WITH DATA TOOLS

ANALYZE AND CHART FINANCIAL DATA

MANAGING YOUR DATA WITH DATA TOOLS

FORMATTING WORKBOOK TEXT AND DATA

Performing Calculations with Formulas and Functions

ANALYZE DATA WITH TABLES AND WHAT-IF TOOLS

GENERATING REPORTS FROM MULTIPLE WORKBOOKS

PERFORM FINANCIAL CALCULATIONS

SUMMARIZING YOUR DATA WITH PIVOTTABLES

ANALYZE DATA WITH POWER TOOLS

SUMMARIZE DATA WITH PIVOTTABLES

CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

EXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS

PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS

DEVELOP AN EXCEL APPLICATION

GENERATE REPORTS FROM MULTIPLE WORKBOOKS

Analyze and chart financial data

Enter and update company data

MANAGING YOUR DATA WITH DATA TOOLS

ANALYZE DATA WITH POWER TOOLS

ANALYZE DATA AND WORK WITH FINANCIAL TOOLS

MANAGING YOUR DATA WITH DATA TOOLS

Analyze and Chart Financial Data

SUMMARIZING YOUR DATA WITH PIVOTTABLES