Slicing based on OR and XOR conditions in Power BI
Excel
Slicers on a report page in Power BI are an effective way to slice and dice your data under different conditions. But one situation that can be challenging to implement effectively is being able to apply multiple slicers, and show the rows that satisfy one condition or the other, not just the rows that satisfy both. In this blog post, …
How to make Histograms in Power BI to answer business questions
Power BI
A histogram is a common tool in statistics to describe the distribution of values across a dataset. They can show you the most common values, the outliers, and the spread of your values, all at a single glance. Histograms can be useful not just within statistics, but also for answering business questions. However it’s not immediately obvious how to set …
Announcing LAMBDA: Turn Excel formulas into custom functions
Excel
Today we are releasing to our Beta customers a new capability that will revolutionize how you build formulas in Excel. Excel formulas are the world’s most widely used programming language, yet one of the more basic principles in programming has been missing, and that is the ability to use the formula language to define your own re-usable functions. =LAMBDA Simply …
70+ of the best add-ins, plugins and apps for Microsoft Excel, free or not
Excel
Microsoft Excel is by far the most used application for data analysis. Mastering Excel is a must-have skill in many companies. It can also be a huge time-saver: an Excel master can be tens or hundreds of times more productive than a beginner. In this post, we list and describe over 75 add-ins, plugins and apps that complement Microsoft Excel …
Excel Tips and Ticks from our Experts
Excel
In the article below we addressed a couple of our latest Excel tips to help you to work faster using Excel in your daily routine. You will learn how to deselect cells or a range from a current selection, how to quick analyse data in Excel, to add a conditional column, and finally add a column from an example. Get your …
Pivot tables in excel: how to use the pivottable function
Power Pivot
The PivotTable function is one of the most widely used features of Microsoft Excel. It allows you to analyse and visualise data in various ways that can provide deep insights. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you’re in the right place. (Note: PivotTable is the trademarked term for …
5 microsoft excel powerhacks that will make your day
Excel
Here are five tips borne of hard hours grafting through messy databases in search of some grains of gold. Sounds like an exaggeration? Think again… or at least have a read first! 1. Preserve your source data When you’re about to spend your weekend crunching through a data dump, do yourself a favour and make sure you can back out, …
9+ Excel Formulas Every Beginner Should Know
Excel
Excel formulas make calculating numbers and making sense of large amounts of data simple. By knowing a few key formulas, you can do a variety of actions in Excel that will increase your productivity and decrease the risk of making calculation mistakes. We’ve put together 10 Excel formulas you need to get started. There are a lot of complicated formulas out there, but …
5+ Ways To Get The Weekday Name From A Date In Excel
Excel
What day of the week is 1928-11-14? Is it a Monday, Tuesday, Wednesday, etc… It’s pretty common to want to know what day of the week a given date falls on and unless you’ve got some sort of gift for knowing that, you’re going to need a way to figure it out. In Excel, there are many different ways to …