Formulas and Functions Excel 2007 New Horizons Lebanon
Price: TBA
  • Duration: 2 Hours

Course details

Excel 2007 provides numerous functions and formulas to perform simple and complex calculations with information from a workbook. The formulas of the tape tab provides easy access to the groups of analysis tools and data cá¡lculo such as Function library groups, defined names, formulas and Cá¡lculo Audit. This course shows how to create and edit formulas, use references and names and working with tables in Excel 2007. Also © n explains the bá¡sicas, logical, financial, and date and time functions.

  • identify the elements of a formula
  • identify the default order in which the calculations occur
  • link absolute, relative, and 3D mixed references examples
  • insert a formula in Excel 2007
  • use names to clarify formulas
  • edit formulas
  • work with Excel 2007 formulas in given situations
  • AutoCalculate use the function to perform basic functions
  • use a logic function
  • use a financial function
  • use a function of date and time
  • use functions to perform calculations in Excel 2007
  • using formulas and functions to calculate data in a given situation
Updated on 08 November, 2015

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.

See all New Horizons Lebanon courses
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