- Duration: 2 Hours
Course details
Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data organization features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct, that it is entered in the proper format, and that formulas are working correctly, all of which are incredibly important for maintaining accurate records. This course explores organizing and subtotaling data in Excel 2007 using the available features. It also covers data validation, including error messages, invalid data prevention, formula auditing, error checking, and the Watch window.
- sort data
- filter data in a range or table
- group and outline data
- insert subtotals in a worksheet
- display different levels of data using outlines
- outline data
- filter and sort data
- apply subtotals to data
- organize worksheet data to facilitate data analysis
- specify the data that is allowed in a particular range
- recognize which error alert to use in given examples
- locate and correct formula errors
- use the Watch Window to audit formulas
- locate and correct formula errors
- add data validation to prevent the errors from recurring
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 Access for Beginners One EducationUSD 22
USD 460Duration: Upto 5 Hours - USD 111Duration: Upto 80 Hours
