Learn Microsoft Excel : Advanced Tactics for Professionals

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

Course Description

If you are looking for an Excel Course for beginner to Experts then this course is all about the small Tips and Tricks used in Microsoft Excel. This Course has some important tips for every beginner to expert.

Excel is the spreadsheet application in the newest Microsoft Office suite. In the videos you will learn the basic techniques including the maths, statistics and logical functions and many more other areas. You will also learn the advanced techniques like VLOOKUP , PIVOT etc.

Once you are enrolled i will always be there to assist you in case of any doubts.



Who this course is for:

  • From Beginners to Expert in Excel
  • IT Professionals

Course content

3 sections • 23 lectures • 1h 55m total length

Instructor

Certified SAP MM Consultant
  • 3.9 Instructor Rating
  • 916 Reviews
  • 3,430 Students
  • 30 Courses

Over 10 years of experience on SAP MM, IM and WM functional consultant in various SAP R/3 implementations, industries- Process, Manufacturing, Energy and chemical.

Excellent understanding of business processes in Logistics – Material management & Inventory management.

Experienced in 6 full life-cycle implementation phases of a project (ASAP Methodology) - blueprinting, realization, testing ( Unit testing, User acceptance testing, Assembly testing and integration testing ), final preparation, training, documentation, data uploading, go live and post go live (production) support.

Interacted with business partners to understand the AS-IS process and work on developing TO-BEprocess.

Designed, tested and supported for the development of functional specifications for RICEFW objects..

Conducted Business blue printings - Requirement definitions, system/process mapping & solution design.

Worked on different kinds of projects such as New End-to-end implementation projects, Development projects, up gradation projects, Enhancement projects.

Configured MM Organizational Elements: Company code, Purchasing Organization, Plant & Storage loc.

MM-Purchasing/Procurement: Hands on experience in configuring Material Master, Vendor Master, Partner schema, Purchase requisition, Purchases order, Venison management, shelf like check and pricing schemas.

Expertise in designing scenarios like outline agreements, RFQ, source list, info records, quota arrangement, Scheduling agreement, Reservation, Vendor consignment, subcontracting and vendor evaluation.

Inventory Management: Customizing done in Goods Movements, Cross Company and Intra-company Stock Transport orders using Stock Transport order (STO), Subcontracting, Customer and Vendor Consignment & Third Party Orders, Physical Inventory, Cycle Counting.

Configuration of Inventory Management Movement Types, Number ranges for material document of Goods Receipt, Goods Issue, shelf life check for movement types and Stock Transfers- inter and intra company.

