Microsoft Excel-Green to Guru (Novice-Intermediate course)

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

Course Description

Are you one of the many – afraid to start learning about Excel because you think it is ‘too technical’? So many people I meet in training think that there will always be someone at their company who is better than they are in Excel. What if I told you that you could become that expert within your company in only 8 hours or less?

Your computer or tech proficiency doesn’t matter, the Green to Guru course has been tried and tested across many different industries and skill levels – you WILL become the Guru for your company if you follow this curriculum.

This interactive learningexperience encourages student participation and engagement every step of the way, with examples of each technique in action.

Course Features:

  • Learn the three fastest ways to Navigate Excel like a pro
  • Learn how to Input, Sort & Filter and manipulate data of all kinds in Excel
  • Master the methods of Formatting, creating Charts and designing beautiful spreadsheets
  • Learn to Maneuver through Excel's Menus with ease to locate any command quickly and efficiently
  • Grasp the knowledge of Excel’s many Functions and how to employ them to do your bidding at will
  • Acquire the skills of Spellcheck, Verifying data, Translation, Protecting worksheets and more.
  • Master the many Keyboard shortcuts of Excel through practical application to become a Guru of efficiency
  • Become a Wizard with any spreadsheet quickly by learning the Fundamentals and Advanced techniques of Excel in a logical fashion
  • Harness the power to create functional resources in Excel to skyrocket productivity at any company
  • Change your life for the better by becoming one of Excel’s Elite – a true GURU!

As a Certified Excel Instructor, I understand the importance of being available for all my students 7 days a week, responding to questions and emails quickly and with detail. There will even be an FAQ section at the end of course 2 where I will answer each months most frequently answered question with Video and Tutorial explaining the solutions.

Upon completion of the course, ALL students who complete and submit the required exercises (in this and the Intermediate to Advanced course) will receive a signed, verified Excel Guru certificate to let the world know- you are one of Excel’s Elite!

Who this course is for:

  • Beginner to Intemediate Excel users looking to hone their skills to the highest level

