Blue256 offer Microsoft Office training courses..
MS Excel Course Content
INTRODUCTION
- Getting started
- Entering text and numbers
- Copy, Cut and Paste
- Simple calculations
- Formatting Cells and Ranges
- Printing Spreadsheets
- Working with Worksheets
- Saving and opening files
- More formulae
- Absolute Cell referencing
- Sorting data
- Creating Graphs and Charts
INTERMEDIATE
- Working with text and numbers
- Copy, Cut and Paste
- Using formulae
- Formatting text and numbers
- Aligning text and numbers
- Conditional Formatting
- Working with Worksheets
- Date and time calculations
- Working with Rows and Columns
- Using Headers and Footers
- Using Comments
- Printing options
- Using Excel as a Database
- Using If statements
- Using Graphs and Charts
- Saving Worksheets
ADVANCED
- Review and refresh exercise
- Manipulating text
- Useful formulae and functions
- Linking Worksheets and Workbooks
- Lookup tables
- Absolute Cell referencing
- Goal Seeking
- Formatting options
- Date and Time calculations
- Data manipulation
- Data Validation
- Scenarios
- Protection and passwords
- Macros
- Auditing a Spreadsheet