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
Curiosity Sale
Current price: $10 Original price: $60 Discount: 83% off
30-Day Money-Back Guarantee
  • 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
  • You should generally understand how to use the mouse and keyboard
  • You will need access to Excel 2010, 2013, 2016 or Excel 365 version

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
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

Understanding Workbooks and Worksheets

Using the Formula Bar

Using the Status Bar

Using Short Cut Menus and the Mini Toolbar

Using Excel help

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

Entering data with AutoFill

Working with dates and times

Using Undo and Redo

Adding Comments

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

Calculating Year to date totals

Creating a percent change formula

Working with absolute and relative references

Auto Sum and Auto Average

Other popular Excel functions

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

Adjusting Columns and Rows

Align and Merge

Designing Borders

Exploring Numeric and special formats

Using Conditional Formatting

Creating and Customizing tables

Inserting Shapes

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

Hiding and Un-hiding Rows and Columns

Moving Copying and Inserting Data

Find and Replace

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

Page Break Preview

Page Setup
Creating Charts
4 Lectures 34:31
Creating Charts

Chart Types

Format Charts and Elements

View Options
3 Lectures 14:22
Freezing and Unfreezing Panes

Splitting Screens

View Multiple Worksheets and Workbooks
3 Lectures 37:06
Viewing Multiple Workbooks and Worksheets

Working With Sheets

Linking Worksheets and Workbooks with Formulas
IF Functions and VLOOKUP
4 Lectures 23:55
If functions and VLOOKUP

VLOOKUP Approximate

VLOOKUP Exact with Function Assistance

IF Family Functions
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.