How to Reduce Excel File Size

How to Reduce Excel File Size

How to Reduce Excel File Size Did you ever wonder why your seemingly simple Excel file is so large (in terms of KB or MB) or why it seems “sluggish”? We recently received a file from a client who was frustrated because it was taking Excel way too long to open...

Continue reading

Excel’s “Double” F2 Key

Excel’s “Double” F2 Key

Excel’s “Double” F2 Key Everybody (well, almost everybody) knows that pressing the F2 key in Excel activates the “editing” mode for the active cell – the cursor goes into the cell so that you can change the contents, and the various cell references in that formula turn different colors. What many people...

Continue reading

A Short Guide to Hyperlinks in Excel

Help, I Am Lost in this Massive Excel File! A Short Guide to Hyperlinks in Excel Have you ever opened an Excel file and seen multiple tabs each containing multiple schedules? Did you start working through the file and find yourself frustrated going back and forth between different schedules and /...

Continue reading

Automate Excel Charts

Top 5 Time-Saving Tips to Automate Excel Charts

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

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