Microsoft Office 2016 Online Bundle, 3 Courses

Learn To Use The Basic Features Of Three Of The Most Fundamental Software Programs Used In Educational And Professional Settings

Microsoft Office 2016 Online Bundle, 3 Courses

NOW ONLY

US$539

Save US$1261 (70%)
OFF RRP US$1800
Get Info Pack

Get Introduction to Microsoft Word 2016, Introduction to Microsoft Excel 2016, Introduction to Microsoft PowerPoint 2016 in this Bundle

1. Introduction to Microsoft Word 2016 : Gain the foundational skills you need to make the most of this powerful program

One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016 (now available through Office 365). In this course, you'll gain the foundational skills you need to make the most of this powerful program.

Through hands-on instructions, you'll learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously, and format your text. You'll also see how to save, retrieve, copy, organize, and print your documents.

You'll learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.

By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You'll also explore the program's thesaurus feature, which can help you find precisely the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be able to use Word confidently at home or on the job.

2. Introduction to Microsoft Excel 2016 : Learn Excel in this fun, step-by-step online course

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.  

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.  

In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.

This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.

3. Introduction to Microsoft PowerPoint 2016 : Take your PowerPoint presentations from ordinary to extraordinary 

In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll start by learning how to plan and create dazzling slide presentations using a variety of slide and layout masters that make global changes to your presentation in a snap. You'll also see how to embellish your slides with pictures, shapes, WordArt, and SmartArt, as well as multimedia effects such as animations, slide transitions, audio, video, and text and object hyperlinks.

And that's just the start! You'll explore the options on the PowerPoint Ribbon, including the new Tell Me feature (an enhanced Help feature) and Smart Lookup, which allows you to look up definitions of a word or phrase. You'll explore the File menu options and Backstage View, and learn how to print slides, handouts, and even an outline. And you'll discover the best view for creating and editing your slides and running your presentations, including how to use Reading View to proof your work. 

You'll have fun creating a PowerPoint photo album with your digital pictures, and become acquainted with OneDrive and PowerPoint Online to save, edit, and share your presentations online. Finally, you'll add versatility to your PowerPoint skills as you learn how to use the Share and Export commands to save presentations as PDF files, videos, and more.

Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  2. Instructors lead each course and you will be able to interact with them and ask questions
  3. You can study from home or at work at your own pace in your own time
  4. You can download printer friendly course material or save for viewing off line
  5. You will be awarded a certificate at completion of this course

How to study online course?

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete each course receive a certificate of completion per course, with a passing score (for the online assessment) and will be issued a certificate via email.

The 3 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Introduction to Microsoft Word 2016

Lesson 01 - Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2016's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Lesson 02 - Typing and Navigation 

The whole purpose of Word is to let you create and edit text, so in this lesson, we'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

Lesson 03 - File Management

In today's lesson, you're going to learn how to save the documents you create in Word. We'll go over how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so you'll always be in complete control of all the files you create.

Lesson 04 - Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Lesson 05 - Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Lesson 06 - Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Lesson 07 - Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Lesson 08 - Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Lesson 09 - Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Lesson 10 - Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Lesson 11 - Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Lesson 12 - Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

Course 2 - Introduction to Microsoft Excel 2016

Lesson 01 - Excel Basics

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Lesson 02 - Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Lesson 03 - Time-Savers

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Lesson 04 - Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Lesson 05 - 3-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Lesson 06 - Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Lesson 07 - Charting Basics

In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 08 - Advanced Charting Techniques

Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Lesson 09 - Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Lesson 10 - Financial Functions

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Lesson 11 - Worksheet Automation

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Lesson 12 - Mastering Excel's IF Function

I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Course 3 - Introduction to Microsoft PowerPoint 2016

Lesson 01 - The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program. And you'll practice working with different views, task panes, tabs, and templates.

Lesson 02 - Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. We'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature, and we'll discuss how to save a file so you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, we'll go over the ways to put on a slide show. Important stuff in Lesson 2!

Lesson 03 - Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. I'll also show you multiple ways to open a presentation. Then, I'll teach you how to preserve different versions of your work by saving with different filenames.

Lesson 04 - Creating and Printing Error-free Presentations

Today we'll cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! And to make sure your printed presentation is as close to perfect as it can be, we'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Lesson 05 - Working With Saved and Online Images

