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.…
Category: Tech Tips
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…
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…
Does Your Version of Excel Contain Power Pivot?
Over the years, knowing whether you have access to the Power Pivot feature in Excel has been challenging at times to say the least. First introduced as an add-in for…
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…