Course details
Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.
- identify the elements of a formula
- identify the default order in which calculations occur
- match absolute, relative, mixed, and 3-D references with examples
- insert an Excel 2007 formula
- use names to clarify formulas
- edit formulas
- work with Excel 2007 formulas in given scenarios
- use the AutoCalculate feature to perform basic functions
- use a logical function
- use a financial function
- use a date function
- use functions to perform calculations in Excel 2007
- use formulas and functions to calculate data in a given scenario
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
- MS Office 365 Skill-UpUSD 19
USD 420Duration: Upto 1 Hour - USD 24Duration: Upto 1 Hour
