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
$19
$45
58% off
Take This Course
  • Lectures 23
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

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.



What are the requirements?

  • Basic Knowledge of Computers

What am I going to get from this course?

  • 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

What is the target audience?

  • From Beginners to Expert in Excel
  • IT Professionals

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the Course
Introduction
Preview
04:29
Section 2: Learn Microsoft Excel Step by Step
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
Section 3: Short Cut Keys
Short Cut Keys - Part 1
06:47
Short Cut Keys - Part 2
08:10
Short Cut Keys - Part 3
06:28

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sumit Jain, 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.

Ready to start learning?
Take This Course