Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel 2019 - Learn Formulas and Functions
Rating: 4.4 out of 5(36 ratings)
85 students

Excel 2019 - Learn Formulas and Functions

Unleash to power of Excel with popular and useful formulas and functions
Created byTim Wright
Last updated 6/2020
English

What you'll 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

Course content

2 sections • 12 lectures • 1h 18m total length

  • Using the exercise files0:24

    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.

  • Creating simple formulas and funtions12:37

    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. 

  • Formulas and Functions
  • Copying a formula into an adjacent cell3:29
  • Copy formulas and functions
  • Calculating year-to-date totals2:56
  • Creating a percentage change formula3:43
  • Working with relative and absolute references10:54
  • Relative and Absolute refferences
  • Using Auto Sum and Auto Average8:18
  • Auto Sum
  • Using other popular Excel functions12:01
  • Excel Functions

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 2018 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 this course is for:

  • Anyone who wants to improve their Excel skills and learn to use formulas and Functions.

Report abuse