Extra rows in your ranges are important to prevent extra work and bad calculations. When you insert rows to a spreadsheet, Excel can sometimes behave in an unexpected way. To make things worse, Excel doesn’t make it obvious that it’s doing something weird. If you aren’t paying close attention, you could easily end up with […]
Always Include Extra Rows in Ranges Read More »
[Cross-posted from Self Helping Yourself] Note: This post originally appeared on Rockstar Excel founder Steven Ray Marks’s self-improvement and weight loss blog Self Helping Yourself. To see more from Self Helping Yourself, or to receive weekly suggestions of articles on easy ways to improve your life, subscribe to the Five Boosts by Self Helping Yourself
Improving Skills to Overcome Impostor Syndrome – The Story of Rockstar Excel Read More »
Reader SV wrote in to ask: “How to I transpose a table, like copying and pasting a vertical column of cells to a horizontal row of cells?” Great question! Let’s say you have data that looks like this: Then you decide that you’d rather have the dates running across the top, with each individual and
How to Transpose Information in Excel Read More »
Rockstar Excel has now officially launched! The site is still a work-in-progress, so please bear with us. It’s a very bare-bones design. We aren’t yet able to offer any information about the courses and consulting we’ll be offering. But in both Excel and in life, it’s better to have something that exists and works, instead
Welcome to Rockstar Excel Read More »
