Excel tips and tutorials
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!
There’s an Excel UserForm that you can download from my Contextures site, and use it to search, view, and edit records in an Excel table. The two short videos below show how the UserForm works, and how you can put flexible criteria in the search boxes.
And remember – it’s almost Spreadsheet Day – we’ll celebrate on Monday, October 17th!
Continue reading “Search Transaction Records with Excel UserForm”
In the past, I’ve written about a duplicate grand total problem in Excel’s automatic Subtotals feature. Yesterday I noticed another problem, and it was nasty surprise!
