Calculating with Absolute Reference: Understanding the difference between a Relative and Absolute referenced formula. Using a $ sign to lock formulas
onto cells when copying.
Working with Groups of Worksheets: Grouping sheets together. Inputting
data into multiple sheets. Writing formulas to sum between sheets.
Creating Linked Tables: Linking to a source table. Using Paste Link to link a table to another file. Using Link Manager to manage linked tables.
The Function Library: Using the Function Library to help you write formulas. Search formulas with Insert Function. Writing statistical functions: COUNTA, COUNTBLANK, COUNTIFS and more.
The Logical IFS Function: Writing Logical IFS functions to generate results
from a test. Running multiple tests for multiple results.
Conditional Formatting: Automatically format data using rules. Enabling text and numbers to standout with automatic formatting. Copy formatting with
“As an IT professional I need accredited training and your courses meet that criteria with the bonus of great customer care”
the Format Painter.
The Side by Side Feature: Viewing two tables in two different files together.
Viewing two tables in two different sheets in the same file together.
Pivot Table Report: Analysing table data with PivotTable reports. Managing a PivotTable’s layout. Output statistics. Controlling number formats. Creating a
PivotChart, and inserting Slicers for filtering.
Using Data Validation: Apply Data Validation to control and quicken the input of data.
Lookup Functions: The Lookup and Reference function. Best practices for writing a VLOOKUP function. Best practices for writing an HLOOKUP function.
Achieving a professional finish to formulas by nesting within an IFERROR.
Printing Options: Printing page titles across pages. Scaling content for print.