|
|
|
Excel 2000 foundation
A first look at Excel 2000
- The advantages of using Excel
2000
- What are workbooks and worksheets?
- Creating and opening workbooks
- Entering data
- Further data entry techniques
- Autocorrect
- Autocomplete
- Using the pick list
- Navigating in the worksheet
- Selecting items within Excel
2000
- Inserting and deleting cells,
rows and columns
- Saving workbooks
- Moving between worksheets
- Using the spelling checker
- Closing an Excel 2000 workbook
- Exiting Excel 2000
A closer look at the Excel
2000 screen
- The standard toolbar
- The formatting toolbar
- Selecting worksheet views
- Undo and repeat
- The office assistant
Formatting and customizing
data
- Formatting options within Excel
2000
- Alignment
- Data indentation and rotation
- To center items in a cell/cells
- Using fonts
- Formatting numbers
- Decimal places
- Formatting columns and rows
- Deleting cells, formats, objects
and worksheets
- Adding, editing and removing
borders
- Using Autoformat
- Copying data
- Copying data using drag and
drop
- Copying columns and rows
Formulas, functions and named
ranges
- Formulas
- Operator evaluation order within
Excel 2000
- Functions
- Using the sum function
- Other commonly used functions
- Using paste function
- Naming cells and ranges
- Using named ranges with formulas
Introducing charts
- Creating a chart
- Manipulating charts
- Changing the chart type
Printing
- Page setup
- Margins
- Centering printed output
- Headers and footers
- Sheet printing options
- Choosing a printer and changing
settings
- Printing a worksheet
- Printing multiple files
Excel
2000 intermediate
Worksheets, a further look
- Renaming worksheets
- Deleting and inserting worksheets
- Finding files
- Displaying other toolbars
- Customizing the look of the
toolbars & menus
- Freeze panes
- Grouping and ungrouping worksheets
- The series command
Further formatting techniques
- Conditional formatting
- Creating new styles based on
existing cell formatting
- Using colors in Excel 2000
- Using colors based on values
- Gridlines
- Hiding data and re-displaying
data
Further functions
- What are functions?
- Using paste function
- The if( ) function
- Data validation functions
- The hlookup / vlookup functions
- A sample hlookup
- The choose function
- Entering a choose function
- The date functions
- Mathematical date functions
- Time functions
- Text manipulation functions
Database and list management
- What is a database?
- Excel 2000 databases
- Database terminology
- Creating, editing and navigating
a database
- Sorting an internal Excel 2000
database
- What is autofilter?
- Filtering data
- Top 10 autofilter
- Advanced filtering
- Totaling and manipulating filtered
data
- Creating subtotals
- Using data forms
- The Excel 2000 data form
Customizing charts
- The chart wizard
- Adding and removing data
- Changing data by dragging and
dropping columns
- Formatting the chart area
- Chart formatting - legends
- Chart formatting - axis
- Chart formatting - the plot
area
- Chart formatting - gridlines
- Chart formatting - the data
series
Drawing and pictures
- Drawing lines, boxes, ovals
and arcs
- Using autoshapes
- Creating text boxes
- Pictures
- Bring to front/send to back
- Grouping and un-grouping objects
Excel 2000 and other applications
- Using the conversion feature
- Cut, copy and paste - using
the clipboard
- Using paste special
- OLE - embedding vs. Linking
- Linking data from other worksheets
- Linking data from Word
- Linking data to Word
Excel 2000 advanced
Templates and styles
- What are templates?
- Creating templates
- Using templates
- What are styles?
- Creating and using styles
Importing data
- Why import data?
- The text wizard
- Importing from a database
- Database terminology
- Using Microsoft query
"what if?" Utilities
- Excel "what if?" Type
utilities
- Goal seek
- Graphical goal seeking
- Scenario manager
- Solver
- Solver terminology and examples
Macros and custom controls
- What are macros?
- To record a macro
- Running macros
- Creating a button in a worksheet
and assigning a macro to it
- Attaching macros to a button
- Drawing, editing and formatting
buttons
Customizing Excel
- Customizing Excel 2000 - options
- Customizing toolbars
Security and proofing within
Excel
- Auditing and security features
within Excel 2000
- The spell checker
- What are shared workbooks?
- Advanced workbook sharing options
- Data validation
- Workbook password protection
- Workbook protection
- Worksheet protection
- Cell protection
- Excel 2000 auditing tools
- Auditing worksheets
- Cell comments
Data maps
- What are data maps?
- The data map control dialog
box
- Placing data on a map
- Formatting a data map
Consolidation
- What is consolidation?
- Consolidating rows and columns
|
