Using Financial Functions and What-If Analysis in Excel 2013 New Horizons Jordan
Price: TBA
  • Duration: 1 Hour

Course details

Excel 2013 provides powerful financial functions and data-analysis tools that enable you to explore data and to make educated business decisions based on that data. Using financial functions, iterative calculations, and the Watch Window can help you make the make better financial decisions and ensure the calculations are accurate. This course will cover What-if Analysis which enables you to retrieve required results from formulas by determining the data the formula requires, forecast worksheet outcome models, and to see how changing values in formulas affect the formula results. These tools include Goal Seek, Scenario Manager, and Data Tables. This course will help prepare learners for the Microsoft Certification Exam 77-421: Excel 2013 Expert which certifies individuals as Microsoft Office Specialist (MOS): Excel Expert 2013.

  • use financial functions in Excel 2013
  • enable iterative calculations in Excel 2013
  • decide how to use financial functions in Excel 2013
  • decide how to allow circular references in Excel 2013
  • add a watch to a cell in Excel 2013
  • decide how to watch cells in Excel 2013
  • use Goal Seek to find the input for a result in Excel 2013
  • compare scenarios with Scenario Manager in Excel 2013
  • create a data table in Excel 2013
  • decide how to use what-if analysis in Excel 2013
Updated on 13 November, 2015

About New Horizons Jordan

As changes in technology have accelerated, it’s become even more essential for people to master technology to be productive, invaluable employees who optimize, program and invent solutions—and even grow companies of their own. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer ctheirses and certifications. they’re now the world’s largest independent IT training company, and they continue to lead:
  • 300 computer training centers in 70 countries (and counting)
  • Largest Guaranteed-to-Run ctheirse schedule in the world
  • Ranked in the top 5% of the industry for training quality and customer satisfaction
  • Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
  • Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
  • World’s largest Cisco-authorized training partner
See all New Horizons Jordan courses
Are you from New Horizons Jordan ? Claim your course!
Courses you can instantly connect with... Do an online course on Microsoft Office starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or