
Shelly Cashman Excel 365 | Module 5: SAM Project A York Medical Center
CONSOLIDATE WORKBOOK DATA

CONSOLIDATE WORKBOOK DATA

CREATE, SORT, AND QUERY TABLES

COMPLETE A BUDGET SUMMARY WORKSHEET

CREATE, SORT, AND QUERY TABLES

CREATE AN INVESTMENT ANALYSIS

CREATE, SORT, AND QUERY TABLES

IMPORT DATA AND WORK WITH SMARTART AND IMAGES

CREATE A LOAN ANALYSIS

ANALYZE DATA WITH CHARTS AND PIVOTTABLES

Analyze Data with Charts and PivotTables

CREATE A USER INTERFACE

Complete a client tracker worksheet

FORMAT WORKSHEETS

CREATE, SORT, AND QUERY TABLES

CREATE FORMULAS WITH FUNCTIONS

COLLABORATE AND DEVELOP A USER INTERFACE

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

CREATE A SALES REPORT

FORMAT WORKSHEETS

Analyze Data with Charts and PivotTables

CONSOLIDATE WORKBOOK DATA

CREATE A LOAN ANALYSIS

CREATE A SALES REPORT

CREATE A SALES PROJECTION WORKSHEET

ANALYZE DATA AND SOLVE PROBLEMS

COLLABORATE AND DEVELOP A USER INTERFACE

IMPORT DATA AND INSERT SMARTART, SHAPES, AND CHARTS

IMPORT DATA AND INSERT SMARTART, IMAGES, AND CHARTS

IMPORT DATA AND INSERT SMARTART, SHAPES, AND CHARTS

Format worksheets

Create a loan analysis

ANALYZE DATA AND SOLVE PROBLEMS

FORMAT WORKSHEETS

CONSOLIDATE WORKBOOK DATA

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

COLLABORATE AND DEVELOP A USER INTERFACE

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

CREATE FORMULAS WITH FUNCTIONS

FORMAT WORKSHEETS