Searching... Searching...

Total Subscribers Receiving Our Weekly Excel Lessons

+55,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Replace Excel Formatting with Another Formatting

Imagine this, you have a table full of bold text.  The bold text could also be all over your worksheet in random cells. Then you decide that the bold text does not suit your expected design and prefer red colored text instead. What would you do? Changing all of the formatting one by one would Continue Reading

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

Show & Hide Field List in Excel Pivot Table

Have you ever had the scenario where you are working on your Pivot Table and the Field List disappears? Lots of Excel users get annoyed with this but luckily I'm here to help you out :) If your Pivot Table Field List disappears, you can easily bring it back as I show you below! For our Continue Reading

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

Get the Average of Values with Excel’s AVERAGE Formula

What does it do? Gives you the average of a group of values Formula breakdown: =AVERAGE(number1, number2...) What it means: =AVERAGE(the numbers you want to average)   There are times when you have to get the average of your values in your Excel worksheet and you would normally have to SUM all of the values then Continue Reading

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

What Microsoft Excel Version Do I Have?

We know that Microsoft Excel has different features across different versions and there are several Excel version, like Excel 2003, 2007, 2010, 2013 and 2016! So whenever I use Microsoft Excel I want to know right away which Excel Version I am using.  And boy, do I get confused to tell what Excel Version I am Continue Reading

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

Remove Columns Using Power Query or Get & Transform

Power Query (in Excel 2010 & 2013) 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 do is to remove columns easily. This is helpful when you have columns that you want to eliminate and do not need in Continue Reading

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

Move an Excel Pivot Table

If you have your Excel Pivot Table ready, but it's not in the best location, how do you move this onto another section of your Excel worksheet? Well, you can simply select Move PivotTable and you can move your Excel Pivot Table very quickly! For our example, let's move this lovely Pivot Table upwards! DOWNLOAD EXCEL 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 45,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis & DOWNLOAD my 80 page Excel Resource Guide eBook for Free!