Often in Excel, formulas referencing dates don’t work right, returning a #VALUE error.
Here is an explanation of what’s going on, and quick instructions on how to easily fix the problem in just a few seconds.
How to fix broken dates in Excel Read More »
Quick instructions on how to update the Rockstar Excel Expense Tracker for the new year.
How to update Rockstar Excel Expense Tracker for new year Read More »
XLOOKUP is one of the most useful tools in Excel, but doesn’t allow you to use multiple variables/criteria.
Here I show three ways to make this work:
– Use a SUMIFS
– Use a helper column
– Nest an XLOOKUP inside another XLOOKUP
How to do an XLOOKUP with multiple variables Read More »
Learn how to make a goal tracker in Excel in minutes!
Great for:
– Weight loss
– Exercise targets
– Self-improvement
– Learning a skill
– Reading X books per year
– Sending out a certain number of sales pitches per week
Make a Goal Tracker in Excel in 11 Minutes Read More »
Tracking initiative and hit points in Dungeons and Dragons is always a pain. Here I show you how to make your life easier with a quick Excel spreadsheet that automatically puts player characters and monsters in initiative order, and keeps track of any damage and healing. Let Excel do the math, so you can focus
Build a Dungeons and Dragons Initiative/Hit Point Tracker in Excel in Seconds Read More »
Have you ever wanted to copy or import data from print, paper, images, or video into Excel? That used to be impossible without manually retyping it. But now you can automatically import the data in seconds with Excel’s new Import from Picture feature. Copy or import data from print, paper, images, or video into Excel
How to copy or import data from print, paper, images, or video into Excel Read More »
Microsoft recently added three new text functions to Excel: TEXTBEFORE, TEXTAFTER, AND TEXTSPLIT. These are incredibly powerful and will save you loads of time! Learn how to use these new text functions, some tips on making them even more useful, and how to add these to your version of Excel if you don’t already have
Three new Excel text functions to save you loads of time! Read More »
Automated lists are a great way to save time in Excel. By simply dragging the fill-handle (or little green box in the lower right corner of highlighted cells), you can create lists of numbers, dates, months, or days of the week. You can also set up your own custom lists for names, departments, regions, expense
Master Automated Lists in Excel in 3 Minutes Read More »
Figuring out how to make a Dungeons and Dragons encounter hard enough to be a challenge to the players, but not so hard that it kills the entire party, is quite difficult. The method for doing so involves a lot of trial and error and repetitive math. Here I walk you through creating an Excel
Build a Dungeons and Dragons encounter tool in Excel – an XLOOKUP tutorial Read More »
In this video, I explain why using the Merge & Center button in Excel can cause you all sorts of problems. I also show you the Center Across Selection feature, which accomplishes the same thing as Merge, but without any of the drawbacks. When you merge cells, it stops you from selecting individual columns in
Don’t merge cells! Center across selection instead Read More »