We're going to switch gears in this lesson and work with images instead of text, which I think you'll enjoy. I'll show you how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

Lesson 06 - WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which I think you'll find exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create. And you'll add visual sophistication to your text with SmartArt Graphics.

Lesson 07 - Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! But if you don't enjoy math, that's okay—I'll walk you through everything you need to know and do to create a chart slide. I'll also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Lesson 08 - Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. Today we'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Lesson 09 - Creating Links

In this lesson, we'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and Web pages. You can even add sounds and 3-D effects if you want!

Lesson 10 - Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll also find out how to add sound effects, such as chimes and whooshes, to slide transitions. And perhaps most important, you'll learn how to avoid overdoing these effects!

Lesson 11 - Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Lesson 12 - Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, we'll focus on different ways to save and share them. You'll see how easy it is to make your presentation into a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online. And you'll turn your presentation into a video.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Get Introduction to Microsoft Word 2016, Introduction to Microsoft Excel 2016, Introduction to Microsoft PowerPoint 2016 in this Bundle

1. Introduction to Microsoft Word 2016 : Gain the foundational skills you need to make the most of this powerful program

One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016 (now available through Office 365). In this course, you'll gain the foundational skills you need to make the most of this powerful program.

Through hands-on instructions, you'll learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously, and format your text. You'll also see how to save, retrieve, copy, organize, and print your documents.

You'll learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.

By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You'll also explore the program's thesaurus feature, which can help you find precisely the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be able to use Word confidently at home or on the job.

2. Introduction to Microsoft Excel 2016 : Learn Excel in this fun, step-by-step online course

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.  

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.  

In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.

This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.

3. Introduction to Microsoft PowerPoint 2016 : Take your PowerPoint presentations from ordinary to extraordinary 

In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

You'll start by learning how to plan and create dazzling slide presentations using a variety of slide and layout masters that make global changes to your presentation in a snap. You'll also see how to embellish your slides with pictures, shapes, WordArt, and SmartArt, as well as multimedia effects such as animations, slide transitions, audio, video, and text and object hyperlinks.

And that's just the start! You'll explore the options on the PowerPoint Ribbon, including the new Tell Me feature (an enhanced Help feature) and Smart Lookup, which allows you to look up definitions of a word or phrase. You'll explore the File menu options and Backstage View, and learn how to print slides, handouts, and even an outline. And you'll discover the best view for creating and editing your slides and running your presentations, including how to use Reading View to proof your work. 

You'll have fun creating a PowerPoint photo album with your digital pictures, and become acquainted with OneDrive and PowerPoint Online to save, edit, and share your presentations online. Finally, you'll add versatility to your PowerPoint skills as you learn how to use the Share and Export commands to save presentations as PDF files, videos, and more.

Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. This course is delivered 100% on-line and is accessible 24/7 from any computer or smartphone
  2. Instructors lead each course and you will be able to interact with them and ask questions
  3. You can study from home or at work at your own pace in your own time
  4. You can download printer friendly course material or save for viewing off line
  5. You will be awarded a certificate at completion of this course

How to study online course?

Upon enrolment an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. New courses start every month to ensure that we have the correct ratio of students to tutors available, please ensure you select a starting date when you go through our shopping cart, at checkout. The course is easy to follow and understand.

Recognition & Accreditation

All students who complete each course receive a certificate of completion per course, with a passing score (for the online assessment) and will be issued a certificate via email.

The 3 Course Bundle includes the following courses, below is a summary of each course: 

Course 1 - Introduction to Microsoft Word 2016

Lesson 01 - Getting Started

In this introductory lesson, you'll learn how to use the different parts of Word 2016's user interface, how to look at your document in different types of views, how to zoom in and out to magnify or shrink your text, and how to change the margins of individual paragraphs.

Lesson 02 - Typing and Navigation 

The whole purpose of Word is to let you create and edit text, so in this lesson, we'll go over the basics of moving the Insertion Pointer, or Cursor, and deleting text. Pressing the BACKSPACE and DELETE keys can delete text one character at a time. The keyboard lets you move the cursor one character, one word, or one line at a time. The mouse lets you quickly move the cursor and scroll through large documents far faster than the keyboard. By knowing the pros and cons of navigating through a document with the keyboard and mouse, you can use both to help you work faster in Word.

