Intermediate Excel 2007 - Beyond the Basics Improve the quality, accuracy and usefulness of every worksheet.
Benefits:
- Use a spreadsheet in decision making through the use of statistical, financial, logical and lookup functions
- The importance of isolating assumptions in a worksheet
- Data Validation - Validation criteria, drop down list, finding and noting invalid data
- Conditional Formatting and formatting the overall appearance of the worksheet using styles
Introduction to Excel
Benefits:
- Understand the vast potential of an excel worksheet
- Create a simple worksheet and understand how the rows and columns of a spreadsheet are identified and how its cells are labeled
- Open and modify an existing excel worksheet
- Use Excel functions
- Insert and delete rows and columns in a worksheet
- Save and print a worksheet with formulas
|