Search Results

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.

What’s the difference between Excel VBA macros and Office Scripts? Do you need to switch from VBA to Office Scripts? Find out in this detailed article. I show examples of what you can achieve with VBA and the current status of Office Scripts and explain what each is for.

If you find yourself repeatedly performing the same steps in the same order in Excel, your brain should immediately declare, “I should automate this with an Excel macro!”. You will see that VBA doesn’t have to be scary and that you can easily generate VBA code by recording your actions.

What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

What is the Excel Spill error and how can you fix it? Sometimes it’s obvious but sometimes it’s not clear why you get this error. Find out why and how to fix it in this article.

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.

You can spend a lot of time on design and formatting when you create Excel dashboards. Discover 4 hidden tips that will make the process a lot easier.

A progress bar is a great addition for Excel macros that take long to run. It gives your project a more professional touch. It’s also quite easy to add. You can create your progress bar once and reuse it in your Excel VBA projects.

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You’ll find a lot of hidden gems in the way this Excel dashboard was created.

You can use Excel VBA GetOpenFileName method to copy data from another Excel file by browsing for and selecting the file from the Open File Dialog Box.

Learn all about Excel’s custom formatting – what is the rule for the custom formatting dialog box? How can you use it to hide zero values and much more.