Microsoft Office Training at at Birmingham Graduate School, UK

BGS’s Microsoft Experienced and Qualified trainers deliver in campus and on-site training courses for Microsoft Word, Microsoft Power Point, Microsoft Excel, Microsoft Access and Microsoft Outlook.

MS Word 2007

Creating and Customizing Documents
• Introduction to Word
• Create and format documents.
• Lay out documents.
• Make documents and content easier to find.
• Personalize Office Word 2007.

Formatting Content
• Format text and paragraphs.
• Manipulate text.
• Control pagination.

Working with Visual Content
• Insert illustrations.
• Format illustrations.
• Format text graphically.
• Insert and modify text boxes.

Organizing Content
• Structure content by using Quick Parts.
• Use tables and lists to organize content.
• Modify tables.
• Insert and format references and captions.
• Merge documents and data sources.

Reviewing Documents
• Navigate documents.
• Compare and merge document versions.
• Manage tracked changes.
• Insert, modify, and delete comments.

Sharing and Securing Content
• Prepare documents for sharing.
• Control document access.
• Attach digital signatures.


MS Power Point 2007

Creating and Formatting Presentations
• Introduction to Power Point
• Create new presentations.
• Customize slide masters.
• Add elements to slide masters.
• Create and change presentation elements.
• Arrange slides.

Creating and Formatting Slide Content
• Insert and format text boxes.
• Manipulate text.
• Add and link existing content to presentations.
• Apply, customize, modify, and remove animations

Working with Visual Content
• Create SmartArt diagrams.
• Modify SmartArt diagrams.
• Insert illustrations and shapes.
• Modify illustrations.
• Arrange illustrations and other content.
• Insert and modify charts.
• Insert and modify tables.

Collaborating on and Delivering Presentations
• Review presentations.
• Protect presentations.
• Secure and share presentations.
• Prepare printed materials.
• Prepare for and rehearse presentation delivery.


MS Excel 2007

Creating and Manipulating Data
• Introduction to Excel
• Insert data by using AutoFill.
• Ensure data integrity.
• Modify cell contents and formats.
• Change worksheet views.
• Manage worksheets.

Formatting Data and Content
• Format worksheets.
• Insert and modify rows and columns.
• Format cells and cell content.
• Format data as a table.

Creating and Modifying Formulas
• Reference data in formulas.
• Summarize data by using a formula.
• Summarize data by using subtotals.
• Conditionally summarize data by using a formula.
• Look up data by using a formula.
• Use conditional logic in a formula.
• Format or modify text by using formulas.
• Display and print formulas.

Presenting Data Visually
• Create and format charts.
• Modify charts.
• Apply conditional formatting.
• Insert and modify illustrations.
• Outline data.
• Sort and filter data.

Collaborating on and Securing Data
• Manage changes to workbooks.
• Protect and share workbooks.
• Prepare workbooks for distribution.
• Save workbooks.
• Set print options for printing data, worksheets, and workbooks.

MS Access 2007

Fundamentals of MS Access
• Introduction to MS Access
• Starting Access and Opening a Database
• Understanding the Access Program Screen
• Using Menus Using Toolbars and Creating a New Workbook
• Filling Out Dialog Boxes
• Keystroke and Right Mouse Button Shortcuts
• Opening and Modifying Database Objects
• Working with Multiple Windows
• Tour of a Table
• Adding, Editing, and Deleting Records
• Tour of a Form
• Tour of a Query
• Tour of a Report
• Previewing and Printing a Database Object
• Selecting Data Cutting, Copying, and Pasting Data
• Using Undo
• Checking Your Spelling
• Getting Help from the Office Assistant
• Changing the Office Assistant and Using the "What's This" Button
• Using the Zoom Box
• Closing a Database and Exiting Access

Advanced Database 
Creating and Working with a Database
• Finding, Filtering, and Formatting Data
• Working with Tables and Fields

MS Outlook 2007

Managing Messaging
• Introduction to Outlook
• Create and send an e-mail message.
• Create and manage your signature and automated messages.
• Manage e-mail message attachments.
• Configure e-mail message sensitivity and importance settings.
• Configure e-mail message security settings.
• Configure e-mail message delivery options.
• View e-mail messages.

Managing Scheduling
• Create appointments, meetings, and events.
• Send meeting requests.
• Update, cancel, and respond to meeting requests.
• Customize calendar settings.
• Share your calendar with others.
• View other calendars.

Managing Tasks
• Create, modify, and mark tasks as complete.
• Accept, decline, assign, update, and respond to tasks.

Managing Contacts and Personal Contact Information
• Create and modify contacts.
• Edit and use an electronic business card.
• Create and modify distribution lists.
• Create a secondary address book.

Organizing Information
• Categorize Office Outlook 2007 items by colour.
• Create and manage Office Outlook 2007 data files.
• Organize mail folders.
• Locate Office Outlook 2007 items by using Search.
• Create, modify, and remove rules to manage e-mail messages.
• Customize your Office Outlook 2007 experience