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.04 (612 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
4,318
students
23 hours
content
Mar 2024
last update
$89.99
regular price

What you will learn

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

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!

Content

Excel 2016: Introduction

Acquiring Excel 2016 and Information on Installation and Upgrade
Essential Information for a Successful Training Experience
Excel 2016 Course Exercise Files
Excel 2016 Course Demo Files
Course exercise files
Section 1 Quiz

Excel 2016: What's New

New and Improved Features in Excel 2016

Excel 2016: Using Touch

Overview of Principles of Using Touchscreen

Excel 2016: Getting Started

Creating and Saving a Workbook
Opening a Workbook

Excel 2016: Using Help

Online Help and Contextual Help
Section 5 Quiz

Excel 2016: Excel Options

Personalizing Your Use of Excel
Section 6 Quiz

Excel 2016: The Ribbon and Toolbars

Basics of using the Ribbon
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Status Bar
Section 7 Quiz

Excel 2016: Entering and Editing Data

Basics of Entering and Editing Data in a Workbook
Exercise 01
Formatting Dates
Formatting Numbers
Exercise 02
Section 8 Quiz

Excel 2016: Backup and Recovery

AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 9 Quiz

Excel 2016: Fill and Series

Working with Fill and Series
Flash Fill
Section 10 Quiz

Excel 2016: Viewing and Printing

Workbook Views, Zoom, and Freeze
Printing
Exercise 03
Section 11 Quiz

Excel 2016: Cut, Copy, and Paste

Methods of Cutting, Copying, and Pasting
Section 12 Quiz

Excel 2016: Formatting a Worksheet

Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Alignment
Themes and Styles
Exercise 04
Section 13 Quiz

Excel 2016: Formulas and Functions

Basics of Fomulas and Functions
Complex Examples of Formulas
Exercise 05
Section 14 Quiz

Excel 2016: Managing Worksheets

Rename, Insert, Move, and Reference a Worksheet
Section 15 Quiz

Excel 2016: Working with Multiple Workbooks

Working with Multiple Workbooks
Section 16 Quiz

Excel 2016: Saving Workbooks

Saving in Different File Types
Section 17 Quiz

Excel 2016: Proofing

The Spell Checker

Excel 2016: Inserting Comments

Inserting Comments
Exercise 06

Excel 2016: Basic Functions in Excel

The VLOOKUP Function
Text Functions
Date and Time Functions
Logical Functions
Section 20 Quiz

Excel 2016: Graphs and Charts

Creating Graphs and Charts
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Exercise 07
Section 21 Quiz

Excel 2016: Sorting and Filtering Data

Managing Data by Sorting
Managing Date by Filtering
Customizing Tables
Section 22 Quiz

Excel 2016: Shapes and Pictures

Inserting Shapes and Pictures
Exercise 08
Section 23 Quiz

Excel 2016: Formatting Cells Based on Content

Conditional Formatting
Section 24 Quiz

Excel 2016: Protection and Security

Protecting Worksheets
Protecting Workbooks

Excel 2016: Naming Items

Giving Items Names
Exercise 09

Excel 2016: Finding and Replacing Words

Find and Replace
Section 27 Quiz

Excel 2016: Borders

Adding Borders
Section 28 Quiz

Excel 2016: Workbook Inspection

Inspecting a Workbook

Excel 2016: Privacy Options

Trust Center Privacy Options

Excel 2016: Sharing Options

Sharing a Workbook
Section 31 Quiz

Excel 2016: Wrap Up

Closing
Course Review

Excel 2013: Introduction

Introduction to Excel 2013
Essential Information for a Successful Training Experience
Excel 2013 Course Exercise Files
What's New

Excel 2013: Using Touch

Overview of Principles

Excel 2013: Getting Started

Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Templates; Creating, Opening, and Saving a Workbook

Excel 2013: Help

Online, Offline, and Contextual Help

Excel 2013: Settings and Preferences

Excel Options

Excel 2013: The Ribbon and Toolbars

Ribbon Interface
Quick Access Toolbar
Mini Toolbar

Excel 2013: Backup and Recovery

Create Backup Option; Auto-Recover and Autosave

Excel 2013: Entering and Deleting Data

Entering Text and Numbers
Date Formats
Formatting Cells; Editing and Deleting Data
Fill
Flash Fill

Excel 2013: Formatting a Worksheet

Themes and Cell Styles
Inserting, Deleting, Hiding and Adjusting Rows and Columns
Wrap Text and Alignment
Merging Cells; Applying Themes and Styles
Borders

Excel 2013: Copy, Paste and Paste Special

Copy, Cut and Paste

Excel 2013: Proofing

Spell checking

Excel 2013: Managing Worksheets

Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets

Excel 2013: Comments

Inserting Comments

Excel 2013: Viewing and Printing

Workbook Views, Zoom and Freeze
Printing; Headers, Footers and Margins

Excel 2013: Formulas and Functions

Overview of Formulas and Functions
Cell References
Names
Finding Errors; New Excel Functions

Excel 2013: Working with Workbooks

Multiple Workbooks and Windows; Comparing Workbooks

Excel 2013: Find and Replace

Go to; Find and Replace Options

Excel 2013: Conditional Formatting

Applying, Clearing and Managing Rules

Excel 2013: Graphing and Charting

Chart Types; Chart Recommendation
Basic Formatting
Selecting Data, Positioning and Printing Charts

Excel 2013: File Types

Saving Workbooks; PDF and CSV Formats

Excel 2013: Managing Data

Sorting
Filtering
Tables

Excel 2013: Functions Case Study

VLOOKUP
Text Function
Date and Time Functions
Logical Functions

Excel 2013: Analyzing Data

Financial Analysis Case Study - Part 1
Financial Analysis Case Study - Part 2
Quick Analysis Tool

Excel 2013: Shapes and Pictures

Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt

Excel 2013: Sharing and Protecting

Protecting Worksheets
Protecting Workbooks
Sharing and SkyDrive

Excel 2013: More Backstage View Options

Trust Center; Export; Inspect Workbook

Excel 2013: Closing

Summary; More Help

Excel 2013: Assessment

Course Quiz

Screenshots

Master Microsoft Excel 2013 & 2016 for Beginners - Screenshot_01Master Microsoft Excel 2013 & 2016 for Beginners - Screenshot_02Master Microsoft Excel 2013 & 2016 for Beginners - Screenshot_03Master Microsoft Excel 2013 & 2016 for Beginners - Screenshot_04

Reviews

Crystal
April 19, 2023
Yes, facilitator explains and then visually displays the work. Facilitator moves at a good pace and does not take for granted that the learner knows anything.
Matthew
November 13, 2021
This course would be far more effective if it were split in to separate courses covering each edition of Excel. As it is, it's far too unwieldly for a new user (the target audience) to take in in an efficient manner. The course material is good, if occasionally a little too talky, but the sheer number of videos makes for a dreary experience.
Elizabeth
May 27, 2020
It's really nice, with plenty of time to practice each lesson as in a regular school setting. Maybe I'll register on my own later. It's really good in detail which I like.
Stembile
May 21, 2020
It was very helpful, I learned a lot, but some of the videos the picture quality was very bad couldn't see anything. I enjoyed the PIVOT Tables a lot.
Miranda
April 10, 2020
This course should split into two parts or begin with Excel 2013 at the beginning since the title is "Master Microsoft Excel 2013 & 2016 for Beginners. I can apply many things from Excel 2016 to my current excel format. I'd like if the instructor can show us how to work on the graph/chart from the beginning using a blank form. Should have quizzes on each section.
Anonymized
September 10, 2018
I recommend this course to someone who needs to work with MS Excel. Some subjects are too long (more than 15 minutes). In my opinion, each subject should not longer than 10 minutes to be more effectively.
Redvers
September 30, 2016
An absolutely essential course to take in order to improve your I T skills. This course is a very comprehensive, interesting, educational and easy to understand the narrator.
Steve
April 14, 2016
Person recording the video had his mouth too close to the microphone. Can hear breathing in between words and sentences. Other than that it is great.
Sakib
March 29, 2016
Every step is detailed with proper information. The sequence of the topics are very effective for the beginners. Overall, a great course to spend time and money. Excellent experience so far. I highly recommend it.

Charts

Price

Master Microsoft Excel 2013 & 2016 for Beginners - Price chart

Rating

Master Microsoft Excel 2013 & 2016 for Beginners - Ratings chart

Enrollment distribution

Master Microsoft Excel 2013 & 2016 for Beginners - Distribution chart

Related Topics

739942
udemy ID
1/24/2016
course created date
11/20/2019
course indexed date
Bot
course submited by