Power BI Tips & Tricks

Power BI can do THAT? Learn 10 quick tips to enhance your Power BI dashboards: Conditionally format charts, create a separate measures table, customize your own tool tips and a lot more.

How to Use Checkboxes in Excel

Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas and conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

Excel Job Interview Questions by Position

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.

Excel Advanced Pivot Tables

These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

Excel Stock Data

Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

Excel Conditional Formatting with Formula

Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows or format values based on another cell. Using the formula feature in conditional formatting is tricky. I share the secret to getting it right every time.

Yearly Calendar in Excel with Formula

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

Excel Conditional Bar Charts

Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.

Understanding and Creating Barcodes in Excel

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.

Excel Fun – Mosaic Chart

GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and some creative uses of Excel features. We want to play