Our real-world inspired Business Spreadsheets will assist you with everyday issues you face when running your business. Don’t waste time endlessly googling for help. Let us help you bypass that painful learning curve so that you can concentrate on the reason you started a business in the first place.
Our Business Spreadsheets take Excel functions and formatting and apply them to real-life everyday Business needs. You can learn along with us if you want, or just download the finished spreadsheet (most of these are complementary!) and start entering your data.
Complementary Downloads
-
-
Flagging Late Payments
Business: Keep track of which invoices are not being paid on time Technical: Nested IF statements PLUS Conditional Formatting GoTo: How To Flag Late Payments using MS Excel Screenshot: 
-
-
Cross-referencing tables and spreadsheets
Business: Combine and cross-reference lists and tables Technical: vLookup Function GoTo: How to cross reference spreadsheet data using VLOOKUP Screenshot 
-
VAT Calculator
Business: Add and Remove VAT from costs and prices Technical: Arithmetic Functions PLUS SUM function GoTo: Adding and Removing VAT with VAT Calculator v3.0 Screenshot: 
-
Analyse Sales
Business: Get insight into how your business is doing and why Technical: Pivot Tables GoTo: How to Analyse Sales using Pivot Tables Screenshot: 
-
Calculating Volume Discounts
Business: Review pricing levels with accurate modelling Technical: Nested IF statements PLUS SUM function GoTo: Volume Discounts – Nested IF Example Screenshot: 
-
Sales By Supplier
Business: Who is your best supplier? Whose goods do you sell the most of? Technical: SUMIF function GoTo: How to find number of sales, sales value and average sale by supplier Screenshot: 
If you have any suggestions for other possible Business Spreadsheets that would help you in your business, just contact us.
Premium Downloads
-
Simple Excel Timesheet
Business: A neat, printable, reusable timesheet that calculates your wages
Technical: No learning required, all taken care of
GoTo: A Simple Excel Timesheet
Screenshot:
-
Simple Excel Mileage Claim Form
Business: A neat, printable, reusable Mileage Claim form that calculates your mileage claim
Technical: No learning required, all taken care of
GoTo: A Simple Excel Mileage Claim form.
Screenshot:
-
Simple Excel Markup & Margin Tool
Business: A tool which helps you with your costs, pricing, markups and margins
Technical: No learning required, all taken care of
GoTo: Simple Excel Markup and Margin Tool
Screenshot: