by laramellortraining | Jan 21, 2021 | Excel Hints and Tips
Until Excel 2019 the SWITCH function did not exist but since then it has provided a viable alternative to using nested IF functions, IFS or VLOOKUPs. It evaluates one value (called the expression) against a list of values and returns the result corresponding to the...
by laramellortraining | Nov 19, 2020 | Excel Hints and Tips
Consistent formatting helps to make documents look tidier and makes them easier to read and understand. One feature that can help with this is cell styles. There are over 40 pre-created styles for you to get started with or you can create your own bespoke designs to...
by laramellortraining | Nov 5, 2020 | Excel Hints and Tips
An often underutilised option in Microsoft Excel is format as table. However, it can have a significant positive impact on your productivity when working with data stored in a table layout. It can be accessed from the Format as Table option on the Home tab or from...
by laramellortraining | Oct 22, 2020 | Excel Hints and Tips
With the volume of data we now get bombarded with on a day to day basis it’s not always easy to decide what to do with it all. If you have no idea how to get started why not let Excel provide some ideas for you. The ideas button is available in Microsoft Excel if you...
by laramellortraining | Oct 8, 2020 | Excel Hints and Tips
Excel is a brilliant calculation package but when your calculation goes wrong where do you start to troubleshoot Excel calculations? This article gives some key features that are available that will help. Double clicking on the cell By double clicking on the cell...
by laramellortraining | Sep 24, 2020 | Excel Hints and Tips
Do you work with geographical data? By showing this information on a map the data can be understood more easily. It can be used with countries, counties or post codes. Setting up the data for filled maps The first step involves creating a simple summary table...