Category: Tech Tips

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 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…

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…

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 offers tremendous opportunities for you to summarize and analyze data automatically. In this tip, you will learn how you can take advantage of Ideas.

Many business professionals are turning to Microsoft’s Power BI platform to address reporting, analysis, and business intelligence efforts. As they do, one question that many have is how to secure…

If you are working with Power BI, you probably already know how powerful Slicer filters are. In this tip, you will learn how to manage your Slicers for even more…

When sorting or filtering data in Excel, most users instinctively click the drop-down arrows at the top of a column to initiate the process. In this tip, you will learn…

Suppose you need to add your signature to a Word document. What’s the best way of doing it? Why, Building Blocks and Quick Parts, of course! In this tip, learn…