Microsoft Excel 2013 Level 2
LessonsThis course provides you with the knowledge and skills to become familiar with advanced spreadsheet analysis features and functionality of Microsoft Excel 2013.
This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 60-day access to online mentoring via chat from Microsoft Office experts.
This course prepares you for Microsoft exams 77-427 and 77-428: Excel 2013, which are required for the MOS: Microsoft Office Excel 2013 Expert certification.
What You'll Learn
- Create formulas using absolute and mixed references and financial functions
- Use the Goal Seek feature and data tables
- Create and manage scenarios and scenario reports
- Define and solve problems with Solver, and create Solver reports
- Understand and utilize the various tools used to audit workbooks
Anyone who needs to use Microsoft Office Excel 2013 proficiently
1. Using Functions
- Function Concepts
- Absolute and Mixed References
- Financial Functions
- Goal Seek
- Data Tables
- Scenario Concepts
- Creating Scenarios
- Managing Scenarios
- Scenario Reports
- Solver Concepts
- Defining the Problem
- Solving the Problem
- Solver Reports
- Solver Options
- Auditing Concepts
- Tracing a Worksheet
- Evaluating Formulas
- Locating and Correcting Errors in Formulas
- Tracking Cells in a Workbook
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted. Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
your city, your province