Performing Calculations Using Functions in Excel 2013 New Horizons Lebanon
Price: TBA
  • Duration: 1 Hour

Course details

Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.

  • create a basic formula in Excel 2013
  • reference cells in formulas in Excel 2013
  • create a named range in Excel 2013
  • reference cells and create a named range in Excel 2013
  • use basic functions in Excel 2013
  • decide the best way to use basic formulas and functions in Excel 2013
  • create formulas using basic logical functions in Excel 2013
  • create an IF-type formula in Excel 2013
  • decide how to create IF-type functions and nested formulas in Excel 2013
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