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 »
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 »
Do you want to get better at Excel? Here I share some of my methods for improving at Excel over the course of your career/life. As a bonus, you get to see what I look like. Ways to get better at Excel Highlights: Getting better at Excel isn’t about knowing the most functions. It’s about
How to Get Better at Excel Read More »
I’m doing a new thing where on select Mondays, I’ll offer free Excel assistance to as many people as I have time to help. Is there something you’ve always wanted to know how to do? A spreadsheet you’re having trouble with? A process that’s difficult/annoying, where you wish there was a better way? Send me
Free Excel Help Monday Read More »
Are your blank cells acting weird? Perhaps Excel is treating them like they’re not blank. Or it’s giving you bizarre errors. In this video, I explain what’s going on and how to fix it. How to fix blank cells acting weird If your blank cells are acting weird, it’s because Excel is seeing them as
Blank cells acting weird? Here’s how to fix it! Read More »
The most useful Excel shortcuts will help you work a lot faster and make your life easier, which is what Rockstar Excel is all about. In this video, I walk you through the 16 most useful Excel shortcuts. Some of these are keyboard shortcuts, and some of these are tools Excel makes available to you.
16 Most Useful Excel Shortcuts Read More »
