Handle Growing Lookup Tables with a Two-Key Combo
A time-saving VLOOKUP trick that can be solved with a simple Ctrl+T.
How to Search for Cell Comments Using Excel
Here’s a handy Excel macro that quickly searches and finds the comments you've posted in cells.
Imagine There’s No Excel
With the rise of analytics and Big Data, replacements for Excel are proliferating and CFOs of companies large and small are beginning to pay attention.
Embedding a PDF in an Excel Worksheet
The strangest thing happens after embedding a PDF in Excel. But don’t worry, there is an easy way to make sure recipients of your worksheet get both the PDF and spreadsheet.
Desperately Seeking Excel Spreadsheet Links
Are you trying to detect if something in your Excel spreadsheet is linked to another spreadsheet? The trick is to look for a “left square bracket,” says Bill Jelen.
10 Keystrokes to Navigate Scads of Excel Data
A trick to navigate and sum thousands of rows and columns that is simple enough for novices to use, and still useful to experts.
Honey, I Shrunk the Scroll-Bar Slider in Excel
The slider on the vertical scroll bar that allows Excel users to navigate among several screens has been accidentally shrunk to a point that it is unusable. What now?
Excel – Rein In the Dueling Pivot Table Problem
Stumped by how to link two pivot tables so updating data on both is a snap? Here’s how to use Excel’s “slicer” function to get the job done without reformatting.
Automate the Selection and Sum of Variable Rows in Excel
Make quick work of summing variable rows choosing only data you specify based on row numbers and labels.
Spreadsheets: Using Text-to-Columns in a Macro
The thorny problem of reformatting data quickly that comes in from another department is solved using a combination of Excel’s text-to-column and macro recorder.