Microsoft Office 2007
- Professionals who need to learn how to be more productive with all five applications that make up Office 2007.
- Employees who want to learn more about using the Microsoft Office 2007 suite of applications.
- Workers and individuals who want to develop the knowledge required to earn the world-famous Microsoft Office Specialist qualification.
- Employees who need to prove their Microsoft Office expertise with an industry-recognised qualification.
- Individuals who would like to improve their productivity skills for work or home.
- Building and using templates and the Styles function to streamline document creation.
- Creating, modifying and sorting tables and columns.
- Using page headers and footers.
- Inserting graphics, symbols and charts.
- Using the Track Changes tools to audit changes made during editing.
- Using Mail Merge tools to create a set of individualised documents (such as addressed letters) in a single file, and repeating the process to print labels and envelopes.
- Utilising academic tools to implement referencing, footnotes and indexes.
- Protecting documents from unauthorised access with encryption and passwords.
- Working with multiple document formats, including PDF files.
- Organising long documents using outline view and inbuilt heading tools.
- Creating forms to collect data.
- Programming advanced functions with macros and XML.
- Create and using a Sparkline to analyse data trends.
- Filtering data to focus only on the information that matters.
- Autosizing columns to fit data and improve visibility.
- Editing and auditing formulae to ensure they continue to generate the required calculations correctly.
- Freezing panes to help better navigate large spreadsheets.
- Using Excel spreadsheet data to create charts.
- Moving and copying cells between sheets.
- Using the VLOOKUP function to locate key data quickly.
- Using Paste Special (Transpose Values) to automate data copying.
- Working with XML Data for use in other applications.
- Mark the Workbook as Final and Read Only to prevent further editing.
- Deleting duplicate records to maintain data integrity.
- How to read, write, edit and send emails.
- How to use address lists to choose message recipients, and mail folders to file emails.
- How to personalise messages with a signature, adding attachments and printing mail.
- Creating, using, sorting and categorising contacts in the Outlook address book.
- Working with rules and junk mail folders to streamline and simplify message management.
- Sending automatic replies, like out of office notices, or requesting read receipts to further simplify messaging.
- Working with the calendar to plan and arrange appointments, and use the address book to inform invitees and confirm attendance.
- Using Notes and Tasks to stay on top of other non-mail related jobs.
- Using the Outlook Journal to track activities and workload.
- Using data import and export functions to back up important information or transfer data between computers.
- How to use personal and public files to share messages and information with other Outlook users.
- Working with text boxes, and formatting text to improve slide appearance.
- Using shapes, object snapping and WordArt Styles to add visual variety.
- Moving and copying slides, or creating slide templates to speed up the creation process.
- Using tables to display data – including tables from other applications like Excel.
- Adding formatted charts to display data visually.
- Using video clips and animated pictures to create additional visual interest.
- Proofing and autocorrection tools to prevent spelling mistakes being left in the final presentation.
- Using themes, format editing and sections to create a consistent “look” for a presentation.
- Applying slide transitions, animation effects and object actions to further improve appearance of the slideshow as a whole.
- Building a slide show and editing the timing to fit with a script and time constraints of the presentation.
- Adding speaker’s notes and comments to the presentation to assist with delivery.
- Understanding table creation and design.
- Finding, editing, sorting and filtering data to highlight key information.
- Building table relationships and enforcing referential integrity to keep data “clean”.
- A basic introduction to functions and using the formula creator.
- Using aggregate functions and totals to simplify calculations.
- Building forms using the forms wizard to simplify data collection and display.
- Using form controls to create a true application interface for the database.
- Building reports, and using calculations and graphics to improve the appearance of data.
- Building macros and assigning actions to form buttons, increasing the functionality of database applications.
- Importing and exporting data.
- Using the SQL language to manipulate data in the database directly.
- Gaining the skills and experience required to be more efficient when using Office 2007 to create documents, capture numerical data, manage communications, build presentations and analyse datasets.
- A marked boost in productivity, allowing Office 2007 users to spend more time on other, more profitable tasks.
- An in-demand skill set that will help learners perform better in their jobs.
- An in-depth understanding of Office 2007 that can be used to provide ad-hoc training to colleagues.
- Microsoft Word 2007 Online Training
- Microsoft Excel 2007 Online Training
- Microsoft Powerpoint 2007 Online Training
- Microsoft Outlook 2007 Online Training
- Microsoft Access 2007 Online Training
Qualification = Certificate of Attendance/Completion/Achievement
Location = online
Duration = Self paced
Course Access = 12 months