Excel 2016 - Learn Formulas and Functions
0.0 (0 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.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016 - Learn Formulas and Functions to your Wishlist.

Add to Wishlist

Excel 2016 - Learn Formulas and Functions

Unleash to power of Excel with popular and useful formulas and functions
0.0 (0 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.
2 students enrolled
Created by Tim Wright
Last updated 5/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create formulas and functions
  • Copy a formula into an adjacent cell
  • Calculate year to date totals
  • Create a percent change formula
  • Work with and understand absolute and relative references
  • Use Auto Sum and Auto Average effectively
  • Use other popular Excel functions
View Curriculum
Requirements
  • Be able to do basic mouse and keyboard computer operations
  • Have access to Excel 2010, 2013, 2017 or Microsoft Office 365 Version
Description

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 2013 and 2010.

Enroll now to start getting so much more out of 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 learn 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 formulas 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 formulas and functions
  • Copy a formula into an adjacent cell
  • Calculate year to date totals
  • Create a percent change formula
  • Work with and understand absolute and relative references
  • Use Auto Sum and Auto Average effectively
  • Use other popular Excel functions

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 Excel skills and learn to use formulas and Functions.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:18:15
+
An Introduction to Formulas and Functions in Excel 2016
8 Lectures 54:22

This course includes an exercise file with multiple worksheet tabs. One tab for each lecture. It is recommended that you download the exercise file and un-zip the file 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:24

This video lecture introduces some simple formulas and some simple functions. You will learn the basics that will allow you to start trying the hundreds of other Excel functions. It is recommended that you download the exercise file from Lecture #1 before you begin and follow along with the lectures. 

Preview 12:37

This quiz was designed as a knowledge check to help you assess your comprehension of different key aspects of Excel formulas and functions

Formulas and Functions
2 questions

Copying a formula into an adjacent cell
03:29

Copy formulas and functions
1 question

Calculating year-to-date totals
02:56

Creating a percentage change formula
03:43

Working with relative and absolute references
10:54

Relative and Absolute refferences
1 question

Using Auto Sum and Auto Average
08:18

Can you change the cells selected by Auto Sum?

Auto Sum
1 question

Using other popular Excel functions
12:01

Excel Functions
1 question
+
Advanced Functions: IF and VLOOKUP
4 Lectures 23:53
Using the IF function
05:58

Using VLOOKUP Aproximate
06:02

Using VLOOKUP Exact with Function Assistance
05:47

Using the IF family of Functions
06:06

Using the IF Function
2 questions
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.