Rockstar Excel
@RockstarExcel
Followers
134
Following
520
Media
42
Statuses
1K
Learn how Excel can save you five hours a week! Even for non-techies afraid of spreadsheets. Automate processes, organize/sort info. Book a FREE consult!
DM your Excel questions
Joined October 2020
Rockstar Excel offers FREE consults!. Learn how you can:. Save five hours a week. Always be able to find the information you need. Cut your billing time in half, while greatly increasing your collection rate. Even for non-techies afraid of spreadsheets!.
rockstarexcel.com
Let Rockstar Excel build spreadsheets for you. We will create custom bespoke spreadsheets to suit your business needs. Such as: Financial statements Cash forecasts Commission calculators Investment...
0
1
3
Having problems with dates in Excel? Here's the super easy way to fix them in under 10 seconds.
0
0
0
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.
0
0
0
I have a new video dropping tomorrow, on how you can fix broken dates and #VALUE errors in 10 seconds.
0
0
1
I've had several people reach out to me about updating the Rockstar Excel Expense tracker for a new year. Here are quick instructions on how to do so.
rockstarexcel.com
How to quickly and easily update the Rockstar Excel Expense Tracker for a new year.
0
0
0
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
rockstarexcel.com
XLOOKUP with multiple variables using SUMIFS, helper columns, or nesting an XLOOKUP inside another XLOOKUP.
0
0
5
And yes, this IS an invitation for you to ask me for free Excel help. DM me or email [my twitter username] at gmail.
If I can solve a (potential) client's problem in a few minutes, I'll do it for free. Is this good business practice?. My customers don't care how much time I spend. They care about making their lives easier. But it's good karma. And hopefully they'll hire me for bigger stuff.
2
0
1
If I can solve a (potential) client's problem in a few minutes, I'll do it for free. Is this good business practice?. My customers don't care how much time I spend. They care about making their lives easier. But it's good karma. And hopefully they'll hire me for bigger stuff.
0
0
2
I don't talk about politics, so no comment on this case. But remember that filtering an Excel sheet HIDES rows. It doesn't REMOVE them. To remove classified info from an Excel doc before sending it, filter, then copy-paste to a fresh document.
1
0
3
People may be interested in this Quora answer I wrote about who should and should not work at startups:.
quora.com
Steve Friedman's answer: I spent over 25 years in startups, rising from summer intern to CFO to founding my own company. Working in startups is awesome for certain types of people, and terrible for...
0
0
2
Los Angeles always has good weathe--. Hmm. I'm pretty sure my office ceiling didn't have a tree coming through it yesterday.
2
1
3
The dirty truth about how I got so good at Excel.
@heyecs Why I always preferred Accounting to Finance:. Accounting describes reality. Finance (in startups) is making stuff up, then creating complex Excel spreadsheets to hide that it's all made up. And every startup will be profitable in 11 months. (According to their projections.).
0
0
1
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
rockstarexcel.com
Make a goal tracker in Excel in minutes. A dashboard for your health, self-improvement, and business targets.
0
0
1
Like 3 minutes passed of silence, and I thought, "Maybe it's safe to start recording". Then it started up again.
0
0
0
TFW when you're just about to record a new video and then someone starts using a leaf-blower. Anyway, a new tutorial on creating a goal tracker in Excel should be coming soon. If I can actually record it.
1
0
0
Check out my latest video. If you play Dungeons and Dragons, it'll make your life easier. If you don't play D&D, it'll give ideas on using Excel for tracking stuff. I use this myself while playing D&D, and it's definitely made things easier for me.
0
0
2
Build a Dungeons and Dragons Initiative/Hit Point Tracker in Excel inĀ Seconds
rockstarexcel.com
Dungeons and Dragons Initiative is a pain to track. As are hit points. This quick Excel tool does the math, so you can focus on role-playing.
0
0
0
Working on a video about using #Excel for #DungeonsandDragons, so I searched stock photo sites for #RolePlayingGames. I got a whole lot of photos of the *other* kind of #roleplaying. Maybe I should have turned safe search on. š¤.
0
0
2