- Duration: 1 Hour
Course details
The Excel 2010 function library includes a number of functions in Lookup & Reference, Math & Trig, and Text categories that enable you to quickly complete tasks and analyze data. 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, HLOOKUP, INDEX, ROW, and COLUMNS. Math & Trig functions provide multiple methods of working with numbers and triangles. This course explores rounding functions, INT, TRUNC, AGGREGATE, COS, SIN, and TAN. Excel 2010 also provides a number of functions to make working with text easier. Text functions, such as TRIM, CLEAN, PROPER, SEARCH, and MID, as well as string concatenation, are covered.
- use lookup functions in Excel 2010
- recognize when to use the lookup functions in Excel 2010
- use reference functions in Excel 2010
- use math functions in Excel 2010
- recognize when to use the rounding functions in Excel 2010
- use trig functions in Excel 2010
- use text functions in Excel 2010
- use advanced functions in Excel 2010
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
- Microsoft Office Essentials Certificate Adams AcademyUSD 37
USD 370Duration: Upto 2 Days - Microsoft PowerPoint Complete Diploma Alpha AcademyUSD 25
USD 280Duration: 34 Hours
