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…
Category: Tech Tips
Technology Tools-Change With The Times
Are you doing things the same old way? Do you wish there were an easier way? Have you noticed how rapidly our technology tools are changing? Continuous updates via the…
Snap a Picture to Import Data into Excel
Last fall, Microsoft announced forthcoming capabilities to take a picture of a data set using your Android-based or iOS-based device and import that data in Excel. That feature has now…
Automating Your Reports With Excel's Power Query Feature
Automating Your Reports With Excel’s Power Query Feature Excel’s Power Query provides fantastic opportunities for business professionals to automate many reporting processes and practices. Ranging from simple queries to sophisticated…
Multi-Factor Authentication – A Necessity in Today’s World
From the perspective of data security, today’s world is an extremely dangerous one. It is hard to go a single day without hearing about yet another data breach, a phishing…
Working with Stock and Geography Data Types in Excel
Working with Stock and Geography Data Types in Excel Microsoft recently added two new data types to Excel – 1) Stock and 2) Geography. If you use Excel 2019 obtained…
Unpivoting Data with Excel's Power Query Tool
Unpivoting Data with Excel’s Power Query Tool Power Query – a feature available in Excel dating back to 2010 – has emerged as “mainstream” tool for many Excel users. No…
Adding Performance Bands to Charts
Adding Performance Bands to Charts Many business professionals use charts when attempting to communicate more effectively. Unfortunately, these charts are not always as helpful as they should be. A common…
Automated Sales Tax to the Rescue in QuickBooks Online
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…
Using Excel's AutoCorrect Feature to Store and Insert Formulas
Click here to return to Technology Tips 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…