COURSE OVERVIEW
MS Office is probably the single most important computer application in the workplace.
Word, Excel, PowerPoint and Outlook are essential tools to anyone working in a business environment.
Not only does the MS Office package enable you to professionally and clearly communicate information, it also allows you to create correspondence, spreadsheets and reports for business presentations and external and internal correspondence.
If you want to save time, enhance your MS Office skills and move from creating standard business documents to creating outstanding documents that will impress both your manager and the rest of your team, then BizTech’s course on “Practical MS Office 2007 Skills” is for you.
The course covers the following key topics:
WORKING EFFICIENTLY IN MICROSOFT EXCEL
• Working with Formulas & Functions
• Creating and using Templates
• All the Shortcuts to save you time
• Creating Effective Charts (Bar Charts, Line, Pie, etc)
• Linking and Embedding Charts and inserting into other office documents
• Working with Databases - Data manipulation, Auto Filtering and Advanced Filters
• Using Scenarios - Allowing for “what if” scenarios
• Pivot Tables - Using Pivot Tables to show information with a different focus
• Labelling, Colouring and Formatting for clarity of display
POWERFUL PRESENTATIONS WITH MICROSOFT POWERPOINT
• Creating master Templates - Design Title and Content Slides
• Create Custom Animation and Transition Slides
• Creating Charts, Linking and Embedding from Excel
• Working with Tables, Graphics and Charts
• Using built in Diagrams and Organograms
CREATING PROFESSIONAL DOCUMENTS WITH MICROSOFT WORD
• Headings and Styles to enable Auto Formatting
• Using Section Breaks for different Formatting Styles
• Automatic Inclusion of Tables of Content
• Complex Reports and Contracts
• Time Sheets, Calendars & Schedules
• Forms, Newsletters, Invitations, Brochures & Adverts
• Letterheads and Fax Cover Pages
• Mail Merge, Auto Text & Auto correct
• Including Graphics such as Charts, Pictures and Diagrams
• Using Watermarks for Drafts or Confidentiality
• Managing complex Tables and Table Data
ESSENTIAL MS OUTLOOK SKILLS
• Flag and Categorise e-mails
• Using signatures and stationery
• Creating, updating and tracking tasks
• Use the notes function effectively
• Arranging messages and applying rules
• Creating a message in HTML mail format and inserting a hyperlink
WHO SHOULD ATTEND
• Anyone wanting to increase their productivity
• Anyone aiming to outperform their peers and co workers
• Executive Assistants and Secretaries
• Personal Assistants and Office Administrators
• Anyone else who wishes to learn MS Office 2007 features
OUTCOMES:
• Format Excel, Word, PowerPoint and Outlook with ease and speed
• Apply complex functions to make documents more professional and easier to work with
• Produce professional documents your organisation can be proud to send out
• Select the most appropriate MS Office application for each project