Expected Outcomes

  1. Learn about the basic terms of Microsoft Excel Learn about the various functions used in Excel Learn about the various short cut keys of Excel Requirements Basic Knowledge of Computers Description If you are looking for an Excel Course for beginner to Experts then this course is all about the small Tips and Tricks used in Microsoft Excel. This Course has some important tips for every beginner to expert. Excel is the spreadsheet application in the newest Microsoft Office suite. In the videos you will learn the basic techniques including the maths, statistics and logical functions and many more other areas. You will also learn the advanced techniques like VLOOKUP , PIVOT etc. Once you are enrolled i will always be there to assist you in case of any doubts. Who this course is for: From Beginners to Expert in Excel IT Professionals Show more Show less Course content 3 sections • 23 lectures • 1h 55m total length Expand all sections Introduction to the Course 1 lecture • 4min Introduction Preview 04:29 Learn Microsoft Excel Step by Step 19 lectures • 1hr 29min Basic Terms of Microsoft Excel Preview 11:50 Auto Sum Function 06:40 Average Function 03:22 Count Function 05:11 Concatenate Function 04:09 Absolute Reference Function 02:56 Auto Fill Function 05:19 UPPER and PROPER Function 02:18 LEN and TRIM Function 03:27 MAX MIN and IF Function 04:58 COUNTIF Function 06:03 CHART Feature 03:38 VLOOKUP Function 07:15 HLOOKUP Function 03:26 Sum As Running Total Formula 02:35 Fill Serial Numbers Automatically 03:00 Hyperlink Feature 03:45 Convert Number to Text 02:41 Pivot Table Function 06:54 Short Cut Keys 3 lectures • 21min Short Cut Keys - Part 1 06:47 Short Cut Keys - Part 2 08:10 Short Cut Keys - Part 3 06:28 Instructor Sumit Jain Certified SAP MM Consultant 3.9 Instructor Rating 916 Reviews 3,430 Students 30 Courses Over 10 years of experience on SAP MM, IM and WM functional consultant in various SAP R/3 implementations, industries- Process, Manufacturing, Energy and chemical. Excellent understanding of business processes in Logistics – Material management & Inventory management. Experienced in 6 full life-cycle implementation phases of a project ( ASAP Methodology ) - blueprinting, realization, testing ( Unit testing, User acceptance testing, Assembly testing and integration testing ), final preparation, training, documentation, data uploading, go live and post go live ( production ) support. Interacted with business partners to understand the AS-IS process and work on developing TO-BE process. Designed, tested and supported for the development of functional specifications for RICEFW objects.. Conducted Business blue printings - Requirement definitions, system/ process mapping & solution design. Worked on different kinds of projects such as New End-to-end implementation projects, Development projects, up gradation projects, Enhancement projects. Configured MM Organizational Elements: Company code, Purchasing Organization, Plant & Storage loc. MM-Purchasing/Procurement : Hands on experience in configuring Material Master, Vendor Master, Partner schema, Purchase requisition, Purchases order, Venison management, shelf like check and pricing schemas . Expertise in designing scenarios like outline agreements , RFQ , source list, info records, quota arrangement, Scheduling agreement, Reservation, Vendor consignment, subcontracting and vendor evaluation. Inventory Management: Customizing done in Goods Movements , Cross Company and Intra-company Stock Transport orders using Stock Transport order (STO ), Subcontracting, Customer and Vendor Consignment & Third Party Orders, Physical Inventory, Cycle Counting. Configuration of Inventory Management Movement Types, Number ranges for material document of Goods Receipt, Goods Issue, shelf life check for movement types and Stock Transfers- inter and intra company. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781ea0d885c405d',m:'e13744d9a510b26eb69a4bbe2722a3e9b556a0f8-1627850770-1800-ARUkgUHk7TcNyXZTviu8RsGwvUfl8YWpjZChh8a8tDA1jyU/k4jTYGzf0iptK0jJUR9sZc/VCMvoUfTRummuKDGAeyqDjpl9Xfi1ywr5bJPHebYVbXxxY1sf8CZf3IyikVNYx4TQ82Q1mVfe6Dn3KohzEe4BGmPvBjWZlyDEqgMF',s:[0xd88b85a763,0x8d8d3a0951],}})();
  2. Learn about the various functions used in Excel Learn about the various short cut keys of Excel Requirements Basic Knowledge of Computers Description If you are looking for an Excel Course for beginner to Experts then this course is all about the small Tips and Tricks used in Microsoft Excel. This Course has some important tips for every beginner to expert. Excel is the spreadsheet application in the newest Microsoft Office suite. In the videos you will learn the basic techniques including the maths, statistics and logical functions and many more other areas. You will also learn the advanced techniques like VLOOKUP , PIVOT etc. Once you are enrolled i will always be there to assist you in case of any doubts. Who this course is for: From Beginners to Expert in Excel IT Professionals Show more Show less Course content 3 sections • 23 lectures • 1h 55m total length Expand all sections Introduction to the Course 1 lecture • 4min Introduction Preview 04:29 Learn Microsoft Excel Step by Step 19 lectures • 1hr 29min Basic Terms of Microsoft Excel Preview 11:50 Auto Sum Function 06:40 Average Function 03:22 Count Function 05:11 Concatenate Function 04:09 Absolute Reference Function 02:56 Auto Fill Function 05:19 UPPER and PROPER Function 02:18 LEN and TRIM Function 03:27 MAX MIN and IF Function 04:58 COUNTIF Function 06:03 CHART Feature 03:38 VLOOKUP Function 07:15 HLOOKUP Function 03:26 Sum As Running Total Formula 02:35 Fill Serial Numbers Automatically 03:00 Hyperlink Feature 03:45 Convert Number to Text 02:41 Pivot Table Function 06:54 Short Cut Keys 3 lectures • 21min Short Cut Keys - Part 1 06:47 Short Cut Keys - Part 2 08:10 Short Cut Keys - Part 3 06:28 Instructor Sumit Jain Certified SAP MM Consultant 3.9 Instructor Rating 916 Reviews 3,430 Students 30 Courses Over 10 years of experience on SAP MM, IM and WM functional consultant in various SAP R/3 implementations, industries- Process, Manufacturing, Energy and chemical. Excellent understanding of business processes in Logistics – Material management & Inventory management. Experienced in 6 full life-cycle implementation phases of a project ( ASAP Methodology ) - blueprinting, realization, testing ( Unit testing, User acceptance testing, Assembly testing and integration testing ), final preparation, training, documentation, data uploading, go live and post go live ( production ) support. Interacted with business partners to understand the AS-IS process and work on developing TO-BE process. Designed, tested and supported for the development of functional specifications for RICEFW objects.. Conducted Business blue printings - Requirement definitions, system/ process mapping & solution design. Worked on different kinds of projects such as New End-to-end implementation projects, Development projects, up gradation projects, Enhancement projects. Configured MM Organizational Elements: Company code, Purchasing Organization, Plant & Storage loc. MM-Purchasing/Procurement : Hands on experience in configuring Material Master, Vendor Master, Partner schema, Purchase requisition, Purchases order, Venison management, shelf like check and pricing schemas . Expertise in designing scenarios like outline agreements , RFQ , source list, info records, quota arrangement, Scheduling agreement, Reservation, Vendor consignment, subcontracting and vendor evaluation. Inventory Management: Customizing done in Goods Movements , Cross Company and Intra-company Stock Transport orders using Stock Transport order (STO ), Subcontracting, Customer and Vendor Consignment & Third Party Orders, Physical Inventory, Cycle Counting. Configuration of Inventory Management Movement Types, Number ranges for material document of Goods Receipt, Goods Issue, shelf life check for movement types and Stock Transfers- inter and intra company. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781ea0d885c405d',m:'e13744d9a510b26eb69a4bbe2722a3e9b556a0f8-1627850770-1800-ARUkgUHk7TcNyXZTviu8RsGwvUfl8YWpjZChh8a8tDA1jyU/k4jTYGzf0iptK0jJUR9sZc/VCMvoUfTRummuKDGAeyqDjpl9Xfi1ywr5bJPHebYVbXxxY1sf8CZf3IyikVNYx4TQ82Q1mVfe6Dn3KohzEe4BGmPvBjWZlyDEqgMF',s:[0xd88b85a763,0x8d8d3a0951],}})();
  3. Learn about the various short cut keys of Excel Requirements Basic Knowledge of Computers Description If you are looking for an Excel Course for beginner to Experts then this course is all about the small Tips and Tricks used in Microsoft Excel. This Course has some important tips for every beginner to expert. Excel is the spreadsheet application in the newest Microsoft Office suite. In the videos you will learn the basic techniques including the maths, statistics and logical functions and many more other areas. You will also learn the advanced techniques like VLOOKUP , PIVOT etc. Once you are enrolled i will always be there to assist you in case of any doubts. Who this course is for: From Beginners to Expert in Excel IT Professionals Show more Show less Course content 3 sections • 23 lectures • 1h 55m total length Expand all sections Introduction to the Course 1 lecture • 4min Introduction Preview 04:29 Learn Microsoft Excel Step by Step 19 lectures • 1hr 29min Basic Terms of Microsoft Excel Preview 11:50 Auto Sum Function 06:40 Average Function 03:22 Count Function 05:11 Concatenate Function 04:09 Absolute Reference Function 02:56 Auto Fill Function 05:19 UPPER and PROPER Function 02:18 LEN and TRIM Function 03:27 MAX MIN and IF Function 04:58 COUNTIF Function 06:03 CHART Feature 03:38 VLOOKUP Function 07:15 HLOOKUP Function 03:26 Sum As Running Total Formula 02:35 Fill Serial Numbers Automatically 03:00 Hyperlink Feature 03:45 Convert Number to Text 02:41 Pivot Table Function 06:54 Short Cut Keys 3 lectures • 21min Short Cut Keys - Part 1 06:47 Short Cut Keys - Part 2 08:10 Short Cut Keys - Part 3 06:28 Instructor Sumit Jain Certified SAP MM Consultant 3.9 Instructor Rating 916 Reviews 3,430 Students 30 Courses Over 10 years of experience on SAP MM, IM and WM functional consultant in various SAP R/3 implementations, industries- Process, Manufacturing, Energy and chemical. Excellent understanding of business processes in Logistics – Material management & Inventory management. Experienced in 6 full life-cycle implementation phases of a project ( ASAP Methodology ) - blueprinting, realization, testing ( Unit testing, User acceptance testing, Assembly testing and integration testing ), final preparation, training, documentation, data uploading, go live and post go live ( production ) support. Interacted with business partners to understand the AS-IS process and work on developing TO-BE process. Designed, tested and supported for the development of functional specifications for RICEFW objects.. Conducted Business blue printings - Requirement definitions, system/ process mapping & solution design. Worked on different kinds of projects such as New End-to-end implementation projects, Development projects, up gradation projects, Enhancement projects. Configured MM Organizational Elements: Company code, Purchasing Organization, Plant & Storage loc. MM-Purchasing/Procurement : Hands on experience in configuring Material Master, Vendor Master, Partner schema, Purchase requisition, Purchases order, Venison management, shelf like check and pricing schemas . Expertise in designing scenarios like outline agreements , RFQ , source list, info records, quota arrangement, Scheduling agreement, Reservation, Vendor consignment, subcontracting and vendor evaluation. Inventory Management: Customizing done in Goods Movements , Cross Company and Intra-company Stock Transport orders using Stock Transport order (STO ), Subcontracting, Customer and Vendor Consignment & Third Party Orders, Physical Inventory, Cycle Counting. Configuration of Inventory Management Movement Types, Number ranges for material document of Goods Receipt, Goods Issue, shelf life check for movement types and Stock Transfers- inter and intra company. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781ea0d885c405d',m:'e13744d9a510b26eb69a4bbe2722a3e9b556a0f8-1627850770-1800-ARUkgUHk7TcNyXZTviu8RsGwvUfl8YWpjZChh8a8tDA1jyU/k4jTYGzf0iptK0jJUR9sZc/VCMvoUfTRummuKDGAeyqDjpl9Xfi1ywr5bJPHebYVbXxxY1sf8CZf3IyikVNYx4TQ82Q1mVfe6Dn3KohzEe4BGmPvBjWZlyDEqgMF',s:[0xd88b85a763,0x8d8d3a0951],}})();