26

## How Dates Work in Excel – The Calendar System Explained + Video

Bottom line: With Valentine's Day rapidly approaching I thought it would be good to explain how you can get a date with your Excel skills. Â Just kidding! đź™‚ Â This post and video explain how the date calendar system works in Excel.

Skill level: Beginner

16

## How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video

Bottom line: Learn how to create month to date (MTD) calculations in your pivot tables for month-over-month, quarter-over-quarter, or year-over-year comparisons.

Skill level: Intermediate

15

## How to use the COUNTIF Function Instead of VLOOKUP + Video

Bottom line: Learn how to use the COUNTIF function instead of VLOOKUP to determine if a value exists in a list or range.

Skill level: Beginner

4

## What Are Your (Excel) Plans For 2016?

I hope you had a safe and very happy new year!

Did you make any New Year's Resolutions yet?

Whether you make a concrete list of goals or just think about some plans, this is the time we review last year and think about what we want to accomplish this year.

4

## I Wish Excel Could… Excel User Voice Explained

Bottom line: This post contains a few new ways that you can help make Excel better, plus a video about Excel UserVoice.

## Excel UserVoice Gives You the Mic

Have you ever been using Excel and thoughtÂ to yourself, “I wish Excel could do this task better, or had this feature!”

I know I have!Â  I have always wished Excel couldâ€¦

• Make coffee
• Fold the laundry
• Stop global warming
• And solve world peace

Just kidding! đź™‚

5

## A Few Questions About VLOOKUP & INDEX MATCH

As I mentioned in the newsletter, my long awaited Ultimate Lookup Formulas Course is coming soon. This is an online video course that will help you learn how to write a variety of lookup formulas in Excel.

The course covers a lot of different functions like VLOOKUP, INDEX, MATCH, COUNTIFS, SUMIFS, INDIRECT, GETPIVOTDATA, Excel Tables,Â and so much more.

25

## How to Analyze Survey Data in Excel + Video

Bottom line:Â Learn how to analyze multiple choiceÂ survey data. Â We will use Power Query to transform the data, then analyze the resultsÂ with Pivot Tables and Charts. A 3-part video series explains all the techniques in detail.

Skill level: Intermediate

399

## Win a Copy of the New Mr. Excel Book! It’s Awesome!

I'm giving away 4 copies of Bill Jelen's newest book,Â MrExcel XL: The 40 Greatest Excel Tips of All Time.

Note: The contest is now over, but checkout my review of this great book below. Â There is also a video at the end of the page with a tutorial on the winning tips.

66

## 3 Ways to Group Times in Excel

Bottom line: Learn how to group timesÂ in a data set for summarized reports and charts. Â We will use Pivot Tables, and the FLOOR, TRUNC, and VLOOKUP functions for the different solutions.

Skill level: Intermediate

120

## 5 Keyboard Shortcuts for Rows and Columns in Excel

Bottom line: Learn some of my favorite keyboard shortcuts when working with rows and columns in Excel.

Skill level: Easy