Excel’s New Dynamic Array Feature Excel’s new dynamic array feature is one of the best enhancements Microsoft has added to Excel in years. With dynamic arrays, we now have the…
Category: Tech Tips
Excel's XLOOKUP Feature Begins Arriving
Microsoft has begun rolling-out Excel’s anticipated XLOOKUP feature to some Office 365 subscribers. While not all Office 365 subscribers yet have access to this feature, if you are an Office…
How To Protect Yourself Against A Phishing Attack
How do you protect yourself against phishing attacks? You have probably heard about phishing in the context of the Internet. But in fact, phishing is older than the web itself.…
Use Power Query to Split Data Into Multiple Columns
Excel offers multiple ways to split data in a cell. Among these are the venerable Text to Columns tool, Flash Fill, and writing formulas that incorporate Excel functions such as…
Bring Your Team Together
The following post was written by Ward Blatch, Managing Director of K2E Canada. We appreciate Ward’s contribution and thank him for willingly sharing his knowledge. Bring your team together with…
How to Link QuickBooks Data into Excel
As an accounting application designed for small businesses, QuickBooks and QuickBooks Online have relatively robust reporting options. In addition to numerous, standard reports, these tools offer customization options and the…
Five Tips to Improve Efficiency for Your Accounting Team
The following post was written by Valerie Silvani, Vice President of Sales and Marketing at Gravity Software. Valerie was kind enough to allow us to share it with our readers.…
Excel's Easy to Use LARGE and SMALL Functions
For many years, the MAX and the MIN functions have overshadowed Excel’s LARGE and SMALL functions. However, as you will see in this tip, the LARGE and the SMALL functions…
Maximize Your ROI On Office 365
Many businesses are utilizing Office 365, Microsoft’s subscription-based combination of desktop applications and Cloud-based services. However, most of these businesses are not receiving the ROI they anticipated when they subscribed…
Using Power Query To Combine Excel Workbooks
The more we dig into Excel’s Power Query feature, the more we find out just what a powerful tool it really is. For example, Power Query includes tools to ease…