Our Top 5 Excel tips of 2018

1 minute read time.

These Microsoft Registered Excel Registered tips and tricks are the top performing tips of 2018, and have raked up a combined viewership of over 200 000. Without further ado, here they are, the Top 5 Excel tips and tricks of 2018. 


How to consolidate data in Excel using Data Consolidation (66,027 views)

How to get a distinct count in a Pivot Table (55,116 views)

Easy steps to opening an Excel workbook on a specific worksheet (31,146 views)

How to extract text from a text string using the MID and FIND functions (29,609 views)

How to find the position of a value in a data range using the MATCH function (27,642 views)

Our Excel tips and tricks will help you make the most of the business reporting features in Excel. If you wish to revisit any of our previously published tips, please visit our website.