Excel - Creating Dashboards

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

Course Description

Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers

Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards.

The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that.

Who this course is for:

  • Microsoft Excel users looking to get more out of their Excel experience.

Course content

1 section • 20 lectures • 2h 49m total length
  • Using Defined Names in a Formula
    04:17
  • Using Specialized Functions, Part 1
    07:18
  • Using Specialized Functions, Part 2
    11:58
  • Applying Data Validation
    12:28
  • Using a Data Form
    05:49
  • Adding Form Controls
    09:26
  • Using Lookup Functions
    11:39
  • Combining Functions
    11:10
  • Creating a Chart
    07:19
  • Formatting and Modifying Charts
    13:56
  • Dual Axis Charts
    05:38
  • Forecasting with Trend Lines
    08:03
  • Creating Chart Templates
    02:58
  • Creating Sparklines
    07:18
  • Inserting Pivot Tables
    09:47
  • Analyzing Pivot Table Data, Part 1
    07:42
  • Analyzing Pivot Table Data, Part 2
    08:36
  • Presenting Data with Pivot Charts
    06:47
  • Filtering Data with Slicers
    06:53

Instructor

Bigger Brains
  • 4.4 Instructor Rating
  • 20,832 Reviews
  • 95,390 Students
  • 98 Courses

Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness.

Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine.

Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa.

Expected Outcomes

  1. Use range names in formulas Create nested functions Work with forms, form controls, and data validation Use lookup functions Combine multiple functions Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  2. Create nested functions Work with forms, form controls, and data validation Use lookup functions Combine multiple functions Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  3. Work with forms, form controls, and data validation Use lookup functions Combine multiple functions Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  4. Use lookup functions Combine multiple functions Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  5. Combine multiple functions Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  6. Create, modify, and format charts Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  7. Use sparklines, trendlines, and dual-axis charts Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  8. Create a PivotTable and analyze PivotTable data Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  9. Present data with PivotCharts Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();
  10. Filter data with slicers Requirements A copy of Microsoft Excel is recommended. Description Get More From Excel – Learn To Use Forms, Lookup Functions, Charts, PivotTables, and Slicers To Turn Data Into Answers Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, PivotTables, and Slicers) which will do just that. Who this course is for: Microsoft Excel users looking to get more out of their Excel experience. Show more Show less Course content 1 section • 20 lectures • 2h 49m total length Creating Dashboards 20 lectures • 2hr 49min Creating Range Names Preview 10:17 Using Defined Names in a Formula 04:17 Using Specialized Functions, Part 1 07:18 Using Specialized Functions, Part 2 11:58 Applying Data Validation 12:28 Using a Data Form 05:49 Adding Form Controls 09:26 Using Lookup Functions 11:39 Combining Functions 11:10 Creating a Chart 07:19 Formatting and Modifying Charts 13:56 Dual Axis Charts 05:38 Forecasting with Trend Lines 08:03 Creating Chart Templates 02:58 Creating Sparklines 07:18 Inserting Pivot Tables 09:47 Analyzing Pivot Table Data, Part 1 07:42 Analyzing Pivot Table Data, Part 2 08:36 Presenting Data with Pivot Charts 06:47 Filtering Data with Slicers 06:53 Instructor Chip Reaves Bigger Brains 4.4 Instructor Rating 20,832 Reviews 95,390 Students 98 Courses Bigger Brains Founder and President Chip Reaves is a serial entrepreneur who has started five successful companies. An Atlanta native, Chip began fixing computers for small businesses in the 1980's while studying Computer Science at Georgia Tech. After 10 years building a successful IT Service Practice in Atlanta, Chip founded the Computer Troubleshooters franchise system alongside Wilson & Suzanne McOrist, which became the world's largest computer service franchise and received multiple awards from Entrepreneur Magazine, Franchise Business Review, and AllBusiness. Chip has been interviewed on TV and other major media on topics related to small business technology and entrepreneurship, including ABC News, BusinessWeek TV, the Wall Street Journal, and the New York Times, and is a member of Jim Blasingame's "Brain Trust" on SmallBusinessAdvocate. In 2010 Chip was listed among the Top 150 most influential people in small business IT by SMB PC magazine. Chip lives with his wife Maren and step-daughter Meg in Anderson, South Carolina where they also co-own a Computer Troubleshooters franchise location. In his spare time Chip is very active with his church and local charities, and consults with two aid organizations serving Rwanda and the Democratic Republic of Congo in Africa. 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:'6781d0617c1040f0',m:'a76d50a13bc4047f8423b1c4cc8d129851f1239a-1627849719-1800-ASULdLZFeJ7mLoRECQriLLc7c3PFCxxgdmI2jRBTck9H34mmj9OBYvGB6KsEDuxYNEzA/CRzRz5/RoymekZ5qzpwJOczNnpiKGD423ipZCozLmi0LsRV73QbkZP1NhB0cLmythFD2mYQpTfT50lTBDwlMoaq6Zj3fyuIEfKPySoP',s:[0xbc7a0bf1c2,0x42bc98c5df],}})();