Excel 2019 - Learn Formulas and Functions

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

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

Course content

2 sections • 12 lectures • 1h 18m total length
  • 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
  • Auto Sum
    1 question
  • Using other popular Excel functions
    12:01
  • Excel Functions
    1 question

Instructor

Nationally Recognized Instructional Designer
  • 4.4 Instructor Rating
  • 584 Reviews
  • 8,285 Students
  • 8 Courses

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.

Expected Outcomes

  1. 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 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  2. 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 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  3. 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 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  4. 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 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  5. Work with and understand absolute and relative references Use Auto Sum and Auto Average effectively Use other popular 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  6. Use Auto Sum and Auto Average effectively Use other popular 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();
  7. Use other popular 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. Show more Show less Course content 2 sections • 12 lectures • 1h 18m total length Expand all sections An Introduction to Formulas and Functions in Excel 2016 8 lectures • 54min Using the exercise files Preview 00:24 Creating simple formulas and funtions Preview 12:37 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 Auto Sum 1 question Using other popular Excel functions 12:01 Excel Functions 1 question Advanced Functions: IF and VLOOKUP 4 lectures • 24min 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 Instructor Tim Wright Nationally Recognized Instructional Designer 4.4 Instructor Rating 584 Reviews 8,285 Students 8 Courses 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781b5007f714095',m:'0436bb5b47613b909fc370a5081ef337500e4ca5-1627848598-1800-AVZNFNjUepVxr4+VDkzAJfV7WUZWMa5iEOPP4ZsVsB0vs824ofzvl9GqXGqbOrYIa00AXRHSBq8Uv6ADJq4LbLe76F/j1mlee7S26PZd/sQ1dgqSdV5yd9NyzmjBSESiK0eWDLHIeJXOCnWrJnDjxCWrv/796rYxb4p7mqQgb2m/mwK9Ltx4ox/+ry8CareiVw==',s:[0xd0f19ee555,0x3fffd8510b],}})();