1. Create a New Document 2. Open an existing Document 3. Entering Data 4. Editing Data 5. Aligning Data 6. Saving 7. Copy & Paste 8. Selecting and Deleting from a Cell Range 9. Adjusting Rows & Columns 10. Headers and Footers 11. Page Orientation 12. Print Preview 13. Printing on one page Invalid Input
14. Adding & Deleting Rows & Columns 15. Checking Spelling 16. Change Cell Shading 17. Using Go to 18. Find & Replace 19. Insert a page break 20. Undo 21. Change Number Display 22. Adding worksheets 23. Moving between Worksheets 24. Re-naming Worksheets 25. Deleting Worksheets 26. Centre Over Columns 27. Freezing Cells 28. Creating simple Formulae Invalid Input
29. Editing a formula 30. Copying a Formula 31. Sorting a Cell Range 32. Creating a Chart 33. Change the Chart Type 34. Naming a Range 35. Linking Data 36. Filtering Data 37. Macros 38. Create a scenario 39. Using the Function Wizard to create Formulae 40. Linking Workbooks Invalid Input
41. Useful Functions: SUM, COUNT, COUNTIF 42. The IF Function 43. The VLOOKUP Function 44. Sub-grouping Rows or Columns 45. Pasting Sheets or Charts into Word 46. Advanced orientation of text in Cells 47. Protecting Cells and Worksheets from changes 48. Paste Special 49. Moving and Copying Sheets 50. Using Fill and Series 51. Date Calculations 52. 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