Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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
English [Auto],

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

    Master calculating year-to-date totals in Excel 2019 by building a formula that adds today’s profits to the previous total and uses autofill to copy the pattern.

  • Creating a percentage change formula3:43

    Create a percentage change formula in Excel 2019 to measure day-to-day profit changes, using parentheses to enforce order of operations and formatting results as a percentage.

  • Working with relative and absolute references10:54

    Learn how relative and absolute references work in Excel 2019, create and copy formulas, use the auto fill handle, and apply dollar signs to lock references.

  • Relative and Absolute refferences
  • Using Auto Sum and Auto Average8:18

    learn to use auto sum and auto average in Excel 2019 to create quick formulas and totals, and control which numbers get totaled via selection and the dropdown options.

  • Auto Sum
  • Using other popular Excel functions12:01

    Learn to build and copy Excel formulas with auto sum, auto average, autofill, and relative references, applying count, median, large, small, standard deviation, and rank to salary data.

  • 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