Request a Quote or More Information on this Workshop >
WORKSHOP DESCRIPTION
Microsoft Excel has become the de facto spreadsheet application for business. This versatile software package can help you manage virtually any type of data. Whether you are tracking orders, working with budgets, or analyzing a database – Excel is the powerful and flexible solution your job requires.
This hands-on course will teach you the important functions of this industry-standard software.
Courses offered for Excel 2010, 2013, 2016, 365
Other workshops on this topic: Excel – Basic | Excel – Intermediate | Excel Advanced (Data Management)
WHO SHOULD ATTEND:
- Experienced Excel users who need to analyze and manage financial models
YOU WILL LEARN:
- Use absolute and mixed references in a formula, as well as using financial functions
- Use the Goal Seek feature and Data Tables
- Create and manage scenarios, as well as create scenario reports
- Define and solve problems with Solver, as well as create reports
- Understand and utilize the various tools used to audit workbooks
COURSE OUTLINE
Using Functions
- Reviewing function concepts
- Exploring absolute and mixed references
- Using financial functions
Projecting Figures
- Using goal seek
- Creating data tables
Performing What-If Scenarios
- Understanding scenario concepts
- Creating scenarios
- Managing scenarios
- Preparing scenario reports
Using Solver
- Reviewing solver concepts
- Defining the problem
- Solving the problem
- Preparing solver reports
- Providing solver options
Auditing Workbooks
- Reviewing auditing concepts
- Tracing a worksheet
- Evaluating formulas
- Locating and correcting errors in formulas
- Tracking cells in a workbook
Summary and Evaluations
METHODOLOGY
- Live, instructor-led training with hands-on exercises
Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.