Excel Formulas Made Easy - Learn more than 100 Formulas

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

Course Description

Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas.

Master Excel Formulas Easily with this Comprehensive Course

  • Understand Excel formulas inside out.

  • Learn over 60 different Excel functions.

  • Write complex formulas with ease.

  • Recognise formula errors and fix common problems.

Hear What Some of our Students have Been Saying

"Great instructor and excellent way of explaining."

"Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work."

"straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example."

Learn Everything You Need to Write Formulas with Ease.

Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease.

Learning how to write formulas is an important skill for any Excel user looking to develop their talents.

Content and Overview

This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further.

The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells.

Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas.

In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past.

Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have.

Who this course is for:

  • Newbies to formulas in Excel who need to learn the formulas on their spreadsheets.
  • Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques.

Expected Outcomes

  1. Write advanced formulas for summing and counting values in a list. Use lookup functions to fetch values on a spreadsheet. Perform calculations with dates and times Use formulas to clean and prepare data for analysis. Identify and solve formula errors Requirements Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel. Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated. Description Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have. Who this course is for: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets. Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques. Show more Show less Course content 18 sections • 87 lectures • 7h 15m total length Expand all sections Introduction 2 lectures • 3min Introduction, Meet the Instructor, What to Expect Preview 03:06 Course Files - Download these files to follow along 00:06 Formulas in a Nutshell 4 lectures • 33min Getting Started with Formulas Preview 09:37 Order of Calculation Preview 06:02 Calculating Percentages Preview 06:26 Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN 10:50 Referencing Cells, Sheets and Workbooks in a Formula 5 lectures • 32min Absolute References Preview 03:54 Mixed References 03:23 Formula References to other Sheets and Workbooks 06:54 Using Defined Names in a Workbook 08:54 Formatting a Range as a Table 08:55 Using Logical Functions 4 lectures • 24min The IF Function Preview 04:47 Nesting Multiple IF Functions 05:13 Using the AND and OR Functions to Test Multiple Conditions 09:41 Taking Alternative Action to Error Values 04:46 Formulas for Summing Values 4 lectures • 15min Create a Running Total 02:53 Summing Values that Meet Specific Criteria 04:19 Summing Only the Negative Values 02:44 Summing Values that Meet Multiple Criterion 04:56 Counting Formulas 5 lectures • 19min Counting the Blank Cells in a Range 01:39 Counting the Nonblank Cells in a Range 01:49 Counting Cells that Meet Specific Criteria 06:24 Counting Cells that Meet Multiple Criterion 04:02 Counting the Unique Values in a Range 04:40 Calculating Averages 7 lectures • 21min Finding the Mean Average 01:43 Calculate the Average of Values that Meet Specific Criteria 03:07 Calculating the Average Excluding Zeros 02:52 Calculating the Average of Values that Meet Multiple Criterion 03:21 Finding the Most Frequently Occurring Value 04:14 Calculating the Median (Middle) Value in a Range 03:09 Calculating the Trimmed Mean 02:41 Specialised Functions for Summing and Counting 4 lectures • 24min The SUBTOTAL Function 04:59 The AGGREGATE Function 04:42 The Awesome SUMPRODUCT Function 07:31 Summing 'Every Nth' Row 06:49 Working with Text 7 lectures • 40min Changing the Case of Text 02:42 Removing Leading and Trailing Spaces 03:05 Joining Text from Different Cells 04:11 Extracting Text from the Start, Middle and End of a String 07:02 Extracting Text from Irregular Strings 10:06 Extracting Text from the Nth Occurrence of a Character 07:50 Counting the Number of Words in a Cell 04:45 Date Formulas 8 lectures • 40min Calculating the Current Date and Date & Time 03:31 Calculating the Number of Days Between Two Dates 03:23 Calculating the Number of Workdays Between Two Dates 06:10 Calculating the Difference Between Two Dates in Years and Months 07:24 Adding Months to a Date - EDATE and EOMONTH 04:40 Adding Working Days to a Date 05:36 Highlighting the Sundays in a List 04:41 The DATE Function 04:25 8 more sections Instructor Alan Murray Microsoft MVP, Founder of Computergaga 4.5 Instructor Rating 2,160 Reviews 17,868 Students 5 Courses Alan Murray is a Microsoft MVP and Excel trainer. He has been training for over 20 years for businesses around the world. He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials. He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses. Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 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:'67814ccc2e8d4256',m:'b69a556fcd1128d2d61497692a584ce990f03304-1627844329-1800-AWUXx8Ek6s7+/9y/4N2i7GuY8d1Vhn6uArZMoNLHL+y/HfaBJ+xOOIeBtiCuOqWe7G8/7aK/FRvM2JxRES/30p1hZqjlZGWFJ35X5DB1KmUPJ7++qXFpXY+ZBn96Q/hmLgfB5Y0U1akDSdTQhhsF3qRPMZvcFjKMlmnq47Bd4eiZ',s:[0xb93929df16,0x549309c12b],}})();
  2. Use lookup functions to fetch values on a spreadsheet. Perform calculations with dates and times Use formulas to clean and prepare data for analysis. Identify and solve formula errors Requirements Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel. Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated. Description Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have. Who this course is for: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets. Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques. Show more Show less Course content 18 sections • 87 lectures • 7h 15m total length Expand all sections Introduction 2 lectures • 3min Introduction, Meet the Instructor, What to Expect Preview 03:06 Course Files - Download these files to follow along 00:06 Formulas in a Nutshell 4 lectures • 33min Getting Started with Formulas Preview 09:37 Order of Calculation Preview 06:02 Calculating Percentages Preview 06:26 Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN 10:50 Referencing Cells, Sheets and Workbooks in a Formula 5 lectures • 32min Absolute References Preview 03:54 Mixed References 03:23 Formula References to other Sheets and Workbooks 06:54 Using Defined Names in a Workbook 08:54 Formatting a Range as a Table 08:55 Using Logical Functions 4 lectures • 24min The IF Function Preview 04:47 Nesting Multiple IF Functions 05:13 Using the AND and OR Functions to Test Multiple Conditions 09:41 Taking Alternative Action to Error Values 04:46 Formulas for Summing Values 4 lectures • 15min Create a Running Total 02:53 Summing Values that Meet Specific Criteria 04:19 Summing Only the Negative Values 02:44 Summing Values that Meet Multiple Criterion 04:56 Counting Formulas 5 lectures • 19min Counting the Blank Cells in a Range 01:39 Counting the Nonblank Cells in a Range 01:49 Counting Cells that Meet Specific Criteria 06:24 Counting Cells that Meet Multiple Criterion 04:02 Counting the Unique Values in a Range 04:40 Calculating Averages 7 lectures • 21min Finding the Mean Average 01:43 Calculate the Average of Values that Meet Specific Criteria 03:07 Calculating the Average Excluding Zeros 02:52 Calculating the Average of Values that Meet Multiple Criterion 03:21 Finding the Most Frequently Occurring Value 04:14 Calculating the Median (Middle) Value in a Range 03:09 Calculating the Trimmed Mean 02:41 Specialised Functions for Summing and Counting 4 lectures • 24min The SUBTOTAL Function 04:59 The AGGREGATE Function 04:42 The Awesome SUMPRODUCT Function 07:31 Summing 'Every Nth' Row 06:49 Working with Text 7 lectures • 40min Changing the Case of Text 02:42 Removing Leading and Trailing Spaces 03:05 Joining Text from Different Cells 04:11 Extracting Text from the Start, Middle and End of a String 07:02 Extracting Text from Irregular Strings 10:06 Extracting Text from the Nth Occurrence of a Character 07:50 Counting the Number of Words in a Cell 04:45 Date Formulas 8 lectures • 40min Calculating the Current Date and Date & Time 03:31 Calculating the Number of Days Between Two Dates 03:23 Calculating the Number of Workdays Between Two Dates 06:10 Calculating the Difference Between Two Dates in Years and Months 07:24 Adding Months to a Date - EDATE and EOMONTH 04:40 Adding Working Days to a Date 05:36 Highlighting the Sundays in a List 04:41 The DATE Function 04:25 8 more sections Instructor Alan Murray Microsoft MVP, Founder of Computergaga 4.5 Instructor Rating 2,160 Reviews 17,868 Students 5 Courses Alan Murray is a Microsoft MVP and Excel trainer. He has been training for over 20 years for businesses around the world. He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials. He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses. Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 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:'67814ccc2e8d4256',m:'b69a556fcd1128d2d61497692a584ce990f03304-1627844329-1800-AWUXx8Ek6s7+/9y/4N2i7GuY8d1Vhn6uArZMoNLHL+y/HfaBJ+xOOIeBtiCuOqWe7G8/7aK/FRvM2JxRES/30p1hZqjlZGWFJ35X5DB1KmUPJ7++qXFpXY+ZBn96Q/hmLgfB5Y0U1akDSdTQhhsF3qRPMZvcFjKMlmnq47Bd4eiZ',s:[0xb93929df16,0x549309c12b],}})();
  3. Perform calculations with dates and times Use formulas to clean and prepare data for analysis. Identify and solve formula errors Requirements Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel. Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated. Description Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have. Who this course is for: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets. Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques. Show more Show less Course content 18 sections • 87 lectures • 7h 15m total length Expand all sections Introduction 2 lectures • 3min Introduction, Meet the Instructor, What to Expect Preview 03:06 Course Files - Download these files to follow along 00:06 Formulas in a Nutshell 4 lectures • 33min Getting Started with Formulas Preview 09:37 Order of Calculation Preview 06:02 Calculating Percentages Preview 06:26 Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN 10:50 Referencing Cells, Sheets and Workbooks in a Formula 5 lectures • 32min Absolute References Preview 03:54 Mixed References 03:23 Formula References to other Sheets and Workbooks 06:54 Using Defined Names in a Workbook 08:54 Formatting a Range as a Table 08:55 Using Logical Functions 4 lectures • 24min The IF Function Preview 04:47 Nesting Multiple IF Functions 05:13 Using the AND and OR Functions to Test Multiple Conditions 09:41 Taking Alternative Action to Error Values 04:46 Formulas for Summing Values 4 lectures • 15min Create a Running Total 02:53 Summing Values that Meet Specific Criteria 04:19 Summing Only the Negative Values 02:44 Summing Values that Meet Multiple Criterion 04:56 Counting Formulas 5 lectures • 19min Counting the Blank Cells in a Range 01:39 Counting the Nonblank Cells in a Range 01:49 Counting Cells that Meet Specific Criteria 06:24 Counting Cells that Meet Multiple Criterion 04:02 Counting the Unique Values in a Range 04:40 Calculating Averages 7 lectures • 21min Finding the Mean Average 01:43 Calculate the Average of Values that Meet Specific Criteria 03:07 Calculating the Average Excluding Zeros 02:52 Calculating the Average of Values that Meet Multiple Criterion 03:21 Finding the Most Frequently Occurring Value 04:14 Calculating the Median (Middle) Value in a Range 03:09 Calculating the Trimmed Mean 02:41 Specialised Functions for Summing and Counting 4 lectures • 24min The SUBTOTAL Function 04:59 The AGGREGATE Function 04:42 The Awesome SUMPRODUCT Function 07:31 Summing 'Every Nth' Row 06:49 Working with Text 7 lectures • 40min Changing the Case of Text 02:42 Removing Leading and Trailing Spaces 03:05 Joining Text from Different Cells 04:11 Extracting Text from the Start, Middle and End of a String 07:02 Extracting Text from Irregular Strings 10:06 Extracting Text from the Nth Occurrence of a Character 07:50 Counting the Number of Words in a Cell 04:45 Date Formulas 8 lectures • 40min Calculating the Current Date and Date & Time 03:31 Calculating the Number of Days Between Two Dates 03:23 Calculating the Number of Workdays Between Two Dates 06:10 Calculating the Difference Between Two Dates in Years and Months 07:24 Adding Months to a Date - EDATE and EOMONTH 04:40 Adding Working Days to a Date 05:36 Highlighting the Sundays in a List 04:41 The DATE Function 04:25 8 more sections Instructor Alan Murray Microsoft MVP, Founder of Computergaga 4.5 Instructor Rating 2,160 Reviews 17,868 Students 5 Courses Alan Murray is a Microsoft MVP and Excel trainer. He has been training for over 20 years for businesses around the world. He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials. He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses. Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 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:'67814ccc2e8d4256',m:'b69a556fcd1128d2d61497692a584ce990f03304-1627844329-1800-AWUXx8Ek6s7+/9y/4N2i7GuY8d1Vhn6uArZMoNLHL+y/HfaBJ+xOOIeBtiCuOqWe7G8/7aK/FRvM2JxRES/30p1hZqjlZGWFJ35X5DB1KmUPJ7++qXFpXY+ZBn96Q/hmLgfB5Y0U1akDSdTQhhsF3qRPMZvcFjKMlmnq47Bd4eiZ',s:[0xb93929df16,0x549309c12b],}})();
  4. Use formulas to clean and prepare data for analysis. Identify and solve formula errors Requirements Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel. Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated. Description Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have. Who this course is for: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets. Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques. Show more Show less Course content 18 sections • 87 lectures • 7h 15m total length Expand all sections Introduction 2 lectures • 3min Introduction, Meet the Instructor, What to Expect Preview 03:06 Course Files - Download these files to follow along 00:06 Formulas in a Nutshell 4 lectures • 33min Getting Started with Formulas Preview 09:37 Order of Calculation Preview 06:02 Calculating Percentages Preview 06:26 Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN 10:50 Referencing Cells, Sheets and Workbooks in a Formula 5 lectures • 32min Absolute References Preview 03:54 Mixed References 03:23 Formula References to other Sheets and Workbooks 06:54 Using Defined Names in a Workbook 08:54 Formatting a Range as a Table 08:55 Using Logical Functions 4 lectures • 24min The IF Function Preview 04:47 Nesting Multiple IF Functions 05:13 Using the AND and OR Functions to Test Multiple Conditions 09:41 Taking Alternative Action to Error Values 04:46 Formulas for Summing Values 4 lectures • 15min Create a Running Total 02:53 Summing Values that Meet Specific Criteria 04:19 Summing Only the Negative Values 02:44 Summing Values that Meet Multiple Criterion 04:56 Counting Formulas 5 lectures • 19min Counting the Blank Cells in a Range 01:39 Counting the Nonblank Cells in a Range 01:49 Counting Cells that Meet Specific Criteria 06:24 Counting Cells that Meet Multiple Criterion 04:02 Counting the Unique Values in a Range 04:40 Calculating Averages 7 lectures • 21min Finding the Mean Average 01:43 Calculate the Average of Values that Meet Specific Criteria 03:07 Calculating the Average Excluding Zeros 02:52 Calculating the Average of Values that Meet Multiple Criterion 03:21 Finding the Most Frequently Occurring Value 04:14 Calculating the Median (Middle) Value in a Range 03:09 Calculating the Trimmed Mean 02:41 Specialised Functions for Summing and Counting 4 lectures • 24min The SUBTOTAL Function 04:59 The AGGREGATE Function 04:42 The Awesome SUMPRODUCT Function 07:31 Summing 'Every Nth' Row 06:49 Working with Text 7 lectures • 40min Changing the Case of Text 02:42 Removing Leading and Trailing Spaces 03:05 Joining Text from Different Cells 04:11 Extracting Text from the Start, Middle and End of a String 07:02 Extracting Text from Irregular Strings 10:06 Extracting Text from the Nth Occurrence of a Character 07:50 Counting the Number of Words in a Cell 04:45 Date Formulas 8 lectures • 40min Calculating the Current Date and Date & Time 03:31 Calculating the Number of Days Between Two Dates 03:23 Calculating the Number of Workdays Between Two Dates 06:10 Calculating the Difference Between Two Dates in Years and Months 07:24 Adding Months to a Date - EDATE and EOMONTH 04:40 Adding Working Days to a Date 05:36 Highlighting the Sundays in a List 04:41 The DATE Function 04:25 8 more sections Instructor Alan Murray Microsoft MVP, Founder of Computergaga 4.5 Instructor Rating 2,160 Reviews 17,868 Students 5 Courses Alan Murray is a Microsoft MVP and Excel trainer. He has been training for over 20 years for businesses around the world. He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials. He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses. Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 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:'67814ccc2e8d4256',m:'b69a556fcd1128d2d61497692a584ce990f03304-1627844329-1800-AWUXx8Ek6s7+/9y/4N2i7GuY8d1Vhn6uArZMoNLHL+y/HfaBJ+xOOIeBtiCuOqWe7G8/7aK/FRvM2JxRES/30p1hZqjlZGWFJ35X5DB1KmUPJ7++qXFpXY+ZBn96Q/hmLgfB5Y0U1akDSdTQhhsF3qRPMZvcFjKMlmnq47Bd4eiZ',s:[0xb93929df16,0x549309c12b],}})();
  5. Identify and solve formula errors Requirements Only a basic use of Excel is required as this course starts from scratch in understanding and creating formulas in Excel. Excel 2013 is used on the course, but the lessons apply to any version of Excel. When a formula is new to a specific version of Excel this will be stated. Description Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas. Master Excel Formulas Easily with this Comprehensive Course Understand Excel formulas inside out. Learn over 60 different Excel functions. Write complex formulas with ease. Recognise formula errors and fix common problems. Hear What Some of our Students have Been Saying "Great instructor and excellent way of explaining." "Brilliant course! Finally a course that leaves you understanding everything without needing to review a dozen times. I have reviewed and learned much more from this easy to follow course due to the step by step tutorials and its clear, engaging delivery by an excellent and knowledgeable instructor. It has helped me understand more formulas in excel that can help me with my business. Many thanks to all involved and keep up the great work." "straight to the point, clear explanation and demo, use common sense language to interpret the formula, and simple and easy illustrative example." Learn Everything You Need to Write Formulas with Ease . Formulas are what drive Excel. They are the muscles allowing users to manipulate, lookup, aggregate and test data with ease. Learning how to write formulas is an important skill for any Excel user looking to develop their talents. Content and Overview This course was designed for anybody who needs to be able to confidently work with formulas in Excel. It is suitable both for complete beginners who want to start from the basics, and for those that have some experience but want to take things further. The course is broken into different sections. It starts with building an understanding of the different elements of a formula, what the various symbols mean, some basic functions and different techniques for referencing cells. Each section then focuses on a specific function category such as date or lookup functions. It starts to take things further by tackling mini projects and looking at more advanced formulas. In over 80 lectures this course will teach you all the necessary skills to write advanced formulas with ease, and make those formula demons a thing of the past. Working files are provided so that you can follow along and practice. You can also get assistance from myself with any queries you may have. Who this course is for: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets. Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques. Show more Show less Course content 18 sections • 87 lectures • 7h 15m total length Expand all sections Introduction 2 lectures • 3min Introduction, Meet the Instructor, What to Expect Preview 03:06 Course Files - Download these files to follow along 00:06 Formulas in a Nutshell 4 lectures • 33min Getting Started with Formulas Preview 09:37 Order of Calculation Preview 06:02 Calculating Percentages Preview 06:26 Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN 10:50 Referencing Cells, Sheets and Workbooks in a Formula 5 lectures • 32min Absolute References Preview 03:54 Mixed References 03:23 Formula References to other Sheets and Workbooks 06:54 Using Defined Names in a Workbook 08:54 Formatting a Range as a Table 08:55 Using Logical Functions 4 lectures • 24min The IF Function Preview 04:47 Nesting Multiple IF Functions 05:13 Using the AND and OR Functions to Test Multiple Conditions 09:41 Taking Alternative Action to Error Values 04:46 Formulas for Summing Values 4 lectures • 15min Create a Running Total 02:53 Summing Values that Meet Specific Criteria 04:19 Summing Only the Negative Values 02:44 Summing Values that Meet Multiple Criterion 04:56 Counting Formulas 5 lectures • 19min Counting the Blank Cells in a Range 01:39 Counting the Nonblank Cells in a Range 01:49 Counting Cells that Meet Specific Criteria 06:24 Counting Cells that Meet Multiple Criterion 04:02 Counting the Unique Values in a Range 04:40 Calculating Averages 7 lectures • 21min Finding the Mean Average 01:43 Calculate the Average of Values that Meet Specific Criteria 03:07 Calculating the Average Excluding Zeros 02:52 Calculating the Average of Values that Meet Multiple Criterion 03:21 Finding the Most Frequently Occurring Value 04:14 Calculating the Median (Middle) Value in a Range 03:09 Calculating the Trimmed Mean 02:41 Specialised Functions for Summing and Counting 4 lectures • 24min The SUBTOTAL Function 04:59 The AGGREGATE Function 04:42 The Awesome SUMPRODUCT Function 07:31 Summing 'Every Nth' Row 06:49 Working with Text 7 lectures • 40min Changing the Case of Text 02:42 Removing Leading and Trailing Spaces 03:05 Joining Text from Different Cells 04:11 Extracting Text from the Start, Middle and End of a String 07:02 Extracting Text from Irregular Strings 10:06 Extracting Text from the Nth Occurrence of a Character 07:50 Counting the Number of Words in a Cell 04:45 Date Formulas 8 lectures • 40min Calculating the Current Date and Date & Time 03:31 Calculating the Number of Days Between Two Dates 03:23 Calculating the Number of Workdays Between Two Dates 06:10 Calculating the Difference Between Two Dates in Years and Months 07:24 Adding Months to a Date - EDATE and EOMONTH 04:40 Adding Working Days to a Date 05:36 Highlighting the Sundays in a List 04:41 The DATE Function 04:25 8 more sections Instructor Alan Murray Microsoft MVP, Founder of Computergaga 4.5 Instructor Rating 2,160 Reviews 17,868 Students 5 Courses Alan Murray is a Microsoft MVP and Excel trainer. He has been training for over 20 years for businesses around the world. He is the founder of the Computergaga blog and YouTube channel. It has over 530 videos and more than 28 million views. He regularly shares new Excel tips and tutorials. He is the author of the "Advanced Excel Success" book, showing hwo to get to the next level in your Excel jurney. Alan uses a fun and relaxed style of training that gets to the point and uses real-world practical examples uncovered from his experience of training and developing software for businesses. Files are provided to follow along and exercises used to recap on topics covered. Alan is always eager to help and will be there for you when needed. He will do his best to answer any question or query related to his courses within 48 hours. 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:'67814ccc2e8d4256',m:'b69a556fcd1128d2d61497692a584ce990f03304-1627844329-1800-AWUXx8Ek6s7+/9y/4N2i7GuY8d1Vhn6uArZMoNLHL+y/HfaBJ+xOOIeBtiCuOqWe7G8/7aK/FRvM2JxRES/30p1hZqjlZGWFJ35X5DB1KmUPJ7++qXFpXY+ZBn96Q/hmLgfB5Y0U1akDSdTQhhsF3qRPMZvcFjKMlmnq47Bd4eiZ',s:[0xb93929df16,0x549309c12b],}})();