EXCEL 2013 – 2016 – 2019 INTERMEDIATE COURSE – ONE DAY

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

  1. What is a Formula?
  2. BasicFormulas
  3. Order of Operation
  4. MovingSelection
  5. Seven Methods to Add numbers
  6. Relative & Absolute Reference
  7. Basic & Intermediate Functions
  8. Financial Functions
  9. TextFunctions
  10. Date Functions
  11. Logical Functions
  12. Conditional Functions
  13. Extraction Functions
  14. Formula Auditing
  15. Naming Cells & Ranges
  16. Sort & Custom Lists
  17. Filtering Data
Share This Post
Have your say!
0 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>