Lesson 03 - File Management

In today's lesson, you're going to learn how to save the documents you create in Word. We'll go over how to save documents with unique names, as well as in other formats so that you can share your documents with people using different word processors or even different computers. Finally, you'll learn how to rename, copy, and even delete any files you've created so you'll always be in complete control of all the files you create.

Lesson 04 - Editing Text

After you've typed some text in a Word document, you may need to edit that text. The easiest way to edit is to delete individual characters using the BACKSPACE or DELETE keys. Another option is using Word's Overtype mode by typing over text you no longer need. If you ever delete anything by mistake, don't panic! Word's handy Undo and Redo commands retrieve unintentionally deleted text. You may also want to delete large chunks of text. Use your keyboard or mouse in tandem with the BACKSPACE or DELETE keys to efficiently remove entire sections of text. By learning how to delete text and undo mistakes, you can edit your documents quickly using Word.

Lesson 05 - Working With Multiple Documents

Most people use Word to view and edit a single document at a time, but Word actually lets you open and view two or more documents at the same time. This can be handy for copying text from one document to another, comparing two different drafts of the same document, or simply using one document as a reference while writing in the second one. By learning how to open, switch between, and view multiple documents, you can increase your productivity with Word.

Lesson 06 - Text Formatting and Alignment

Once you know how to add, delete, copy, and move text, the next step to modifying your document is to change the physical appearance of your text. You can make text appear in different colors or background highlighting, change the actual size of text, alter the alignment of text, and even choose different fonts to modify the way individual letters look. As you can see, Word provides plenty of ways to help you both edit text and change it so it looks visually appealing.

Lesson 07 - Printing

Most people use Word to print letters and reports. But Word also helps you get creative by letting you choose different paper sizes and orientations. For example, you can print a letter in portrait orientation or print a sign in landscape orientation. Just think of turning a page up so its height is taller than its width (portrait orientation) or turning the page on its side so its width is wider than its height (landscape orientation). Word also lets you choose to print on different paper sizes, such as envelopes, just as long as you can run those odd-shaped paper sheets in your printer. With Word's ability to print on different types of paper sizes and orientation, you can create more than just typical documents using Word.

Lesson 08 - Margins, Tabs, and Page Numbering

Most of the time when you create a document, you can use the default page settings. But sometimes you may want to modify those settings to change margins around a page to give you more (or less) space on the top, bottom, left, or right sides of a page. By knowing how to set and use margins, you can modify an entire document or just a single page. By using tabs, you can modify how individual paragraphs look on a page. Finally, you'll also learn how to add page numbers to the top or bottom of a page to keep track of the right page order when you print out your document.

Lesson 09 - Paragraph Formatting

Word can be handy for typing and formatting text, but once you've written several paragraphs worth of text, you may need to format individual paragraphs separately from the rest of your document. Word provides ways to change the appearance of a paragraph's first line, line spacing within a paragraph, and line spacing between paragraphs. In addition, Word lets you create bullet and numbered lists so you can display short bits of information in a visual manner. With Word's various paragraph-formatting options, you can customize the appearance of all your paragraphs.

Lesson 10 - Language Tools

It's not enough just to write and format your text. After you're done writing, you may need to check your spelling, change your words, and even hyphenate your text to make your entire document look the best it can. For important documents, you may even need to collaborate with others. To keep track of all the changes multiple authors may make to a single document, Word offers a Track Changes feature so you can see exactly what and who changed the document. With so many ways to polish your document, there's no reason not to write exactly what you want to say with Word.

Lesson 11 - Customizing Word

Word can easily handle any characters you type with a keyboard, but sometimes you may need to type an occasional foreign language character, a mathematical symbol, or another unusual character that doesn't appear on your keyboard. With Word, you can press different types of keystrokes or search and click the symbol you want to use. This lets you add practically any type of unusual character to your documents, even smiley faces. You probably won't need to type all of these characters regularly, so just find the ones you'll likely need and remember how to use them. Word lets you type practically anything you want, regardless of the limitation of the keys on your keyboard.

Lesson 12 - Making a Word Document Pretty and Organized

Writing involves more than just typing and editing text. With Word's advanced features, you can insert page breaks and cover pages to adjust how your text appears when you print it out. To make text on each page look its best, you can use drop caps and styles. Finally, you can use outlines to organize your text and quickly move chunks of text within a document just by rearranging an outline heading. By learning these advanced features of Word, you can make each document display text in the most appealing way possible.

