Excel

Excel

Spreadsheet tips and tutorials to boost your knowledge of the world’s favourite accounting tool.

Subscribe to our newsletter for Accountants and Bookkeepers

Sign up

Spreadsheets and graphs on a desk
Excel
Sep 27th 2018

Why Excel 2019 is Already Obsolete

Sep 17th 2018
Blog

Thoughts on the QBOA “Work” Feature Part 2

By
Jody Linick
Owner
Bookkeeping
Spreadsheets and graphs on a desk
Excel
Jun 28th 2018
1 comment

Dealing with Inventive Malware Exploits in Excel

Spreadsheets and graphs on a desk
Excel
May 3rd 2018

Dealing With Excel's Ctrl Key Paradox

Spreadsheets and graphs on a desk
Excel
Feb 27th 2018

How to Set Cloud-Based Reports to Open in Excel

Trending

Spreadsheets and graphs on a desk
Clearing the Decks
Excel
Jan 30th 2018

How to Use Excel to File Form 1040 for 2017 Taxes

Newsletter

Building a Profitable Cash Flow Forecasting Service

As firms across the US invest in cash flow forecasting technology, the accounting profession seems to be responding to an underserved demand among small business clients.
Download this Guide

Popular resources

Oct 31st 2017

Vanishing Excel Features and How to Handle Them

Excel users that subscribe to Microsoft's Office 365 platform have the benefit of being on the vanguard of new features that are being...
Oct 20th 2017

How to 'Heat Map' Columns of Numbers in Excel

It can often be difficult to get a measure of numbers in a spreadsheet, but Excel offers many data visualization techniques. In this...
Sep 21st 2017
1

Excel Tip: How to Copy 'Visible' Cells Only

Here's a convenient Excel tip that I hope you can use! Often at work I would find myself filtering a spreadsheet to show only the specific...
Sep 5th 2017
1

How Excel Pivot Tables Can Assign Random Numbers

Periodically you may have a need to assign random numbers to an employee list, such as for raffle drawings or drug testing. In this article...
Spreadsheets and graphs on a desk
Excel
Aug 2nd 2017
3 comments

Troubleshooting When VLOOKUP Function Returns #N/A

Spreadsheets and graphs on a desk
Excel
Jul 26th 2017
1 comment

Dealing With Office 365’s Frequent Builds and Bugs

Spreadsheets and graphs on a desk
Excel
Jun 30th 2017

2 Ways to Disable Excel’s Pivot Table Drill-Down

Spreadsheets and graphs on a desk
Excel
Jun 23rd 2017
2 comments

How to Deal With Excel’s New Persistent Clipboard

Spreadsheets and graphs on a desk
Excel
May 30th 2017
1 comment

Filtering Grand Totals in Excel Pivot Tables

Spreadsheets and graphs on a desk
Excel
May 23rd 2017

How to Recover Damaged Excel Workbooks

Spreadsheets and graphs on a desk
Excel
Apr 5th 2017
2 comments

Displaying Decimal Places in Excel: Part 3

Spreadsheets and graphs on a desk
Excel
Mar 13th 2017

How to Reset an Excel Spreadsheet for Data Entry

Spreadsheets and graphs on a desk
Excel
Mar 2nd 2017
2 comments

Key Shortcuts to Use Within Excel Worksheets

Spreadsheets and graphs on a desk
Excel
Feb 10th 2017

3 Approaches for Counting Data Instances in Excel

Spreadsheets and graphs on a desk
Excel
Feb 1st 2017
2 comments

Dealing with Grand Totals in Excel Pivot Tables

Spreadsheets and graphs on a desk
Prepping for Busy Season
Excel
Jan 13th 2017
2 comments

How to Use Excel 2016 to File Form 1040