David (@5minutelessons) profile picture

Learn to use Microsoft Excel, Word and Google Analytics. Cool tips and tricks to be more productive in just five minutes. Tweet if you need help!

Online
Joined February 2009
Here's an easy way to use the SUMIFs function to calculate a running total based on a date range in your... fb.me/7QX0dhB0M
1
1
We really like the new Office 2016 for Mac but ... the Autoupdate feature has revealed a major flaw. Check out... fb.me/3ofnP2uPl
We really like the new Office 2016 for Mac but ... the Autoupdate feature has revealed a major flaw. Check out... fb.me/4cqG9WWHQ
The COUNTIF and COUNTIFS functions are both must-haves for anyone who wants to become an Excel expert. Related to... fb.me/2epvx8UVD
Great news for Mac users of Microsoft Office - Office 2016 for Mac has just been released, ahead of the Windows... fb.me/3UxJlCMwG
Looking for a quick way to check if a cell contains a valid number or not? Try the ISNUMBER function. This lesson... fb.me/7wlr57jpb
If you're a Mac user, it's no secret that Office 2011 for Mac is an awful piece of software - slow, buggy, and... fb.me/uUBXReFv
Have you ever imported data from another system into Excel and found that the times provided in the data convert... fb.me/47UGw7jN1
1
The VLOOKUP function is an essential part of any Excel expert's toolkit. However, it has some serious limitations... fb.me/7uMIQSTOc
Here's an interesting Excel challenge for you: write a formula to find out who made the highest sales across your... fb.me/4KJK4eMDC
Here's an interesting Excel challenge for you: write a formula to find out who made the highest sales across your... fb.me/3BIU19a97
The VLOOKUP function is an essential part of any Excel expert's toolkit. However, it has some serious limitations... fb.me/6p8GkGyhn
This is exactly how many people have contributed to #Drupal8 so far. 2300! buytaert.net/drupal-8-beta-1… #DrupalCon
1
19
12
A must-know for data analysis. Pivot tables in #Excel, the quick and dirty verson. shar.es/NEo3l via @5minutelessons
Ever needed to find duplicate rows in Excel where multiple columns need to be checked? Try this lesson: http://t.co/fQtlKMDczT
1
2
Have you ever had a table of data in Excel in which you need to identify the rows with duplicate values? There... fb.me/2WNoIlEGY
Have you ever tried the SUMPRODUCT function in Excel? It comes in very handy when you have two columns of numbers... fb.me/2Zsr4LAet
Latest Excel lesson shows you how conditional formatting can highlight dates that are in the past: http://t.co/MFxejaq9zi