You may add more courses here,
your list will be saved.

Home Online Courses Microsoft Office Advanced Formulas and Functions in Excel 2013

Advanced Formulas and Functions in Excel 2013 New Horizons Jordan

Advanced Formulas and Functions in Excel 2013

Name: Advanced Formulas and Functions in Excel 2013
Availability: InStock
Rating: 1 (1 reviews)

New Horizons Jordan

Add to wishlist

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 14 November, 2015

About New Horizons Jordan

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. For 30 years, New Horizons has provided more than 30 million students with industry-leading technical training that delivers the most relevant and intuitive computer ctheirses and certifications. they’re now the world’s largest independent IT training company, and they continue to lead:

300 computer training centers in 70 countries (and counting)
Largest Guaranteed-to-Run ctheirse schedule in the world
Ranked in the top 5% of the industry for training quality and customer satisfaction
Official training partner for technology leaders such as Microsoft, Cisco, CompTIA and VMware
Microsoft’s largest training provider, delivering more than 40% of all authorized Microsoft training worldwide
World’s largest Cisco-authorized training partner

See all New Horizons Jordan courses

Ask Laimoon

View more similar courses

Are you from New Horizons Jordan ? Claim your course!

Courses you can instantly connect with... Do an online course on Microsoft Office starting now.