Learn techniques for working with multiple sheets and large sheets as well as how to perform 3D math and use absolute references in formulas.Learners will also learn about Excel's extensive database features such as data validation rules, sorting, filtering, and subtotaling data. Learners will create dynamic charts using Excel 2007's updated charting feature.
Course Topics:
- Summarize data that meets specific conditions
- Find and correct errors in calculations
- Change the appearance of data based on its value
- Customize the appearance of charts
- Find trends in your data
- Print charts
- Add images to worksheets
- Create diagrams by using SmartArt
- Define valid sets of values for ranges of cells
- Limit data that appears on your screen
- Manipulate list data
- Sort data lists
- Organize data into levels
- Look up information in a data list
- Use data lists as templates for other lists
- Print data lists
- Print parts of data lists
- Link to data in other worksheets and workbooks
|
Login/Create account
checkout
view cart (
0
)
