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 »
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 »
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 »
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 »
It’s easy to Convert between Excel and Google Sheets. Convert between Excel and Google Sheets – Open an Excel file in Google Sheets To open an Excel file in Sheets, start with a blank Sheets workbook, go to the File menu, and select Import. Then select Upload, and Select a file from you device. Find
Convert between Excel and Google Sheets in seconds Read More »
Sometimes you want to convert Excel to a PDF. You may be making a presentation to your boss, or sending someone financial statements. And you don’t want to use a live spreadsheet. This is incredibly easy to do in Excel. It literally takes 3 seconds. Yet I often see advertorials selling useless rip-off third party
Convert Excel to a PDF in 3 Seconds Read More »
Never use the CONCATENATE function in Excel! Sometimes you’ll read Excel tips suggesting the CONCATENATE function as a great tool you may not have known about. And CONCATENATE would be super useful, except that there’s a much better and easier way to do exactly what CONCATENATE does. CONCATENATE joins two or more text strings –
Never use CONCATENATE! Use & instead Read More »
Freezing panes will make your life a whole lot easier. Anytime you have a spreadsheet that is too big to fit on one screen, you have a problem. When you scroll down, you can’t see the column headers. And when you scroll to the right, you can’t see the row labels. You end up having
Freezing Panes to Make Your Life Easier Read More »
