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 NowRelated Articles
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
Next up:
- Automate your website publishing process using Github and Azure
- 3 TED talks on habit
- How-to: Promote a Sub-Site to a Top-Site in SharePoint 2013
- Have you got bubbles?
- Mastering InDesign
- How-to: Add public holidays to a Microsoft Project 2013/2016 calendar
- What they don't tell you about becoming a manager
- The first tool of Power BI
- Use conditional formatting to create a Gantt Chart in Excel
- Reduce those pesky meeting request response messages in Outlook
Previously
- Automate your website publishing process using Github and Azure
- How to improve your business writing
- SQL Server 2016 – Row Level Security (RLS)
- Assertiveness in practice
- Working with Styles – Part 4
- Float workloads into the cloud with Microsoft Azure
- How-to: Install Windows 10 using the media creation tool
- I am merging traditional and digital selling – And it is working!
- What you did not know about the Excel SUMPRODUCT function
- How-to: Validate data based on the value of a different cell in Excel
