Excel Data Validation, Filters, Grouping
Excel
In this tutorial, we are going to cover the following topics. Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let’s assume you are recording student exam marks and you know the minimum is 0 and the maximum is 100. You can take advantage of validation features to ensure …
How to Use Excel: 18 Simple Excel Tips, Tricks, and Shortcuts
Excel
Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I’d ever need to do manually can be done automatically. Need to merge two sheets with similar data? Excel can do it. Need to do simple math? Excel can do it. Need to combine information in multiple cells? Excel …
20 excel formulas you should start using now
Excel
MS Excel is one of the most popular data analysis tools in the world. More and more companies greatly depend on this software and quite a lot of people are using it on a daily basis. However, from my experience, not many are taking full advantage of the opportunities that the program can offer. Here is my list of the …
18 ready to use vba codes that will save your day
Excel
In this article, I am going to show you some of the most amazing VBA Excel codes that you can use to optimize your work. VBA is a programming language, which can be used to extend the capabilities of MS Excel and other MS Office applications. It is extremely helpful for MS Excel users, because it can be used to …
The 100 Definitive most useful Excel tips?
Excel
After 30 years, Microsoft Excel remains ubiquitous in business. The world’s quarter of a billion knowledge workers on average spend half an hour in the application every day. But despite this, Excel’s full capabilities are still poorly understood. Of 100,000 workers we’ve tested over the past three years, less than half know what Conditional Formatting – an essential feature – …
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, …
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 …
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, …