Expected Outcomes

  1. Drastically Increase your value as an employee or prospect by taking your Excel wizardry to the next level Create comprehensive Excel solutions to Solve any problem Generate graphs and make sense of any data Requirements Excel 2010, 2013 and 2016 Desire to become an Excel power-user Description Are you one of the many – afraid to start learning about Excel because you think it is ‘too technical’? So many people I meet in training think that there will always be someone at their company who is better than they are in Excel. What if I told you that you could become that expert within your company in only 8 hours or less? Your computer or tech proficiency doesn’t matter, the Green to Guru course has been tried and tested across many different industries and skill levels – you WILL become the Guru for your company if you follow this curriculum. This interactive learningexperience encourages student participation and engagement every step of the way, with examples of each technique in action. Course Features: Learn the three fastest ways to Navigate Excel like a pro Learn how to Input , Sort & Filter and manipulate data of all kinds in Excel Master the methods of Formatting , creating Charts and designing beautiful spreadsheets Learn to Maneuver through Excel's Menus with ease to locate any command quickly and efficiently Grasp the knowledge of Excel’s many Functions and how to employ them to do your bidding at will Acquire the skills of Spellcheck , Verifying data , Translation , Protecting worksheets and more. Master the many Keyboard shortcuts of Excel through practical application to become a Guru of efficiency Become a Wizard with any spreadsheet quickly by learning the Fundamentals and Advanced techniques of Excel in a logical fashion Harness the power to create functional resources in Excel to skyrocket productivity at any company Change your life for the better by becoming one of Excel’s Elite – a true GURU! As a Certified Excel Instructor, I understand the importance of being available for all my students 7 days a week, responding to questions and emails quickly and with detail. There will even be an FAQ section at the end of course 2 where I will answer each months most frequently answered question with Video and Tutorial explaining the solutions. Upon completion of the course, ALL students who complete and submit the required exercises (in this and the Intermediate to Advanced course) will receive a signed, verified Excel Guru certificate to let the world know- you are one of Excel’s Elite! Who this course is for: Beginner to Intemediate Excel users looking to hone their skills to the highest level Show more Show less Course content 8 sections • 35 lectures • 4h 12m total length Expand all sections The Basics 7 lectures • 27min Getting Started Quick Guide Preview 01:45 Introduction to the Green to Guru Curriculum 04:57 What are Workbooks and Worksheets? 02:00 Rows and Columns 02:05 Selecting Rows & Columns Preview 02:42 Excel Window 101: Zoom & Page View Options 05:35 Intro to Excel Ribbon & Menus 08:20 Navigation 2 lectures • 12min Basic Navigation Techniques 09:05 Ninja ShortCutz: Keyboard Navigation 02:59 Basic Navigation Quiz 4 questions Basic Formatting 3 lectures • 22min Basic Formatting 07:52 Basic Formatting Pt. 2 09:31 Formatting Dates 05:06 Entering & Editing Data in Excel 6 lectures • 56min Entering Data in Excel 07:01 Editing in Excel: Cut, Copy & Paste pt. 1 06:00 Cut, Copy & Paste: Paste Options Explained 17:24 Sort & Filter Preview 10:33 Conditional Formatting 06:25 Entering & Editing Data & Text (Basics Review) 08:42 Basics Level Test-Out 7 questions Level 2 - Basic to Intermediate 4 lectures • 32min Managing Workbooks 1: The Backstage View 11:50 Backstage Menu Recap 00:19 Worksheet Management 07:47 Searching your Spreadsheets: The Find & Select Feature 11:38 Intro to Formulas and Functions 8 lectures • 1hr 7min Intro to Formulas: Part 1 10:26 Intro to Formulas: Part 2 (Order of Operations) 08:34 Function AutoComplete (why its awesome) 08:49 The Fill Handle 09:03 Intro to Functions (& The SUM Function) 10:39 COUNT & COUNTA Functions 05:09 MAX, MIN and AVERAGE Functions 05:58 Essential Functions: Intro to IF 07:52 Formulas & Functions Quiz 8 questions Visualizing Data: Charts, Tables & more 3 lectures • 36min Charts 101 09:11 Charts 201: Chart Formatting & Options 15:39 Creating a Table 11:29 Final Exam and Exercises Re-cap 2 lectures • 1min Required Exercise Recap 00:11 Final Exam 11 questions Final Exercises 00:09 Instructor Pat Excel Certified MS Excel Specialist / Reporting Guru 4.6 Instructor Rating 15 Reviews 2,361 Students 1 Course As a Worksource coordinator in Los Angeles county, I took the initiative to begin teaching Microsoft Office to underprivileged youth and low-income homeless populations at New Image Shelter in Los Angeles. It brought me great joy being able to help those with little hope find confidence in their abilities and cultivate employment opportunities. As the coordinator of the Worksource program at a shelter serving about 1,000 per night, I was able to implement a new course curriculum which resulted in over 100 homeless receiving employment in various fields over the course of just 1 year. From there, I went on to take more courses and hone my skills with the Microsoft Office suite which is where I better realized my propensity and aptitude with Microsoft Excel. Now working for the world's second largest Music Publishing company, I have been able to create useful forms and solutions to decades old problems simply by using MS Excel. In 2 short years, I have been twice promoted and am now Supervisor of Customer Support and corporate reporting for the company. 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:'6781b71ad8e8ce1b',m:'6f5e5cea722dd02476f347f7f5fdfee3cfbebe09-1627848683-1800-AVhIXyxbUuSeCAw5nSuWMt/bs2XziTiqXFvFBocsidpubN3kUxuHIDMoT5Q0zeKhP81sKq6SP6uCkNB+su8NwRMryGasJCz2LKSV3q43M9BJeK1Sf4dupmTM6CkZr59S7Z1vJnuoQXnFpxDOOkx3K9eqNuhu8+165FZEMzN0rcgxOdPtVlfpp4FeCqehr98Imcun0+vDahCuVXu/3QClOCk=',s:[0xe999be0d1c,0x8c4eb1a70d],}})();
  2. Create comprehensive Excel solutions to Solve any problem Generate graphs and make sense of any data Requirements Excel 2010, 2013 and 2016 Desire to become an Excel power-user Description Are you one of the many – afraid to start learning about Excel because you think it is ‘too technical’? So many people I meet in training think that there will always be someone at their company who is better than they are in Excel. What if I told you that you could become that expert within your company in only 8 hours or less? Your computer or tech proficiency doesn’t matter, the Green to Guru course has been tried and tested across many different industries and skill levels – you WILL become the Guru for your company if you follow this curriculum. This interactive learningexperience encourages student participation and engagement every step of the way, with examples of each technique in action. Course Features: Learn the three fastest ways to Navigate Excel like a pro Learn how to Input , Sort & Filter and manipulate data of all kinds in Excel Master the methods of Formatting , creating Charts and designing beautiful spreadsheets Learn to Maneuver through Excel's Menus with ease to locate any command quickly and efficiently Grasp the knowledge of Excel’s many Functions and how to employ them to do your bidding at will Acquire the skills of Spellcheck , Verifying data , Translation , Protecting worksheets and more. Master the many Keyboard shortcuts of Excel through practical application to become a Guru of efficiency Become a Wizard with any spreadsheet quickly by learning the Fundamentals and Advanced techniques of Excel in a logical fashion Harness the power to create functional resources in Excel to skyrocket productivity at any company Change your life for the better by becoming one of Excel’s Elite – a true GURU! As a Certified Excel Instructor, I understand the importance of being available for all my students 7 days a week, responding to questions and emails quickly and with detail. There will even be an FAQ section at the end of course 2 where I will answer each months most frequently answered question with Video and Tutorial explaining the solutions. Upon completion of the course, ALL students who complete and submit the required exercises (in this and the Intermediate to Advanced course) will receive a signed, verified Excel Guru certificate to let the world know- you are one of Excel’s Elite! Who this course is for: Beginner to Intemediate Excel users looking to hone their skills to the highest level Show more Show less Course content 8 sections • 35 lectures • 4h 12m total length Expand all sections The Basics 7 lectures • 27min Getting Started Quick Guide Preview 01:45 Introduction to the Green to Guru Curriculum 04:57 What are Workbooks and Worksheets? 02:00 Rows and Columns 02:05 Selecting Rows & Columns Preview 02:42 Excel Window 101: Zoom & Page View Options 05:35 Intro to Excel Ribbon & Menus 08:20 Navigation 2 lectures • 12min Basic Navigation Techniques 09:05 Ninja ShortCutz: Keyboard Navigation 02:59 Basic Navigation Quiz 4 questions Basic Formatting 3 lectures • 22min Basic Formatting 07:52 Basic Formatting Pt. 2 09:31 Formatting Dates 05:06 Entering & Editing Data in Excel 6 lectures • 56min Entering Data in Excel 07:01 Editing in Excel: Cut, Copy & Paste pt. 1 06:00 Cut, Copy & Paste: Paste Options Explained 17:24 Sort & Filter Preview 10:33 Conditional Formatting 06:25 Entering & Editing Data & Text (Basics Review) 08:42 Basics Level Test-Out 7 questions Level 2 - Basic to Intermediate 4 lectures • 32min Managing Workbooks 1: The Backstage View 11:50 Backstage Menu Recap 00:19 Worksheet Management 07:47 Searching your Spreadsheets: The Find & Select Feature 11:38 Intro to Formulas and Functions 8 lectures • 1hr 7min Intro to Formulas: Part 1 10:26 Intro to Formulas: Part 2 (Order of Operations) 08:34 Function AutoComplete (why its awesome) 08:49 The Fill Handle 09:03 Intro to Functions (& The SUM Function) 10:39 COUNT & COUNTA Functions 05:09 MAX, MIN and AVERAGE Functions 05:58 Essential Functions: Intro to IF 07:52 Formulas & Functions Quiz 8 questions Visualizing Data: Charts, Tables & more 3 lectures • 36min Charts 101 09:11 Charts 201: Chart Formatting & Options 15:39 Creating a Table 11:29 Final Exam and Exercises Re-cap 2 lectures • 1min Required Exercise Recap 00:11 Final Exam 11 questions Final Exercises 00:09 Instructor Pat Excel Certified MS Excel Specialist / Reporting Guru 4.6 Instructor Rating 15 Reviews 2,361 Students 1 Course As a Worksource coordinator in Los Angeles county, I took the initiative to begin teaching Microsoft Office to underprivileged youth and low-income homeless populations at New Image Shelter in Los Angeles. It brought me great joy being able to help those with little hope find confidence in their abilities and cultivate employment opportunities. As the coordinator of the Worksource program at a shelter serving about 1,000 per night, I was able to implement a new course curriculum which resulted in over 100 homeless receiving employment in various fields over the course of just 1 year. From there, I went on to take more courses and hone my skills with the Microsoft Office suite which is where I better realized my propensity and aptitude with Microsoft Excel. Now working for the world's second largest Music Publishing company, I have been able to create useful forms and solutions to decades old problems simply by using MS Excel. In 2 short years, I have been twice promoted and am now Supervisor of Customer Support and corporate reporting for the company. 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:'6781b71ad8e8ce1b',m:'6f5e5cea722dd02476f347f7f5fdfee3cfbebe09-1627848683-1800-AVhIXyxbUuSeCAw5nSuWMt/bs2XziTiqXFvFBocsidpubN3kUxuHIDMoT5Q0zeKhP81sKq6SP6uCkNB+su8NwRMryGasJCz2LKSV3q43M9BJeK1Sf4dupmTM6CkZr59S7Z1vJnuoQXnFpxDOOkx3K9eqNuhu8+165FZEMzN0rcgxOdPtVlfpp4FeCqehr98Imcun0+vDahCuVXu/3QClOCk=',s:[0xe999be0d1c,0x8c4eb1a70d],}})();
  3. Generate graphs and make sense of any data Requirements Excel 2010, 2013 and 2016 Desire to become an Excel power-user Description Are you one of the many – afraid to start learning about Excel because you think it is ‘too technical’? So many people I meet in training think that there will always be someone at their company who is better than they are in Excel. What if I told you that you could become that expert within your company in only 8 hours or less? Your computer or tech proficiency doesn’t matter, the Green to Guru course has been tried and tested across many different industries and skill levels – you WILL become the Guru for your company if you follow this curriculum. This interactive learningexperience encourages student participation and engagement every step of the way, with examples of each technique in action. Course Features: Learn the three fastest ways to Navigate Excel like a pro Learn how to Input , Sort & Filter and manipulate data of all kinds in Excel Master the methods of Formatting , creating Charts and designing beautiful spreadsheets Learn to Maneuver through Excel's Menus with ease to locate any command quickly and efficiently Grasp the knowledge of Excel’s many Functions and how to employ them to do your bidding at will Acquire the skills of Spellcheck , Verifying data , Translation , Protecting worksheets and more. Master the many Keyboard shortcuts of Excel through practical application to become a Guru of efficiency Become a Wizard with any spreadsheet quickly by learning the Fundamentals and Advanced techniques of Excel in a logical fashion Harness the power to create functional resources in Excel to skyrocket productivity at any company Change your life for the better by becoming one of Excel’s Elite – a true GURU! As a Certified Excel Instructor, I understand the importance of being available for all my students 7 days a week, responding to questions and emails quickly and with detail. There will even be an FAQ section at the end of course 2 where I will answer each months most frequently answered question with Video and Tutorial explaining the solutions. Upon completion of the course, ALL students who complete and submit the required exercises (in this and the Intermediate to Advanced course) will receive a signed, verified Excel Guru certificate to let the world know- you are one of Excel’s Elite! Who this course is for: Beginner to Intemediate Excel users looking to hone their skills to the highest level Show more Show less Course content 8 sections • 35 lectures • 4h 12m total length Expand all sections The Basics 7 lectures • 27min Getting Started Quick Guide Preview 01:45 Introduction to the Green to Guru Curriculum 04:57 What are Workbooks and Worksheets? 02:00 Rows and Columns 02:05 Selecting Rows & Columns Preview 02:42 Excel Window 101: Zoom & Page View Options 05:35 Intro to Excel Ribbon & Menus 08:20 Navigation 2 lectures • 12min Basic Navigation Techniques 09:05 Ninja ShortCutz: Keyboard Navigation 02:59 Basic Navigation Quiz 4 questions Basic Formatting 3 lectures • 22min Basic Formatting 07:52 Basic Formatting Pt. 2 09:31 Formatting Dates 05:06 Entering & Editing Data in Excel 6 lectures • 56min Entering Data in Excel 07:01 Editing in Excel: Cut, Copy & Paste pt. 1 06:00 Cut, Copy & Paste: Paste Options Explained 17:24 Sort & Filter Preview 10:33 Conditional Formatting 06:25 Entering & Editing Data & Text (Basics Review) 08:42 Basics Level Test-Out 7 questions Level 2 - Basic to Intermediate 4 lectures • 32min Managing Workbooks 1: The Backstage View 11:50 Backstage Menu Recap 00:19 Worksheet Management 07:47 Searching your Spreadsheets: The Find & Select Feature 11:38 Intro to Formulas and Functions 8 lectures • 1hr 7min Intro to Formulas: Part 1 10:26 Intro to Formulas: Part 2 (Order of Operations) 08:34 Function AutoComplete (why its awesome) 08:49 The Fill Handle 09:03 Intro to Functions (& The SUM Function) 10:39 COUNT & COUNTA Functions 05:09 MAX, MIN and AVERAGE Functions 05:58 Essential Functions: Intro to IF 07:52 Formulas & Functions Quiz 8 questions Visualizing Data: Charts, Tables & more 3 lectures • 36min Charts 101 09:11 Charts 201: Chart Formatting & Options 15:39 Creating a Table 11:29 Final Exam and Exercises Re-cap 2 lectures • 1min Required Exercise Recap 00:11 Final Exam 11 questions Final Exercises 00:09 Instructor Pat Excel Certified MS Excel Specialist / Reporting Guru 4.6 Instructor Rating 15 Reviews 2,361 Students 1 Course As a Worksource coordinator in Los Angeles county, I took the initiative to begin teaching Microsoft Office to underprivileged youth and low-income homeless populations at New Image Shelter in Los Angeles. It brought me great joy being able to help those with little hope find confidence in their abilities and cultivate employment opportunities. As the coordinator of the Worksource program at a shelter serving about 1,000 per night, I was able to implement a new course curriculum which resulted in over 100 homeless receiving employment in various fields over the course of just 1 year. From there, I went on to take more courses and hone my skills with the Microsoft Office suite which is where I better realized my propensity and aptitude with Microsoft Excel. Now working for the world's second largest Music Publishing company, I have been able to create useful forms and solutions to decades old problems simply by using MS Excel. In 2 short years, I have been twice promoted and am now Supervisor of Customer Support and corporate reporting for the company. 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:'6781b71ad8e8ce1b',m:'6f5e5cea722dd02476f347f7f5fdfee3cfbebe09-1627848683-1800-AVhIXyxbUuSeCAw5nSuWMt/bs2XziTiqXFvFBocsidpubN3kUxuHIDMoT5Q0zeKhP81sKq6SP6uCkNB+su8NwRMryGasJCz2LKSV3q43M9BJeK1Sf4dupmTM6CkZr59S7Z1vJnuoQXnFpxDOOkx3K9eqNuhu8+165FZEMzN0rcgxOdPtVlfpp4FeCqehr98Imcun0+vDahCuVXu/3QClOCk=',s:[0xe999be0d1c,0x8c4eb1a70d],}})();