Microsoft Excel Bootcamp - Learn to Master Excel in 3hrs!

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

Course Description

This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more!


WHAT MAKES OUR EXCEL COURSE UNIQUE?

  • Earn points as you complete the course and unlock your spirit animal

  • Engaging instructor that won't put you to sleep

  • G-rated humor and lighthearted lessons

  • ZERO FLUFF!

  • Real world application that you can start applying today


WHAT YOU'LL BE LEARNING

This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours:

  • Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C

  • VLOOKUP, IF, and Nested IF statements

  • SUMIFS and COUNTIFS

  • Text formulas including LEFT, RIGHT, and TRIM

  • Date formulas including EOMONTH and EDATE

  • PivotTables and Slicers

  • Conditional Formatting, Remove Duplicates, and Text-to-Columns


By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course.

__________

NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016.

Who this course is for:

  • This course is for ANYONE in ANY industry who uses Excel semi-regularly

Course content

7 sections • 39 lectures • 2h 46m total length
  • Course materials
    00:06

Expected Outcomes

  1. Learn Excel in a fun, interactive, and entertaining manner (no sleeping in this course) Wow your team with powerful formulas such as VLOOUP, IF, SUMIFS, and more! Gain powerful insights into your data using PivotTables and Slicers Master keyboard shortcuts and become the Usain Bolt of Excel Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();
  2. Wow your team with powerful formulas such as VLOOUP, IF, SUMIFS, and more! Gain powerful insights into your data using PivotTables and Slicers Master keyboard shortcuts and become the Usain Bolt of Excel Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();
  3. Gain powerful insights into your data using PivotTables and Slicers Master keyboard shortcuts and become the Usain Bolt of Excel Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();
  4. Master keyboard shortcuts and become the Usain Bolt of Excel Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();
  5. Organize and dissect large quantities of data using Text-to-Columns, Conditional Formatting, Sorting Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();
  6. Practice your skills multiple times using real-life case studies Requirements This course was created with Excel 2016 but all features will work in Excel 2010, 2013, 2016 (including Mac). You should know how to do basic functions in Excel like SUM. Description This is not your grandma's Excel course! Our Excel course will give you the Excel skills to become an Excel ninja. You'll discover keyboard shortcuts, IF statements, VLOOKUP, PivotTables, and more! WHAT MAKES OUR EXCEL COURSE UNIQUE? Earn points as you complete the course and unlock your spirit animal Engaging instructor that won't put you to sleep G-rated humor and lighthearted lessons ZERO FLUFF! Real world application that you can start applying today WHAT YOU'LL BE LEARNING This course will help you master the most important and widely used formulas and functions in Excel. This course is beneficial to ANYONE who uses Excel. Here's what you'll master in the next 4 hours: Keyboard shortcuts beyond the simple Ctrl+S or Ctrl+C VLOOKUP, IF, and Nested IF statements SUMIFS and COUNTIFS Text formulas including LEFT, RIGHT, and TRIM Date formulas including EOMONTH and EDATE PivotTables and Slicers Conditional Formatting, Remove Duplicates, and Text-to-Columns By the end of this course, you'll be a total boss at Excel! Then you can take those skills to a whole new level by taking our Advanced Microsoft Excel course and Microsoft Excel VBA (Macros) course. __________ NOTE: If you would like to receive CPE credit for this course, you must complete the final exam on our website. All lectures are compatible with Excel 2010, Excel 2013 or Excel 2016. Who this course is for: This course is for ANYONE in ANY industry who uses Excel semi-regularly Show more Show less Course content 7 sections • 39 lectures • 2h 46m total length Expand all sections Welcome! 3 lectures • 4min Introduction Preview 01:47 Course materials 00:06 Workbook overview Preview 01:56 Formatting & Keyboard Shortcuts 8 lectures • 35min Font coloring & assumptions 06:44 Other formatting best practices 02:56 Keyboard shortcuts introduction Preview 03:01 Basic keyboard shortcuts Preview 03:13 Basic keyboard shortcuts II Preview 02:44 The Almighty Alt key 04:55 Customizing the Quick Access Toolbar 05:25 Ctrl + Shift key 05:53 Quiz: Formatting & Keyboard Shortcuts 5 questions Formula Bootcamp Pt. I 9 lectures • 44min Absolute cell references 07:29 SUMIFS pt. I 04:31 SUMIFS pt. II 04:36 COUNTIFS 03:47 VLOOKUP introduction 03:33 VLOOKUP formula 04:54 VLOOKUP common pitfalls 06:11 Case study 1 pt. I 05:58 Case study 1 pt. II 03:27 Quiz: Formula Bootcamp pt. I 5 questions Formula Bootcaomp Pt. II 6 lectures • 27min IF statements 05:32 Nested IF statements 05:01 EDATE and EOMONTH 04:54 YEAR, MONTH, and DAY 02:12 LEFT, RIGHT, and MID 04:28 TRIM 04:32 Quiz: Formula Bootcamp pt. II 4 questions Working w/ Data and Conditional Formatting 5 lectures • 21min Text-to-Columns 04:59 Remove duplicates 03:28 Conditional formatting pt. I 05:46 Conditional formatting pt. II 03:44 Conditional formatting pt. III 02:42 Quiz: Working with Data & Conditional Formatting 3 questions PivotTables & Slicers 7 lectures • 33min Introduction 04:55 Drilling into our data 02:20 Formatting our PivotTable 05:29 Slicers 06:48 Case Study 2 pt. I 05:01 Case Study 2 pt. II 04:24 Case Study 2 pt. III 04:32 Quiz: PivotTables 4 questions Conclusion 1 lecture • 2min Conclusion 02:17 Instructor Nate @ Wisdify Co-Founder & Lead Instructor @ Wisdify 4.5 Instructor Rating 4,247 Reviews 16,468 Students 11 Courses Wisdify is an online training platform with a mission to empower young professionals with the skills and knowledge to succeed professionally. Our engaging online courses equip you with extremely relevant and in-demand hard and soft skills so you can become more employable and promotable. Our courses include : SQL for Data Analytics, Intro to Data Analytics, Microsoft Power BI, Marketing Analytics, Microsoft VBA Macros, Financial Statement Analysis and more! To receive CPE credit , you must complete the final exam on our website. About the instructor: Nate is the co-founder of Wisdify and has a passion for teaching. His teaching style has been described as entertaining, energetic, and passionate. Prior to Wisdify, Nate co-founded BostonExcel, a Microsoft Excel training and consulting company. During that time, he trained and performed consulting work for 60+ companies (including multiple Fortune 500 companies) . Prior to BostonExcel, Nate was an Acquisitions Senior Associate at Gladstone Commercial (a publicly traded REIT), an Acquisitions Analyst for the RMR Group (another publicly traded REIT), and an auditor for Ernst & Young. Nate is a CPA with the Commonwealth of Massachusetts. Nate earned an MS in Finance & Accounting from Boston College and a BS in Business Management from Brigham Young University–Idaho. 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:'678138748faace8b',m:'a3717b807fe5a55a4fb86326cdf013bdb3368f10-1627843496-1800-AewXeTfCTk3xr9UXn723h4ED0awyliRtjB3uLWqeRigGkkAJJssCEuBPH1Co+TvJJF+UZ/N4hTxr5IBgk22HnYsdGRis8+49YY25qxYbEtUU/meOrQc85X7xo5+Unej4LHl8q1+KvAmqPKpNGeTaF1CTEnOBNWQ9a333+s7wwgKn',s:[0xe76dc99be9,0x3f8860bbcc],}})();