≡ Menu

Excel’s VLOOKUP searches for a value in one column and returns a value from a different column with the same row as the value you’re searching for. This article will show you how to write a VLOOKUP formula, how VLOOKUP works, VLOOKUP best practices, how to fix your VLOOKUP errors, and advanced VLOOKUP use cases. […] Read More

Excel pivot tables provide an incredibly powerful tool to help you make sense of and summarize large data sets. This comprehensive guide covers all aspects of Excel pivot tables, from beginner to advanced. To jump straight to a section click on its link in the Table of Contents below. Click here for a set of […] Read More

The DIV/0 error occurs when you divide a number by zero. Below are 2 ways to fix the DIV/0 error with the iferror formula and increase the professionalism of your spreadsheet. Click here for a printable PDF of all of the solutions covered in this video. To go straight to the video, click here. When […] Read More

VALUE errors occur when you combine text (strings and words) with numerical operators (+ , - , * , /). Below are 3 ways to solve the VALUE error in your formulas. To go straight to the video, click here. Do you want a printable PDF of all of the solutions covered in this video? Click […] Read More

Click here for a printable PDF of the solutions covered in the YouTube video and this article Below are 3 ways to solve your #N/A error in Excel VLOOKUP. To jump straight to the video tutorial click here. Don't know how to do a VLOOKUP? Click here to view my article teaching you everything you need […] Read More

We’ve all been there: distracted, uninspired, and cycling between email, texts, Instagram, CNN.com, and back around. In the middle of one of these loops I decided to time myself on a task. When the timer expired I would feel accomplished, even if I hadn’t produced massive progress. Overtime I’ve honed the technique and it’s become my […] Read More

  Microsoft Excel is a big, robust program with tons of features. There are 7 sections of the ribbon, top bar in Excel that lets you do cool things: Home, Insert, Page Layout, Formulas, Data, Review, and View. For the sake of this example let’s say there are 20 options on each section. 7 sections […] Read More

  This post is the 2nd of 3 posts dedicated to Microsoft Excel keyboard shortcuts. The first post, all about the CTRL key, can be found here. Below is a list of ALT key Excel shortcuts that will make you fast at the things that matter. As I mention in the YouTube video, anything you can […] Read More

  Congratulations on making it to part 3 of the 3 part series on how to navigate your Microsoft Excel spreadsheet using your keyboard. If you missed parts 1 and 2 that’s ok, this video can be viewed independently. Click here for Part 1: how the CTRL key can help you navigate your spreadsheet without […] Read More

I mentioned in last week’s newsletter that my wife and I honeymooned in Thailand. One day we traveled to a floating market, a market on boats, outside Bangkok. At the floating market I encountered an awesome negotiating tactic. The vendor would type a number into a calculator, show me the number, pull the calculator down, […] Read More