Microsoft Excel Intermediate to Advanced - Step by Step

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

Course Description

Are you looking to improve your Excel skills to become an advanced level user?

This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel.

In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK.

Microsoft Excel - Fundamentals of Advanced Level Users

  • Paste Special

  • Conditional Formatting

  • Locking and Protection

  • Advanced Charts

  • Data Validation

  • Scenarios

  • Formula Auditing and Comments

  • Subtotalling

  • Sparklines

  • Filtering and Advanced Filtering

  • Pivot Tables and Pivot Charts

  • Named Cells and Named Ranges

  • Mixed Cell Referencing

  • Mathematical & Statistical Functions

  • Vlookup Function

  • Nested Functions

  • Database Functions

  • Text Functions

  • Date Functions and Calculations

Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place. In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master!

See you there!

-Richard Walters (Microsoft Excel Trainer)

__________

Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project.

Who this course is for:

  • Existing Excel users looking to improve their skill base.
  • Self-taught learners looking to improve Excel working knowledge.

Course content

2 sections • 19 lectures • 4h 47m total length
  • Conditional Formatting
    18:19
  • Locking and Protection
    17:00
  • Advanced Charts
    18:48
  • Data Validation
    12:06
  • Scenarios
    19:00
  • Subtotalling
    13:27
  • Sparklines
    07:48
  • Filtering and Advanced Filtering
    15:44
  • Pivot Tables and Pivot Charts
    16:04

Instructor

Learn online IT skills, anywhere, anytime.
  • 4.5 Instructor Rating
  • 96 Reviews
  • 369 Students
  • 14 Courses

Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime!

Expected Outcomes

  1. Use the paste special feature Apply conditional formatting to cells Lock and protect worksheets Create advanced charts Audit and apply comments to data Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  2. Apply conditional formatting to cells Lock and protect worksheets Create advanced charts Audit and apply comments to data Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  3. Lock and protect worksheets Create advanced charts Audit and apply comments to data Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  4. Create advanced charts Audit and apply comments to data Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  5. Audit and apply comments to data Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  6. Apply filter and advanced filter techniques Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  7. Create pivot tables Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();
  8. Use Functions (Vlookup, Nested, Text, Date, etc.) Requirements A familiarity with all skills covered in our previous video, Microsoft Excel - The Beginners Introduction To Excel Description Are you looking to improve your Excel skills to become an advanced level user? This course gives you a deep understanding of how to use some of the the advanced level features in Microsoft Excel. We will assume you have all the knowledge taught in our prerequisite course, Microsoft Excel - The Beginners Introduction To Excel. In this course we will cover a variety of advanced level Functions, Advanced Charts, Paste Special, Scenario's Formulas Auditing and Locking and Security . Most lectures are 10 - 18 minutes long, with no lecture being over 20 minutes in length. Your trainer for this course, Richard Walters, is a Microsoft Certified Trainer who has been training Microsoft Excel for the past 9 years throughout the UK. Microsoft Excel - Fundamentals of Advanced Level Users Paste Special Conditional Formatting Locking and Protection Advanced Charts Data Validation Scenarios Formula Auditing and Comments Subtotalling Sparklines Filtering and Advanced Filtering Pivot Tables and Pivot Charts Named Cells and Named Ranges Mixed Cell Referencing Mathematical & Statistical Functions Vlookup Function Nested Functions Database Functions Text Functions Date Functions and Calculations Whether you're looking for a quick overview on the Excel Formulas, or hoping to step up your Paste Special game in a major way, you've come to the right place . In today's increasingly data-driven world, Excel makes it easy and intuitive to view and analyse data. Enrol today and start your journey to becoming a Excel master! See you there! -Richard Walters ( Microsoft Excel Trainer ) __________ Richard is a professional trainer with more than a decade of experience as an IT and business skills trainer, with a very advanced understanding of all Microsoft Office packages, particularly Excel, Word, PowerPoint, Visio and Project. Who this course is for: Existing Excel users looking to improve their skill base. Self-taught learners looking to improve Excel working knowledge. Show more Show less Course content 2 sections • 19 lectures • 4h 47m total length Expand all sections Excel Fundamentals 10 lectures • 2hr 37min Paste Special Preview 18:49 Conditional Formatting 18:19 Locking and Protection 17:00 Advanced Charts 18:48 Data Validation 12:06 Scenarios 19:00 Subtotalling 13:27 Sparklines 07:48 Filtering and Advanced Filtering 15:44 Pivot Tables and Pivot Charts 16:04 Excel Functions 9 lectures • 2hr 11min Mathematical & Statistical Functions 13:42 Vlookup Function 17:08 Nested Functions 17:15 Database Functions 11:06 Text Functions 14:49 Date Functions and Calculations 09:30 Named Cells and Named Ranges 16:23 Mixed Cell Referencing 16:27 Formula Auditing and Comments 14:32 Instructor Office Skills Learn online IT skills, anywhere, anytime. 4.5 Instructor Rating 96 Reviews 369 Students 14 Courses Since 2014, Office Skills has been providing individuals and organisations across the UK with online based training from our portfolio of 500+ courses, delivered by expert instructors. Our skills and training knowledge mean we're fortunate enough to be one of the UK's leading provider of professional training courses and we're working to bring this knowledge online, allowing you to learn anywhere, anytime! 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:'6781c2c2eab24251',m:'e448859332b6a59e2f107135d0293a1e108c1560-1627849161-1800-AS9+hlBGzIslLYnyFGVmjqSyogW7/LJgsrJm577fZ1qjMwsiiN6jXUWupJchTVdk3RxLgxtUrKPOyhGhWweq9DnGbI/UBpl6yXZ0Rqk8UG/KdJxzg79HkNWLxYZwnX8Ek2N2tySYkt+WcMS75Y3qpU8n2XI2B2p2eCJV8e6CwYiYbYRXj778wjbQ5Cxdc7YlWQ==',s:[0x045969ba4e,0x3f8860bbcc],}})();