Excel Fast Exit Excel Close All – Episode 2270

A fast way to close all workbooks in Excel

View on YouTube

Excel Subtotal 9 versus 109 – Episode 2269

A Power Excel audience member in Omaha asked about the difference between 9 and 109 in the Excel SUBTOTAL function.

View on YouTube

Excel VBA Macro to TRIM Selection – Episode 2268

Kristin wants to have a fast way to remove leading a trailing spaces from an entire range of Excel cells. In this episode, a 7-line macro to solve this problem.
Sub TrimSelection()
Dim cell As Range
For Each cell In Selection
If Not cell.HasFormula Then
cell.Value = Trim(cell.Value)
End If
Next cell
End Sub

View on YouTube

Excel Power Query Move To Beginning – Episode 2267

How to move a column to the beginning of a data set in Excel Power Query. How to Group and summarize data in Excel Power Query

View on YouTube

Excel Power Query Column From Examples – Episode 2266

Flash Fill in Excel 2013 was a neat party trick. But the Column From Examples feature in Excel Power Query is far better. See how Column From Examples works.

View on YouTube

Refreshing Stock Data In Excel 2265

Some tricks with the new Stocks data type in Microsoft Excel. How to refresh the current stock price in Excel. How to change the Stock Market Exchange for one security.

View on YouTube

Refreshing Stock Data In Excel 2265

Some tricks with the new Stocks data type in Microsoft Excel. How to refresh the current stock price in Excel. How to change the Stock Market Exchange for one security.

View on YouTube

Excel Data Types Geography 2264

A second look at the new Geography Data Types in Excel.

View on YouTube

Excel Slicer Selections In Title 2263

When you filter a pivot table to many items, the title of (Multiple Items) is nearly useless. Which items? Printing the whole slicer can take up a lot of space. Today, I combine a Mike Alexander trick with TEXTJOIN to create a title that shows which items are selected in the slicer.

View on YouTube

Excel Ctrl Click to Unselect Cells – 2262

You are selecting multiple ranges in Excel using Ctrl. Then, you accidentally click some cells that should not be in the selection. Previously, you would have to start over. Now, you can Ctrl+Click to Unselect if you are using Office 365.

View on YouTube