Searching... Searching...

Total Subscribers Receiving Our Weekly Excel Lessons

+75,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

CountIf Formula in Excel

What does it do? Counts the number of cells that matches your specified condition Formula breakdown: =COUNTIF(range, criteria) What it means: =COUNTIF(range of cells to check, condition to check against) Do you have a scenario where you want to count the number of cells that match a specific condition? I'm sure you do!  There is Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

How to Change & Convert UK Dates to US in Excel

Have you ever come across a scenario where your dates in Excel are in the wrong format? Say you type in 01/05/2018 which actually means January 5, 2018 in the US but it shows as May 1, 2018!  It drives me nuts because the entire spreadsheet of dates is interpreted incorrectly by Excel! That happens because your computer's Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Distribute and Align Shapes in Excel

Imagine you have a lot of shapes in your Excel file and the shapes are all over the place! You want to organize the shapes but it seems a pain to move them one by one! What would you do? Thankfully, Excel allows you to distribute and align shapes! This is our initial layout of Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Keep Duplicate Records Using Power Query or Get & Transform

Power Query or Get & Transform (In Excel 2016) lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to keep duplicate records. We usually remove duplicate lines but if we need to keep and check what the duplicates are, Excel allows us to do Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Sort an Excel Pivot Table Manually

You have your Pivot Table ready, all sorted nicely both from a row and column perspective.  However you just need that one minor sorting tweak or two. Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually! For our example, let's see this Pivot Table below.  It is Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

Count Formula in Excel

What does it do? Counts the number of cells that contain numbers Formula breakdown: =COUNT(value1, [value2]...) What it means: =COUNT(range of cells to check, [additional cells to include in the check]...) Ever had a column of data and wanted to check if all of the values contain valid numbers? It would be cumbersome to count Continue Reading

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+
Searching... Searching...
Get better at Excel!

Do you want to get better at Excel?

If so, join over 75,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis & DOWNLOAD my 80 page Excel Resource Guide eBook for Free!