Microsoft Excel 2016 Course - Basics to Expert

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

Course Description

Excel 2016 Course is a complete set of guides from the popular Microsoft application.

We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting.

The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards.

Who this course is for:

  • Anyone who wants to learn how to use the popular Excel 2016 program

Course content

1 section • 22 lectures • 1h 45m total length
  • Working with data cells
    07:15
  • Formatting data
    05:24
  • Sorting and filtering data
    03:21
  • Grouping data in tables
    05:10
  • Creating charts
    07:41
  • Creating sparklines
    04:19
  • Using formulas
    07:54
  • Using AutoSum
    02:39
  • Financial functions
    04:25
  • Logical functions
    02:49
  • Text functions
    02:34
  • Date and time functions
    03:01
  • Lookup and reference functions
    03:37
  • Math and trigonometry functions
    04:22
  • Specific functions
    04:19
  • Creating pivot tables
    07:05
  • Creating pivot charts
    03:10
  • Automating work by using macros
    06:56
  • Saving and sharing a finished workbook
    03:30

Instructor

Oficjalny Partner Microsoft
  • 4.1 Instructor Rating
  • 715 Reviews
  • 2,892 Students
  • 24 Courses

Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas.

Expected Outcomes

  1. Create and work with spreadsheets Create charts Create data tables Work with data cells Apply basic and advanced formulas Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();
  2. Create charts Create data tables Work with data cells Apply basic and advanced formulas Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();
  3. Create data tables Work with data cells Apply basic and advanced formulas Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();
  4. Work with data cells Apply basic and advanced formulas Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();
  5. Apply basic and advanced formulas Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();
  6. Create reports Requirements Basic computer skills Description Excel 2016 Course is a complete set of guides from the popular Microsoft application. We work with data cells and develop a sales report. We use charts, formulas and tables as well as apply macros. In addition, we discuss pivot tables, pivot charts, sparklines and the mechanisms of conditional formatting. The course prepared by Partner of the Year Microsoft 2016 and Finalist 2017 Microsoft Partner of the Year Awards. Who this course is for: Anyone who wants to learn how to use the popular Excel 2016 program Show more Show less Course content 1 section • 22 lectures • 1h 45m total length Introducing the spreadsheet 22 lectures • 1hr 45min Introducing the spreadsheet Preview 06:33 Working with data cells 07:15 Formatting data 05:24 Excel status bar Preview 04:11 Sorting and filtering data 03:21 Conditional formatting Preview 04:49 Grouping data in tables 05:10 Creating charts 07:41 Creating sparklines 04:19 Using formulas 07:54 Using AutoSum 02:39 Financial functions 04:25 Logical functions 02:49 Text functions 02:34 Date and time functions 03:01 Lookup and reference functions 03:37 Math and trigonometry functions 04:22 Specific functions 04:19 Creating pivot tables 07:05 Creating pivot charts 03:10 Automating work by using macros 06:56 Saving and sharing a finished workbook 03:30 Instructor Akademia CentrumXP Oficjalny Partner Microsoft 4.1 Instructor Rating 715 Reviews 2,892 Students 24 Courses Jesteśmy największym w Polsce sprzedawcą Office 365 i Azure dla małych i średnich przedsiębiorstw oraz liderem na rynku szkoleń e-learningowych z oprogramowania Microsoft. Prowadzimy też najpopularniejszy w Polsce portal o technologii Microsoft - CentrumXP. Naszą pasją jest technologia Microsoft, dlatego zapraszamy na nasze media społecznościowe, gdzie możecie dołączyć do największej społeczności ludzi podobnych do nas. 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:'6781e74cfcad0656',m:'b9706ae5ed8cff41989be2331a1a48004157cec7-1627850657-1800-Af9bhKe1YyMaSkZQda0dqYv7yuAl90SRJxqCUpeY69CGjwgwSMMwe8P6a2H+ShInzmz6G1197Qvtw7xQtSQkN8ejOYsy50Wmfpder0vWT9z50bwJ85u4HhzCw0KVcLmPfj9lBj0N6VH+G3dPlgoa54e4Diq1QcYhLRDIDIuDaiY5D5+am3fQHCL7Li1WEEXUMA==',s:[0xa39a9a5c76,0x8ded63dda6],}})();