Excel 2016 Beginning to Intermediate - Complete Course
4.8 (8 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.
28 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 Beginning to Intermediate - Complete Course to your Wishlist.

Add to Wishlist

Excel 2016 Beginning to Intermediate - Complete Course

Learn all the great features like Pivot Tables, Vlookup, Charts, Flash Fill, Auto Fill and so much more!
4.8 (8 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.
28 students enrolled
Created by Tim Wright
Last updated 5/2017
English
Curiosity Sale
Current price: $10 Original price: $60 Discount: 83% off
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Move around efficiently in Excel
  • Understand how to use the Excel interface and Ribbon
  • Effectively use the Status Bar
  • Use the many help features in Excel
  • Enter data quickly and effeciently
  • Create formulas and use built-in functions
  • Calculate dates and times
  • Quickly format text, numbers, percentages, and currency
  • Create conditional formatting such as data bars and highlighted text based on rules
  • Create and format tables easily
  • Create slicers to quickly filter table data
  • Create and format shapes, images, and SmartArt to enhance your data
  • Quickly "best fit" columns and rows
  • Easily shift, insert, and move any data in rows or columns
  • Use a wide rang of tools to prpare data for looking professional when printed
  • Create insightful charts and control every aspect of layout and detail
  • Freeze rows and or columns for better views of worksheet data
  • View multiple worksheets or multiple workbooks ata the same time
  • Moving, copying, grouping, and formating worksheets and worksheet tabs
  • Undertand how to use the powerful IF, Vlookup and other Power Functions
  • Use security and Sharing features
  • Sort any column and sort multiple items at the same time
  • Automatically insert subtotal data
  • Filter out any item or data
  • Quickly find and replace data
  • Split data such and City, State, Zip between columns for better sorting
  • Remove duplicate data easily
  • Create drop down "pick lists"
  • Use validation tools to only accept specific data in specified cells
  • Create pivot table with ease
  • Create pivot charts and change them quickly
  • Use dozens of Excel hacks, short cuts, tricks, and tips!
View Curriculum
Requirements
  • You should generally understand how to use the mouse and keyboard
  • You will need access to Excel 2010, 2013, 2016 or Excel 365 version
Description

Microsoft Excel 2016 Complete Course

This Microsoft Excel course was recorded with the latest version of Excel 2016 to ensure it is up to date with all the latest features and enhancements. However it works great with 2010 and 2013 versions.

Enroll now to get over 9 hours and over 70 lessons of professional training!

Enroll now to go from a beginner in Excel to an Intermediate user ready to tackle most day to day work in Excel. Microsoft Excel is one of  the most popular spreadsheet and business productivity tools in the world. I will be your guide using my 15 years experience as an instructional designer to quickly bring you up to speed on Excel saving you months and even years of frustration. 

Stop struggling through your daily tasks at work or wishing you had the skills to advance.  Now you can quickly and easily go from beginner to intermediate step-by-step with clear video lessons and easy to use practice files designed just for this course.

When you have finished this course you will be able to perform the most popular Excel functions and features and have the confidence to take on new challenges, responsibilities and opportunities.  Here are a few of the highly sought after skills you will acquire in Excel:

  • Create attractive and effective spreadsheets
  • Sort and format large sets of data
  • Create and format tables quickly
  • Master useful functions like SUM, VLOOKUP, IF, AVERAGE,  and many others
  • Create dynamic Pivot Tables and Pivot Charts
  • Automate your tasks with Macros
  • Secure workbooks and worksheets
  • Use conditional formatting to highlight data

Enroll now and take the next step in making a real difference in your career and income potential. You are only a few clicks away from your new future!

Who is the target audience?
  • Anyone who wants to improve their Microsoft Excel skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
71 Lectures
09:27:07
+
Getting familiar with Excel
10 Lectures 45:31

This course includes exercise files for each lecture. It is recommended that you download the exercise files (Excel_Practice_Files.zip) and un-zip the files somewhere convenient like your desktop. Also Included is a FREE high quality Quick Reference Guide. If you can print it out in color and have it laminated for best results.

Preview 00:22

This is an introduction to Excel's usage and abilities. Before you begin, download the include exercise files and Quick Reference Guide in Lecture #1. Laminating the guide is recommended.

Preview 03:14

Using the Menu System
11:00


Understanding Workbooks and Worksheets
05:54

Using the Formula Bar
02:41

Using the Status Bar
03:54


Using Short Cut Menus and the Mini Toolbar
03:25

Using Excel help
03:09

Introduction to Excel
2 questions
+
Entering Data in Excel
5 Lectures 24:27
Exploring data entry and editing techniques
06:39

Entering data with AutoFill
06:07

Working with dates and times
06:14

Using Undo and Redo
02:35

Adding Comments
02:52

Which of the following is FALSE about entering data into Excel?

Entering data
2 questions
+
Creating Formulas and Functions
7 Lectures 54:08
Creating Formulas and Functions
12:47


Calculating Year to date totals
02:56

Creating a percent change formula
03:43

Working with absolute and relative references
10:54

Auto Sum and Auto Average
08:18

Other popular Excel functions
12:01

Creating Formulas and Functions
2 questions
+
Formatting Excel data
8 Lectures 01:39:53
Fonts and Styles
14:22

Adjusting Columns and Rows
05:16

Align and Merge
04:28

Designing Borders
08:15

Exploring Numeric and special formats
12:52

Using Conditional Formatting
12:50

Creating and Customizing tables
17:50

Inserting Shapes
24:00

Adjusting Columns or Rows
2 questions
+
Layout Features
4 Lectures 28:38
Insert and Delete Rows and Columns
06:45

Hiding and Un-hiding Rows and Columns
04:38

Moving Copying and Inserting Data
09:58

Find and Replace
07:17

Layout Features
2 questions
+
Preparing for Printing
3 Lectures 27:14
Page Layout View
15:38

Page Break Preview
04:54

Page Setup
06:42
+
Creating Charts
4 Lectures 34:31
Creating Charts
07:40

Chart Types
11:21

Format Charts and Elements
07:16

Sparklines
08:14
+
View Options
3 Lectures 14:22
Freezing and Unfreezing Panes
04:59

Splitting Screens
03:57

Outlining
05:26
+
View Multiple Worksheets and Workbooks
3 Lectures 37:06
Viewing Multiple Workbooks and Worksheets
09:21

Working With Sheets
06:37

Linking Worksheets and Workbooks with Formulas
21:08
+
IF Functions and VLOOKUP
4 Lectures 23:55
If functions and VLOOKUP
06:00

VLOOKUP Approximate
06:02

VLOOKUP Exact with Function Assistance
05:47

IF Family Functions
06:06
5 More Sections
About the Instructor
Tim Wright
4.8 Average rating
8 Reviews
28 Students
4 Courses
Instructional Designer at Udemy

Tim Wright has been an Instructional Designer for 10 years and an Educator for over 20 years. Mr. Wright developed and taught a nationally recognized course taught in San Francisco and New York City.

Mr. Wright has a BFA Film School degree, a Secondary Education degree, and a Masters of Science degree in Technology Education.

As a consultant, Mr. Wright's clients include the Pennsylvania Veterans Affairs Dept., the Los Angeles Fire Dept, and the National Emergency Training Center in Bethesda Maryland. 

Mr. Wright believes that anything can be learned if taught correctly.