Excel tips and tutorials
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?
Happy December! We’ve almost made it to the end of this year, and you’re probably getting reading for next year’s tasks and projects. If you need to set up monthly workbooks for next year, or automatically add sheets to existing workbooks, these Excel macros can help you!
Continue reading “Excel Macros Create Monthly Workbooks Entire Year”
It’s only a week until Thanksgiving, if you live in the USA, and maybe you’ve got everything organized, and ready to go. If not, I’ve got a couple of Excel holiday planner tools that can help you. There’s short video below, that shows a quick demo of the Excel holiday tools.
Round 2 of the Excel World Championship 2022 is happening today, so don’t miss it! There are details below, and the Final round is on November 12th. And for those of us who have personal competitions with Excel every day, at the office/school/home, Excel expert David Ringstrom has some great tips for you. Continue reading “Microsoft Excel Quirks and Competitions”
It’s finally here – the best day of the fall holiday season – Spreadsheet Day! You don’t need to buy any gifts, or cook a big meal, or find a trendy costume. Just open up your favourite spreadsheet, sit back, and enjoy the day!
