Advanced Certificate in Office Administration

This course includes beginners to advanced skills in using Microsoft Office applications to master office and business communications, complex documents to create proposals, quotes, brochures, using Excel for data, complex calculations and graphs and charts PLUS creating powerful presentations.

Data Entry & Microsoft Office Beginners Training Course

• Microsoft Word Beginners: The screen, non-printing text, editing characters
• Microsoft Word Beginners: Saving, Selecting and formatting
• Microsoft Word Beginners: Page, character and paragraph formatting
• Microsoft Word Beginners: Borders, shading and bullets
• Microsoft Excel Beginners: Selecting, editing and resizing cells & columns
• Microsoft Excel Beginners: Database structures
• Microsoft Excel Beginners: Formulas and functions introduction
• Microsoft Excel Beginners: Formatting and autoformats

See more detail about what is included in the Data Entry & Microsoft Office Beginners Training Course

Office Support & Administration using Microsoft Office

• Microsoft Word Intermediate: Tabs and Tables that Structure Data
• Microsoft Word Intermediate: Headers/Footers, templates and page breaks
• Microsoft Word Intermediate: Customising screen, toolbars/ribbons
• Microsoft Word Intermediate: Symbols, clipart and images
• Microsoft Word Intermediate: Drawing and Graphics
• Microsoft Excel Intermediate: Complex views & printing
• Microsoft Excel Intermediate: Charts & Graphs
• Microsoft Excel Intermediate: Functions and Cell Referencing
• Microsoft PowerPoint: Create and Edit Presentations
• Microsoft PowerPoint: Design templates and complex formatting
• Microsoft Outlook: Email and Meetings
• Microsoft Outlook: Invitations and time management
• Microsoft Outlook: Customer Relationship Management and tasks

See more details about what is included in the Office Support & Administration using Microsoft Office training course package

Advanced Office Certificate Training Course

• Advanced Certificate Microsoft Word: Working with Databases
• Advanced Certificate Microsoft Word: Using Microsoft Word for Complex documents
• Advanced Certificate Microsoft Word: Using Microsoft Word for Corporate Style & Navigation in documents
• Advanced Certificate Microsoft Excel: Databases, filter/sort and Named Ranges
• Advanced Certificate Microsoft Excel: Advanced Formulas, Protecting Cells & Pivot tables and Charts
• Advanced Certificate Microsoft Excel: Goals, Forecasting, Data Consolidation

See more detail about what is included in the Advanced Office Admin Certificate Courses

Microsoft Outlook

Email Management

Many people are familiar with email addresses at the large software companies like gmail (from Google), Yahoo (from Yahoo) and Live or Hotmail (from Microsoft). These email addresses are great for personal use because you can set them up very easily and access them from everywhere but businesses want staff to have an email address at their own domain (like allison @ ezylearn.com.au etc).

Owning the email domain means that companies can control who gets an email address and how that email address is configured.

Calendar and Meetings

Microsoft Outlook training course for calendar and meeting management. Time management is an essential tool for companies and Microsoft Outlook Calendars enable you to schedule meetings, invite participants and write down the topics to be discussed at that meeting. You can also set reminders and other alerts to ensure meeting participants are kept up-to-date about the meeting.

Calendars are also a great way for office admin staff to schedule meetings for sales staff and management when they are out and about and it ensures that staff aren’t double booked and only invited to meetings when they have available time.

Contacts and CRM

Microsoft Outlook training course for contact management and CRM. Although there are now dozens of well know Customer Relationship Management tools to help businesses keep track of the contact details of important customer, suppliers and team members, Microsoft Outlook was and in some cases is the main central database of company contacts. This ensures that all key staff are aware of the contact details for customers.

Microosft Outlook is available as a smart phone app on iOS and Android so managers and sales people can add contacts while they are out of the office and all team members will be able to see those details and work on them at the same time.

Tasks

Microsoft Outlook training course for tasks. Another important aspect of time management and being productive is to clearly define the work tasks that you need to complete and Tasks in Microsoft Outlook is one way to schedule tasks to block out space as well as plan your week/day to achieve the important things.

Industry Connect

The case study in this training package involves you working with multiple Microsoft Office files. You’ll manipulate these files to produce outcomes requested by a manager. Some of these changes relate to merging data and creating a mail merge, formatting a complex long form document including the use of document information fields. You’ll create pivot tables, charts and use complex formulas to create reports for management and display information graphically.

Task include:

• • Merging documents and spreadsheet files
  • Using advanced formatting and data fields in long form complex documents
  • Use Excel spreadsheet data from orders and sales to generate management reports
  • Use Advanced PowerPoint formatting and design to create a professional presentation based on management requirements