Practical MS Office 2007 & 2010 Skills

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 & 2010 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 & 2010 features

outcomes

take home tools

• Training Manual & CD

• All delegates receive one month of telephonic support relating to course content

general

COURSE DURATION

The course will take place over 3 days - 08:30 to 16:30 daily

COURSE FEES

R8 950.00 (excl. VAT) per delegate
(5% discount for enrolment 2 weeks prior to course date.)

REGISTRATION DEADLINE

Registration Confirmation must be sent prior to the start of the scheduled course.

the venue

The course will take place at the AstroTech Conference Centre in Parktown, Johannesburg. 

The AstroTech Conference centre is in a gracious mansion in one of the most historic and beautiful areas of Johannesburg.

It is a high-end business focused conference centre with competitively priced packages, excellent facilities and top client service.

Close to major highways, airport and Johannesburg city centre, this state-of-the-art venue offers elegance, discretion, security and convenience with safe parking.

Course venues will be confirmed prior to course commencement.
 

bbbee compliance

BizTech is BBBEE Level 1 compliant. This means that we are a 135% contributor and companies investing money in training their staff through BizTech can also improve their own BBBEE scorecard. Not only does it offer an opportunity to improve your company's Skills Development BBBEE category, but you can also improve your BBBEE Preferential Procurement category. In each case your company will benefit 135% of the spend made.