Search Results

With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You’ll have to combine these multiple values into one cell. I’ll show you 3 methods to get this done.

In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You’ll be surprised at the level of Excel that’s currently required for some of these positions.

Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You’ll discover new Excel tips and tricks that will make your working life a lot easier.

This is the list of my favorite tips and functions in Google Sheets. If you’re new to Google Sheets, this list will give you an overview of the potential of Sheets. If you’re advanced, you’ll probably find some new features and functions you didn’t know about.

Learn the basics of using Microsoft Excel. How a spreadsheet is setup, and how you can enter data in Excel. Learn useful Excel shortcuts. Understand how the menu bar (the Excel Ribbon) works and where to find different features. This basic tutorial is for all versions of Excel.

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

What can Google Sheets do and should I learn it? This was a question I asked myself some time ago. I noticed more companies were switching to Google Sheets specially because of the events of 2020. In this post I talk about what Google Sheets can do.

Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

These are 10 Excel features that are better than Google Sheets. This post is like a “top 10 tips and tricks” type of post. Even if you’re currently using Excel, you might discover new tips you can use.

Is Google Sheets the right spreadsheet application for you? Or should you go with Excel? Here is a list of 10 features where Google Sheets beats Excel. It’s a mix of Google sheets basic to advanced functions and hidden features.

What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.