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.
- 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.
- Setting up email accounts.
- Creating and sending email messages.
- Organizing email.
- Calendar appointments and attachments.
- Create and manage meetings.
- Adding email signatures.
- How to archive email.
- Spam and junk mail removal.
- Creating and managing tasks and reminders.
- Using the mail merge feature to import contact information to Microsoft Word.
- Adding, managing and searching contacts in the address book.
- Creating filters to automate incoming messages.
- Practice what you learned with included exercise files.
Master the Ins and Outs of Microsoft Office 2016
Spreadsheets with Excel 2016
E-mail and calendar management with Outlook 2016
Documents with Word 2016
The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.
Through 23 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.
Master Microsoft Outlook 2016 the Easy Way: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.
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.
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 install 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.
Get Organized, Productive, and Stay on Schedule with Microsoft Outlook 2016!
Topics include:
Create and send messages
Organizemail
Workwith email attachments
Createand manage meetings
Addingcontacts
Searchingfor contacts
Settingup and managing accounts
Creatingtasks
Archiving email
Usingmail merge
All the Tools You Need to Master Microsoft Outlook 2016
When you sign up for this course, you’ll gain access to 8 hours of video content – as well as special exercises and quizzes. After absorbing this comprehensive course, you’ll be able to impress your colleagues with your knowledge and productivity. You will of course receive a certificate of completion when you’re finished to let others know of your accomplishment.
We present all the videos in this course in crisp, easy-to-watch HD for optimal learning speed and clarity. With these tools, you’ll find out what’s new in Microsoft Outlook 2016, the basics of the Outlook interface, and how to work in the user interface. From keyboard shortcuts to using Outlook on a touch device, you’ll discover the pro techniques that save time and effort with this sophisticated software platform.
You’ll learn to create, reply to and manage email messages, and also organize your messages using folders. Precise meeting setup and management of meetings can turn an amateur into a productivity pro. With this course, you’ll learn to seamlessly integrate new contacts into your address book. You can easily view and share calendars with others in Microsoft Outlook 2016, create a to-do list, and print your calendar to share with others. In addition, this course describes how to create time-saving rules to filter your email based on your own needs and requirements.
You’ll even find out how to use the mail merge feature to merge your contact information stored in Outlook 2016 to a Microsoft Word document.
Whether you’re new to this software platform or just need an update on the latest features and pro tips, this course has everything you need to be productive and organized!
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, edit, 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.
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.
Here’s what our students are saying…
“This course was the perfect match for me. I would highly recommend anyone to do it be it to brush up on your skill or new beginners.
Thank you.”
– Anesa Daniels
"I'm only 72% through the course, but I had zero experience with most of the applications covered prior. Now I feel like I'm ready to tackle just about any project using the applications I've learned.
– Lauren Bury
"Yes, brilliant. All the details of signes and names, how every task works, etc... Feels like a real teacher is beside you explaining everything."
– Julia Costa
