Your result

After completing this course:

• You can create a clear overview of your messages, appointments and collaborations in Outlook
• You can automatically apply electronic references and styles in Word
• You can apply advanced functions in Excel files
• You can give dynamic presentations and apply your own themes in PowerPoint

Audience

You want to use the advanced options of Word, Outlook, Excel and PowerPoint. You like to study in a flexible way and want to decide where and when you study.

Approach

With this online course you can study at your own pace, at a time and place that suits you best. You will get started with advanced features of Word. You will learn quickly using professional and English e-learning and associated exercises. With this e-learning you will discover all the ins and outs of Office, including many tips and tricks to work faster and more efficiently with Office. Within the study program you are flexible in which subjects you want to study. Skip topics you already know.

This e-learning course covers the following:

• English spoken video classes
• Exercises in the application itself
• Assessments

Prior knowledge

To take this course it is important that you can operate a computer and know how to open files.

Course material

This course uses a English-language online learning platform with interactive tools and assignments, where specific attention is also paid to tips for independent, online learning.

Content

• Excel Fundamentals
• Introduction to Excel
• Creating, opening and saving a worksheet
• Moving the cell pointer and entering data
• Selecting, copying and moving cells
• Calculations
• Formatting
• Page settings
• Charts
• Excel Advanced
• Absolute and relative references
• Using functions
• Calculating with date and time
• Searching in tables
• Logical and information functions
• Working with text functions
• Conditional formatting
• Links
• Combining data
• Modifying charts
• Using comments
• Sharing a worksheet
• Tracking changes
• Macros
• Group and ungroup data
• Overviews
• Lists
• Tables
• Sorting and filtering
• Deleting double values
• Calculating, viewing and deleting subtotals
• Creating and refreshing a pivot table
• Adjusting numeric fields’ calculations
• Wizard Text to columns
• Word Fundamentals
• Introduction to Word
• Creating, opening and saving documents
• Moving the insertion point and entering text
• Selecting, copying and moving text
• Printing text
• Formatting characters
• Structure of Word
• Working with multiple documents
• Formatting paragraphs
• Text and grammar corrections
• Word Advanced
• Formatting a document
• Borders and shading
• Tables
• Document styles
• Electronic references
• Document navigation and overview
• Illustrations and images
• Draw, SmartArt, chart, screenshot
• Labels and envelopes
• Outlook Fundamentals
• Email
• Email attachments
• Signatures and automatic replies
• Calendar
• Quick steps
• Searching and search options
• Outlook Web Access
• Outlook Advanced
• Email – multiple message options
• Email – search options
• Modifying Outlook
• Additional calendar options
• Using group planning
• Contacts and mail merge
• Notes
• Collaborating via Exchange Server
• PowerPoint Fundamentals
• Using themes and templates
• Views in PowerPoint
• Creating, saving, opening and closing a presentation
• Entering, formatting and changing text
• Adding and formatting tables
• Adding, adjusting and formatting charts
• Adding and formatting SmartArt
• Images, audio and video
• Adding and formatting drawn objects
• Structuring and finishing a presentation
• Playing a slideshow
• PowerPoint Advanced
• Dynamic presentations and animations
• Themes, models and templates