Excel Nyheder

Which student got the top score? If you have test results, or another list of numbers in Excel, you could sort them to see which scores are at the top. But if you want to leave the list in alphabetical order, you can use the RANK function to show the rank for each score. Video: … Continue reading “Compare List of Numbers With Excel RANK Function”

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”