To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Basic Level.
This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook.
Items marked with an asterisk* are taught for 2010 only.
Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel- Level 2 2010, Microsoft Excel- Level 2 2013, or Microsoft Excel Level 2 2016.
Learning How to read a function tip (like a musical note) in order to deal with anyone of the 461 built-in functions.
Excel Intermediate Topics
- What is a Formula?
- Order of Operation
- Seven Methods to Add numbers
- Relative & Absolute Reference
- Basic & Intermediate Functions
- Financial Functions
- Date Functions
- Logical Functions
- Conditional Functions
- Extraction Functions
- Formula Auditing
- Naming Cells & Ranges
- Sort & Custom Lists
- Filtering Data