
Shelly Cashman Excel 2019 | Module 7: SAM Project 1a Ballantyne Investments
IMPORT DATA AND INSERT SMARTART, IMAGES, AND CHARTS

IMPORT DATA AND INSERT SMARTART, IMAGES, AND CHARTS

COLLABORATE AND DEVELOP A USER INTERFACE

CONSOLIDATE WORKBOOK DATA

ANALYZE DATA WITH CHARTS AND PIVOTTABLES

CREATE, SORT, AND QUERY TABLES

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

Format Worksheets

CREATE A SALES REPORT

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

Create an order and inventory projection

FORMAT WORKSHEETS

CREATE A SALES REPORT

COMPLETE A BUDGET SUMMARY WORKSHEET

CONSOLIDATE WORKBOOK DATA

COLLABORATE AND DEVELOP A USER INTERFACE

CONSOLIDATE WORKBOOK DATA

Complete a Budget Summary Worksheet

ANALYZE DATA WITH CHARTS AND PIVOTTABLES

Format Worksheets

CREATE, SORT, AND QUERY TABLES

CONSOLIDATE WORKBOOK DATA

COMPLETE A TRAVEL EXPENSE WORKSHEET

IMPORT DATA AND WORK WITH SMARTART AND IMAGES

ANALYZING DATA WITH POWER TOOLS

CONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTS

ANALYZING DATA WITH POWER TOOLS AND CREATING MACROS

CREATE FORMULAS WITH FUNCTIONS

CREATE A LOAN ANALYSIS

ANALYZE DATA AND SOLVE PROBLEMS

CONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTS

ANALYZE DATA WITH CHARTS AND PIVOTTABLES

FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING

IMPORT DATA AND INSERT SMARTART, IMAGES, AND CHARTS

ANALYZING DATA WITH POWER TOOLS AND CREATING MACROS

CREATE, SORT, AND QUERY TABLES

CREATE FORMULAS WITH FUNCTIONS

CREATE A USER INTERFACE

CREATE A SALES PROJECTION WORKSHEET

CREATE AN INVESTMENT ANALYSIS

CREATE, SORT, AND QUERY TABLES

CREATE A LOAN ANALYSIS

Format Worksheets

Complete a Client Tracker Worksheet

CREATE A LOAN ANALYSIS