Course 2 - Introduction to Microsoft Excel 2016

Lesson 01 - Excel Basics

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

Lesson 02 - Creating a Worksheet

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Lesson 03 - Time-Savers

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Lesson 04 - Relative, Absolute, Mixed, and Circular References

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Lesson 05 - 3-Dimensional Workbooks

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

Lesson 06 - Sorting, Subtotaling, and Filtering

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Lesson 07 - Charting Basics

In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 08 - Advanced Charting Techniques

Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Lesson 09 - Intro to Excel's Statistical Functions

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

Lesson 10 - Financial Functions

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Lesson 11 - Worksheet Automation

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

Lesson 12 - Mastering Excel's IF Function

I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Course 3 - Introduction to Microsoft PowerPoint 2016

Lesson 01 - The PowerPoint 2016 Interface

Come explore the basic features of Microsoft PowerPoint 2016! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll find out how to plan a presentation and start the PowerPoint program. And you'll practice working with different views, task panes, tabs, and templates.

Lesson 02 - Creating Presentations

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. We'll start by choosing a theme for the presentation and create slides with a variety of slide layouts. You'll find out about the Live Preview feature, and we'll discuss how to save a file so you can find it later. You'll also create and edit slides in the slide pane and in Outline view. Finally, we'll go over the ways to put on a slide show. Important stuff in Lesson 2!

Lesson 03 - Creating and Editing Tables and Opening and Saving Files

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and format tables. I'll also show you multiple ways to open a presentation. Then, I'll teach you how to preserve different versions of your work by saving with different filenames.

Lesson 04 - Creating and Printing Error-free Presentations

Today we'll cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! And to make sure your printed presentation is as close to perfect as it can be, we'll explore the Spelling, AutoCorrect, and Thesaurus features, along with the new Smart Lookup feature.

Lesson 05 - Working With Saved and Online Images

We're going to switch gears in this lesson and work with images instead of text, which I think you'll enjoy. I'll show you how to embellish your slides with media clips, which could include illustrations, clip art, and photographs. You'll even learn how to download an image from a website and insert the image on a slide.

Lesson 06 - WordArt, Shapes, and SmartArt

You're going to work with WordArt, Shapes, and SmartArt Graphics in this lesson, which I think you'll find exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the objects you create. And you'll add visual sophistication to your text with SmartArt Graphics.

Lesson 07 - Creating and Editing a Chart

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! But if you don't enjoy math, that's okay—I'll walk you through everything you need to know and do to create a chart slide. I'll also show you how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart formatting buttons.

Lesson 08 - Making Global Changes to a Presentation

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. Today we'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the slide master. You'll also make global changes when you modify your presentation's theme colors or background.

Lesson 09 - Creating Links

In this lesson, we'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and Web pages. You can even add sounds and 3-D effects if you want!

Lesson 10 - Applying Animation to Slides, Text, and Objects

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, the options on the Transition tab, and you'll apply animation to text and objects on slides and the slide or layout master with the options on the Animations tab. You'll also find out how to add sound effects, such as chimes and whooshes, to slide transitions. And perhaps most important, you'll learn how to avoid overdoing these effects!

Lesson 11 - Applying Advanced Animation Effects to Text and Objects

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on slides and slide and layout masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add an audio clip to your presentation.

Lesson 12 - Sharing and Saving Your Presentations, Including OneDrive and Office Online

Now that you know so much about creating PowerPoint presentations, we'll focus on different ways to save and share them. You'll see how easy it is to make your presentation into a PDF file, so it'll be accessible on computers that don't have PowerPoint 2016. You'll learn to open, edit, and share your presentation online with a Windows OneDrive account and PowerPoint Online. And you'll turn your presentation into a video.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$539 Save US$1261 (70%)
OFF RRP US$1800
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 007MSOF163CB
Delivery Mode: Online
Course Access: 6-8 Weeks Per Course
Time required: 72 hours
Assessments: Yes
Qualification: Certificate of Completion

Start Dates

This course is available to begin on the following dates

  • 11 September
  • 16 October
  • 13 November
  • 11 December

Popular Courses and Bundles

Get a FREE Career Planner