Mastering Excel 2016 - Basics
4.2 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled

Mastering Excel 2016 - Basics

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others W
4.2 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled
Created by Chip Reaves
Last updated 3/2018
English
English, Spanish
Current price: $27.99 Original price: $39.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Effectively navigate and utilize Excel 2016
Requirements
  • Basic computer knowledge.
Description

The World Is Filled With Two Kinds Of People: A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were

If you’ve mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders – from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course is your first step towards getting started with Microsoft Excel.

This is our most requested training course!  If you learn to use Excel 2016, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified Trainers Barbara Evers and Christina Tankersley walk you through the basics of what you need to know about Microsoft Excel 2016, including:

·         Navigating around Excel

·         Creating and saving a Workbook

·         Using basic Office features including Undo, Redo, and the Office clipboard

·         The basics of Functions and Formulas

·         Applying Formatting

·         Managing Workbook properties

Quickly Search For And Find The Skills You Want To Master– Then Just Point, Click, And Learn

2+ hours of high quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher/Learner style!

Who this course is for:
  • This course is ideal for anyone using Office 365.
Course content
Expand 27 lectures 04:04:42
+ Excel 2016 Basics
27 lectures 04:04:42
05: The Quick Access Toolbar (1B)
04:27
06: Creating a New Spreadsheet (1C)
09:07
07: Compatibility Issues
05:26
08: Cell Data & Data Types (1D)
12:41
09: Accessing Help (1E)
03:10
10: Creating Worksheet Formulas (2A)
11:11
11: Insert Functions (2B)
11:28
12: Re-using Formulas and functions (2C)
11:59
13: Insert, Delete, and Adjust Columns and Rows (3A)
07:22
14: Find and Replace (3B)
09:51
15: Use Proofing and Research Tools (3A)
11:21
16: Apply Text Formats (4A)
14:13
17: Apply Number Formats (4B)
07:00
18: Align Cell Contents (4C)
08:44
19: Applying Styles and Themes (4D)
11:42
20: Conditional Formatting (4E)
11:42
21: Creating and Using Templates (4F)
06:12
22: Preview and Print a Notebook (5A)
08:48
23: Page Layout (5B)
11:53
24: Configure Headers and Footers (5C)
12:36
25: Managing Worksheets (6A)
06:32
26: View Options (6B)
10:54
27: Managing Workbook Properties (6C)
04:57