Microsoft Office Course: Essentials
Microsoft Office. All the office productivity tools you need.
Learn Microsoft Office the smart way with Microsoft Office courses at CCE, The University of Sydney.
This short course will allow you to become productive by acquiring a basic understanding of Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook and learn to share data between these applications.
Upon completion of this short course, you should be able to:
- Minimise, maximise, move and resize windows.
- Start Microsoft Office applications and work with the Microsoft Office interface.
- Create documents in Microsoft Word.
- Create workbooks in Microsoft Excel.
- Create presentations in Microsoft PowerPoint.
- Access and work with calendars in Microsoft Outlook.
- Work with and use contacts in Microsoft Outlook.
- Work with and use tasks in Microsoft Outlook.
- Share data between Microsoft Office applications.
This short course covers the following topics:
At Home in Microsoft Office
- Understanding Microsoft Office.
- Starting Microsoft Office Applications.
- A Typical Application Screen.
- Working With Screen Features.
- Understanding Dialog Boxes.
- Launching Dialog Boxes.
- The Office Button.
- Understanding How Help Works.
- Accessing The Help Window.
- Browsing For Help.
- Returning To The Home Page.
- Using The Help Table Of Contents.
- Other Sources Of Help.
- Exiting From Microsoft Office Applications.
- At Home In Microsoft Office Quick Reference.
Word Processing in Microsoft Word
- Understanding Word Processing.
- Creating Documents In Word.
- Starting Microsoft Word.
- Using The Blank Document Template.
- Typing Text Into A Document.
- Saving Your New Document.
- Typing Numbers Into Your Document.
- Inserting A Date Into Your Document.
- Making Basic Changes To Your Document.
- Checking The Spelling In Your Document.
- Saving Changes To An Existing Document.
- Printing Your Document.
- Safely Closing Your Document.
- Word Processing Quick Reference.
Spreadsheets in Microsoft Excel
- How Spreadsheets Work.
- Spreadsheet Functionality.
- Starting Microsoft Excel.
- Understanding Workbooks.
- Using The Blank Workbook Template.
- Typing Text Into A Worksheet.
- Saving Your New Workbook.
- Typing Numbers Into A Worksheet.
- Typing Simple Formulas In a Worksheet.
- Easy Formulas.
- Typing Dates In A Worksheet.
- Easy Formatting.
- Checking Spelling In A Worksheet.
- Making And Saving Changes.
- Printing A Worksheet.
- Charting Your Data.
- Safely Closing A Workbook.
- Spreadsheets Quick Reference.
Presentations in Microsoft PowerPoint
- Understanding Electronic Presentations.
- Starting Microsoft PowerPoint.
- The PowerPoint Screen.
- Creating A New Presentation.
- Adding Text To Your Presentation.
- Saving Your New Presentation.
- Adding More Slides Using The Ribbon.
- Typing Directly Into A Slide.
- Inserting Clip Art Images.
- Safely Closing A Presentation.
- Opening An Existing Presentation.
- Running A Presentation Slide Show.
- Printing Audience Handouts.
- Presentations Quick Reference.
Calendars in Microsoft Outlook
- Understanding Outlook.
- Starting Outlook.
- Common Outlook screen Elements.
- Accessing The Calendar.
- Changing Calendar Components.
- Displaying Specific Dates.
- Navigating Within A Calendar.
- Scheduling An Appointment Using Click To Add.
- Scheduling Using The Appointment Window.
- Creating Recurring Appointments.
- Scheduling An Event.
- Printing Your Calendar.
- Calendars Quick Reference.
Contacts in Microsoft Outlook
- Understanding The Contact Form.
- Understanding Electronic Business Cards.
- Viewing Your Contacts.
- Creating A New Contact.
- Entering Contact Details.
- Deleting An Unwanted Contact.
- Printing Contact Details.
- Contacts Quick Reference.
Tasks in Microsoft Outlook
- Viewing Tasks.
- Creating Simple Tasks.
- Typing Tasks Directly.
- Changing Task Views.
- Sorting Tasks.
- Completing Tasks.
- Deleting Tasks.
- Printing A Task List.
- Tasks Quick Reference.
Sharing Data between Microsoft Office Applications
- Understanding Data Sharing.
- Opening Files In The Documents Window.
- Using Copy And Paste.
- Capturing The Screen.
- Drag And Drop Moving.
- Right Dragging.
- Object Embedding.
- Updating An Embedded Object.
- Object Linking.
- Updating A Linked Source.
- Sharing Data Quick Reference.
This short course is conducted using Microsoft Office and Microsoft Windows. Due to the comparative complexity of each application in the Microsoft Office suite, the time spent on each application will not necessarily be equal and will also be guided by student needs.
You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.
- Free repeat class - Conditions apply
- Free USB flash drive
- Expert trainer
- Dedicated computer for every student
- Small class size
- Student notes – yours to keep
- Certificate of completion
What others say.
An excellent tutor who was attentive, knew the material extremely well and was humorous! I feel really motivated to continue learning and would love to enrol in more courses run by this tutor.
Course was very informative and I have come away with many new skills. Tutor was fantastic, course flowed very well and we even had a few laughs.
Great tutor who kept the perfect pace. Wish I could afford to go on many more of these courses! I’m now feeling confident and I will be back for more in time. If everyone could be trained by this tutor Sydney would be a better business centre.
I have found both courses I have been on so far very enjoyable and have learnt a lot and am looking at booking the Excel one day course. I did the computer basics and the one up from that with the same tutor and I found that I actually took in the information.... I know I have a long way to go with computers but I am willing to spend the money for these courses as they are helpful.
An excellent tutor and I’m delighted to have gained so many shortcut options after years of the same old habits. The course provided a well rounded overview of Office.
This course was excellent. Really interesting, well paced and presenter very clear and knowledgeable.
I found this course to be very informative and just what I needed to improve my skillls and increase my knowledge of computers and how to navigate. I would recommend this to my friends and workplace.
The tutor is a wonderful educator who makes sure everyone in the class understands. The teaching technique and the knowledge is second to none.
I was a little intimidated as I was concerned the course content may have been pitched above my level. Our tutor soon alleviated those concerns with his consultative, personalised and professional style. Nobody appeared to be left behind; and I certainly feel more confident as I start to put those skills into action. Certainly encouraged me to continue to expand my studies.
I thoroughly enjoyed the course and can put those skills to practice now. The tutor was fantastic and was patient and precise in teaching us.
The tutor for this course is great. I was especially impressed with the so-called computer “magic tricks”. Highly recommended.
Rarely does a short course teach you what it claims to in the description. This course was excellent, mainly due to the trainers knowledge and teaching method.
A great teacher, able to explain course material in a very practical way. Highly recommend your courses to others.