Learn Excel from Bill Jelen with this daily 2 minute video podcast.
A combination of six cool tricks allow you to take detailed transactional data and produce a chart of the top five customers in about 12 clicks. Episode 762 shows you how.
Labels: Data wrangling, Subtotals, visible cells
posted by Bill at 9:00 AM
Today’s problem involves a complex data set with headings throughout the data. We want to add new columns to the dataset, but it is incredibly tedious to copy the new column headings throughout the report. Episode 546 shows you how to use a combination of AutoFilter, and Visible Cells Only to solve the problem.
Labels: AutoFilter, visible cells
posted by Bill at 9:00 AM
Jonathan writes in to mention Ctrl+; enters today’s date. In Episode 542, I run through several of my favorite shortcut keys, including Show Formulas, Visible Cells Only, and more.
Labels: dates, shortcut keys, shortcuts, visible cells
posted by Bill at 9:00 AM
A question from Mike in Oklahoma City. Excel is supposed to copy only the visible rows in a dataset where AutoFilter is turned on. However, sometimes this does not work. Episode 445 shows the simple shortcut to make sure that you have only the visible rows.
Labels: AutoFilter, shortcuts, visible cells
posted by Bill at 9:00 AM
There is another way to use the AutoSum icon in the standard toolbar. This alternate method will show you the totals of the visible cells, ignoring cells in hidden rows. Episode 350 shows you how.
Labels: AutoSum, visible cells
posted by Bill at 9:00 AM
