Introduction to Microsoft Excel 2016 for Absolute Beginners
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,181 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to Microsoft Excel 2016 for Absolute Beginners to your Wishlist.

Add to Wishlist

Introduction to Microsoft Excel 2016 for Absolute Beginners

Learn the essentials of Microsoft Excel 2016 in easy to follow steps
4.3 (24 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,181 students enrolled
Created by Simon Sez IT
Last updated 6/2017
English
English
Price: Free
Includes:
  • 3 hours on-demand video
  • 5 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
  • Using flash fill for rapidly filling Excel cells with data.
View Curriculum
Requirements
  • Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.
Description

During this introductory course on using Microsoft Excel 2016, we'll teach the basics of using Excel 2016.

We'll start with navigating the Excel 2016 interface, including the Ribbon, Backstage View and the Quick Access Toolbar.

Discover concepts to help you understand how enter data into a Excel spreadsheet, using Flash Fill and working with worksheets.

Contents and Overview

This easy to understand course starts at the very beginning, specifically designed for those with little or no Excel experience. The first task is to find the software and install it on your computer. Then we show you in easy step-by-step fashion how to get Excel up and running and begin using it in its most popular ways.

Then we discover the new and improved features added to the 2016 version. There are new features that could be a big help in your job, your business, or in personal projects.

We start with essential first steps. You will learn to create a Workbook, save it, then open it. We show you simple ways to use Microsoft's powerful online and contextual help, so you are never left wondering when you have a question or encounter a challenge.

Along the way we keep in mind you will want to personalize Excel to accomplish the things you want. We learn all about Ribbons and Toolbars that make Excel extremely flexible.

Next we move on to entering and editing data in your Workbook, formatting dates and numbers, auto saving and creating backups, and finally how to print your work.

All along the way there are plenty of exercises and quizzes that help you fully understand all the concepts and solidify them in your memory.

This is the course you need to learn the most important ways to expertly use MS Excel 2016. It assumes you are just beginning with Excel and easily steps you through the process of being highly proficient with this widely used tool.

This course is for absolute beginners, thus is appropriate for those new to Excel and who appreciate a methodical, patient and conversational pace.

Who is the target audience?
  • Those new to using Microsoft Excel 2016.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel.
  • Users of earlier versions of Excel looking to update their skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
29 Lectures
03:15:34
+
Introduction
5 Lectures 15:07
Acquiring Excel 2016 and Information on Installation and Upgrade
12:02

Essential Information for a Successful Training Experience
01:53

Course Exercise Files
00:26

Course Demo Files
00:26

Downloadable Course Transcripts
00:19

Section 1 Quiz
1 question
+
What's New
1 Lecture 02:55
New and Improved Features in Excel 2016
02:55
+
Using Touch
1 Lecture 05:36
Overview of Principles of Using Touchscreen
05:36
+
Getting Started
2 Lectures 25:29
Creating and Saving a Workbook
15:16

Opening a Workbook
10:13
+
Using Help
1 Lecture 06:27
Online Help and Contextual Help
06:27

Section 5 Quiz
1 question
+
Excel Options
2 Lectures 11:33
Course review
00:43

Personalizing your use of Excel
10:50

Section 6 Quiz
2 questions
+
The Ribbon and Toolbars
5 Lectures 36:19
Basics of using the Ribbon
14:56

Quick Access Toolbar
05:45

Tell Me Feature
06:49

Mini Toolbars and Contextual Menus
03:47

Status Bar
05:02

Section 7 Quiz
2 questions
+
Entering and Editing Data
5 Lectures 43:26
Basics of Entering and Editing Data in a Workbook
13:29

Exercise 01
01:50

Formatting Dates
12:36

Formatting Numbers
13:48

Exercise 02
01:43

Section 8 Quiz
5 questions
+
Backup and Recovery
1 Lecture 07:35
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35

Section 9 Quiz
1 question
+
Fill and Series
2 Lectures 13:13
Working with Fill and Series
09:09

Flash Fill
04:04

Section 10 Quiz
2 questions
1 More Section
About the Instructor
Simon Sez IT
4.4 Average rating
11,481 Reviews
303,127 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.