|
| |
Microsoft Excel 2000
(One Day Courses)
Basic
- Basics: Spreadsheet terminology, exploring
Excel, opening & navigating a workbook, closing a workbook
- 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
- Using functions: Entering functions, using the
AutoSum feature, Using AVERAGE, MIN, MAX and COUNT
- Formatting worksheets: Formatting text,
formatting rows and columns, number formatting, other formatting features
- Printing: Preparing to print, page setup
options, printing worksheets
- Working with charts: Creating, modifying, and
printing charts
- Web Features: Saving worksheets as a Web
pages, adding hyperlinks, sending a worksheet via email
Intermediate
- Organizing large worksheets: viewing options,
hiding and displaying data, printing large worksheets
- Managing multiple worksheets & workbooks:
Linking worksheets using 3-D formulas, consolidating data,
linking 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, styles, other advanced formatting
- 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
- Collaborating with a workgroup: Sharing
workbooks, managing changes, merging a shared workbook
- Additional Functions: IF, PMT, and FV
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, data forms
- PivotTables: Creating, rearranging, and
formatting PivotTables, PivotCharts
- Exporting & importing: Exporting and
importing data, Querying external databases
- Using analytical options: working with Goal
Seek and Solver, working with scenarios, working with views, reports
- Working with Macros: running and recording
macros, editing VBA code, creating function procedures
- Advanced web topics: Creating interactive web
spreadsheets, PivotTables on the web
|
