
Shelly Cashman Excel 365
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