Microsoft Excel Level 2 / Med (2013, 2016, 2019)
Course Description
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.
Instruction will be personalized by version. Students have the option to progress through the course using, Microsoft Excel- Level 2 2013, or Microsoft Excel Level 2 2016.
Highlights
Upon successful completion of this course, you will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions. You will work with functions?and?lists, create advanced formulas, protect your spreadsheets and work with custom view.
Target Audience
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Course Outline
Creating Advanced Formulas
- Apply Range Names
- Use Specialized Functions
Analyzing Data with Logical and Lookup Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Data Functions
- Use Financial Functions
Organizing Worksheet Data with Tables
- Create and Modify Tables
- Sort and Filter Data
- Subtotal and Database Functions in Calculate Data
Visualization Data with Charts
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
Prerequisites
The prerequisites for this course are an introductory Excel course, or equivalent working knowledge of the software.
ALL ACCESS PASS FROM
$3,995
per license
Sign Up for All Access Pass and gain 12-month access up to 300+ Live instructor-led courses.
BUY NOWUpcoming Courses
| Date | Geography | Location | Days | Cost | |
| Nov 26, 2024 | AMER | Remote-EST | 1 | $295 USD | Register |
| Dec 03, 2024 | AMER | Remote-EST | 1 | $295 USD | Register |
| Dec 10, 2024 | AMER | Remote-EST | 1 | $295 USD | Register |
| Jan 16, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Jan 23, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Feb 04, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Feb 20, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Mar 06, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Mar 13, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Apr 10, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
| Apr 18, 2025 | AMER | Remote-EST | 1 | $295 USD | Register |
We’re Ready Lets Talk
Do You Have More Questions? We're delighted to assist you!