July 26, 2018
Key values such as dates, weekdays and months can be used to create automatic series. A series can be dragged and copied in any direction, saving time and promoting accuracy. Custom lists can also be created that automatically replicate lists that you use often.
July 25, 2018
You can use range names in formula and function calculations or to instantly select a pre-defined range of cells. Using range names can also simplify calculations by replacing absolute references.
July 21, 2018
Lookup functions can rapidly and easily perform a multitude of tedious data matching tasks e.g. highlighting data mis-matches and anomalies between large tables; matching salaries to employees; awarding bonuses according to sales volumes; and mapping values from different sources into consolidated reports.
July 9, 2018
The Insert Function wizard helps you find and select the function that you want to use and to define the arguments that the function requires, as per it’s syntax, to perform its calculation
July 9, 2018
Nesting is using brackets to group a function as one of the arguments in a formula. That function is referred to as a nested function or formula.
July 9, 2018
The IF function is a logical category function that returns one value if a condition is met and another value if it is not met.
July 9, 2018
The 3 basic Count functions in Excel can count the number of selected cells in a range that have numbers only, numbers or text, or blank cells.
July 9, 2018
There may be times when you do not want cell references to change ‘relatively’ when copying cells. Absolute references do not change when copied, and keep row and/or column references constant
July 9, 2018
When you copy and move formulas and functions cell references change either relatively or absolutely
July 9, 2018
The Status Bar can show or hide automatic calculations for selected cells, simplifying basic data analysis without the need to create calculations on your spreadsheet
July 9, 2018
Non contiguous cells or ranges are those which have been selected separately and may be adjacent, partially adjacent or completely separate. You can use this functionality in various ways to save time and work more efficiently
July 9, 2018
When you select AutoSum on the Formulas tab, Excel automatically enters the SUM function to add a range of adjacent numbers above or to the left of the selected cell.
July 9, 2018
Formulas can use brackets and operators such as + – * and / to perform calculations. Functions are predefined calculations using key words such as SUM, MAX and AVERAGE. There are over 450 functions in Excel 2016.
July 9, 2018
Understanding formula and function structure or “syntax” is vital before you attempt more complex calculations in Excel
July 9, 2018
Power Pivot is a data modelling technology that allows you to manage large data sets, build extensive relationships, and create simple or complex calculations within the Excel application environment.
July 9, 2018
PivotTables are the most powerful data analysis feature in Excel, combining the ability to sort, filter, subtotal, calculate and chart data in minutes.
July 9, 2018
Linking between spreadsheets, workbooks and applications offers huge efficiencies, but needs clear understand to work accurately and avoid risks that linking can pose.
July 9, 2018
When it comes to dynamically looking up and retrieving information from small or huge tables of data, Lookup functions can significantly boost accuracy, productivity and time savings in Excel.
July 9, 2018
Upper Lower and Proper Functions change the case of existing text in cells.
June 10, 2018
It is essential to understand the location of relevant operator keys and also what functions and function categories exist in Excel before you start using Excel.