Recently added to Excel is the new STOCKHISTORY function. You can use STOCKHISTORY to retrieve historical prices for stocks as of a given date or range of dates. Read on,…
Category: Tech Tips
QuickBooks Online Management Reports: A Feature You Should Use
QuickBooks Online is one of the leading accounting solutions used by small businesses today. One great feature in QBO is Management Reports and this article you will learn how to…
Measure Your Team's Productivity With Microsoft Productivity Score
If your team is running Microsoft 365/Office 365, they have access to many applications and services that can increase productivity – but only if they use the tools available to…
The Best Ways To Collaborate With Office Documents
Collaboration is more important today than it ever has been. With many team members working remotely, it can be challenging, to say the least, to share documents so that all…
Artificial Intelligence Meets Microsoft Office
Many have written about the future of Artificial Intelligence (AI) and its potential in our personal and professional lives. So far, most of the literature describes the impacts as “futuristic”…
How To Format Excel PivotTables For Even Greater Effect
One of the unfortunate misperceptions regarding PivotTables in Excel is that you cannot format them to meet your specific reporting needs. Read on, and in this article, you will learn…
Excel's New "LET" Function Can Simplify Your Formulas
Excel’s new LET function can really help you to simplify and streamline your formulas. With LET, you can declare variables within a formula and then use those variables to shorten…
Converting And Importing PDF Data Into Excel
Did you know that you now have the option of converting and importing PDF data into Excel? In this tip, you will learn just how easy it is to import…
Comparing Excel's Merge Cells and Center Across Selection Features
Merge Cells and Center Across Selection are long-standing features in Excel. You can use both these features to change the appearance of data in a spreadsheet. In this tip, you…
Excel's Ideas Feature - A Great Way To Summarize And Analyze Data
Excel’s Ideas feature offers tremendous opportunities for you to summarize and analyze data automatically. In this tip, you will learn how you can take advantage of Ideas.