Advanced Formulas and Functions in Excel 2013 New Horizons Lebanon
Price: TBA
  • Duration: 1 Hour

Course details

The Excel 2013 function library includes a number of functions in the Date and time, Logical, and Lookup and reference categories that enables you to quickly complete tasks and analyze data. Date and time functions allow you to capture dates and times properly. This course covers date and time functions such as NOW, TODAY, DATE, and NETWORKDAYS. Logical and IF-type functions help you make decisions. This course covers IF, AND, OR, AVERAGEIFS, COUNTIFS, and SUMIFS. Lookup and reference functions allow you to perform table lookups to return required information about specific worksheet cells. This course covers lookup and reference functions such as LOOKUP, VLOOKUP, and HLOOKUP. Excel 2013 also provides tools to identify, trace, and troubleshoot errors. 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 date and time functions in Excel 2013
  • decide how to use date and time functions in Excel 2013
  • use logical functions in Excel 2013
  • choose the logical functions to use in Excel 2013
  • transpose data in Excel 2013
  • look up data with functions in Excel 2013
  • decide how to look up data with functions in Excel 2013
  • trace errors in Excel 2013
  • decide how to trace errors 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