Microsoft Excel Pro Tips: Go from Beginner to Advanced Excel

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

Course Description

COURSE DESCRIPTION:

This course is designed to transform everyday people into Excel POWER USERS.


It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies.


Unlike most Excel courses, this one is non-linear and constantly evolving. This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons.


The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick and easy access.


The Excel tips and techniques covered in this course fall into six core categories:

  • Excel Productivity Tips (navigation, flash fill, cell protection, advanced sorting & filtering, etc.)

  • Excel Formatting Tips (freeze panes, row/column grouping, advanced custom formats, etc.)

  • Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc.)

  • Excel Visualization Tips (sparklines, filled maps, custom templates, Excel form controls, etc.)

  • Excel Pivot Table Tips (slicers & timelines, custom layouts, value calculations, etc.)

  • Excel Analytics Tips (outlier detection, monte carlo simulation, forecasting, CUBE functions, etc.)


While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas, for example).


It's time to start working smarter, not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you.


Join today and get immediate, lifetime access to the following:

  • 10+ hours of high-quality video

  • Downloadable PDF ebook

  • Excel project files & solutions

  • Expert-support and Q&A forum

  • 30-day money-back guarantee


Happy learning!

-Chris (Founder, Maven Analytics)


NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!


See why this is one of the TOP-RATED Excel courses on Udemy:

"At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!"

- Judit Bekker

"One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!"

- Ernie Atkins

"I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!"

-Ryan Hughes

Who this course is for:

  • Excel users looking to level-up and master the same tools and techniques used by Excel MVPs
  • Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level
  • Students looking for an engaging, hands-on, and highly interactive approach to Excel training
  • Anyone looking to pursue a career in data analysis or business intelligence
  • This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged)

