Analyze data using analysis of assumptions in Excel 2010 New Horizons Jordan
Price: TBA
  • Duration: 1 Hour

Course details

Excel 2010 provides powerful data analysis tools that permitirá¡n explore large volumes of data and take appropriate basá¡ndose on that data more business decisions. With the tools podrá¡ Goal Seek and Solver retrieve the results of the formulas need determining the data required by the formula. In addition, podrá¡ use components analysis of hypotheses, data tables and scenarios to predict results models Calculation sheet and see how they affect the results of changes in the values ​​of formulas.

  • use Goal Seek to analyze data
  • use the Solver tool for data analysis
  • create scenarios with the Scenario Manager
  • Hypothesis handle scenarios in Excel 2010
  • create a table of data for analysis of hypotheses
  • recognize how project values ​​in a series
  • use the analysis of hypotheses to find out how to get the desired result
  • the analysis of assumptions used to determine the maximum or minimum value of one cell by changing other cells
  • the analysis of assumptions used to forecast the best and worst results
  • use the analysis of hypotheses to explore a range of possible results at a glance
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?

Rate this page

Didn't find what you were looking for ?

or