Lesson 1: Analysing Data with Logical and Lookup Functions
TOPIC A: Use Text Functions
- Text Functions
- Logging into Office 365
- Launching Excel Online
- The LEFT and RIGHT Functions
- The MID Function
- The LEN Function
- The TRIM Function
- The UPPER, LOWER, and PROPER Functions
- The CONCATENATE Function
- The TRANSPOSE Function
TOPIC B: Use Logical Functions
- Logical Functions
- Logical Operators
- The AND Function
- The OR Function
- The IF Function
TOPIC C: Use Lookup Functions
- Lookup Functions
- The LOOKUP Function
- The VLOOKUP Function
- The HLOOKUP Function
- The MATCH Function
- The INDEX Function
TOPIC D: Use Date Functions
- The TODAY Function
- The NOW Function
- Serialising Dates and Times with Functions
TOPIC E: Use Financial Functions
- The IPMT Function
- The PPMT Function
- The NPV Function
- The FV Function
Lesson 2: Organising Worksheet Data with Tables
TOPIC A: Create and Modify Tables
- Tables
- Table Components
- The Create Table Dialog Box
- Table Modification Options
TOPIC B: Sort and Filter Data
- The Difference Between Sorting and Filtering
- Sorting Data
- Filter Operators
- Removing Duplicate Values
Lesson 3: Visualising Data with Charts
TOPIC A: Create Charts
- Charts
- Chart Types
- Chart Insertion Methods
- Resizing and Moving the Chart
- Adding Additional Data
TOPIC B: Modify and Format Charts
- The Difference Between Modifying and Formatting
- Chart Elements
- Minimise Chart Elements
- The Chart Tools
Lesson 4: Enhancing Workbooks
TOPIC A: Customise Workbooks
- Comments
- Hyperlinks
- Pictures
TOPIC B: Preparing a Workbook for Multiple Audiences
- Adding Alternative Text to Objects
- Modifying Worksheets Using the Accessibility Checker
- Managing Fonts