Excel Nyheder

In the olden days of computing, some programs, including Excel, had hidden features called Easter eggs, so here’s a quiz for you. Quick Quiz: Which version of Excel had a hidden Flight Simulator game as its Easter egg?      a) Excel 5.0     b) Excel 95     c) Excel 97     d) Excel 2000 Answer: … Continue reading “Excel Easter Eggs and Hidden Treasures”

To quickly combine text and numbers from multiple cells in Excel, use the TEXTJOIN Excel function. I’ll show you two examples, and you can scroll down to watch the video demo. What is TEXTJOIN? TEXTJOIN is an Excel function that combines values from two or more cells, and you can choose what to put between … Continue reading “Combine Excel Text with Conditions – TEXTJOIN Function”

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? Video: Pivot Table Not … 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! Excel Milestones We love Excel milestones, here on the Contextures Blog. • … Continue reading “Happy Excel Day 45678”

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. New on Contextures Quick Tip: Pinned Files Excel Quiz Excel Stories Monthly Photo – Best By New on Contextures … Continue reading “Debra’s Excel News–January 2025”