Excel Formulas and Functions: Make Basic & Advanced Formulas

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

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated: Nov 01. 2016

Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks.

Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course.

Let’s discuss now what you will learn from this course.

  1. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details.
  2. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box.
  3. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course.
  4. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course.
  5. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed.
  6. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on.
  7. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course.
  8. Then you will work with 3-D Referencing with Excel Formulas.
  9. In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions, Text manipulating functions, and many more.
  10. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions.
  11. Then you have worked with VLOOKUP, INDEX, and Array formulas.
  12. And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions.
  13. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions.

So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course!

Who this course is for:

  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.

Expected Outcomes

  1. Learn Excel Formulas and Functions from Zero. Learn how to build a professional level Excel Template using Excel functions. Requirements Microsoft Office Software Installed. Description Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course. Let’s discuss now what you will learn from this course. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course. Then you will work with 3-D Referencing with Excel Formulas. In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions , Text manipulating functions, and many more. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions. Then you have worked with VLOOKUP, INDEX, and Array formulas. And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions. So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course! Who this course is for: This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features. Show more Show less Course content 8 sections • 55 lectures • 5h 22m total length Expand all sections Welcome to the Course! Be a Professional Excel User with this course! 5 lectures • 14min 0101 Welcome to the course! Preview 03:04 Download Working Files, Ongoing Support & How to Instantly Contact Me 00:49 List of sites where you can practice Excel problems 00:46 0102 How to Best View This Course 06:58 0103 How to Review this Course and Obtain Your Certificate of Completion 02:40 Formula and Function Basics 14 lectures • 1hr 42min 0201 Operators Used in Formulas and How to Build Basic Formulas Preview 10:28 0202 Operator Precedence in Formulas Preview 09:31 0203 How Built in Excel Functions Make Your Job Easier 07:17 0204 Inserting Functions into Formulas Effectively 09:40 0205 Relative Cell References - Using Relative Cell References to Copy Formulas 05:23 0208 Subtotal Function - Using Subtotal Function Effectively 06:56 0209 Using Formulas in Tables - Summarizing and Referencing Data in a Table 12:44 0210 Use Structured References in Excel Tables Preview 08:31 0211 Displaying All the Formulas on a Worksheet 03:04 0212 Handling Circular References 03:24 0213 Using Named Cells and Ranges in the Formulas 07:48 0214 Using Names for Constants & Formulas & Applying Names to Existing Reference 08:01 0215 Union and Intersection of Ranges 05:28 0216 Some Tips on How to Work with Formulas 03:38 Useful Mathematical Functions 5 lectures • 32min 0301 SUM(...) Function - The Most Useful Function in Excel 07:51 0302 Mathematical Functions: Average(), Max() and Min() 06:54 0303 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN() 07:10 0304 Count Functions in Excel 03:17 0305 Learn About 3-D Reference in Excel 07:06 Advanced Excel Formulas 14 lectures • 1hr 20min 0401 Using the IF(...) Function 07:54 0402 Using IF(...) & IFERROR(...) function to Hide Excel Errors 06:05 0403 DATEDIF(...) Function - A Useful Function 10:06 0404 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions 06:59 0405 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator 04:15 0406 Using TEXT(...) Function to Manipulate Numbers 04:55 0407 REPT(...) Function - Using REPT(...) Function to Make a Histogram 06:44 0408 Date Manipulation Functions 09:18 0410 Use of Rank Functions to Calculate Placings 07:44 0412 WEEKDAY(...) Function: Use of WEEKDAY(...) Function 03:38 0413 OR(...) Function: Using OR(...) Function 03:06 0414 ISTEXT(...) Function: Using ISTEXT(...) Function 02:48 0415 ROW(...) and COLUMN(...) Functions 01:52 0416 INDIRECT(...) - Creating a Dependent Drop Down List in Excel 04:34 Creating Formulas that Manipulate Text 7 lectures • 30min 0501 Finding and Searching within a Text 06:02 0502 Counting Specific Characters in a Cell 02:57 0503 Counting the Occurrences of a Substring in a Cell 02:26 0504 Extracting the First and Last Words of a String 06:13 0505 Extracting All but the First Word from a Text or String 02:41 0506 Separating the First, Middle, and Last names from the Full Names 04:44 0507 Counting the Number of Words in a Cell 04:40 Project - Develop a Professional Excel Template Using Excel Formulas 8 lectures • 1hr 3min 0601 Introducing Array Formulas - How to Enter Arrays into Worksheet Cells 07:35 0602 Introducing Array Formulas - How to Create Array Formulas with Examples 05:42 0603 INDEX(...) Function in Excel 08:11 0604 VLOOKUP(...) Function in Excel 04:32 0605 Invoice Template in Excel - Part 1 07:08 0606 Invoice Template in Excel - Part 2 07:38 0607 Invoice Template in Excel - Part 3 10:39 0608 Invoice Template in Excel - Part 4 11:12 Conclusion 1 lecture • 1min Wrap-up 00:14 Learn More: A Special Offer! 1 lecture • 2min Bonus Lecture: A Special Offer for You! 01:32 Instructor Kawser Ahmed Founder ExcelDemy.com | Data Analyst 4.4 Instructor Rating 9,450 Reviews 148,254 Students 10 Courses Love to see you here. I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur. I love to make courses in the combination of both theory and practice. Monthly 100,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile). I love to learn and teach (teaching from my eighteen)! Visit my blog. You will find plenty of useful posts, articles, video tutorials, and important Excel resources. What I love most is: add some value to people around me, believe me. Here are some of my working areas: 1. Corporate Budgeting, Planning & Forecasting 2. Mission-critical financial processes 3. Month-end close processes 4. Big Data Analysis using Excel 5. Company Reports (Sales, Marketing, Administrative) 6. Large Projects using Excel VBA 7. Dashboard Design using Excel 8. And Basic Accounting I am always around you to help and support. Just contact me. 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:'67812b73e9c2f413',m:'e46b7e1a514eeb51d3fcf5ef2e3fadd616bad676-1627842963-1800-AfbWNnH4FHslJ22N+b6UFHs2fPleIhZnm1uPfiEAORK3CA7YKYUNk7c2dFqE3if/N+hS1Zg/BgP38bDm04Wg+A0rcgULggm1B9zIOFa1zrzyXZLT9JSdcgPU1QWuIF37YRXoSOLrmfuOB+bpQQcY0VFURzpOptQA/LnWl/1+pQBF39KbBZRNOyBoPu2INBpsy/IoKt7PgbLFzGlktCSEVvw=',s:[0x533ff3eabd,0xe39ed6b2d0],}})();
  2. Learn how to build a professional level Excel Template using Excel functions. Requirements Microsoft Office Software Installed. Description Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated: Nov 01. 2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. Without Excel formulas and functions, Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course. Let’s discuss now what you will learn from this course. Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. Relative, Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So, they have got a good time in the course. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture, structured referencing with Excel tables has been discussed. Then you will learn how to handle circular references with Excel formulas, how named cells and ranges work with Excel formulas, and so on. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course, you will learn about SUM, AVERAGE, MAX, MIN, INT, MOD, ROUND, RAND, and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course. Then you will work with 3-D Referencing with Excel Formulas. In Advanced Excel formulas, you will learn: IF, IFERROR, DATE related functions , Text manipulating functions, and many more. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions. Then you have worked with VLOOKUP, INDEX, and Array formulas. And at the end of the course, you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions. So, if you are interested to learn advanced Excel formulas and functions with a real life project, then this course is for you. Thanks for reading. Enjoy the course! Who this course is for: This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features. Show more Show less Course content 8 sections • 55 lectures • 5h 22m total length Expand all sections Welcome to the Course! Be a Professional Excel User with this course! 5 lectures • 14min 0101 Welcome to the course! Preview 03:04 Download Working Files, Ongoing Support & How to Instantly Contact Me 00:49 List of sites where you can practice Excel problems 00:46 0102 How to Best View This Course 06:58 0103 How to Review this Course and Obtain Your Certificate of Completion 02:40 Formula and Function Basics 14 lectures • 1hr 42min 0201 Operators Used in Formulas and How to Build Basic Formulas Preview 10:28 0202 Operator Precedence in Formulas Preview 09:31 0203 How Built in Excel Functions Make Your Job Easier 07:17 0204 Inserting Functions into Formulas Effectively 09:40 0205 Relative Cell References - Using Relative Cell References to Copy Formulas 05:23 0208 Subtotal Function - Using Subtotal Function Effectively 06:56 0209 Using Formulas in Tables - Summarizing and Referencing Data in a Table 12:44 0210 Use Structured References in Excel Tables Preview 08:31 0211 Displaying All the Formulas on a Worksheet 03:04 0212 Handling Circular References 03:24 0213 Using Named Cells and Ranges in the Formulas 07:48 0214 Using Names for Constants & Formulas & Applying Names to Existing Reference 08:01 0215 Union and Intersection of Ranges 05:28 0216 Some Tips on How to Work with Formulas 03:38 Useful Mathematical Functions 5 lectures • 32min 0301 SUM(...) Function - The Most Useful Function in Excel 07:51 0302 Mathematical Functions: Average(), Max() and Min() 06:54 0303 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN() 07:10 0304 Count Functions in Excel 03:17 0305 Learn About 3-D Reference in Excel 07:06 Advanced Excel Formulas 14 lectures • 1hr 20min 0401 Using the IF(...) Function 07:54 0402 Using IF(...) & IFERROR(...) function to Hide Excel Errors 06:05 0403 DATEDIF(...) Function - A Useful Function 10:06 0404 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions 06:59 0405 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator 04:15 0406 Using TEXT(...) Function to Manipulate Numbers 04:55 0407 REPT(...) Function - Using REPT(...) Function to Make a Histogram 06:44 0408 Date Manipulation Functions 09:18 0410 Use of Rank Functions to Calculate Placings 07:44 0412 WEEKDAY(...) Function: Use of WEEKDAY(...) Function 03:38 0413 OR(...) Function: Using OR(...) Function 03:06 0414 ISTEXT(...) Function: Using ISTEXT(...) Function 02:48 0415 ROW(...) and COLUMN(...) Functions 01:52 0416 INDIRECT(...) - Creating a Dependent Drop Down List in Excel 04:34 Creating Formulas that Manipulate Text 7 lectures • 30min 0501 Finding and Searching within a Text 06:02 0502 Counting Specific Characters in a Cell 02:57 0503 Counting the Occurrences of a Substring in a Cell 02:26 0504 Extracting the First and Last Words of a String 06:13 0505 Extracting All but the First Word from a Text or String 02:41 0506 Separating the First, Middle, and Last names from the Full Names 04:44 0507 Counting the Number of Words in a Cell 04:40 Project - Develop a Professional Excel Template Using Excel Formulas 8 lectures • 1hr 3min 0601 Introducing Array Formulas - How to Enter Arrays into Worksheet Cells 07:35 0602 Introducing Array Formulas - How to Create Array Formulas with Examples 05:42 0603 INDEX(...) Function in Excel 08:11 0604 VLOOKUP(...) Function in Excel 04:32 0605 Invoice Template in Excel - Part 1 07:08 0606 Invoice Template in Excel - Part 2 07:38 0607 Invoice Template in Excel - Part 3 10:39 0608 Invoice Template in Excel - Part 4 11:12 Conclusion 1 lecture • 1min Wrap-up 00:14 Learn More: A Special Offer! 1 lecture • 2min Bonus Lecture: A Special Offer for You! 01:32 Instructor Kawser Ahmed Founder ExcelDemy.com | Data Analyst 4.4 Instructor Rating 9,450 Reviews 148,254 Students 10 Courses Love to see you here. I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur. I love to make courses in the combination of both theory and practice. Monthly 100,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile). I love to learn and teach (teaching from my eighteen)! Visit my blog. You will find plenty of useful posts, articles, video tutorials, and important Excel resources. What I love most is: add some value to people around me, believe me. Here are some of my working areas: 1. Corporate Budgeting, Planning & Forecasting 2. Mission-critical financial processes 3. Month-end close processes 4. Big Data Analysis using Excel 5. Company Reports (Sales, Marketing, Administrative) 6. Large Projects using Excel VBA 7. Dashboard Design using Excel 8. And Basic Accounting I am always around you to help and support. Just contact me. 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:'67812b73e9c2f413',m:'e46b7e1a514eeb51d3fcf5ef2e3fadd616bad676-1627842963-1800-AfbWNnH4FHslJ22N+b6UFHs2fPleIhZnm1uPfiEAORK3CA7YKYUNk7c2dFqE3if/N+hS1Zg/BgP38bDm04Wg+A0rcgULggm1B9zIOFa1zrzyXZLT9JSdcgPU1QWuIF37YRXoSOLrmfuOB+bpQQcY0VFURzpOptQA/LnWl/1+pQBF39KbBZRNOyBoPu2INBpsy/IoKt7PgbLFzGlktCSEVvw=',s:[0x533ff3eabd,0xe39ed6b2d0],}})();