Word
2010
Courses
Excel
2010
Courses
Access
2010
Courses
PowerPoint
2010
Courses
Outlook
2010
Courses
Microsoft Excel Course Contents
| Excel 2010 Introduction EX1 Dates |
Creating
a Spreadsheet Using the Ribbons Entering Text & Numbers Absolute & Relative References Spreadsheet Navigation Printing a Spreadsheet Using Auto Complete Editing Cells Formatting Data |
Aligning Cells Simple Formulae Precedence of Operators Using Auto Fill Editing Formulae Saving Spreadsheets Changing Page Orientation Naming Worksheets Inserting & Deleting Rows, Columns & Cells |
| Excel 2010 Intermediate EX2 Dates |
Borders
& Shading Changing Text Orientation Using Page Breaks Hiding Gridlines Deleting a Worksheet Freezing Panes & Splitting Windows |
Cell
Formatting Wrapping & Rotating Text Using Headers & Footers Aggregate Functions Simple Charts Cell Styles Printing Row & Column Headings |
| Excel 2010 Advanced EX3 Dates |
Database
Functions Auditing Tools Goal Seek Conditional Formatting Data Tables |
Lookup
Functions Pivot Tables Scenarios Slider Bars and Command Buttons Macros |
| Excel 2010 Graphs & Charts EX4 Dates |
Creating
Charts Changing Axis Markings Using a Secondary Axis Formatting Charts |
Adding
& Removing Series Adding a Trend Line 3D Charts Changing Chart Type |
WHT (Subsidiary) Ltd. Colliers Way, Old Park, Telford, TF3 4AW Tel: 01952 217081 Fax: 01952 213950
Email: training@stratatraining.co.uk Registered in England: 4128641.