How to Randomize a List in Excel (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Shuffling a list is easy to do in Excel. True, there are lots of random generators out there online. But if your data or list lives inside Excel, there’s no need to use some other platforms to [...]
How to Use Excel's Scenario Manager (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Have you been in a situation when you wanted to have different values in the same cell? Chances are, you created another sheet for it or worse, created a new file to compare your different scenarios. But did [...]
How to Use Sparklines in Excel to Show Trends (Fast & Easy) Written by co-founder Kasper Langmann, Microsoft Office Specialist. In Excel, there are lots of graphs that you can add to your report (and Excel keeps on adding new charts). But what if you want to put a mini chart into a [...]
Circular Reference in Excel: How to Find, Enable, Use, or Remove Written by co-founder Kasper Langmann, Microsoft Office Specialist. One of the most common warnings users encounter in Excel is the circular reference error. In fact, you may already have seen a few of them already on your reports (which is probably how [...]
How to Headline Highlight Every Other Row in Excel - Fast and Easy Written by co-founder Kasper Langmann, Microsoft Office Specialist. Highlighting every other row makes it easier to read the contents of the spreadsheet. Some people also highlight their sheets to give it a bit of flair. In this article, you’ll [...]
How to Find the Absolute Value in Excel (ABS Function) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Numbers in Excel could either be positive or negative. Sometimes, due to formulas and calculations, the resulting numbers could be negative. Unfortunately, there are cases where you would want all the numbers in your spreadsheet [...]
How to Mail Merge Using an Excel Spreadsheet and Word Written by co-founder Kasper Langmann, Microsoft Office Specialist. If you’re not a fan of using expensive email platforms to send emails to a large list, knowing how to using mail merge is one of your best options. By using a combination of [...]
How to Insert Excel Data into Word Like Tables, Files, and Spreadsheets Written by co-founder Kasper Langmann, Microsoft Office Specialist. Microsoft Word is great for working on documents—but not so great with tables. If you want to put a table into a Microsoft Word document, you can work with Word's built-in table [...]
How to Switch X and Y Axis in Excel (without changing values) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Knowing how to switch the x-axis and y-axis in Excel will save you a lot of trouble. Microsoft Excel is a powerful spreadsheet software that will let you store data and [...]
How To Use Excel: A Beginner's Guide To Getting Started Written by co-founder Kasper Langmann, Microsoft Office Specialist. Excel is a powerful application—but it can also be very intimidating. That's why we've put together this beginner's guide to getting started with Excel. It will take you from the very beginning (opening a spreadsheet), [...]