Search Results

What would your life look like if you became an Excel Black Belt?
You’ll get the best deal with this package. It will take you from Excel Newbie to Grand Master.

Includes Power Query course, Power Pivot and DAX (Learn in Excel, Apply in Power BI as well)

Automate ANYTHING you need done in Excel with VBA and macros. Go from Beginner to VBA Expert and design automations with confidence.

Ready to supercharge your Excel skills? This course will help you master the new set of functions introduced to Excel for Office 365. You’ll create professional-grade reports in a fraction of the time it used to take you.

Create eye-catching Excel Dashboards with actionable tips you can use right away.

It’s one thing to get data into Excel. It’s another to turn that data into meaningful reports.

Power Query is an Essential tool for Data Analysis. Learn to Collect and Analyze Data with Ease.

Become Confident. Learn Excel from Scratch or Fill in the Gaps.

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.