Master Microsoft Excel 2013 & 2016 for Beginners

Do all the Excel terms, data, charts and reports get you down? Demystify Excel forever with this effective course.
4.7 (11 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.
1,903 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 123
  • Length 20 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Quickly Learn How to Master Microsoft Excel 2013 and 2016 – Beginner

Become Proficient with Excel and Its Powerful Data Functions Using These Training Classes

  • Great for personal and professional finances
  • Use conditional formatting to see what numbers matter most
  • Bring information from various files and documents together
  • Unlock the potential of your data with tables, charts, and pivots
  • Master statistical functions and data analysis to identify trends

Effortlessly Bring Important Data Together

If you're new to Excel, then you should take this class, and master all of its frequently used features. From showing you how to do a calculation, to creating useful graphs and tables, all of that is available so that you can understand your data better. There's a lot more to it than that though. This is a tool you just can't be without. In fact, when it comes to making the most of resources, and maximizing return on investment, this is the best thing out there.

Our course was designed for beginners who are familiar with Excel, but would like to improve their skills and see what else they can do with this unique and handy program. One benefit to taking this comprehensive course and using Excel is that it will be a huge time saver.

How, you ask? Excel saves you time by offering an intuitive graphical user interface. When you think of what Excel is good at, you probably first think of data manipulation: filtering, sorting, tabulating and calculating all kinds of information and data. You can use these easy-to-understand classes to reach the next level of database tracking and reporting.

Contents and Overview

Through hours of content, this beginner's course will take you through learning how to use functions for all your work-related issues. Many functions are covered including payments, future value, and depreciation. Learn statistical functions like averages, percentiles, and regression too. Excel's extensive data tools are very impressive as they can also provide the benefit of a shortened workload. In other words, this course shows you how to master this special and versatile spreadsheet program so that you can import and export common and not-so-common data formats, which reduces your need for specialized software.

This new course will easily help improve your efficiency as we cover many of Excel's core concepts. Understanding pivot tables and data analysis, for example, will be important for you moving forward. For help with reporting, you will learn stock charts, surface charts, radar charts, and bubble charts - just to list a few. A very easy to use and well-structured course.

Upon completion of this course, you'll be able to effectively create charts and graphs for personal or company records. You'll also be able to access the ribbon (and other tools), allocate valuable resources, meet tight deadlines, manage extra tasks, manage data, and much more. The material found inside is easily laid out and quite relevant.

So, take this course to possess all the skills necessary to organize and deliver your projects in the most efficient and effective way possible!

What are the requirements?

  • Microsoft Excel 2013 or 2016 desktop version for Windows installed and ready to use on your computer.

What am I going to get from this course?

  • Discover new and improved features in Excel 2013 and 2016
  • How to effectively use Excel 2013 or 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
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface
  • Tips for mouse and touch screen users
  • Graphs and charts using templates or custom designs
  • SkyDrive and other tools for sharing work
  • Pivot tables and slicing
  • Working with flash fill
  • Bonus exercise files

What is the target audience?

  • Those new to using Microsoft Excel 2013 or 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel 2016: Introduction
Acquiring Excel 2016 and Information on Installation and Upgrade
Preview
12:02
Course exercise files
Preview
02:28
IMPORTANT - Read this to ensure the best video quality!
Article
Article

The course exercise files consist of a single .ZIP file. You will need to download the Excel 2016 Course Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.

Excel 2016 Course Demo Files
Article
Section 1 Quiz
1 question
Section 2: Excel 2016: What's New
New and Improved Features in Excel 2016
Preview
02:55
Section 3: Excel 2016: Using Touch
Overview of Principles of Using Touchscreen
05:36
Section 4: Excel 2016: Getting Started
Creating and Saving a Workbook
Preview
15:16
Opening a Workbook
10:13
Section 5: Excel 2016: Using Help
Online Help and Contextual Help
06:27
Section 5 Quiz
1 question
Section 6: Excel 2016: Excel Options
Personalizing Your Use of Excel
Preview
10:50
Section 6 Quiz
2 questions
Section 7: Excel 2016: The Ribbon and Toolbars
Basics of using the Ribbon
Preview
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
Section 8: Excel 2016: Entering and Editing Data
Basics of Entering and Editing Data in a Workbook
Preview
13:29
Exercise 01
01:50
Formatting Dates
12:36
Formatting Numbers
13:48
Exercise 02
01:43
Section 8 Quiz
5 questions
Section 9: Excel 2016: Backup and Recovery
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
07:35
Section 9 Quiz
1 question
Section 10: Excel 2016: Fill and Series
Working with Fill and Series
Preview
09:09
Flash Fill
04:04
Section 10 Quiz
2 questions
Section 11: Excel 2016: Viewing and Printing
Workbook Views, Zoom, and Freeze
08:41
Printing
14:30
Exercise 03
02:56
Section 11 Quiz
3 questions
Section 12: Excel 2016: Cut, Copy, and Paste
Methods of Cutting, Copying, and Pasting
13:32
Section 12 Quiz
1 question
Section 13: Excel 2016: Formatting a Worksheet
Delete and Clear
13:45
Insert, Hide, Column Width and Row Height, and Merge
12:46
Alignment
12:05
Themes and Styles
11:19
Exercise 04
01:44
Section 13 Quiz
4 questions
Section 14: Excel 2016: Formulas and Functions
Basics of Fomulas and Functions
Preview
11:15
Complex Examples of Formulas
13:36
Exercise 05
03:25
Section 14 Quiz
1 question
Section 15: Excel 2016: Managing Worksheets
Rename, Insert, Move, and Reference a Worksheet
08:40
Section 15 Quiz
1 question
Section 16: Excel 2016: Working with Multiple Workbooks
Working with Multiple Workbooks
15:48
Section 16 Quiz
1 question
Section 17: Excel 2016: Saving Workbooks
Saving in Different File Types
12:59
Section 17 Quiz
2 questions
Section 18: Excel 2016: Proofing
The Spell Checker
13:11
Section 19: Excel 2016: Inserting Comments
Inserting Comments
04:54
Exercise 06
03:02
Section 20: Excel 2016: Basic Functions in Excel
The VLOOKUP Function
Preview
14:07
Text Functions
08:17
Date and Time Functions
06:47
Logical Functions
15:51
Section 20 Quiz
2 questions
Section 21: Excel 2016: Graphs and Charts
Creating Graphs and Charts
Preview
12:10
Customizing a Cluster Column Chart
15:42
Customizing a Pie Chart
13:36
New Chart Types in Excel 2016
02:01
Exercise 07
02:28
Section 21 Quiz
2 questions
Section 22: Excel 2016: Sorting and Filtering Data
Managing Data by Sorting
09:39
Managing Date by Filtering
11:59
Customizing Tables
13:23
Section 22 Quiz
3 questions
Section 23: Excel 2016: Shapes and Pictures
Inserting Shapes and Pictures
15:00
Exercise 08
00:47
Section 23 Quiz
2 questions
Section 24: Excel 2016: Formatting Cells Based on Content
Conditional Formatting
15:32
Section 24 Quiz
2 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 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,000+ 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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course