
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

IMPORT DATA AND INSERT SMARTART, SHAPES, AND CHARTS

ANALYZING DATA WITH POWER TOOLS AND CREATING MACROS

CONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTS

CONSOLIDATE WORKBOOK DATA

CONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTS

CREATE AN ORDER AND INVENTORY PROJECTION

CREATE A LOAN ANALYSIS

CREATE FORMULAS WITH FUNCTIONS

COMPLETE A BUDGET SUMMARY WORKSHEET

COMPLETE A BUDGET SUMMARY WORKSHEET

ANALYZING DATA WITH POWER TOOLS

ANALYZING DATA WITH POWER TOOLS AND CREATING MACROS

CREATE A SALES REPORT

Complete a travel expense worksheet

CREATE, SORT, AND QUERY TABLES

ANALYZING DATA WITH POWER TOOLS AND CREATING MACROS

Analyze Data with Charts and PivotTables