Prerequisites
To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Basic Level.
Course overview
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.
Goal
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?
- BasicFormulas
- Order of Operation
- MovingSelection
- Seven Methods to Add numbers
- Relative & Absolute Reference
- Basic & Intermediate Functions
- Financial Functions
- TextFunctions
- Date Functions
- Logical Functions
- Conditional Functions
- Extraction Functions
- Formula Auditing
- Naming Cells & Ranges
- Sort & Custom Lists
- Filtering Data
