You may add more courses here,
your list will be saved.

Home Online Courses Microsoft Office Using Financial Functions and What-If Analysis in Excel 2013

Using Financial Functions and What-If Analysis in Excel 2013 New Horizons Jordan

Using Financial Functions and What-If Analysis in Excel 2013

Name: Using Financial Functions and What-If Analysis in Excel 2013
Availability: InStock
Rating: 1 (1 reviews)

New Horizons Jordan

Add to wishlist

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

Ask Laimoon

View more similar 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.