Microsoft Excel 2013 Advanced. Online Excel Training Course

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

Course Description

Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite

Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including:

  • IF statements
  • VLOOKUP and HLOOKUP
  • Sparklines
  • Pivot Tables and Charts
  • Macro Operations

The Ability to Master Excel

By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Content and Overview

Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment.

Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course.

Who this course is for:

  • Users with a basic knowledge of Excel
  • Users who have completed our Beginners / Intermediate Excel title
  • To gain a solid understanding of the more powerful features and functions in Excel To be able to use Microsoft Excel in a commercial environment Requirements Microsoft Excel 2013, Windows 8, 7, Vista or XP Description Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including: IF statements VLOOKUP and HLOOKUP Sparklines Pivot Tables and Charts Macro Operations The Ability to Master Excel By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process. Content and Overview Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment. Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course. Who this course is for: Users with a basic knowledge of Excel Users who have completed our Beginners / Intermediate Excel title Show more Show less Course content 19 sections • 128 lectures • 9h 52m total length Expand all sections Getting Started 5 lectures • 14min Working Files - Download These First 00:01 0101 Will I Be Able To Keep Up? Preview 03:57 0102 Using The Included Files 01:17 0103 New For 2013: Its All In The Cloud 04:03 0104 The Very Clever Flash Fill Preview 04:13 Using Mathematical Functions 7 lectures • 32min 0201 The Basic SUM, COUNT, MIN, And MAX Preview 03:39 0202 AVERAGE, MODE, MEAN, And MEDIAN 04:04 0203 SUMIF For Selective Adding Up Preview 06:30 0204 COUNTIF For Selective Counting 03:18 0205 AVERAGEIF For The Mean Of Selected Cells 03:29 0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF 07:06 0207 Area And Volume Calculations 04:09 IF Functionality 6 lectures • 35min 0301 IF Syntax And Uses 07:55 0302 Nesting The IF Statement Preview 07:26 0303 Use Of The AND Operator Within An IF 06:29 0304 Use Of The OR Operator Within An IF 04:03 0305 The NOT Operator Within AND And OR Statements Preview 04:28 0306 Display Cell Formulas In Another Cell 04:11 Performing Data Lookups 7 lectures • 37min 0401 VLOOKUP: Syntax And Usage Preview 04:51 0402 VLOOKUP In Live Action 06:53 0403 HLOOKUP: Variation On A Theme 04:42 0404 Using A Near Match In The Lookup 03:44 0405 Dealing With Missing Data In A Lookup Preview 04:55 0406 Managing The Lookup Table 05:03 0407 Lookups Nested Within Lookups 06:29 Sparklines 5 lectures • 18min 0501 Creating A Sparkline 04:58 0502 Altering The Design Of Sparklines 04:26 0503 Dealing With Empty Cells 02:24 0504 Comparing Sparklines Within A Sparkline Group 04:18 0505 Removing Sparklines From A Worksheet 02:14 Further Mathematical Functions 8 lectures • 44min 0601 Working With Time In Excel 10:20 0602 Calculations Using Time 03:58 0603 Useful Time And Date Functions 04:45 0604 Rounding Decimal Places 04:32 0605 MOD And INT Functions And Uses 04:42 0606 Generate And Use A Random Number 05:36 0607 Loan And Investment Calculations 05:58 0608 Loan Calculation Elements And Functions 04:04 Outlining 3 lectures • 14min 0701 Create An Outline Automatically 03:47 0702 Adding An Outline Manually 03:22 0703 Editing And Removing Outlining 06:39 Scenarios 5 lectures • 22min 0801 Setting Up A Set Of Scenarios 06:59 0802 Displaying And Editing The Different Scenarios 03:12 0803 How To Work Out Which Scenario You Are Displaying 04:06 0804 Merging And Deleting Scenarios 03:41 0805 Producing A Summary Of Scenarios 03:52 Custom Views 4 lectures • 15min 0901 Custom Views Explained 03:03 0902 Use Of Outlining To Help Setup Custom Views 03:56 0903 Editing And Deleting Custom Views 04:25 0904 Add Quick Access To Custom Views 03:30 Functions For Manipulating Text 9 lectures • 47min 1001 LEFT And RIGHT: Text Manipulation 04:28 1002 LEN And TRIM: String Extractions 06:34 1003 FIND And MID: Text Functions Working Together 06:53 1004 CONCATENATE: Building Strings From Multiple Cells 05:23 1005 Changing Case Functions 04:03 1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions 04:42 1007 Use Of CHAR Function For More Obscure Characters 06:12 1008 Formatting Numeric And Date Values Using TEXT 05:01 1009 Keeping The Values Created By String Manipulation 03:21 9 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'6780ff14bcca547b',m:'b8ea1b2ae9510f6d1089c2aacb9aa2da9a90a060-1627841147-1800-AVe8q8lyvxZMSfIeFg8sFI3EjHc5CImCuX5faHoHYpRnsiHwcGGLkooxvnKU/OkndsW4OnQy3vIJjannFey7sccww6wLoAqDkOomqTgfQ3pzN1F4WhX5Owf3FthBYEBXw/4QPUHUVhuQeTmABRm3G1M3h+VykzOXhGKfvlENKM++i3eGjToeqPcrcdxvg8QYhg==',s:[0x1def7b6385,0x42643a5183],}})();
  • To be able to use Microsoft Excel in a commercial environment Requirements Microsoft Excel 2013, Windows 8, 7, Vista or XP Description Learn the expert features and functions in Microsoft Excel 2013, alongside our expert author, to help you get you beyond the basics and have advanced-level proficiency within the Excel 2013 suite Whilst in this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements, we’ll quickly move onto more advanced-level topics including: IF statements VLOOKUP and HLOOKUP Sparklines Pivot Tables and Charts Macro Operations The Ability to Master Excel By the completion of this computer based advanced Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer. With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process. Content and Overview Suitable for beginners with Microsoft Excel (as we’ll cover the basics early on) but also for those who wish to cover the advanced topics in Excel. Through the course of 128 lectures and 10+ hours of content, you’ll learn all of the basic and advanced items of Excel, which will enable you to use Excel expertly within in a personal or commercial environment. Complete with working files and code samples, you’ll be able to follow along with the author throughout the lessons, and will receive a verifiable certificate of completion upon finishing the course. Who this course is for: Users with a basic knowledge of Excel Users who have completed our Beginners / Intermediate Excel title Show more Show less Course content 19 sections • 128 lectures • 9h 52m total length Expand all sections Getting Started 5 lectures • 14min Working Files - Download These First 00:01 0101 Will I Be Able To Keep Up? Preview 03:57 0102 Using The Included Files 01:17 0103 New For 2013: Its All In The Cloud 04:03 0104 The Very Clever Flash Fill Preview 04:13 Using Mathematical Functions 7 lectures • 32min 0201 The Basic SUM, COUNT, MIN, And MAX Preview 03:39 0202 AVERAGE, MODE, MEAN, And MEDIAN 04:04 0203 SUMIF For Selective Adding Up Preview 06:30 0204 COUNTIF For Selective Counting 03:18 0205 AVERAGEIF For The Mean Of Selected Cells 03:29 0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF 07:06 0207 Area And Volume Calculations 04:09 IF Functionality 6 lectures • 35min 0301 IF Syntax And Uses 07:55 0302 Nesting The IF Statement Preview 07:26 0303 Use Of The AND Operator Within An IF 06:29 0304 Use Of The OR Operator Within An IF 04:03 0305 The NOT Operator Within AND And OR Statements Preview 04:28 0306 Display Cell Formulas In Another Cell 04:11 Performing Data Lookups 7 lectures • 37min 0401 VLOOKUP: Syntax And Usage Preview 04:51 0402 VLOOKUP In Live Action 06:53 0403 HLOOKUP: Variation On A Theme 04:42 0404 Using A Near Match In The Lookup 03:44 0405 Dealing With Missing Data In A Lookup Preview 04:55 0406 Managing The Lookup Table 05:03 0407 Lookups Nested Within Lookups 06:29 Sparklines 5 lectures • 18min 0501 Creating A Sparkline 04:58 0502 Altering The Design Of Sparklines 04:26 0503 Dealing With Empty Cells 02:24 0504 Comparing Sparklines Within A Sparkline Group 04:18 0505 Removing Sparklines From A Worksheet 02:14 Further Mathematical Functions 8 lectures • 44min 0601 Working With Time In Excel 10:20 0602 Calculations Using Time 03:58 0603 Useful Time And Date Functions 04:45 0604 Rounding Decimal Places 04:32 0605 MOD And INT Functions And Uses 04:42 0606 Generate And Use A Random Number 05:36 0607 Loan And Investment Calculations 05:58 0608 Loan Calculation Elements And Functions 04:04 Outlining 3 lectures • 14min 0701 Create An Outline Automatically 03:47 0702 Adding An Outline Manually 03:22 0703 Editing And Removing Outlining 06:39 Scenarios 5 lectures • 22min 0801 Setting Up A Set Of Scenarios 06:59 0802 Displaying And Editing The Different Scenarios 03:12 0803 How To Work Out Which Scenario You Are Displaying 04:06 0804 Merging And Deleting Scenarios 03:41 0805 Producing A Summary Of Scenarios 03:52 Custom Views 4 lectures • 15min 0901 Custom Views Explained 03:03 0902 Use Of Outlining To Help Setup Custom Views 03:56 0903 Editing And Deleting Custom Views 04:25 0904 Add Quick Access To Custom Views 03:30 Functions For Manipulating Text 9 lectures • 47min 1001 LEFT And RIGHT: Text Manipulation 04:28 1002 LEN And TRIM: String Extractions 06:34 1003 FIND And MID: Text Functions Working Together 06:53 1004 CONCATENATE: Building Strings From Multiple Cells 05:23 1005 Changing Case Functions 04:03 1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions 04:42 1007 Use Of CHAR Function For More Obscure Characters 06:12 1008 Formatting Numeric And Date Values Using TEXT 05:01 1009 Keeping The Values Created By String Manipulation 03:21 9 more sections Instructor Infinite Skills High Quality Training 4.3 Instructor Rating 120,217 Reviews 1,254,639 Students 327 Courses Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. 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:'6780ff14bcca547b',m:'b8ea1b2ae9510f6d1089c2aacb9aa2da9a90a060-1627841147-1800-AVe8q8lyvxZMSfIeFg8sFI3EjHc5CImCuX5faHoHYpRnsiHwcGGLkooxvnKU/OkndsW4OnQy3vIJjannFey7sccww6wLoAqDkOomqTgfQ3pzN1F4WhX5Owf3FthBYEBXw/4QPUHUVhuQeTmABRm3G1M3h+VykzOXhGKfvlENKM++i3eGjToeqPcrcdxvg8QYhg==',s:[0x1def7b6385,0x42643a5183],}})();