Search Results

Don’t merge cells in Excel – Don’t Copy Excel sheets without updating links – Don’t hide rows and columns! There are better ways of doing these things. Find out 7 things you’re doing wrong in Excel and how to do it correctly.

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you’ll have setup your interactive dashboard which you’ve published to the web!

If you’d like to “see” how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers 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.

This example gets you started with Office Scripts in Excel. You’ll learn how to record a macro and how to modify the script to get a dynamic range. You’ll also learn where to find the Office Script and how to save it with your workbook.

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.

This is the list of the most useful, new Excel Functions you need to know. These will save you from wasting time with complex formulas!

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.