- Duration: 1 Hour
Course details
Excel 2010 provides powerful data-analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. Using Goal Seek and Solver enables you to retrieve required results from formulas by determining the data the formula requires. And you can use additional what-if analysis components, data tables and scenarios, to forecast worksheet outcome models and to see how changing values in formulas affect the formula results.
- use Goal Seek for data analysis
- use Solver to perform data analysis
- create scenarios using the Scenario Manager
- manage Excel 2010 what-if scenarios
- create a data table for what-if analysis
- recognize how to project values in a series
- use what-if analysis to find out how to achieve a desired result
- use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
- use what-if analysis to forecast best-case and worst-case results
- use what-if analysis to explore a possible set of outcomes at a glance
About New Horizons Lebanon
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. With over 300 centers in 60 countries, New Horizons is the world’s largest independent IT and Business training company. Over the past 35 years, New Horizons has delivered a full range of IT and business skills/Management training through innovative learning methods that have transformed businesses and helped over 35 million students reach their goals. New Horizons Lebanon branch was established in 1996.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- USD 49Duration: 1 To 2 Months
- Business Planning and Analysis Diploma Adams AcademyUSD 25
USD 240Duration: Upto 12 Hours
