Excel tips and tutorials
Usually, it’s easy to sort an Excel pivot table, but you might run into one that just won’t sort correctly! For example, employee names are listed alphabetically, but there’s a name at the top that doesn’t belong there. Why is the pivot table not sorting that one name with the others?
Continue reading “Pivot Table Not Sorting Correctly – Quick Fix”
Where does the time go? Two years ago, we were celebrating Excel Day 45000, and suddenly it’s Excel Day 45678!
Do you have any special events planned? If not, you could make the office festive, with a few balloons and a magic marker!
Pin your Excel files, make decisions with a spreadsheet, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
There’s always something to celebrate, with several “Day of” events, for every day of the year! Here are events for the upcoming week, and I’ve found Excel templates and links for each of them!
Continue reading “Celebrate Days of Excel – Week of Jan 5 2025”
If your Excel sheet has a column with combined dates and times, you might want to separate date and time into different columns. My short video shows the steps, and there are written steps below.
Fix a column header problem, QAT tips, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
December is only 3 days away, so it’s time for an Excel Advent Calendar! I’ve made a new version this year, and it doesn’t use macros, just basic Excel features. Even if you don’t need an Advent calendar, take a look to see how the calendar is set up. It might give you ideas for other types of Excel projects.
Continue reading “Get This Excel Advent Calendar With No Macros”
Fix pivot table errors, show images in cells, and more, in this month’s Excel news.
Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
New PIVOTBY function, get ready for Spreadsheet Day, and more, in this month’s Excel news.
Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Pivot table sorting, fun with movie titles, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
