Total Subscribers Receiving Our Weekly Excel Lessons

+55,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

The Ultimate Guide to Excel Pivot Table Slicers

Slicers were first introduced in Excel 2010 and they are a visual filter in the way of an interactive button.  There are several cool things that you can do with Slicers. Read on! 1. Insert a Slicer Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen 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+

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+

How to Show & Hide Formulas in Excel

When I have a sheet full of Excel formulas, sometimes I want to quickly check how each formula looks like.  This is great for spreadsheet auditing. It is very easy to do so in Excel! Here is our sample worksheet with formulas: I explain how you can do this below: DOWNLOAD EXCEL WORKBOOK STEP 1 Continue Reading

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

How to Remove Formulas in Excel

There are times when I have an Excel worksheet full of formulas and I want to hard code the results and remove the formulas completely. This is very easy to do in Excel! Here is our sample worksheet which has the following formulas in Column E: I explain how you can remove formulas in Excel below: DOWNLOAD EXCEL WORKBOOK Continue Reading

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

How to Unhide Columns in Excel

We normally use "helper columns" to do calculations in our Excel worksheet.  These "helper columns" are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss! But once we are done with presenting our Excel worksheet to our evil boss, we can unhide these 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!