- Duration: 1 Hour
Course details
Formulas are an integral and important feature of Excel 2010. So ensuring they are correct can save you time and a lot of headaches. Excel 2010 provides you with the tools you need to audit formulas and correct errors that may be found. In addition, using Excel's data validation tools you can restrict the types of data that can be input to your workbooks preventing data entry errors that could otherwise occur. This course describes Excel 2010's auditing and formula correction features and shows you how to use data validation to avoid worksheet errors.
- use Excel's formula auditing tools to evaluate and correct formulas
- use the Watch Window to inspect, audit, or confirm formula calculations and results
- use data tools to convert text to columns and remove duplicates
- add data validation to worksheet cells
- list the different things you can use data validation for
- use error checking to identify a formula error
- separate text in one column into two columns
- restrict data entry in specific cells
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
- Libraries – Office 2007 Bundle Study 365USD 94
USD 673Duration: Upto 16 Hours - Excel Formula VLOOKUP in 60 minutes! Skill-UpUSD 13Duration: Upto 1 Hour
