|
| |
Microsoft Excel
97 (One Day Courses)
Basic
- Basics: Exploring Excel, opening &
navigating a workbook, closing a workbook, exiting Excel
- Entering & editing data: Create a new
Excel workbook, entering & editing labels and values, entering and
editing
formulas, saving and updating a workbook
- Modifying a worksheet: Moving & copying
data, moving & copying formulas, using absolute references, inserting
and deleting ranges, working with multiple worksheets
- Using functions: Entering functions, using the
AutoSum feature, Using AVERAGE, MIN and MAX
- Formatting worksheets: Formatting text,
formatting rows and columns, number formatting, other formatting features
- Printing: Previewing worksheets, page setup
options, printing worksheets
- Working with charts: Creating, modifying, and
printing charts
- Web Features: Saving worksheets as a Web
pages, adding hyperlinks
Intermediate
- Organizing large worksheets: viewing options,
hiding and displaying data, printing large worksheets
- Managing multiple worksheets & workbooks:
Linking worksheets using 3-D formulas, consolidating and merging data,
linking workbooks, sharing workbooks, tracking changes, and merging
workbooks
- Customizing Excel: Changing options,
customizing toolbars and menus
- Advanced charting: Chart formatting options,
combination charts, working with graphic elements
- Advanced formatting: Borders and shading,
special number formats, dates and times, styles
- Creating and managing lists: Creating lists,
sorting and filtering lists, advanced filtering
- Documenting and auditing: Adding comments and
text boxes, auditing features, protecting worksheets
- Using Templates: Using built-in templates,
creating and managing templates
Advanced
- Advanced formulas: Using names, applying
decision-making functions, creating nested functions, using financial
functions
- Lookups & data tables: working with lookup
functions, using MATCH and INDEX, creating data tables
- Advanced list management: Creating subtotals,
Validating cell entries, exploring database functions
- PivotTables: Creating, rearranging, and
formatting PivotTables
- Exporting & importing: Exporting and
importing data, Querying external databases
- Using analytical options: working with Goal
Seek and Solver, working with scenarios, working with views
- Working with Macros: running and recording
macros, editing VBA code, creating function procedures
|
