Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

How to Randomize a List in Excel (Step-By-Step)

2020-08-11T13:19:01+00:00

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 Randomize a List in Excel (Step-By-Step)2020-08-11T13:19:01+00:00

How to Use Excel’s Scenario Manager (Step-By-Step)

2020-08-11T13:19:10+00:00

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 Excel’s Scenario Manager (Step-By-Step)2020-08-11T13:19:10+00:00

How to Use Sparklines in Excel to Show Trends (Fast & Easy)

2020-08-11T13:19:31+00:00

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 [...]

How to Use Sparklines in Excel to Show Trends (Fast & Easy)2020-08-11T13:19:31+00:00

Circular Reference in Excel: How to Find, Enable, Use, or Remove

2020-08-11T13:19:37+00:00

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 [...]

Circular Reference in Excel: How to Find, Enable, Use, or Remove2020-08-11T13:19:37+00:00

How to Highlight Every Other Row in Excel – Fast and Easy

2020-08-11T13:19:45+00:00

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 Highlight Every Other Row in Excel – Fast and Easy2020-08-11T13:19:45+00:00

How to Find the Absolute Value in Excel (ABS Function)

2020-08-11T13:19:52+00:00

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 Find the Absolute Value in Excel (ABS Function)2020-08-11T13:19:52+00:00

How to Mail Merge Using an Excel Spreadsheet and Word

2020-11-05T11:40:20+00:00

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 Mail Merge Using an Excel Spreadsheet and Word2020-11-05T11:40:20+00:00

Power BI Tutorial: Start Learning Power BI Today (For Free)

2020-02-07T09:58:40+00:00

Power BI Tutorial: Start Learning Power BI Today (For Free) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is a great business intelligence and analytics solution. Though packed with lots of functionality, it’s still fairly easy to use. However, not everyone has a knack for technology. That’s why we created [...]

Power BI Tutorial: Start Learning Power BI Today (For Free)2020-02-07T09:58:40+00:00

The 10 Best Power BI Visuals to Get Inspiration From

2020-11-05T11:30:43+00:00

The 10 Best Power BI Visuals to Get Inspiration From Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI is one of the best business intelligence and analytics solutions. Microsoft’s BI solution is especially popular with its stunning and interactive visuals. And if you’ve been working with Power BI, it’s not hard [...]

The 10 Best Power BI Visuals to Get Inspiration From2020-11-05T11:30:43+00:00

How to Do Table Visualization in Power BI (Step-By-Step)

2020-11-05T11:49:57+00:00

How to Do Table Visualization in Power BI (Step-By-Step) Written by co-founder Kasper Langmann, Microsoft Office Specialist. Power BI has a table visualization you can use to view detailed data and the exact values. It’s exactly how a table in a spreadsheet program like Microsoft Excel looks like. How to create a table [...]

How to Do Table Visualization in Power BI (Step-By-Step)2020-11-05T11:49:57+00:00