- 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
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
- Data Analysis and Forecasting in Excel NextGen LearningAED 45Duration: Upto 5 Hours
- Microsoft Office 2016 Study 365AED 138Duration: Upto 40 Hours
