Microsoft IT Office Course - United Kingdom

Introduction

1. Intro to IT & Computers
2. Basic Concept of IT
3. What is a Computer?
4. Components of a Computer
5. Classification of Computers
6. Computer Software
7. System Software
8. Operating System MS Windows
9. Application Software
10. MS Office
11. Operating System
12. The Windows 7 Desktop
13. Desktop Wallpaper
14. The Taskbar
15. Setting the Date and Time
16. Toolbars
17. The Windows 7 Start Button
18. Share your computer with others
19. Setting Parental Controls in Windows 7
20. Copying Pictures to a New Folder
21. How to take a Screenshot in Windows

Microsoft Word

1. Getting Started With Microsoft Word
2. Creating a basic document
3. Enter text
4. Saving a new document
5. Preview document
6. Print document
7. Online help
8. Editing a Document
9. Insert text
10. Select text
11. Create an auto text entry
12. Move and copy text
13. Delete text
14. Undo changes
15. Find and replace text
16. Formatting Text
17. Apply font styles and effects
18. Change text color
19. Highlight text
20. Bulleting text
21. Formatting Paragraphs
22. Set tabs to align text
23. Control paragraph layout
24. Add borders and shading
25. Apply styles
26. Adding Table
27. Create a table
28. Modify the table structure
29. Format a table
30. Table toolbar
31. Header and Footer
32. Understanding header and footer
33. Creating / editing header and footer
34. Insert page number / text on header & footnote and endnote option menu
35. Creating / editing footnote and endnote
36. Drawing Toolbar Word Art
37. Use of Drawing toolbar
38. Use of auto shape
39. Adding shadows and text to a shape
40. Working with textbox object
41. Create word art
42. Advanced word art
43. Create Word Macros
44. What is a macro
45. Create a macro
46. Assign a macro to the keyboard
47. Delete your macro
48. Proofing a Document
49. Check spelling, grammar and word count
50. Customize autocorrect options

Microsoft Excel

1. Getting Started With MS Excel
2. Excel rows and columns
3. Workbook & worksheet
4. Enter text and numbers in a cell
5. Edit text in a cell
6. Cell formatting
7. Font formatting
8. Merge cells
9. Save your work
10. Formulas and Functions
11. Entering formulas
12. Copying data and formulas
13. Using AutoSum
14. Understanding functions
15. Using simple aggregate functions (Sum, Count, Average, Min, Max)
16. Copying formulas
17. Editing Features
18. Using cut , copy, and paste operations
19. Using paste special with values
20. Selection techniques
21. Navigation techniques
22. Working with the Large Workbooks
23. Freezing and unfreezing panes
24. Splitting windows
25. Inserting page breaks for printing-
26. Working with Charts
27. Creating charts using Chart Wizard
28. Creating different types of charts
29. Including titles and values in charts
30. Formatting of charts
31. Inserting Graphic Objects
32. Insert and modify pictures and clipart
33. Draw and modify shapes
34. Illustrate workflow using smartart Graphics
35. Previewing and Printing
36. Previewing worksheets
37. Page setup
38. Printing of worksheets in multiple pages
39. Repeating rows and columns for multiple pages
40. Printing multiple worksheets
41. Simple Database Operation
42. Sorting tables
43. Filtering data with auto filter
44. Referring data from other worksheets
45. Create hyperlinks
46. Analyzing Data Using Pivot Tables and Pivot Charts
47. Create a pivot table report
48. Analyze data using pivot charts

Microsoft PowerPoint

1. Getting Started
2. Microsoft Office Toolbar
3. Quick Access Toolbar
4. Mini Toolbar
5. Creating a Presentation
6. New Presentation
7. Save a Presentation
8. Add Slides
9. Theme
10. Working with Content
11. Enter Text
12. Select Text
13. Copy and Paste
14. Cut and Paste
15. Undo/Redo
16. Spell Check
17. Formatting Text
18. Change Font Typeface and Size
19. Font Styles and Effects
20. Change Text Color
21. WordArt
22. Change Paragraph Alignment
23. Indent Paragraphs
24. Text Direction
25. Adding Content
26. Resize a Textbox
27. Bulleted and Numbered Lists
28. Nested Lists
29. Formatting Lists
30. Adding Video
31. Adding Audio
32. Graphics
33. Adding a Picture
34. Adding ClipArt
35. Editing Picture and ClipArt
36. Adding Shapes
37. Adding SmartArt
38. Tables
39. Create a Table
40. Enter Data in a Table
41. Format a Table
42. Insert a Table from Word or Excel
43. Charts
44. Create a Chart
45. Edit Chart Data
46. Modify a Chart
47. Chart Tools
48. Paste a Chart from Excel
49. Slide Effects
50. Slide Transitions
51. Slide Animation
52. Animation Preview
53. Printing
54. Print a Presentation
55. Package a Presentation

Internet & Microsoft Outlook

1. Introduction to Internet
2. Getting and Using an Email Account
3. Getting an Email account
4. Using an Email account: sending greeting cards and email to one another
5. Online Shopping, Chat and other services
6. MS Outlook
7. How to Set up an new Email account
8. How to Add Email Attachments
9. Set up a Second Outlook Express Account
10. Add a Signature to all outgoing emails
11. Practical Approach