Data Tables Part II – Building an Excel Data Table Across Worksheets This article will dive into more detail on one of the particular issues we identified within a previous resource, which is that Excel’s data table must be on the same worksheet as the original inputs being sensitized. Part I...

Continue reading

Top 5 Time-Saving Tips to Automate Excel Charts Data analysis, communication, and visualization continue to grow in importance and popularity. At TTS, Data Analysis and Communications with Excel, Power BI, and Python Training (Part 1 and Part 2) are among our fastest-growing, highest-demand courses, so it's important to learn and utilize time-saving tricks to...

Continue reading

Threaded Comments in Excel There have been a number of changes to Excel in the last couple of years that have greatly improved the software. One such improvement has been the changes to the Notes and Threaded Comments. The way Comments used to be in Excel In previous versions of Excel, users were...

Continue reading

Excel Hacks – My Favourite Spreadsheet Speed Tips and Tricks Necessity is the mother of invention. Something’s not working and we have to figure it out. It applies to all sorts of things in life. Late at night, we are battling a pesky error message and after some Google searches, we find...

Continue reading

Comparing Dynamic Arrays in Excel Comparing items is one of the main tenets of Excel. Recently, Excel released Dynamic Array and Spill Range functionality to most Excel 365 users. Dynamic Arrays are incredibly powerful and could fundamentally change how we use Excel. However, array functionality has been around for a long time. This...

Continue reading

Are the Spreadsheet Wars Back? A breakdown of Google Sheets and how it compares to Microsoft Excel It is hard to imagine, but waaaaay back in the 1980’s several spreadsheet programs were competing for market dominance in the field of finance. First was VisiCalc, followed by Lotus 1-2-3, and then a number of...

Continue reading

Building Dynamic Charts with Named Ranges This article dives deeper into two methods of creating a dynamic chart. The methods include: (i) Named Ranges with OFFSET and (ii) Excel 365’s new FILTER function. This new FILTER function makes chart automation much easier, allowing you to create powerful automation with much less...

Continue reading

Creating Absolute References and Locking Cells in Excel Creating Excel formulas can become a tedious task if the user doesn’t understand how cell references work. Each cell reference in a formula has two parts – the letter represents the column and the number represents the row. For example, the formula =B3 will show...

Continue reading

Using the ALT key in Excel If you want to become an efficient Excel user (or better yet a lightning-fast user), the ALT key must become your close friend (not literally though). To perform basic, common ALT Key actions in Excel (like adding a border to a cell or removing a...

Continue reading

How to Use Excel’s Paste Special Feature We often want to borrow some, but not all, of the attributes of a cell and paste them elsewhere. While regular pasting will transfer all of the attributes of the copied cell(s), using Excel Paste Special will allow the user to paste some of...

Continue reading