[honeypot address]

Free Excel Templates & Downloads

Free Excel add-ins, templates and other utilities you may find useful. All the Access Analytic downloads & templates are 100% free: no missing features, & no time-expiry.

Free Excel Add-ins, Templates & More!

Here are some free Excel add-ins, templates and other utilities you may find useful.

All the Access Analytic downloads & templates are 100% free: no missing features, & no time-expiry.

Use of these programs is subject to the important disclaimer below.

Developed by Access Analytic

 Power Pivot Calendar Power Pivot Calendar Template
Save a lot of time when building a new Power Pivot report, start with a prebuilt template including:

  1. A flexible Calendar table sorted by Fiscal Month
  2. A measures table
  3. A last time refreshed query
Access Analytic Default Template
Save time and effort with setting up your Excel sheet each time, just use this instead

default template

  1. Contains really useful cell styles:
  2. Commas with Negatives turning Red with brackets and zeros display as a dash
  3. Centre Across Selection instead of the dreaded Merged cells
  4. Print headers and footers already set up
  5. Power Pivot Model already contains a values Table for future DAX measures so it will appear at the top of the measures list
  6. Do a search for the XLSTART folder on your computer and save this file there as BOOK.xltx
 Great 48 Toolbar Great 48 Toolbar  Add-in
48 incredibly useful buttons used by Access Analytic staff and now available to you.  If you’ve ever wanted a button it is probably here…!

  1. Ever got annoyed by the default Pivot Table layout – we’ve got a button for that.
  2. Ever found it painful formatting your numbers    1,234,999 or (1,234,999) – we’ve got a button for that.
  3. Still using VLOOKUP?  Much better to use INDEX MATCH instead – we’ve got a button for that!
 Keyboard Shortcuts Other
A collection of our favourite keyboard shortcuts in Excel.  Pin it up on your wall & share it with your friends.
 pivot table bar (2) Pivot Table  Add-in
3 essential Pivot Table buttons that you didn’t even realise you need, but very soon you’ll wonder how you ever lived without them!

  1. Jump to Pivot Source
  2. Pivot Reformat
  3. Toggle Sum/Count
toc Table of Contents Template
A great utility you can easily incorporate into your own files to generate a Table of Contents page with hyperlinks to all the sheets in your workbook.  It also automatically updates itself every time you  view it. Instructions on how to copy this to your file(s) are included – you don’t need to know VBA.
 Calendar Template
An interactive calendar illustrating the use of the hyperlink function and conditional formatting. Contains tips and quotes along with public holidays for Western Australiacalendar_xlsx
 Festival Planner Template
This handy planner lets you create your wishlist of events in one sheet, organise based on priority and date, labels events as MAYBE or BOOKED and block out days of unavailability. Share with friends and family so they can see what you plan to see and do!Festival Planner
 Excel Charts TemplateExcel Chart
Examples, tips and ideas about just some of the great charts and data visualisations that are now possible in Excel.
 Excel Quiz Night Score Sheet Template
Automatically keeps track of team scores at a Quiz Night (Pub Quiz). Allows for up to 20 teams and 10 rounds of questions. Automatically highlights the team(s) with the highest score each round plus who is coming first, second, third and last overall. Quiz Score Sheet
 Excel Advent Calendar Template
Advent CalendarPerfect for Christmas! An Excel-based Advent calendar! Click each window to see what’s underneath!
 Excel Shortcuts and Functions Cheat Sheet Other
A handy list of the best shortcuts in Excel plus a great Cheat Sheet of the key financial modelling functions. Print them out and keep them where you can see them!Cheat Sheet
 Excel Venn Diagrams Template
Excel VennAutomated tool to generate 3-circle Venn diagrams.
 ExceleRater Skills Tester Template Excelerate
How well do you know Excel? This is a great test to see which areas you know and which you may need to work on. Perfect for pre-employment testing, aptitude testing, promotion testing etc.
 Lucky Number Generator Template Lucky Number Generator
Illustrating the use of linked shapes and the random function. No guarantees but the numbers may prove to be lucky for you.

Developed by Others

 CodeVBA Add-in
VBA coding tools to help create better VBA code faster.

 Zebra BI
Fully responsive, powerful and intuitive visuals for Power BI.
 Invest for Excel Add-in
The software solution for capital budgeting, valuation and financial modelling. Make better models faster with Invest for Excel.
 Spreadsheet Detective Add-in
Spreadsheet auditing tool – like a grammar checker for your spreadsheets.

Important Disclaimer

The software programs developed by Access Analytic Solutions Pty Ltd (“Company”) may be freely distributed, provided that no charge above the cost of distribution is levied, and that this disclaimer is always attached to them. These programs are provided as is without any guarantees or warranty.

Although the Company has attempted to find and correct any bugs in the programs, the Company is not responsible for any damage or losses of any kind caused by the use or misuse of the program.

The Company is under no obligation to provide support, service, corrections, or upgrades to any of these software programs.

Use of the software programs implies agreement with the terms of this disclaimer.

For programs that have been developed by persons or entities other than Access Analytic Solutions, please refer to the terms and conditions imposed by the authors of those programs.

A link above does not constitute a recommendation by Access Analytic Solutions. Access Analytic Solutions is not responsible for the programs developed by other companies.