Expected Outcomes

  1. Build tools to help you automate, streamline, and absolutely revolutionize your workflow with Excel Explore 75+ unique tips, tools and case studies that you won't find in ANY other Excel course, guaranteed Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support Master Excel's powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons . The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty ( 1-5 stars ), organized by category , and hyperlinked for quick and easy access. The Excel tips and techniques covered in this course fall into six core categories : Excel Productivity Tips ( navigation, flash fill, cell protection, advanced sorting & filtering, etc. ) Excel Formatting Tips ( freeze panes, row/column grouping, advanced custom formats, etc. ) Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc. ) Excel Visualization Tips ( sparklines, filled maps, custom templates, Excel form controls, etc. ) Excel Pivot Table Tips ( slicers & timelines, custom layouts, value calculations, etc. ) Excel Analytics Tips ( outlier detection, monte carlo simulation, forecasting, CUBE functions, etc. ) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas , for example) . It's time to start working smarter , not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you . Join today and get immediate, lifetime access to the following: 10+ hours of high-quality video Downloadable PDF ebook Excel project files & solutions Expert-support and Q&A forum 30-day money-back guarantee Happy learning! -Chris ( Founder, Maven Analytics ) NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! See why this is one of the TOP-RATED Excel courses on Udemy: "At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!" - Judit Bekker "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!" - Ernie Atkins "I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!" -Ryan Hughes Who this course is for: Excel users looking to level-up and master the same tools and techniques used by Excel MVPs Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel training Anyone looking to pursue a career in data analysis or business intelligence This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged) Show more Show less Course content 8 sections • 93 lectures • 10h 31m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 01:58 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resource Files 00:19 Setting Expectations Preview 01:45 Excel Productivity Tips 16 lectures • 1hr 41min Introduction 00:29 Customizing the Excel Footer 04:03 Navigating Workbooks with CTRL Shortcuts 08:01 Accessing Ribbon Tools with ALT Key Tips 06:53 Accessing Excel's "Go To" Special Options 04:36 Removing Blank Rows in Excel Worksheets 03:17 Creating Drop-Down Menus with Data Validation Preview 07:11 Filling Patterns with Autofill & Flash Fill 08:26 Customizing the Excel Ribbon Tools 06:53 Splitting Text to Columns in Excel 07:39 Synchronous Scrolling Across Multiple Workbooks 02:58 Extracting Unique Values from a List in Excel 04:06 Using Named Range & Table References in Excel Formulas 08:12 Protecting Cells & Formulas in Excel Workbooks Preview 08:09 Multi-Level Row & Column Sorting 10:54 Configuring Advanced Filter Criteria in Excel 09:27 QUIZ: Excel Productivity Tips 10 questions Excel Formatting Tips 15 lectures • 1hr 31min Introduction 00:26 Excel Formatting Shortcuts 04:28 Snapping Objects to the Excel Grid 04:30 Hiding Excel Workbook Elements 04:03 Replicating Formats & Styles with Excel's Format Painter 06:41 Color & Border Design Tips in Excel 07:03 Freezing Panes in Excel Worksheets Preview 05:58 Centering Across a Selection 04:33 Creating an "Invisible" Format 03:55 Zip Codes & Phone Numbers 05:09 Grouping Worksheet Columns & Rows 06:25 Formatting Excel Errors with IFERROR 05:50 Converting Excel Text to Dates 10:39 Creating Dynamic Formats with Excel Formulas 10:41 Advanced Excel Number Formats Preview 10:37 QUIZ: Excel Formatting Tips 10 questions Excel Formula Tips 16 lectures • 2hr 1min Introduction 00:28 Manual vs. Automatic Calculation Modes in Excel 04:19 Adding Line Breaks to Excel Formulas 04:05 Converting Units of Measurement with Excel Formulas 05:50 Building Real-Time Tools with TODAY & NOW Functions 10:18 Excel Formula Auditing Tools Preview 11:18 Designing Pivot-Style Reports with Excel Formulas 08:37 Counting Words in Excel with LEN & SUBSTITUTE Functions 07:24 Configuring Dependent Drop-Down Menus with INDIRECT 08:29 Creating Custom Hyperlinks Between Excel Worksheets 08:13 Using Approximate Match VLOOKUP Functions 07:15 Randomizing a Selection with OFFSET & RANDBETWEEN Functions Preview 06:26 Combining INDEX & MATCH Functions 08:40 Finding Matching Items Across Lists in Excel 11:00 Counting Duplicate Values with SUMPRODUCT 08:59 Using Many-to-Many Lookups in Excel 09:53 QUIZ: Excel Formula Tips 10 questions Excel Visualization Tips 13 lectures • 1hr 35min Introduction 00:24 Configuring Excel Chart Properties (Move & Size) 05:08 Managing Hidden Chart Source Data in Excel Worksheets 02:43 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365) 05:10 Customizing Excel Charts to Tell a Story 08:54 Adding Sparklines to Worksheet Cells 07:44 Designing Custom Chart Templates in Excel 06:06 Building Excel Heat Maps Using Color Scales Preview 07:11 Analyzing Distribution with Histograms 09:28 Goal Pacing with Custom Excel Gauge Charts 10:26 Highlighting Time Periods with Combo Charts 08:05 Configuring Dynamic Chart Source Ranges 12:08 Creating Interactivity with Excel Form Controls Preview 11:48 QUIZ: Excel Visualization Tips 10 questions Excel Pivot Table Tips 15 lectures • 1hr 37min Introduction 00:18 Customizing the Pivot Table Field List 04:07 Autofitting Column Width in Pivot Tables 04:21 Pivot Table Outline & Tabular Layouts 07:46 Counting Non-Numerical Fields Using Pivots 06:05 Grouping & Ungrouping Dates with Pivot Tables 08:03 Enabling Multiple Pivot Table Filters 05:00 Grouping Values into Buckets with Pivot Tables Preview 06:50 Adding Value Calculations to Pivot Tables 09:01 Configuring Pivot Table Errors & Empty Items 06:22 Configuring Pivot Table Slicers & Timelines 10:23 Advanced Pivot Table Conditional Formatting 08:23 Removing & Reviving Pivot Table Source Data 08:19 Adding Custom Sort Lists in Excel Preview 05:23 Solve Order & List Formula Reports 06:16 QUIZ: Excel Pivot Table Tips 10 questions Excel Analytics Tips 13 lectures • 1hr 59min Introduction 00:29 Excel Quick Analysis Tools 06:03 Comparing Outcomes Using the Scenario Manager 07:55 Solving Simple Optimizations with Goal Seek 06:33 Creating Basic Forecasts in Excel 11:10 Building an Outlier Detection Tool in Excel Preview 09:24 Generating Automated Data Tables 08:06 Connecting & Transforming Data with Power Query 10:41 Creating Relational Data Models in Excel 10:23 Accessing the Data Model with CUBE Functions 16:21 Building a Monte Carlo Simulation in Excel 11:38 Advanced Optimization with Solver Preview 12:16 Excel Analysis ToolPak (Preview) 08:10 QUIZ: Excel Analytics Tips 10 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. 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:'6781006a79554066',m:'9b50c5b3856b208773f57020d38fbf06ae1b32fc-1627841200-1800-AZoSY5JzJIKeWXzsk9I0fx33kJfBXr8Zo6a2hFj07FQtdoEy4IW7PrGfhKyQhT56hiBbazOLKWfoCUpqWV9slGCgMA5XBX61YRgpL2aAKEhR7Kv9rfSqCYR/ja+2eZhZ93T50AelorIlyr9GOGikpsNZ+eN3W20ihviyojzTxX+C44b/scxxPwJS270SpMK7hA==',s:[0x377ee022b0,0x2126bcc04e],}})();
  2. Explore 75+ unique tips, tools and case studies that you won't find in ANY other Excel course, guaranteed Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support Master Excel's powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons . The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty ( 1-5 stars ), organized by category , and hyperlinked for quick and easy access. The Excel tips and techniques covered in this course fall into six core categories : Excel Productivity Tips ( navigation, flash fill, cell protection, advanced sorting & filtering, etc. ) Excel Formatting Tips ( freeze panes, row/column grouping, advanced custom formats, etc. ) Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc. ) Excel Visualization Tips ( sparklines, filled maps, custom templates, Excel form controls, etc. ) Excel Pivot Table Tips ( slicers & timelines, custom layouts, value calculations, etc. ) Excel Analytics Tips ( outlier detection, monte carlo simulation, forecasting, CUBE functions, etc. ) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas , for example) . It's time to start working smarter , not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you . Join today and get immediate, lifetime access to the following: 10+ hours of high-quality video Downloadable PDF ebook Excel project files & solutions Expert-support and Q&A forum 30-day money-back guarantee Happy learning! -Chris ( Founder, Maven Analytics ) NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! See why this is one of the TOP-RATED Excel courses on Udemy: "At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!" - Judit Bekker "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!" - Ernie Atkins "I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!" -Ryan Hughes Who this course is for: Excel users looking to level-up and master the same tools and techniques used by Excel MVPs Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel training Anyone looking to pursue a career in data analysis or business intelligence This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged) Show more Show less Course content 8 sections • 93 lectures • 10h 31m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 01:58 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resource Files 00:19 Setting Expectations Preview 01:45 Excel Productivity Tips 16 lectures • 1hr 41min Introduction 00:29 Customizing the Excel Footer 04:03 Navigating Workbooks with CTRL Shortcuts 08:01 Accessing Ribbon Tools with ALT Key Tips 06:53 Accessing Excel's "Go To" Special Options 04:36 Removing Blank Rows in Excel Worksheets 03:17 Creating Drop-Down Menus with Data Validation Preview 07:11 Filling Patterns with Autofill & Flash Fill 08:26 Customizing the Excel Ribbon Tools 06:53 Splitting Text to Columns in Excel 07:39 Synchronous Scrolling Across Multiple Workbooks 02:58 Extracting Unique Values from a List in Excel 04:06 Using Named Range & Table References in Excel Formulas 08:12 Protecting Cells & Formulas in Excel Workbooks Preview 08:09 Multi-Level Row & Column Sorting 10:54 Configuring Advanced Filter Criteria in Excel 09:27 QUIZ: Excel Productivity Tips 10 questions Excel Formatting Tips 15 lectures • 1hr 31min Introduction 00:26 Excel Formatting Shortcuts 04:28 Snapping Objects to the Excel Grid 04:30 Hiding Excel Workbook Elements 04:03 Replicating Formats & Styles with Excel's Format Painter 06:41 Color & Border Design Tips in Excel 07:03 Freezing Panes in Excel Worksheets Preview 05:58 Centering Across a Selection 04:33 Creating an "Invisible" Format 03:55 Zip Codes & Phone Numbers 05:09 Grouping Worksheet Columns & Rows 06:25 Formatting Excel Errors with IFERROR 05:50 Converting Excel Text to Dates 10:39 Creating Dynamic Formats with Excel Formulas 10:41 Advanced Excel Number Formats Preview 10:37 QUIZ: Excel Formatting Tips 10 questions Excel Formula Tips 16 lectures • 2hr 1min Introduction 00:28 Manual vs. Automatic Calculation Modes in Excel 04:19 Adding Line Breaks to Excel Formulas 04:05 Converting Units of Measurement with Excel Formulas 05:50 Building Real-Time Tools with TODAY & NOW Functions 10:18 Excel Formula Auditing Tools Preview 11:18 Designing Pivot-Style Reports with Excel Formulas 08:37 Counting Words in Excel with LEN & SUBSTITUTE Functions 07:24 Configuring Dependent Drop-Down Menus with INDIRECT 08:29 Creating Custom Hyperlinks Between Excel Worksheets 08:13 Using Approximate Match VLOOKUP Functions 07:15 Randomizing a Selection with OFFSET & RANDBETWEEN Functions Preview 06:26 Combining INDEX & MATCH Functions 08:40 Finding Matching Items Across Lists in Excel 11:00 Counting Duplicate Values with SUMPRODUCT 08:59 Using Many-to-Many Lookups in Excel 09:53 QUIZ: Excel Formula Tips 10 questions Excel Visualization Tips 13 lectures • 1hr 35min Introduction 00:24 Configuring Excel Chart Properties (Move & Size) 05:08 Managing Hidden Chart Source Data in Excel Worksheets 02:43 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365) 05:10 Customizing Excel Charts to Tell a Story 08:54 Adding Sparklines to Worksheet Cells 07:44 Designing Custom Chart Templates in Excel 06:06 Building Excel Heat Maps Using Color Scales Preview 07:11 Analyzing Distribution with Histograms 09:28 Goal Pacing with Custom Excel Gauge Charts 10:26 Highlighting Time Periods with Combo Charts 08:05 Configuring Dynamic Chart Source Ranges 12:08 Creating Interactivity with Excel Form Controls Preview 11:48 QUIZ: Excel Visualization Tips 10 questions Excel Pivot Table Tips 15 lectures • 1hr 37min Introduction 00:18 Customizing the Pivot Table Field List 04:07 Autofitting Column Width in Pivot Tables 04:21 Pivot Table Outline & Tabular Layouts 07:46 Counting Non-Numerical Fields Using Pivots 06:05 Grouping & Ungrouping Dates with Pivot Tables 08:03 Enabling Multiple Pivot Table Filters 05:00 Grouping Values into Buckets with Pivot Tables Preview 06:50 Adding Value Calculations to Pivot Tables 09:01 Configuring Pivot Table Errors & Empty Items 06:22 Configuring Pivot Table Slicers & Timelines 10:23 Advanced Pivot Table Conditional Formatting 08:23 Removing & Reviving Pivot Table Source Data 08:19 Adding Custom Sort Lists in Excel Preview 05:23 Solve Order & List Formula Reports 06:16 QUIZ: Excel Pivot Table Tips 10 questions Excel Analytics Tips 13 lectures • 1hr 59min Introduction 00:29 Excel Quick Analysis Tools 06:03 Comparing Outcomes Using the Scenario Manager 07:55 Solving Simple Optimizations with Goal Seek 06:33 Creating Basic Forecasts in Excel 11:10 Building an Outlier Detection Tool in Excel Preview 09:24 Generating Automated Data Tables 08:06 Connecting & Transforming Data with Power Query 10:41 Creating Relational Data Models in Excel 10:23 Accessing the Data Model with CUBE Functions 16:21 Building a Monte Carlo Simulation in Excel 11:38 Advanced Optimization with Solver Preview 12:16 Excel Analysis ToolPak (Preview) 08:10 QUIZ: Excel Analytics Tips 10 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. 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:'6781006a79554066',m:'9b50c5b3856b208773f57020d38fbf06ae1b32fc-1627841200-1800-AZoSY5JzJIKeWXzsk9I0fx33kJfBXr8Zo6a2hFj07FQtdoEy4IW7PrGfhKyQhT56hiBbazOLKWfoCUpqWV9slGCgMA5XBX61YRgpL2aAKEhR7Kv9rfSqCYR/ja+2eZhZ93T50AelorIlyr9GOGikpsNZ+eN3W20ihviyojzTxX+C44b/scxxPwJS270SpMK7hA==',s:[0x377ee022b0,0x2126bcc04e],}})();
  3. Get LIFETIME access to resources, Excel project files, quizzes, and 1-on-1 expert support Master Excel's powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons . The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty ( 1-5 stars ), organized by category , and hyperlinked for quick and easy access. The Excel tips and techniques covered in this course fall into six core categories : Excel Productivity Tips ( navigation, flash fill, cell protection, advanced sorting & filtering, etc. ) Excel Formatting Tips ( freeze panes, row/column grouping, advanced custom formats, etc. ) Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc. ) Excel Visualization Tips ( sparklines, filled maps, custom templates, Excel form controls, etc. ) Excel Pivot Table Tips ( slicers & timelines, custom layouts, value calculations, etc. ) Excel Analytics Tips ( outlier detection, monte carlo simulation, forecasting, CUBE functions, etc. ) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas , for example) . It's time to start working smarter , not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you . Join today and get immediate, lifetime access to the following: 10+ hours of high-quality video Downloadable PDF ebook Excel project files & solutions Expert-support and Q&A forum 30-day money-back guarantee Happy learning! -Chris ( Founder, Maven Analytics ) NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! See why this is one of the TOP-RATED Excel courses on Udemy: "At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!" - Judit Bekker "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!" - Ernie Atkins "I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!" -Ryan Hughes Who this course is for: Excel users looking to level-up and master the same tools and techniques used by Excel MVPs Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel training Anyone looking to pursue a career in data analysis or business intelligence This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged) Show more Show less Course content 8 sections • 93 lectures • 10h 31m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 01:58 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resource Files 00:19 Setting Expectations Preview 01:45 Excel Productivity Tips 16 lectures • 1hr 41min Introduction 00:29 Customizing the Excel Footer 04:03 Navigating Workbooks with CTRL Shortcuts 08:01 Accessing Ribbon Tools with ALT Key Tips 06:53 Accessing Excel's "Go To" Special Options 04:36 Removing Blank Rows in Excel Worksheets 03:17 Creating Drop-Down Menus with Data Validation Preview 07:11 Filling Patterns with Autofill & Flash Fill 08:26 Customizing the Excel Ribbon Tools 06:53 Splitting Text to Columns in Excel 07:39 Synchronous Scrolling Across Multiple Workbooks 02:58 Extracting Unique Values from a List in Excel 04:06 Using Named Range & Table References in Excel Formulas 08:12 Protecting Cells & Formulas in Excel Workbooks Preview 08:09 Multi-Level Row & Column Sorting 10:54 Configuring Advanced Filter Criteria in Excel 09:27 QUIZ: Excel Productivity Tips 10 questions Excel Formatting Tips 15 lectures • 1hr 31min Introduction 00:26 Excel Formatting Shortcuts 04:28 Snapping Objects to the Excel Grid 04:30 Hiding Excel Workbook Elements 04:03 Replicating Formats & Styles with Excel's Format Painter 06:41 Color & Border Design Tips in Excel 07:03 Freezing Panes in Excel Worksheets Preview 05:58 Centering Across a Selection 04:33 Creating an "Invisible" Format 03:55 Zip Codes & Phone Numbers 05:09 Grouping Worksheet Columns & Rows 06:25 Formatting Excel Errors with IFERROR 05:50 Converting Excel Text to Dates 10:39 Creating Dynamic Formats with Excel Formulas 10:41 Advanced Excel Number Formats Preview 10:37 QUIZ: Excel Formatting Tips 10 questions Excel Formula Tips 16 lectures • 2hr 1min Introduction 00:28 Manual vs. Automatic Calculation Modes in Excel 04:19 Adding Line Breaks to Excel Formulas 04:05 Converting Units of Measurement with Excel Formulas 05:50 Building Real-Time Tools with TODAY & NOW Functions 10:18 Excel Formula Auditing Tools Preview 11:18 Designing Pivot-Style Reports with Excel Formulas 08:37 Counting Words in Excel with LEN & SUBSTITUTE Functions 07:24 Configuring Dependent Drop-Down Menus with INDIRECT 08:29 Creating Custom Hyperlinks Between Excel Worksheets 08:13 Using Approximate Match VLOOKUP Functions 07:15 Randomizing a Selection with OFFSET & RANDBETWEEN Functions Preview 06:26 Combining INDEX & MATCH Functions 08:40 Finding Matching Items Across Lists in Excel 11:00 Counting Duplicate Values with SUMPRODUCT 08:59 Using Many-to-Many Lookups in Excel 09:53 QUIZ: Excel Formula Tips 10 questions Excel Visualization Tips 13 lectures • 1hr 35min Introduction 00:24 Configuring Excel Chart Properties (Move & Size) 05:08 Managing Hidden Chart Source Data in Excel Worksheets 02:43 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365) 05:10 Customizing Excel Charts to Tell a Story 08:54 Adding Sparklines to Worksheet Cells 07:44 Designing Custom Chart Templates in Excel 06:06 Building Excel Heat Maps Using Color Scales Preview 07:11 Analyzing Distribution with Histograms 09:28 Goal Pacing with Custom Excel Gauge Charts 10:26 Highlighting Time Periods with Combo Charts 08:05 Configuring Dynamic Chart Source Ranges 12:08 Creating Interactivity with Excel Form Controls Preview 11:48 QUIZ: Excel Visualization Tips 10 questions Excel Pivot Table Tips 15 lectures • 1hr 37min Introduction 00:18 Customizing the Pivot Table Field List 04:07 Autofitting Column Width in Pivot Tables 04:21 Pivot Table Outline & Tabular Layouts 07:46 Counting Non-Numerical Fields Using Pivots 06:05 Grouping & Ungrouping Dates with Pivot Tables 08:03 Enabling Multiple Pivot Table Filters 05:00 Grouping Values into Buckets with Pivot Tables Preview 06:50 Adding Value Calculations to Pivot Tables 09:01 Configuring Pivot Table Errors & Empty Items 06:22 Configuring Pivot Table Slicers & Timelines 10:23 Advanced Pivot Table Conditional Formatting 08:23 Removing & Reviving Pivot Table Source Data 08:19 Adding Custom Sort Lists in Excel Preview 05:23 Solve Order & List Formula Reports 06:16 QUIZ: Excel Pivot Table Tips 10 questions Excel Analytics Tips 13 lectures • 1hr 59min Introduction 00:29 Excel Quick Analysis Tools 06:03 Comparing Outcomes Using the Scenario Manager 07:55 Solving Simple Optimizations with Goal Seek 06:33 Creating Basic Forecasts in Excel 11:10 Building an Outlier Detection Tool in Excel Preview 09:24 Generating Automated Data Tables 08:06 Connecting & Transforming Data with Power Query 10:41 Creating Relational Data Models in Excel 10:23 Accessing the Data Model with CUBE Functions 16:21 Building a Monte Carlo Simulation in Excel 11:38 Advanced Optimization with Solver Preview 12:16 Excel Analysis ToolPak (Preview) 08:10 QUIZ: Excel Analytics Tips 10 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. 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:'6781006a79554066',m:'9b50c5b3856b208773f57020d38fbf06ae1b32fc-1627841200-1800-AZoSY5JzJIKeWXzsk9I0fx33kJfBXr8Zo6a2hFj07FQtdoEy4IW7PrGfhKyQhT56hiBbazOLKWfoCUpqWV9slGCgMA5XBX61YRgpL2aAKEhR7Kv9rfSqCYR/ja+2eZhZ93T50AelorIlyr9GOGikpsNZ+eN3W20ihviyojzTxX+C44b/scxxPwJS270SpMK7hA==',s:[0x377ee022b0,0x2126bcc04e],}})();
  4. Master Excel's powerful data analysis tools like Goal Seek, Scenario Manager, Solver, and Analysis ToolPak Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons . The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty ( 1-5 stars ), organized by category , and hyperlinked for quick and easy access. The Excel tips and techniques covered in this course fall into six core categories : Excel Productivity Tips ( navigation, flash fill, cell protection, advanced sorting & filtering, etc. ) Excel Formatting Tips ( freeze panes, row/column grouping, advanced custom formats, etc. ) Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc. ) Excel Visualization Tips ( sparklines, filled maps, custom templates, Excel form controls, etc. ) Excel Pivot Table Tips ( slicers & timelines, custom layouts, value calculations, etc. ) Excel Analytics Tips ( outlier detection, monte carlo simulation, forecasting, CUBE functions, etc. ) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas , for example) . It's time to start working smarter , not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you . Join today and get immediate, lifetime access to the following: 10+ hours of high-quality video Downloadable PDF ebook Excel project files & solutions Expert-support and Q&A forum 30-day money-back guarantee Happy learning! -Chris ( Founder, Maven Analytics ) NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! See why this is one of the TOP-RATED Excel courses on Udemy: "At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!" - Judit Bekker "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!" - Ernie Atkins "I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!" -Ryan Hughes Who this course is for: Excel users looking to level-up and master the same tools and techniques used by Excel MVPs Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel training Anyone looking to pursue a career in data analysis or business intelligence This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged) Show more Show less Course content 8 sections • 93 lectures • 10h 31m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 01:58 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resource Files 00:19 Setting Expectations Preview 01:45 Excel Productivity Tips 16 lectures • 1hr 41min Introduction 00:29 Customizing the Excel Footer 04:03 Navigating Workbooks with CTRL Shortcuts 08:01 Accessing Ribbon Tools with ALT Key Tips 06:53 Accessing Excel's "Go To" Special Options 04:36 Removing Blank Rows in Excel Worksheets 03:17 Creating Drop-Down Menus with Data Validation Preview 07:11 Filling Patterns with Autofill & Flash Fill 08:26 Customizing the Excel Ribbon Tools 06:53 Splitting Text to Columns in Excel 07:39 Synchronous Scrolling Across Multiple Workbooks 02:58 Extracting Unique Values from a List in Excel 04:06 Using Named Range & Table References in Excel Formulas 08:12 Protecting Cells & Formulas in Excel Workbooks Preview 08:09 Multi-Level Row & Column Sorting 10:54 Configuring Advanced Filter Criteria in Excel 09:27 QUIZ: Excel Productivity Tips 10 questions Excel Formatting Tips 15 lectures • 1hr 31min Introduction 00:26 Excel Formatting Shortcuts 04:28 Snapping Objects to the Excel Grid 04:30 Hiding Excel Workbook Elements 04:03 Replicating Formats & Styles with Excel's Format Painter 06:41 Color & Border Design Tips in Excel 07:03 Freezing Panes in Excel Worksheets Preview 05:58 Centering Across a Selection 04:33 Creating an "Invisible" Format 03:55 Zip Codes & Phone Numbers 05:09 Grouping Worksheet Columns & Rows 06:25 Formatting Excel Errors with IFERROR 05:50 Converting Excel Text to Dates 10:39 Creating Dynamic Formats with Excel Formulas 10:41 Advanced Excel Number Formats Preview 10:37 QUIZ: Excel Formatting Tips 10 questions Excel Formula Tips 16 lectures • 2hr 1min Introduction 00:28 Manual vs. Automatic Calculation Modes in Excel 04:19 Adding Line Breaks to Excel Formulas 04:05 Converting Units of Measurement with Excel Formulas 05:50 Building Real-Time Tools with TODAY & NOW Functions 10:18 Excel Formula Auditing Tools Preview 11:18 Designing Pivot-Style Reports with Excel Formulas 08:37 Counting Words in Excel with LEN & SUBSTITUTE Functions 07:24 Configuring Dependent Drop-Down Menus with INDIRECT 08:29 Creating Custom Hyperlinks Between Excel Worksheets 08:13 Using Approximate Match VLOOKUP Functions 07:15 Randomizing a Selection with OFFSET & RANDBETWEEN Functions Preview 06:26 Combining INDEX & MATCH Functions 08:40 Finding Matching Items Across Lists in Excel 11:00 Counting Duplicate Values with SUMPRODUCT 08:59 Using Many-to-Many Lookups in Excel 09:53 QUIZ: Excel Formula Tips 10 questions Excel Visualization Tips 13 lectures • 1hr 35min Introduction 00:24 Configuring Excel Chart Properties (Move & Size) 05:08 Managing Hidden Chart Source Data in Excel Worksheets 02:43 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365) 05:10 Customizing Excel Charts to Tell a Story 08:54 Adding Sparklines to Worksheet Cells 07:44 Designing Custom Chart Templates in Excel 06:06 Building Excel Heat Maps Using Color Scales Preview 07:11 Analyzing Distribution with Histograms 09:28 Goal Pacing with Custom Excel Gauge Charts 10:26 Highlighting Time Periods with Combo Charts 08:05 Configuring Dynamic Chart Source Ranges 12:08 Creating Interactivity with Excel Form Controls Preview 11:48 QUIZ: Excel Visualization Tips 10 questions Excel Pivot Table Tips 15 lectures • 1hr 37min Introduction 00:18 Customizing the Pivot Table Field List 04:07 Autofitting Column Width in Pivot Tables 04:21 Pivot Table Outline & Tabular Layouts 07:46 Counting Non-Numerical Fields Using Pivots 06:05 Grouping & Ungrouping Dates with Pivot Tables 08:03 Enabling Multiple Pivot Table Filters 05:00 Grouping Values into Buckets with Pivot Tables Preview 06:50 Adding Value Calculations to Pivot Tables 09:01 Configuring Pivot Table Errors & Empty Items 06:22 Configuring Pivot Table Slicers & Timelines 10:23 Advanced Pivot Table Conditional Formatting 08:23 Removing & Reviving Pivot Table Source Data 08:19 Adding Custom Sort Lists in Excel Preview 05:23 Solve Order & List Formula Reports 06:16 QUIZ: Excel Pivot Table Tips 10 questions Excel Analytics Tips 13 lectures • 1hr 59min Introduction 00:29 Excel Quick Analysis Tools 06:03 Comparing Outcomes Using the Scenario Manager 07:55 Solving Simple Optimizations with Goal Seek 06:33 Creating Basic Forecasts in Excel 11:10 Building an Outlier Detection Tool in Excel Preview 09:24 Generating Automated Data Tables 08:06 Connecting & Transforming Data with Power Query 10:41 Creating Relational Data Models in Excel 10:23 Accessing the Data Model with CUBE Functions 16:21 Building a Monte Carlo Simulation in Excel 11:38 Advanced Optimization with Solver Preview 12:16 Excel Analysis ToolPak (Preview) 08:10 QUIZ: Excel Analytics Tips 10 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. 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:'6781006a79554066',m:'9b50c5b3856b208773f57020d38fbf06ae1b32fc-1627841200-1800-AZoSY5JzJIKeWXzsk9I0fx33kJfBXr8Zo6a2hFj07FQtdoEy4IW7PrGfhKyQhT56hiBbazOLKWfoCUpqWV9slGCgMA5XBX61YRgpL2aAKEhR7Kv9rfSqCYR/ja+2eZhZ93T50AelorIlyr9GOGikpsNZ+eN3W20ihviyojzTxX+C44b/scxxPwJS270SpMK7hA==',s:[0x377ee022b0,0x2126bcc04e],}})();
  5. Practice with fun, interactive, and highly effective lessons from a best-selling Excel instructor Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed to be an independent and self-contained Excel demo, to help you learn these tools and techniques in quick, bite-sized lessons . The best part? I'm including a downloadable Excel workbook and solution file containing every single Excel demo and dataset covered in the course, ranked by difficulty ( 1-5 stars ), organized by category , and hyperlinked for quick and easy access. The Excel tips and techniques covered in this course fall into six core categories : Excel Productivity Tips ( navigation, flash fill, cell protection, advanced sorting & filtering, etc. ) Excel Formatting Tips ( freeze panes, row/column grouping, advanced custom formats, etc. ) Excel Formula Tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, etc. ) Excel Visualization Tips ( sparklines, filled maps, custom templates, Excel form controls, etc. ) Excel Pivot Table Tips ( slicers & timelines, custom layouts, value calculations, etc. ) Excel Analytics Tips ( outlier detection, monte carlo simulation, forecasting, CUBE functions, etc. ) While the level of difficulty varies considerably, the Excel demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of the underlying Excel concepts (like Excel Pivot Tables or formulas , for example) . It's time to start working smarter , not harder. If you're looking to maximize your efficiency, supercharge your productivity, and become an absolute Excel POWER USER, this is the course for you . Join today and get immediate, lifetime access to the following: 10+ hours of high-quality video Downloadable PDF ebook Excel project files & solutions Expert-support and Q&A forum 30-day money-back guarantee Happy learning! -Chris ( Founder, Maven Analytics ) NOTE: Most Excel demos are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 or Office 365 (some may be unavailable in Excel for Mac or Excel Online) __________ Looking for the full business intelligence stack? Search for " Maven Analytics " to browse our full course library, including Excel, Power BI, MySQL , and Tableau courses! See why this is one of the TOP-RATED Excel courses on Udemy: "At first I just said to myself, "Wow, Excel is capable of that? It's amazing!" Then as I continued through the course I told myself "This guy is doing magic!", and now I feel like I'm capable of doing the same. I'm definitely buying his other Excel courses!" - Judit Bekker "One of the very best Excel classes I've taken - great instructor, awesome production, very comprehensive and exceptionally useful. Well worth your time if you want to become an Excel pro!" - Ernie Atkins "I've been using Excel for over 20 years and consider myself to be an Excel "power user". As with every single course by Chris, I go in with pretty solid knowledge of the material (formulas, VBA, Power Query, etc) and walk out twice as powerful as I walked in. This course is no different -- I PROMISE you, you will find absolute gems in this course. You will never regret an investment in your future with Maven Analytics!" -Ryan Hughes Who this course is for: Excel users looking to level-up and master the same tools and techniques used by Excel MVPs Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level Students looking for an engaging, hands-on, and highly interactive approach to Excel training Anyone looking to pursue a career in data analysis or business intelligence This course is NOT recommended for absolute beginners (some prior experience with Excel is encouraged) Show more Show less Course content 8 sections • 93 lectures • 10h 31m total length Expand all sections Getting Started 4 lectures • 6min Course Structure & Outline Preview 01:58 READ ME: Important Notes for New Students 01:54 DOWNLOAD: Course Resource Files 00:19 Setting Expectations Preview 01:45 Excel Productivity Tips 16 lectures • 1hr 41min Introduction 00:29 Customizing the Excel Footer 04:03 Navigating Workbooks with CTRL Shortcuts 08:01 Accessing Ribbon Tools with ALT Key Tips 06:53 Accessing Excel's "Go To" Special Options 04:36 Removing Blank Rows in Excel Worksheets 03:17 Creating Drop-Down Menus with Data Validation Preview 07:11 Filling Patterns with Autofill & Flash Fill 08:26 Customizing the Excel Ribbon Tools 06:53 Splitting Text to Columns in Excel 07:39 Synchronous Scrolling Across Multiple Workbooks 02:58 Extracting Unique Values from a List in Excel 04:06 Using Named Range & Table References in Excel Formulas 08:12 Protecting Cells & Formulas in Excel Workbooks Preview 08:09 Multi-Level Row & Column Sorting 10:54 Configuring Advanced Filter Criteria in Excel 09:27 QUIZ: Excel Productivity Tips 10 questions Excel Formatting Tips 15 lectures • 1hr 31min Introduction 00:26 Excel Formatting Shortcuts 04:28 Snapping Objects to the Excel Grid 04:30 Hiding Excel Workbook Elements 04:03 Replicating Formats & Styles with Excel's Format Painter 06:41 Color & Border Design Tips in Excel 07:03 Freezing Panes in Excel Worksheets Preview 05:58 Centering Across a Selection 04:33 Creating an "Invisible" Format 03:55 Zip Codes & Phone Numbers 05:09 Grouping Worksheet Columns & Rows 06:25 Formatting Excel Errors with IFERROR 05:50 Converting Excel Text to Dates 10:39 Creating Dynamic Formats with Excel Formulas 10:41 Advanced Excel Number Formats Preview 10:37 QUIZ: Excel Formatting Tips 10 questions Excel Formula Tips 16 lectures • 2hr 1min Introduction 00:28 Manual vs. Automatic Calculation Modes in Excel 04:19 Adding Line Breaks to Excel Formulas 04:05 Converting Units of Measurement with Excel Formulas 05:50 Building Real-Time Tools with TODAY & NOW Functions 10:18 Excel Formula Auditing Tools Preview 11:18 Designing Pivot-Style Reports with Excel Formulas 08:37 Counting Words in Excel with LEN & SUBSTITUTE Functions 07:24 Configuring Dependent Drop-Down Menus with INDIRECT 08:29 Creating Custom Hyperlinks Between Excel Worksheets 08:13 Using Approximate Match VLOOKUP Functions 07:15 Randomizing a Selection with OFFSET & RANDBETWEEN Functions Preview 06:26 Combining INDEX & MATCH Functions 08:40 Finding Matching Items Across Lists in Excel 11:00 Counting Duplicate Values with SUMPRODUCT 08:59 Using Many-to-Many Lookups in Excel 09:53 QUIZ: Excel Formula Tips 10 questions Excel Visualization Tips 13 lectures • 1hr 35min Introduction 00:24 Configuring Excel Chart Properties (Move & Size) 05:08 Managing Hidden Chart Source Data in Excel Worksheets 02:43 Visualizing Geospatial Data with Filled Maps (Excel 2016+ or Office 365) 05:10 Customizing Excel Charts to Tell a Story 08:54 Adding Sparklines to Worksheet Cells 07:44 Designing Custom Chart Templates in Excel 06:06 Building Excel Heat Maps Using Color Scales Preview 07:11 Analyzing Distribution with Histograms 09:28 Goal Pacing with Custom Excel Gauge Charts 10:26 Highlighting Time Periods with Combo Charts 08:05 Configuring Dynamic Chart Source Ranges 12:08 Creating Interactivity with Excel Form Controls Preview 11:48 QUIZ: Excel Visualization Tips 10 questions Excel Pivot Table Tips 15 lectures • 1hr 37min Introduction 00:18 Customizing the Pivot Table Field List 04:07 Autofitting Column Width in Pivot Tables 04:21 Pivot Table Outline & Tabular Layouts 07:46 Counting Non-Numerical Fields Using Pivots 06:05 Grouping & Ungrouping Dates with Pivot Tables 08:03 Enabling Multiple Pivot Table Filters 05:00 Grouping Values into Buckets with Pivot Tables Preview 06:50 Adding Value Calculations to Pivot Tables 09:01 Configuring Pivot Table Errors & Empty Items 06:22 Configuring Pivot Table Slicers & Timelines 10:23 Advanced Pivot Table Conditional Formatting 08:23 Removing & Reviving Pivot Table Source Data 08:19 Adding Custom Sort Lists in Excel Preview 05:23 Solve Order & List Formula Reports 06:16 QUIZ: Excel Pivot Table Tips 10 questions Excel Analytics Tips 13 lectures • 1hr 59min Introduction 00:29 Excel Quick Analysis Tools 06:03 Comparing Outcomes Using the Scenario Manager 07:55 Solving Simple Optimizations with Goal Seek 06:33 Creating Basic Forecasts in Excel 11:10 Building an Outlier Detection Tool in Excel Preview 09:24 Generating Automated Data Tables 08:06 Connecting & Transforming Data with Power Query 10:41 Creating Relational Data Models in Excel 10:23 Accessing the Data Model with CUBE Functions 16:21 Building a Monte Carlo Simulation in Excel 11:38 Advanced Optimization with Solver Preview 12:16 Excel Analysis ToolPak (Preview) 08:10 QUIZ: Excel Analytics Tips 10 questions Wrapping Up 1 lecture • 1min BONUS LECTURE: More from Maven Analytics 00:55 Instructors Maven Analytics Award-Winning Analytics & Business Intelligence Training 4.6 Instructor Rating 178,414 Reviews 529,779 Students 23 Courses Maven Analytics transforms everyday people into data rockstars by streamlining, simplifying, and personalizing the online learning experience. Since 2014 we've helped students and teams across 150+ countries develop the most sought-after analytics and business intelligence skills, through on-demand courses, skills assessments, curated learning paths, and enterprise training. Learning new skills shouldn’t be complicated. Think of Maven as your personal team of instructors, experts, mentors and guides, helping you navigate the learning process and develop the skills you need, on-demand. Show more Show less Chris Dutton Founder, Maven Analytics 4.6 Instructor Rating 161,148 Reviews 529,779 Students 6 Courses Chris Dutton is a certified Excel MOS Expert , edtech entrepreneur , and best-selling analytics instructor . As founder and COO of Maven Analytics, Chris' work has been featured by Microsoft , HuffPost , Entrepreneur , and the New York Times , reaching more than 500,000 students around the world. A leader in analytics education, Maven Analytics empowers everyday people to change the world with data. 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:'6781006a79554066',m:'9b50c5b3856b208773f57020d38fbf06ae1b32fc-1627841200-1800-AZoSY5JzJIKeWXzsk9I0fx33kJfBXr8Zo6a2hFj07FQtdoEy4IW7PrGfhKyQhT56hiBbazOLKWfoCUpqWV9slGCgMA5XBX61YRgpL2aAKEhR7Kv9rfSqCYR/ja+2eZhZ93T50AelorIlyr9GOGikpsNZ+eN3W20ihviyojzTxX+C44b/scxxPwJS270SpMK7hA==',s:[0x377ee022b0,0x2126bcc04e],}})();
  6. Become an absolute Excel POWER USER Requirements Microsoft Excel 2007-2019 or Office 365 (Note: some tips may not apply to all versions of Excel) Experience with formulas & functions, basic charts, and PivotTables strongly encouraged (but not required) This course is designed for PC users (some tips & tools may not be available for Mac) Description COURSE DESCRIPTION: This course is designed to transform everyday people into Excel POWER USERS . It's not about comprehensive, 101-style deep dives into Excel's core capabilities, or about showing off cheesy, impractical Excel "hacks". It's about featuring some of the most powerful and effective tools & techniques used by Excel professionals, and sharing them through crystal clear demos and unique, real-world case studies. Unlike most Excel courses, this one is non-linear and constantly evolving . This means that you can jump to different sections or individual lectures freely, and explore brand new Excel tips added on a regular basis. Each video is designed