Carlton's Excel Links:

New in Excel 2016

Link Me

PowerView - 5000 Invoices

PowerView Crime File

PowerView Crime Video

PowerView Basics

PowerView Sports Pie Clip

PowerView Multiples

PowerMap

PowerView Hiearchies

More PowerView Clips

Olympics PowerView Excel

Excel Tips I & Tricks File

Excel Tips II & Tricks File

File - Random Numbers
File - Benford's Law File

QB Regression

Simple Regression

GP Regression Example

File - Proof of Cash

File - Consolidate Similar

File - Consolidate Disimilar

File - Profit Margin

File - QB GL Needs Cleaning

File - 5000 Invoices

File - Real Estate Data

File - Pivot Data - Time Sheets

File - QB GL Needs Cleaning
File - GL Clean Up
File - GL PivotData
File - 15,000 Names

File - Access Database

Excel Data & Fin Reporting

Excel Hands-On Materials
File - Random Numbers
File - Hands-on

File - Benford's Law File

File - New in Excel 2013
File - Invoice File
File - Carlton's 50 Quick Tips

File - Consolidate Similar

File - Consolidate Disimilar

File - 172 Functions File
File - QB Regression

File - Simple Regression

File - GP Regression Example

File - Revenue Budget - Units

File - Rev. Budget - CPA Firm

File - Copy Shop File

File - Gantt Example File

File - Profit Margin

File - Carlton's Formulas

File - Data Bar Formatting

File - More Functions

File - Data Commands 
File - Roth IRA Analysis

File - 15,000 Names
File - GL Clean Up
File - GL PivotData
File - QB GL Needs Cleaning
File - Real Estate Data
File - Large Function
File - Administrative Page
File- Balance Sheet Ratios

File - Amortization Schedule

File - 5000 Invoices
XML File - 5000 Invoices
XML Schema - 5000 Invoices
XML File - Expense Reports

XML File - Book Data

IQY File Stock Query Text

Budgeting Cash-Flow Materials

Excel Budgeting - Iowa

2013 Course Manuals:

Excel Intermediate

Excel 2013 for CPAs 

Advanced Excel for CPAs

Office 2013 Manual

Webinar Materials & Files:

Security Manual (8 hours)

Security Checklist

Excel Macros

Excel Tips & Tricks File

Excel Budgeting Materials
QB Regression

Simple Regression

GP Regression Example

Consolidate Similar

Consolidate Disimilar

Profit Margin

Revenue Budget - Units

Revenue Budget - CPA Firm

New in Excel 13 Materials

Carlton's Smartphone Video

What's New File

Invoice File

Try PowerView Online

Excel Materials:

172 Functions File
Seasonal Budget & Copy Shop

New in Excel 2010

61 New Functions in 2010
New Features in 2007
Missing in 2007
Excel Data Commands
Copy Shop Case Study
Grand Rapids Copy Shop
Excel Macros
Excel Data Analysis

Excel & the Internet

Portfolio Case Study

Office Agenda
Gantt Example

Advanced Excel Concepts

Excel Functions

Excel & Accounting Systems

Samples Files:

File - Top 82 Functions
File - Pivot Data - Invoices
File - Pivot Data - GL

File - Pivot Data - Real Estate
File - Pivot Data - Time Sheets
File - Consolidate Similar Budgets
File - Consolidate Dis-Similar Budgets


File - Hands On Data File 1
Example Excel Files

File- Duluth Copy Shop

File - Copy Shop 
File - Actual vs Budget

File - IF Function 
File - Data Cleaning
File - Carlton's Functions

File - Carlton's Formulas

File - Carlton's 50 Quick Tips

File - Data Bar Formatting

File - More Functions

File - Data Commands 
File - Roth IRA Analysis

PW for CPAs: collins9696

PW for ADV: collins9696adv

PW for INT: collins44int

password: collins1212