|
Course Contents
Microsoft
Excel Introductory
Introduction to Excel
- Opening Screen
- Closing Screen
- Menus and Toolbars
- Customising Toolbars
- Office Assistant
- Creating, Opening, Closing and Saving
Worksheets
- Navigation a Worksheet
- Selecting Ranges
Editing a Worksheet
- Entering data
- Inserting & Deleting cells, columns and
rows
- Adjusting columns and rows
- Copy and Paste
- Clipboard
- Find and Replace
- Undo and Redo
- AutoFill
- Custom Lists
Basic Formulas and Functions
- Basic Calculations
- AutoSum
- Editing Formulae
- Functions
- AutoCalculate
- Relative and Absolute Cells
- Circular References
Formatting Cells
- Formatting Numbers
- Formatting Data
- Alignment
- Adding Borders and Shading
- AutoFormat
- Format Painter
Printing
- Page Setup - Headers and Footer, etc
- Print Preview
- Printing
Linking Worksheets
- Arranging Windows
- Screen Panes
- Freeze Titles
- Zoom
- Named Ranges
Proofing Tools
- AutoCorrect
- Spell Check
- Hiding Data
- Worksheet Protection
Charts
- Creating Charts
- Changing Charts
Click
here to return to Course List
Microsoft
Excel Intermediate
Formatting Workbooks and Templates
- AutoFormat
- Conditional Formatting
- Custom Formatting
- Templates
- Styles
- Paste Special
Databases
- Data Forms
- Sorting Data
- Subtotaling
- Outlining
- Auto Filter
- Advanced Filter
Formulae and Functions
- Lookup Tables - VLOOKUP
- Logical Formula - IF, AND, OR
- Financial Formula - PMT, FV/PV
Pivot Tables and Data Maps
- Create a Pivot Table
- Modify a Pivot Table
- Use PivotTable Charts
- Use External Data in PivotTables
Auditing
- Error Codes
- Rounding Errors
- Circular References
- Data Validation
Other
- Default Options
- Creating Custom Toolbars
- Hyperlinks and E-mail
Click
here to return to Course List
Microsoft
Excel Advanced
Sharing Workbooks
- Resolve Conflicts
- Track Changes
- Accept or Reject Changes
- Merge Workbooks
Macros
- Introduction to Macros
- Recording a Macro
- Editing a Macro
- Macro Playback
- Macro References
- Adding a Macro to a Toolbar
Multiple Workbooks
- Advantages and Disadvantages
- Linking Worksheets with Formulae
- Linking with Paste Special
- Updating Links
- Consolidation of Multiple Files
Import and Export Data
- Microsoft Query
- Import from Other Applications
- Get External Data
- Create a New Data Source
- ASCII or Plain Text Import
- Delimited Text
- Export to Other Applications
Analytical Tools
- Goal Seeking
- Data Tables
- Solver
- Scenarios
- Forecasting Trends
- Trend lines in Charts
Click
here to return to Course List | 