50

## How to Add Leading Zeros to Numbers or Text with Uneven Lengths

Bottom line: Learn how to write a simple formula to add zeros before numbers or text in a column where the values are not the same length. This is also known as padding the numbers with leading or preceding zeros.

Skill level: Easy

19

## Pivot Table Field List Missing? How to Get It Back

Bottom line: If the pivot table field list went missing on you, this article and video will explain a few ways to make it visible again.  I also share a few other tips for working with the field list.

Skill level: Beginner

30

## How to Properly Filter Zeros and Numbers with the Filter Drop-down Menus

Bottom line: Learn the correct way to filter out zeros and numbers with the filter drop-down menus in Excel, and avoid embarrassing mistakes.

Skill level: Intermediate

23

## 3 Ways to Get the Day Name for a Date

Bottom line: Learn a few different ways to return the name of the day or weekday name for cell that contains a date value.

Skill level: Beginner

23

## 2 Ways to Apply Conditional Formatting to Shapes (Video Tutorial)

Bottom line: Learn a few ways to apply conditional formatting to shapes.  This is a great technique for dashboards and interactive reports where you don’t want to be confined by the worksheet grid.

Skill level: Beginner

5

## Free Online Sessions on Excel & PowerBI from the Microsoft Data Insights Summit

Microsoft is holding their first Data Insights Summit this week in Bellevue, Washington.  This event is all about Excel, PowerBI, and the future of data analysis tools.

Although this is a live in-person event, they will also be streaming the sessions live on the web  (and recording them).  And it’s FREE to watch!!!

57

## How to Create a Personal Macro Workbook (Video Series)

Bottom line: This video series explains what the Personal Macro Workbook is, how to create it, and why you should use one.  You will also learn how to add custom macro buttons to the Excel Ribbon, and how to make a Yes/No pop-up window appear before a macro runs.

Skill level: Intermediate

45

## 3 Ways to QUICKLY Attach Excel Files to Emails

Bottom line: Learn how to quickly attach Excel files to your emails.  These techniques and keyboard shortcuts can work for any email client including Outlook, Mac Mail, and Gmail.

Skill level: Beginner

10

## How to Filter or Sort a Slicer with Another Slicer + Video

Bottom line: Learn how to group text or number fields to create a slicer that can sort and filter another slicer.  This technique is great for slicers that contain a lot of items and are difficult to navigate.

Skill level: Intermediate

98

## How to Add a Search Box to a Slicer to Quickly Filter Pivot Tables and Charts + Video

Bottom line: Learn how to add a search box to a slicer to quickly filter your pivot tables, pivot charts, or Excel Tables.  Includes a video tutorial that explains the setup in detail.

Skill level: Intermediate