Total Subscribers Receiving Our Weekly Excel Lessons

+55,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Top Excel Formulas & Function Examples To Get Better At Microsoft Excel

Below you will find many Excel formula examples for key functions like VLOOKUP, INDEX, MATCH, IF, SUMPRODUCT, AVERAGE, SUBTOTAL, OFFSET, LOOKUP, ROUND, COUNT, SUMIFS, ARRAY, FIND, TEXT, and many more. Click on any Excel formula link below and it will take you to the free example tutorial & downloadable Excel workbook for you to practice! Searching Continue Reading

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

50 Things You Can Do With Excel Pivot Tables

Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   They allow you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, highlight key information to management and include Charts & Slicers for your monthly presentations. I Continue Reading

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

How to Remove Leading and Trailing Spaces in Excel

  Leading spaces (at the start of the text) and Trailing spaces (at the end of the text) usually get in the way when we want to perform operations in Excel. Whether it leading or trailing spaces, we already have a couple ways how to clean them in Excel. For example using the TRIM formula Continue Reading

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

Free Excel Webinar Courses

Our Free Excel Webinar Courses have been viewed by more than 55,000 Excel users over the last 12 months and have helped them to get better at Excel! You too can join this free Excel training on Pivot Tables and Power Query & Data Cleansing! Excel Pivot Tables Set up your data and create a Pivot Continue Reading

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

The Ultimate Guide to Excel Pivot Table Slicers

Slicers were first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for Mac. Pivot Table Slicers are a visual filter in the form of an interactive button.  There are several cool things that you can do with Pivot Table Slicers, like customize them, filter them, connect them to multiple Pivot Tables plus much more Continue Reading

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

Excel Chart Template Infographic

Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data. The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. EXCEL COLUMN 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!