Excel tips and tutorials
This step-by-step video shows how to unpivot data in Excel, using Power Query. This creates better source data that you can use to build flexible pivot tables. And it doesn’t change your original data – you can leave that as is!
Continue reading “Unpivot Excel Data with Power Query Step by Step Video”
Where does the time go? Only 556 days ago, we were celebrating Excel Day 44444, and suddenly it’s Excel Day 45000! And we’re still cleaning up from yesterday’s Pi Day Party! Who says numbers are boring?
Since the beginning of (Excel) time, people have asked questions about the big grey “Page 1” that sometimes appears on a worksheet. How did it get there? Is it a watermark? How do I get rid of it? Will it show up on printed copies? My short video, below, answers those questions for you!
Continue reading “Turn Off Grey Watermark Page 1 on Excel Worksheet”
Do you ever use Excel to calculate a ratio? In business, you could compare income to expenses, and at home, you could use ratios to bake a cake, without a recipe. In my latest video, I show a quick Excel formula for the ratio between two numbers, in x:y format. And no, Excel doesn’t have a RATIO function, even though one overly-confident AI helper tool said it does!
Continue reading “Calculate Ratio with Excel Formula – 3 Steps”
Every morning, I use Excel to keep track of the projects I’m working on, and organize my tasks for the day. Of course, things don’t always go as planned, but it helps to know where I’m headed!
Continue reading “Excel Macro to Increase Amount in Multiple Cells”
Keep track of Excel worksheet discussions, with a detailed list of threaded comments and replies. Just click a button, to run a macro, that makes the list for you. And I’ve fixed the macro!
Continue reading “Excel Threaded Comments and Replies List Details-Macro”
Happy Groundhog Day! Have you made plans that you’ll be happy to repeat, day after day? Maybe these Excel REPT function examples will give you some ideas! There are written steps, screen shots, and 3 videos below.
Continue reading “Excel REPT Function Examples Groundhog Day”
Have you played with the ChatGPT app yet, to get AI help with your writing, or your Excel formulas? Yesterday, I asked it to write Excel TEXTJOIN formula examples, and things didn’t go too well!
Continue reading “Excel TEXTJOIN Function Bad Examples from ChatGPT”
If you had to split a text string into separate columns in Excel, how would you do that? There are built-in tools that could help you, and Excel functions and formulas will do the job too. If your version of Excel has the latest functions and features, there are fancy new text functions for you to try.
Continue reading “Split Text Into Columns in Excel-Get Specific Column”
It’s almost the holidays, so relax and enjoy some time away from work. Instead of struggling with budgets and forecasts, you can play games in Excel! And do you remember the games that were hidden in old versions of Excel?
