Course Information
Course Overview
The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes.
Master the Ins and Outs of Microsoft Office 2016
- Spreadsheets with Excel 2016
- Documents with Word 2016
- Presentations with PowerPoint 2016
The course is designed for individuals and office professionals who
need to master the capabilities of the latest edition of Microsoft
Office.
Through 21 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:
- Microsoft Excel 2016 for Beginners: Master the Essentials: Create basic spreadsheets and use formulas for tracking expenses.
- Learn Microsoft Word 2016 For Beginners - Basics to Advanced: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.
- Master Microsoft PowerPoint 2016 the Easy Way: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.
Details:
Master Excel 2016 For Complete Beginners In This Helpful, Info-Packed Video Course
- Easily learn Excel 2016 for complete beginners
- How to get Excel and installation requirements
- Helpful discussion of new features in 2016
- Getting started with a Workbook
- Entering and editing data
- Creating charts and graphs
- How to create functions
- Protecting and securing your data
- All lessons in easy step-by-step format
- Practice with included exercise files
Excel 2016 From The Beginning
This course assumes you've never worked with Microsoft Excel in your
life, or you are upgrading from a previous version. Your professional
trainer will start you from the very beginning from installing the
program to creating your first Workbook and entering data. Before you
know it, you're using Excel 2016 like a pro with advanced functions. You will have the expertise you need to impress the boss at work. You can
also use this essential application to accomplish all kinds of tasks for your personal life or business.
If most Excel courses seem to be designed for people who already have experience with the program, this course will be a breath of fresh air. The videos keep things simple and carefully step you through each
process.
Contents and Overview
This course starts with where to find Microsoft Excel and installing
the program. Then you learn step-by-step, simple 1-2-3 methods for
getting up and running with Excel 2016. Watch just the first few videos
to have a basic knowledge of Excel. Then continue through the detailed
32 chapters of video lessons and 9 exercise files to gradually become a
proficient user.
It's important to note that we don't assume you know anything about
Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.
Then we show you how to personalize Excel for your own use with
exciting Excel Options. We discuss all the Ribbons and Toolbars,
entering and editing data, backup and recovery, fill and series, and
printing your projects. We also work with formulas, functions, sorting
and filtering data, creating charts and graphs, and much more.
Upon completion of this course you will know the essentials of Microsoft Excel 2016.
Become a Word 2016 power user. We start at the very beginning progressing with more than 80 helpful videos.
All you need for work, hobbies, and running your own business. Feel confident with every aspect of Word 2016.
- Practice exercises provided to practice what you learned
- Designed to help beginners get started
- Lessons start right at the very beginning
- Progresses slowly with more than 80 helpful videos
- A big 6 hours of expert instruction
- Learn what's new in Word 2016
- Master the most common uses of Word
- Learn to create many types of documents
- Use the full palette of functions
- Experienced users can fill in gaps in knowledge
- Work faster with better results and greater confidence
- Discover how to use mail merge
Now you can learn Word 2016 from the very beginning. Beautifully
designed for beginners to get a great start while helping more
experienced users fill in any gaps in their knowledge. You enjoy more
than 80 expert tutorial videos that clearly show you how to accomplish
every aspect of Word.
Learn what's new in 2016. Now you can be up to date in order to be a
true Word power user. With 6 hours of expert instruction, you have an
opportunity to cover every inch of Word 2016.
This course is just what you want for being confident with Word in
the workplace. Also gives you everything you need to know for personal
use, hobbies, non-profit volunteering, or running your own business.
The self-learning video format lets you study on your own schedule.
Watch videos as you have time, then come back to learn more later.
Now you can become a master at using one of the world's most popular computer applications – Microsoft Word.
Contents and Overview
Learn Microsoft Word 2016 For Beginners starts with what is
new in this latest version. If you already know Word, this can help you
get up to speed with 2016 right away. Next we start with a blank
document and learn how to create spacing, character choices, save,
editing, search and replace, and much more.
Chapter 3 goes into character formatting including cut, copy and
paste, auto-correction options, and format painter. We also learn about
working with numbers, bullets, and creating an outline.
Then the course covers paragraph formatting, managing lists, and all
aspects of creating tables. Because you want your pages to look good, we teach how to control page appearance, sectioning, and all about using
graphics.
Learn how to print envelopes, mail merge, along with a practice
exercise. These practice opportunities come at the end of each module.
Finally, the course covers using the Thesaurus, spell check,
comments, margins, printing and much more. You will also learn about
time and effort saving Macros that let you speed through assignments and projects.
Discover the Powerful Features of PowerPoint 2016
- Have complete control over your presentation's information
- Now have professional presentations for job or project
- Quickly create top-notch visuals for your audiences
- Feel confident and show off your new powerful slides
- Get all of the new tools to master presentation management
- Effortlessly add text, graphics, audio, video, charts, tables and SmartArt to your slides
- 6 hours of professional video with over 70 individual lessons that make everything clearer and easy to remember
- Practice what you learned with included exercise files
Use This New Course to Easily Create Beautiful Presentations
PowerPoint 2016 is by far the most popular presentation program in
the world as it allows users to create, edit, and show illustrative
presentations with the help of attention-grabbing slides. This crash
course explains how you can combine the text, 3-D graphics, and
multi-media to support your presentation-making needs. Using PowerPoint
as a presentation tool is the way to go.
Do you need some visual impact? Well, look no further. Because this
course can show you how to take this program and make it do just that.
In fact, making your presentation more interesting through the use of
multi-media can only help improve your audience's focus. PowerPoint 2016 allows you to use your choice of images, audio clips, and videos to
help you get your points across. These important sound effects and
visual cues can also help a presenter like yourself, be more
improvisational, and interactive, all of which is a very beneficial
thing. This course essentially shows you why PowerPoint 2016 is the best and most complete presentation package available. It gives you 80
individual video tutorials that are quite in-depth. It also has exercise files so that you can practice the lessons you've learned.
Everything you need is here so that you can learn how to produce a
nice and professional-looking presentation. Once everything is finished, you can begin to prepare your talk. In fact, even if it went well but
someone missed your presentation, you could still have them view it
online at a time that's convenient for them. Simply upload your
presentation to YouTube with everything featured in your work, including all of the slides, commentary, and transitions.
So, whether you need processing, outlining, drawing, graphing, or
more elaborate presentation management tools - it's all covered in this
easy-to-understand course. You can not only create and modify your own
presentations, but gain mastery on it eventually, too. All that is
needed on your part is a little practice.
Overview and Contents
PowerPoint 2016 can be used in a number of different yet effective
ways to communicate with your audience. Slides are completely
customizable. Depending on your approach, you may want to have a
presentation that's text-heavy, image-heavy, or some combination of
both. Combining the two tends to give your listeners the benefit of both visual aids and notes all at the same time.
PowerPoint 2016 also comes with many new features such as the
brand-new transition type, Morph, that can help users make animations,
transitions, and object movements across your slides. Pretty neat,
right? This course covers that and so much more. It also shows you how
to make presentations with alternative forms, styles, and custom layouts which are used by working professionals, teachers, students, medical
practitioners, politicians, and countless others. They see the value in
this unique course on PowerPoint 2016 as they want to know how to use it to quickly showcase their information and data.
Perfect for those who are looking for a comprehensive and organized
method to presentations. Great for those that want to add value to
lectures, make more compelling speeches, or enhance studies and reports. So, what are you waiting for now? If you want to learn how to use the
latest version of PowerPoint, then this is for you. At the completion of this course, you will have more knowledge, better skills, and be fully
prepared to use PowerPoint 2016 for every single one of your complex
presentation needs.
When you complete this course, you'll be well on your way to becoming a master at workplace efficiency with the tools available in Microsoft
Office 2016.
** Updated June 2017. Course transcripts now available.
What People Are Saying:
★★★★★ “The instructor speaks very clearly and is super easy to follow. Her voice is instructive at a good pace and pleasant to listen to. She appears to be very knowledgeable and is very helpful in sharing shortcuts to help speed up the work process.” –Elizabeth Eisley
★★★★★ “First time ever taking online classes. The teachers are explaining everything in details. I think it will be very helpful course. Excited to listen the rest of them.” -Violeta Yordanova
★★★★★ “Very clear, concise and easy to follow. The topics are covered systematically and comprehensively. So far I am very impressed.” –John Lawton
★★★★★ “Very informative. I am familiar with WP, and some of WP is similar. However, Word seems to have a lot of stuff hidden in the drop boxes that nobody would ever think of without this training.” –David Kelly
★★★★★ “The instructor is clear and speaks slow enough that you are able to follow her guidance. pleasant voice and doesn't rush goes to the basic step by step and is easy to follow. I highly recommend her and her course to anyone that is wanting to learn the basics of at least PowerPoint. I have a certificate in Microsoft Office but its outdated and just wanted to freshen up my knowledge and get the cobwebs out of the closet that has used this software in many years. Thank you!!” -Victoria J. SCHALLER
Course Content
- 70 section(s)
- 249 lecture(s)
- Section 1 Excel 2016: Introduction
- Section 2 Excel 2016: What's New
- Section 3 Excel 2016: Using Touch
- Section 4 Excel 2016: Getting Started
- Section 5 Excel 2016: Using Help
- Section 6 Excel 2016: Options
- Section 7 Excel 2016: The Ribbon and Toolbars
- Section 8 Excel 2016: Entering and Editing Data
- Section 9 Excel 2016: Backup and Recovery
- Section 10 Excel 2016: Fill and Series
- Section 11 Excel 2016: Viewing and Printing
- Section 12 Excel 2016: Cut, Copy, and Paste
- Section 13 Excel 2016: Formatting a Worksheet
- Section 14 Excel 2016: Formulas and Functions
- Section 15 Excel 2016: Managing Worksheets
- Section 16 Excel 2016: Working with Multiple Workbooks
- Section 17 Excel 2016: Saving Workbooks
- Section 18 Excel 2016: Proofing
- Section 19 Excel 2016: Inserting Comments
- Section 20 Excel 2016: Basic Functions in Excel
- Section 21 Excel 2016: Graphs and Charts
- Section 22 Excel 2016: Sorting and Filtering Data
- Section 23 Excel 2016: Shapes and Pictures
- Section 24 Excel 2016: Formatting Cells Based on Content
- Section 25 Excel 2016: Protection and Security
- Section 26 Excel 2016: Naming Items
- Section 27 Excel 2016: Finding and Replacing Words
- Section 28 Excel 2016: Borders
- Section 29 Excel 2016: Workbook Inspection
- Section 30 Excel 2016: Privacy Options
- Section 31 Excel 2016: Sharing Options
- Section 32 Excel 2016: Wrap Up
- Section 33 PowerPoint 2016: Course Introduction
- Section 34 PowerPoint 2016: Overview
- Section 35 PowerPoint 2016: Getting Started
- Section 36 PowerPoint 2016: Text and Bullet Editing Options
- Section 37 PowerPoint 2016: Adding Graphics to Your Presentation
- Section 38 PowerPoint 2016: Working with Objects
- Section 39 PowerPoint 2016: Working with Pictures
- Section 40 PowerPoint 2016: Working with SmartArt
- Section 41 PowerPoint 2016: Working with Tables
- Section 42 PowerPoint 2016: Working with Charts
- Section 43 PowerPoint 2016: Masters
- Section 44 PowerPoint 2016: Working with Media
- Section 45 PowerPoint 2016: Transitions
- Section 46 PowerPoint 2016: Animation
- Section 47 PowerPoint 2016: Hyperlinks and Action Buttons
- Section 48 PowerPoint 2016: Slideshow Options
- Section 49 PowerPoint 2016: Preparing a Presentation for Delivery
- Section 50 PowerPoint 2016: Other PowerPoint Features
- Section 51 PowerPoint 2016: Conclusion
- Section 52 Word 2016: Introduction
- Section 53 Word 2016: Getting Started with Word
- Section 54 Word 2016: Character Formatting
- Section 55 Word 2016: Paragraph Formatting
- Section 56 Word 2016: Managing Lists
- Section 57 Word 2016: Tables
- Section 58 Word 2016: Styles
- Section 59 Word 2016: Controlling Page Appearance
- Section 60 Word 2016: Sectioning
- Section 61 Word 2016: Graphics
- Section 62 Word 2016: Envelopes & Labels
- Section 63 Word 2016: Mail Merges
- Section 64 Word 2016: Quick Parts
- Section 65 Word 2016: Indexing and Table of Contents
- Section 66 Word 2016: Review and Printing
- Section 67 Word 2016: Other Word Features
- Section 68 Word 2016: Wrap Up
- Section 69 Extras
- Section 70 Additional Training
What You’ll Learn
- Discover new and improved features in Excel 2016., How to effectively use Excel 2016 on a touchscreen device., How create, save, and open a workbook., Learn how to personalize your use of Excel using Excel Options., How to use and how to customize the Quick Access Toolbar., Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface., The basics of entering and editing data in a workbook., Discover how to format dates and numbers., Learn practical methods in which you can backup and recover your Excel spreadsheets., Effectively use autofill and flashfill so you are more productive., Discover the essentials of using fomulas and functions., How to rename, insert, move, and reference an Excel 2016 worksheet., Discover how to create charts and graphs, Learn practical methods to sort and filter your data, How to protect and secure your Excel data, Practice what you learned with included exercise files, Discover new features in PowerPoint 2016, Learn presentation tips for an effective presentation, Discover how to format text on a PowerPoint slide, Add charts, graphs and tables to present information in a non-text format, Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation, Wow your audience by adding animations, audio and video, Discover practical tips to present your presentation to your audience, Learn time saving techniques including how to copy slides, and exporting your presentation, Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon, Master the most common uses of Word., How to controlling page appearance including using columns, indents, footers, borders and watermarks., Learn to create many types of documents., How to create a mail merge., Printing envelopes and labels., Discover different page setup options., How to protect your document from changes., Learn how to spell check your documents., Insert pictures and graphics in your Word document., Discover how to insert and edit tables., Using "Go To, Find, and Replace"., How to create, save and open documents.
Skills covered in this course
Reviews
-
BBlessing Obada
I learnt a lot on this course. Thanks to all the teachers! Great and clear delivery.
-
SSarah Sackett
I have learned many things I did not know or expect to learn, some of which were quite surprising. Thank you for making this as easy to follow along with as it is.
-
SSarah Scothern
This course was very informative with clear instructions. Fairly easy to follow, even for a beginner like myself.
-
MMadhavi B
Hello, This is Madhavi I know very well in EXCEL and word but i don't know powerpoint presentation. In this presentations i learned many things. Thank you so much all