Search Results

You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

Uncover Windows 10 most useful features in this summarized article. Some of these are what I consider hidden features of Windows 10. Super simple to use BUT not easy to find!

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It’s super easy with Excel dynamic arrays.

Time Value of Money is an important concept for making good decisions when it come to money. The good news: We can easily calculate it in Excel with the NPV function.

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.

Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you’ll just need to “refresh” the data in Excel to get the latest information. It’s super easy!

Here is an Excel trick when using the Advanced Filter Feature in Excel. It’s about copying a filtered result to another sheet. Did you know that you can copy the filtered results for the columns that you need, and you can ignore the columns that you don’t need?

Excel’s Flash Fill feature can save you a ton of time! Check out how you can automatically split names, get the initials, email addresses and more with Excel’s amazing Flash Fill feature. No more writing complex formulas.

Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you’re applying for data analyst jobs.

Use this Excel formula (NO VBA, NO Macros) to convert numbers to words. Download the workbook and copy and paste to your own files. I show you how easily you can adjust the formula to fit your needs.

Are you using all of these 20 Excel keyboard shortcuts in your daily work? They range from data navigation to auto sum, inserting the date and time and even moving rows of data and dropping them between other rows.

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.