Excelling in Excel

 Sep 12, 2016

Microsoft Excel is packed with features, libraries of formulas, and comes with an increasing number of intuitive abilities. Excel is the most powerful spreadsheet application in the world. We even use it well beyond the realm of traditional spreadsheets: it can organise nearly any type of information we encounter.

Our Excel gurus have put together some solid blogs to help you get the most out of Excel. The following posts will show you how to:

  • Prevent macros from running (if you don’t want them)
  • Use range names more efficiently
  • Validate data that other people will input

New Horizons offers Excel training courses in all available versions.

 Aug 11, 2020

Have you ever locked yourself out of an Excel workbook because you wrote a macro that kicks in automatically and then closes the workbook? This way you will never have a […]

 Aug 29, 2020

A Microsoft Excel user can use range names in calculations which will create meaningful reports to management. While names make calculations easier to understand, […]

 Sep 05, 2020

You can get Excel not to accept a cell value if it falls outside a criterion. You specify the criterion in Data Validation located in the Data tab. The criterion, […]

How do your Excel skills stack up?   

Test Now  

How do your Excel skills stack up?   

Test Now  

About the Author:

New Horizons  

New Horizons is Australia’s leading corporate training provider, and has been educating business professionals for over 15 years in the areas of Professional Development, Microsoft Office & Adobe Applications, and IT Technical. Our aim through this blog is to bring you relevant stories, articles, and tips & tricks that can help you to improve your skills and productivity in the workplace. Our expert trainers will also be posting their own articles from time to time, so be sure to keep an eye out.

Read full bio