Due to Covid-19 safety restrictions PhoenixTS will temporarily be unable to provide food to our students who attend class at our Training Center; however, our Break Areas are currently open where students will find a constant supply of Coffee, Tea and Water. Students may bring their own lunch and snacks to eat in our breakrooms or at their seat in the classroom or eat out at one of the many nearby restaurants.
Course Overview
This 1-day instructor-led course builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel 2016 courses map to the Microsoft Office Specialist and Expert exams’ objectives for Excel 2016.
Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will complete their coverage of all the objectives for both exams.
After completion of this course, students will know how to:
- Use functions to make decisions and to return information from arrays and tables.
- Find and trap errors, control formula options, and use array formulas and functions.
- Perform calculations on dates, manipulate text, and about some statistical and financial functions
- Import or create a connection to external data, and export Excel worksheets to other formats
- Perform what-if analyses by using scenarios and the Goal Seek utility and about some of the tools available in the Analysis Toolpak.
- Record and run macros and how to create a simple form.
Schedule
Microsoft Excel 2016 Level 3
8/18/22 - 8/18/22 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
9/14/22 - 9/14/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
9/14/22 - 9/14/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
10/06/22 - 10/06/22 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
10/13/22 - 10/13/22 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
10/13/22 - 10/13/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
10/13/22 - 10/13/22 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
10/14/22 - 10/14/22 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
10/21/22 - 10/21/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
11/09/22 - 11/09/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
11/09/22 - 11/09/22 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
12/08/22 - 12/08/22 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
12/08/22 - 12/08/22 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
12/09/22 - 12/09/22 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
1/04/23 - 1/04/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
1/11/23 - 1/11/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
1/11/23 - 1/11/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
2/01/23 - 2/01/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
2/08/23 - 2/08/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
2/08/23 - 2/08/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
3/08/23 - 3/08/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
3/15/23 - 3/15/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
3/15/23 - 3/15/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
4/05/23 - 4/05/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
4/12/23 - 4/12/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
4/12/23 - 4/12/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
5/03/23 - 5/03/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
5/10/23 - 5/10/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
5/10/23 - 5/10/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
6/07/23 - 6/07/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
6/14/23 - 6/14/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
6/14/23 - 6/14/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
7/12/23 - 7/12/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
7/19/23 - 7/19/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
7/19/23 - 7/19/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
8/09/23 - 8/09/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
8/16/23 - 8/16/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
8/16/23 - 8/16/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
9/13/23 - 9/13/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
9/20/23 - 9/20/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
9/20/23 - 9/20/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
10/04/23 - 10/04/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
10/11/23 - 10/11/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
10/11/23 - 10/11/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
11/08/23 - 11/08/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
11/15/23 - 11/15/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
11/15/23 - 11/15/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
12/06/23 - 12/06/23 (1 days)
8:30AM - 4:30PM EST
Tysons Corner, VA
Open
$299
12/13/23 - 12/13/23 (1 days)
8:30AM - 4:30PM EST
Columbia, MD
Open
$299
12/13/23 - 12/13/23 (1 days)
8:30AM - 4:30PM EST
Online
Open
$299
Not seeing a good fit?
Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.
Course Outline
Logical and Lookup Functions
- Decision-making functions
- Lookup and reference functions
Advanced Formulas
- Auditing and error-trapping
- Formula options
- Arrays
Special functions
- Date and time functions
- Text functions
- Other functions
Importing and Exporting
- The Power Pivot Data Model
- Exporting data
Analysis
- What-if analysis
- The Analysis Toolpak
Macros and Forms
- Recording macros
- Running macros
- Forms
Due to Covid-19 safety restrictions PhoenixTS will temporarily be unable to provide food to our students who attend class at our Training Center; however, our Break Areas are currently open where students will find a constant supply of Coffee, Tea and Water. Students may bring their own lunch and snacks to eat in our breakrooms or at their seat in the classroom or eat out at one of the many nearby restaurants.