Automated Sales Tax to the Rescue in QuickBooks Online Most accounting and financial professionals are aware of the complex sales tax structure that exists across the United States. With sales…
Category: Tech Tips
Using Excel's AutoCorrect Feature to Store and Insert Formulas
Using Excel’s AutoCorrect Feature to Store and Insert Formulas Did you know that you can use Excel’s AutoCorrect feature to store and insert formulas? Many Excel users find themselves frequently…
Adding Slicer Filters to Tables in Excel
Adding Slicer Filters to Tables in Excel Tables were added to the 2007 release of Excel and provide exceptional functionality as automatically expanding and contracting ranges of data. However, you…
Working with Excel's CHOOSE Function
Click here to see more Tech Tips Working with Excel’s CHOOSE Function Excel’s CHOOSE function provides a great alternative to using other lookup functions when you might need to find…
Using Controlled Folder Access to Block Ransomware
Click here to see more Tech Tips Using Controlled Folder Access to Block Ransomware With the Fall 2017 update to Windows 10 (version 1709 or newer), Microsoft added a terrific…
Using Excel's Flash Fill Tool to Clean-Up a QuickBooks Trial Balance
Click here to see more Tech Tips Using Excel’s Flash Fill Tool to Clean-Up a QuickBooks Trial Balance Excel’s Flash Fill tool — first introduced with the 2013 release of Excel…
Building Better Forecasts with Excel's Forecast Sheet Feature
Click here to see more Tech Tips Building Better Forecasts with Excel’s Forecast Sheet Feature Added to the 2016 release of Excel were several new functions – such as FORECAST.ETS – that…
Cleaning Data with Excel's Trim Function
Click here to see more Tech Tips Cleaning Data using Excel’s TRIM Function When working in Excel, sometimes the data in a worksheet is “dirty” and contains leading or trailing…
Microsoft Adds IFS Function to Excel 2019
With the release of Excel 2019, Microsoft added the IFS function to its spreadsheet application. Although IFS appeared in 2016 for Office 365 subscribers, Microsoft did not include it with…
Using Excel's AutoCorrect Feature to Store and Insert Formulas
Many Excel users find themselves frequently entering the same formula and are seeking a method through which they could store the formula and recall it on demand in the future.…