Excel 2007 - Introduction
Discover the tools and techniques to creating powerful spreadsheets such as financial reports, inventory reports, sales and expense reports, budgets, projections, payroll costs, and other tasks.
If you are like most of us, you have taught yourself the basics of Excel through trial and error. While you may have learned enough to get by and do basic tasks, now is the time to learn the skills that will make using Excel easier, faster, and produce remarkable results.
Prerequisites:
Assumes no experience using Excel, but a basic computer background and familiarity with Windows is expected.
Topics Include:
- Components and terminology of spreadsheets
- Creating basic spreadsheet formulas and functions
- Clearing up the confusion of relative and absolute cell referencing
- Speeding up data input with the AutoFill feature
- Formatting to enhance the appearance of spreadsheets
- Adding comments to spreadsheets
- Rearranging your data with the Sort option
- Working with cut, copy, paste, insert, and delete features
- Selecting options to ensure your printouts appear they way you want
- Understanding the IF function
- Understanding Excel error messages and smart tags
- Moving, copying, inserting, and deleting spreadsheets
- Using draw objects (arrows, shapes, text boxes)
- Creating and modifying charts and graphs
- Integrating graphs and tables into Word Documents
|