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…
Author: Tommy Stephens
Product Review - Epson PowerLite 1795F Data Projector
Recently, I needed to purchase a new data projector to replace my Epson PowerLite 1776W. I had used the 1776W for over five years and had a great experience with…
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…
What Is RPA and Why Should I Care?
Many professionals have heard of Robotic Process Automation (RPA) and have asked: What is RPA and why should I care? This is a fair question because the term “RPA” is…
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…
Product Review - Plugable USB 3.0 Dual Display Universal Docking Station
After over six years of uninterrupted service, I found myself needing to replace the Targus docking station I was using to connect my Surface Pro 4 to all my peripheral…
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…
K2 Enterprises Announces the 18th Annual K2 Quality Awards Winners
The K2 Quality Awards are in their eighteenth year and the are among the most well respected and longest standing awards in the Accounting industry. In announcing this year’s award…