Search Results

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

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.

These are 3 easy ways to remove duplicates in your data to create a unique or distinct list of values in Microsoft Excel. It’s a very common task for data cleaning and also a very common job interview question… BUT one of the methods returns a different result. Make sure you understand why.

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.

Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to “merge” the data and sometimes you have to “append” data from multiple sheets for your Pivot Table. Don’t use formulas! Instead use this method.

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.

These are 10 Excel features that are better than Google Sheets. This post is like a “top 10 tips and tricks” type of post. Even if you’re currently using Excel, you might discover new tips you can use.

Sometimes the data you copy or import into Excel has stubborn spaces that can’t be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.

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.