Microsoft Excel: 7 top tricks that you should know [Infographic]

Microsoft Excel has been around for 30 years, it’s one of the most popular programs in the world and it’s likely that most of us at some point or other have used spreadsheets at work.

Recent reports show that, 78 percent of middle-skill jobs require digital literacy and 67 percent of office roles require expertise in Microsoft Excel. So sharpening up your Excel skills really can help improve pay and job prospects.

But is your knowledge up to scratch? Luckily, Best STL has created an infographic to help you become and Excel master, with all the key bases covered.

The guide covers Charting (data presentation), Conditional Formatting (highlighting points of interest within datasets), Quick Analysis (easier when working with small datasets), Autofill (follows patterns to fill in rows or columns automatically), Power View (data exploration and visualization), Pivot Tables (to quickly summarize large sets of data) and Vlookup (collating data from different sheets).

The full infographic can be found below. Go forth and become and Excel master.

Published under license from ITProPortal.com, a Net Communities Ltd Publication. All rights reserved.