Excel 2016 Introduction
5.0 (1 rating)
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.
4 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Introduction to your Wishlist.

Add to Wishlist

Excel 2016 Introduction

Learn the essentials of working with Microsoft Excel worksheets
5.0 (1 rating)
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.
4 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn to create simple worksheets
  • Use Functions in formulas
  • Understand calculation hierarchy and the Order of Operations
  • Add columns and rows
  • Format and align worksheet data
  • Use cell styles and themes
  • Proof and print a workbook
  • Manage Worksheets
View Curriculum
Requirements
  • Basic Windows skills
Description

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.

Who is the target audience?
  • Anyone who needs to create or maintain worksheets
Students Who Viewed This Course Also Viewed
Curriculum For This Course
67 Lectures
03:45:28
+
Introduction
1 Lecture 01:03

Please download the datafiles if you wish to work along with the instructor

Preview 01:03
+
Getting Started with Excel
6 Lectures 23:36

Opening Excel
04:25

Navigating the Excel User Interface
07:48

Using the Excel Ribbon
02:55

Understanding Excel Worksheet Components
03:55

Using the Backstage View
02:32
+
Creating Workbooks and Using Templates
4 Lectures 14:04

Creating Workbooks Using Templates
03:24

Saving an Excel Workbook
05:20

Using Convert and Checking Compatibility
02:19
+
Entering Data
6 Lectures 25:18


Working with Cell and Range Addressing
02:20

Using Various Data Selection Techniques
05:14

Working with Common Excel Commands
07:25

Using the Autofill Handle
02:37
+
Excel Formula Basics Data
7 Lectures 27:07

Understanding the Components of a Formula
05:39

Understanding Calculation Hierarchy and the Order of Operations
02:26

Creating Basic Formulas
08:09

Working with Basic Functions and AutoSum
03:59

Using Cell References
03:37

Using the Quick Analysis Tool
01:15
+
Adjusting a Worksheet
2 Lectures 09:14
Modifying Columns and Rows
06:08

Hiding and Unhiding Columns and Rows
03:06
+
Formatting and Aligning Worksheet Data
7 Lectures 19:56

Merging Data
03:52

Wrapping Text and Adjusting Orientation
01:45

Formatting Numbers
03:10

Using Borders and Shading
02:37

Using the Format Painter
01:21

Removing Formatting Quickly
01:24
+
Using Cell Styles and Themes
3 Lectures 09:14

Applying Cell Styles
04:23

Applying Themes
03:13
+
Inserting Objects and Graphics
9 Lectures 30:37
Inserting and Formatting Images
02:46

Inserting and Formatting Shapes
04:27

Inserting and Formatting SmartArt
03:47

Inserting Screenshots
02:17

Inserting Hyperlinks
02:37

Inserting Symbols and Equations
03:13

Inserting WordArt and Text Boxes
03:50

Inserting Other Excel Objects
03:53

Arranging Objects
03:47
+
Proofing a Workbook
5 Lectures 13:03

Finding and Replacing Formatting
01:19

Using Go To and Go To Special
02:23

Using the Spell Checker
02:34

Using the Thesaurus and Translation Features
03:04
4 More Sections
About the Instructor
Intellezy Trainers
4.4 Average rating
4,524 Reviews
26,554 Students
137 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.