Learn to work more efficiently and impressively in Excel by mastering features such as 3-D references, absolute and relative cell addressing, data tables, named ranges, sorting and filtering, restrict data entry, group worksheets, subtotal reports, and work with conditional formatting.
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
- Consolidate multiple sets of data into a single workbook
- Group multiple sets of data
|