Total Subscribers Receiving Our Weekly Excel Lessons

+45,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

How to Find Duplicates in Excel

Normally when we have dirty data, we tend to get a lot of duplicates. But in Excel it is very easy to spot the duplicates for your data cleanup! Here is our sample list of words, you can see it has a lot of duplicates: I explain how you can do this below: DOWNLOAD EXCEL Continue Reading

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

Round Off Numbers with Excel’s ROUND Formula

What does it do? Rounds a number to the nearest decimal based on your specified number of digits Formula breakdown: =ROUND(number, num_digits) What it means: =ROUND(the number, number of decimal places to round off) Ever had the need to round off numbers? I do it all the time in my financial calculations.  For example, if Continue Reading

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

Sort an Item Row (Left to Right) 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 any row from left to right!! 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 we will Continue Reading

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

Ultimate Dashboard Tools for Excel

Ultimate Dashboard Tools add-in is developed by ExcelDashboardSchool.com and creates awesome looking Excel Dashboards with just a couple of clicks and without using complex Formulas. There isn’t any long standing or well working recipe in the world of Excel data-visualization, so Ultimate Dashboard Tools would like to help you to find the best method. Create professional Excel Dashboards Continue Reading

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

5 Speedy Steps To An Excel Pivot Table!

G'day All, In this free downloadable Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps. If you want to learn more about Pivot Tables, join me in this Free Pivot Table Webinar Training and elevate your Excel skills in 2017: VIEW THE FREE PIVOT TABLE WEBINAR Continue Reading

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

Top 3 Excel Pivot Table Issues Resolved

I have shown my Pivot Table webinar to over 40,000 people over the last couple of years and I continually get the same questions from my webinar attendees regarding the little issues they have when using a Pivot Table. I want to put these issues to bed so you can go out and use a Continue Reading

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

Project Milestone Chart Using Excel

Project Management is no easy feat!  There are lots of moving parts, long hours and constant reporting. It requires you to keep everybody on the same page and focused on the goals and timelines. One of the key reporting tools needed is the project milestone or timeline chart.  Luckily you can create a project milestone chart 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!