Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Sort Largest to Smallest Grand Totals With Excel Pivot Tables

  I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort from largest to smallest with Grand Totals! Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period. Make sure to download the Excel Workbook below so that Continue Reading

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

Getting the remainder with Excel’s MOD Formula

What does it do? Gives you the remainder after dividing one number with another Formula breakdown: =MOD(number1, number2) What it means: =MOD(a number, divided by this number) In Excel it is very easy to divide two numbers. But how about if you need to get the remainder from a division operation? For example, divide 13 by 4: Divide Continue Reading

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

Create a Radar Chart in Excel For Performance Reviews

Radar Charts in Excel are very handy to show a rating on several performance areas. When I had to give out performance reviews, it was a very helpful snapshot for me to show to my colleagues how their performance was compared to last year! Here is an example of a table with several ratings: In this Continue Reading

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

Replicating Excel’s LEN Function with M in Power Query

Power Query lets you perform a series of steps to transform your Excel data. There are times when we want to do things that are not built in the user interface. This is possible with Power Query's programming language, which is M. Unfortunately not all of Excel's formulas can be used in M. For example, if Continue Reading

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

Create a Random List with Excel’s RAND Formula

What does it do? Gives you a random number between 0 and 1 Formula breakdown: =RAND() What it means: =RAND(Will automatically choose a random number between 0 and 1) Excel is able to do a lot of things that most users are unaware of!  One thing that amazes me & I use almost daily is Continue Reading

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

Replicating Excel’s RIGHT Function with M in Power Query

Power Query lets you perform a series of steps to transform your Excel data. There are times when we want to do things that are not built in the user interface. This is possible with Power Query's programming language, which is M. Unfortunately not all of Excel's formulas can be used in M. For example, if 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!