Excel Training – Orbit Series
Excel Orbit takes your Excel skills to another level providing tips and hints to improve presentation of Excel documents and speed up work flow.
The Orbit series will help you to impress your boss and colleagues by advancing your skill set to a higher than average level.
Other functions and formulas can be found in the Launchpad section.
Training modules in Orbit series
1 – Sparklines
Mini charts that sit within a single cell help to highlight trends within data and are a fantastic way to improve the visual appeals of a table or report.
2 – IF Function
Return a certain value or run a certain function based on the value or content of a cell. E.g. if the value is greater than or equal to 10 return “10+” if it is lower than 10 return “0-9”
Use multiple IF functions at the same time to provide deeper analysis of the data.
4 – SUMIF
Sum the data which meets a certain criteria, e.g. From a motor dealers records, sum the price of all cars which are blue.
5 – COUNTIF
Similar to SUMIF but returns the absolute number of data items not a SUM of the data.
6 – VLookup
Find data within a table based on the left hand column of the data table. E.g. Find “Mr Smith” in the table and return his D.O.B.
7 – HLookup
Identical to the VLOOKUP but find data across the top row of the defined table.
8 – Data validation
Data validation allows the restriction of the type of data that is allowable in the cells.
9 – Drop down lists
Use drop down list to improve user experience and reduce the number of avoidable errors.
Create additional drop down lists that display options based upon the selection in the initial box.
11 – IFERROR
Remove those annoying #NA by using the IFERROR function to tell Excel what to display if the formula returns an erroneous value.
12 – ISERROR
Easily identify if an error is present.
13 – Subtotal
Insert subtotals in the data set without the risk of double counting the subtotals in the grand total.
14 – Basic Charts
Charts allow data to be displayed in a visible and effective format, add charts to any dashboard or report to boost it’s appeal.
Now you have conquered Orbit move onto Interstellar and take your skills even further.