Microsoft Excel, PowerPoint and Word 2016 for Beginners
Microsoft Excel, PowerPoint and Word 2016 for Beginners, available at $99.99, has an average rating of 4.95, with 249 lectures, 47 quizzes, based on 799 reviews, and has 6693 subscribers.
You will learn about 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. This course is ideal for individuals who are Anyone new to Microsoft Office or upgrading from a previous version It is particularly useful for Anyone new to Microsoft Office or upgrading from a previous version.
Enroll now: Microsoft Excel, PowerPoint and Word 2016 for Beginners
Summary
Title: Microsoft Excel, PowerPoint and Word 2016 for Beginners
Price: $99.99
Average Rating: 4.95
Number of Lectures: 249
Number of Quizzes: 47
Number of Published Lectures: 249
Number of Published Quizzes: 47
Number of Curriculum Items: 296
Number of Published Curriculum Objects: 296
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will 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.
Who Should Attend
- Anyone new to Microsoft Office or upgrading from a previous version
Target Audiences
- Anyone new to Microsoft Office or upgrading from a previous version
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 Beginnersstarts 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 Curriculum
Chapter 1: Excel 2016: Introduction
Lecture 1: Acquiring Excel 2016 and Information on Installation and Upgrade
Lecture 2: WATCH ME: Essential Information for a Successful Training Experience
Lecture 3: DOWNLOAD ME: Course Exercise Files
Lecture 4: DOWNLOAD ME: Course Demo Files
Lecture 5: Downloadable Course Transcripts
Chapter 2: Excel 2016: What's New
Lecture 1: New and Improved Features in Excel 2016
Chapter 3: Excel 2016: Using Touch
Lecture 1: Overview of Principles of Using Touchscreen
Chapter 4: Excel 2016: Getting Started
Lecture 1: Creating and Saving a Workbook
Lecture 2: Opening a Workbook
Chapter 5: Excel 2016: Using Help
Lecture 1: Online Help and Contextual Help
Chapter 6: Excel 2016: Options
Lecture 1: Personalizing your use of Excel
Chapter 7: Excel 2016: The Ribbon and Toolbars
Lecture 1: Basics of using the Ribbon
Lecture 2: Quick Access Toolbar
Lecture 3: Tell Me Feature
Lecture 4: Mini Toolbars and Contextual Menus
Lecture 5: Status Bar
Chapter 8: Excel 2016: Entering and Editing Data
Lecture 1: Basics of Entering and Editing Data in a Workbook
Lecture 2: Exercise 01
Lecture 3: Formatting Dates
Lecture 4: Formatting Numbers
Lecture 5: Exercise 02
Chapter 9: Excel 2016: Backup and Recovery
Lecture 1: AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Chapter 10: Excel 2016: Fill and Series
Lecture 1: Working with Fill and Series
Lecture 2: Flash Fill
Chapter 11: Excel 2016: Viewing and Printing
Lecture 1: Workbook Views, Zoom, and Freeze
Lecture 2: Printing
Lecture 3: Exercise 03
Chapter 12: Excel 2016: Cut, Copy, and Paste
Lecture 1: Methods of Cutting, Copying, and Pasting
Chapter 13: Excel 2016: Formatting a Worksheet
Lecture 1: Delete and Clear
Lecture 2: Insert, Hide, Column Width and Row Height, and Merge
Lecture 3: Alignment
Lecture 4: Themes and Styles
Lecture 5: Exercise 04
Chapter 14: Excel 2016: Formulas and Functions
Lecture 1: Basics of Formulas and Functions
Lecture 2: Complex Examples of Formulas
Lecture 3: Exercise 05
Chapter 15: Excel 2016: Managing Worksheets
Lecture 1: Rename, Insert, Move, and Reference a Worksheet
Chapter 16: Excel 2016: Working with Multiple Workbooks
Lecture 1: Working with Multiple Workbooks
Chapter 17: Excel 2016: Saving Workbooks
Lecture 1: Saving in Different File Types
Chapter 18: Excel 2016: Proofing
Lecture 1: The Spell Checker
Chapter 19: Excel 2016: Inserting Comments
Lecture 1: Inserting Comments
Lecture 2: Exercise 06
Chapter 20: Excel 2016: Basic Functions in Excel
Lecture 1: The VLOOKUP Function
Lecture 2: Text Functions
Lecture 3: Date and Time Functions
Lecture 4: Logical Functions
Chapter 21: Excel 2016: Graphs and Charts
Lecture 1: Creating Graphs and Charts
Lecture 2: Customizing a Cluster Column Chart
Lecture 3: Customizing a Pie Chart
Lecture 4: New Chart Types in Excel 2016
Lecture 5: Exercise 07
Chapter 22: Excel 2016: Sorting and Filtering Data
Lecture 1: Managing Data by Sorting
Lecture 2: Managing Date by Filtering
Lecture 3: Customizing Tables
Chapter 23: Excel 2016: Shapes and Pictures
Lecture 1: Inserting Shapes and Pictures
Lecture 2: Exercise 08
Chapter 24: Excel 2016: Formatting Cells Based on Content
Lecture 1: Conditional Formatting
Instructors
-
Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries
Rating Distribution
- 1 stars: 13 votes
- 2 stars: 20 votes
- 3 stars: 108 votes
- 4 stars: 282 votes
- 5 stars: 376 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024