1. Create a New Document2. Open an existing Document3. Entering Data4. Editing Data5. Aligning Data6. Saving7. Copy & Paste8. Selecting and Deleting from a Cell Range9. Adjusting Rows & Columns10. Headers and Footers11. Page Orientation12. Print Preview13. Printing on one page Invalid Input
14. Adding & Deleting Rows & Columns15. Checking Spelling16. Change Cell Shading17. Using Go to18. Find & Replace19. Insert a page break20. Undo21. Change Number Display22. Adding worksheets23. Moving between Worksheets24. Re-naming Worksheets25. Deleting Worksheets26. Centre Over Columns27. Freezing Cells28. Creating simple Formulae Invalid Input
29. Editing a formula30. Copying a Formula31. Sorting a Cell Range32. Creating a Chart33. Change the Chart Type34. Naming a Range35. Linking Data36. Filtering Data37. Macros38. Create a scenario39. Using the Function Wizard to create Formulae40. Linking Workbooks Invalid Input
41. Useful Functions: SUM, COUNT, COUNTIF42. The IF Function43. The VLOOKUP Function44. Sub-grouping Rows or Columns45. Pasting Sheets or Charts into Word46. Advanced orientation of text in Cells47. Protecting Cells and Worksheets from changes48. Paste Special49. Moving and Copying Sheets50. Using Fill and Series51. Date Calculations52. Locking Row and/or Column references when pasting formulae Invalid Input
Please indicate when you might like the training
Please provide PostCode
Please tell us you First Name
Please tell us your Last Name
Invalid Input
Please tell us your Phone Number
Please check your email address