Learn Microsoft Excel : Advanced Tactics for Professionals
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Microsoft Excel : Advanced Tactics for Professionals to your Wishlist.

Add to Wishlist

Learn Microsoft Excel : Advanced Tactics for Professionals

Learn about the Microsoft Excel right from the beginning and all important features.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Created by Sumit Jain
Last updated 12/2015
English
Current price: $10 Original price: $45 Discount: 78% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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 is the target audience?
  • From Beginners to Expert in Excel
  • IT Professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 23 Lectures Collapse All 23 Lectures 01:55:21
+
Introduction to the Course
1 Lecture 04:29
+
Learn Microsoft Excel Step by Step
19 Lectures 01:29:27

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 21:25
Short Cut Keys - Part 1
06:47

Short Cut Keys - Part 2
08:10

Short Cut Keys - Part 3
06:28
About the Instructor
Sumit Jain
4.3 Average rating
196 Reviews
1,389 Students
27 Courses
Certified SAP MM Consultant

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.