A Drop of Excel - the most essentials that anyone must know

4.5 /5

(2 Ratings)

Offered byUDEMY

A Drop of Excel - the most essentials that anyone must know
at
UDEMY
Overview

Learn everything you need to know about Excel and give a boost to your professional career

Duration	4 hours
Total fee	₹380
Mode of learning	Online
Credential	Certificate

A Drop of Excel - the most essentials that anyone must know
at
UDEMY
Highlights

Earn a Certificate of completion from Udemy
Get a 30 days money back guarantee on the course
Get full lifetime access of the course material
Learn from 9 downloadable resource

A Drop of Excel - the most essentials that anyone must know
at
UDEMY
Course details

Skills you will learn

Excel Conditional Formatting Vlookup

Who should do this course?

For Working professionals
For Marketing, Sales, Operations, Project managers, Product managers, Human Resource professionals
For Online and corporate trainers

What are the course deliverables?

Essentials of Excel that anyone must know
18 most useful Excel Shortcuts
Manage and work with a ton of data without feeling scared about it
Learn the right way to enter data - yes, the right way
Learn Vlookup in the easiest possible way, and even Xlookup
Dynamic reports using Pivot tables
Create formulas across sheets and files, without any confusion

More about this course

This course starting from the very scratch of Excel and not from any advanced level
Know the basics still getting the fundamentals right is very important and then we will move on to learn further
A lot of people have come to me saying that learning Excel is a very long process and seems very tedious

A Drop of Excel - the most essentials that anyone must know
at
UDEMY
Curriculum

What is a Drop of Excel?

Introduction

Fundamentals of Excel and some formulas to start with

User interface and cell referencing basics

Dataset Understanding

Data types and Data structure

Data and Cell Formatting

How to create Formulas & work with various Functions Fundamentals

Forget those days when a large set meant difficult and time consuming work

How to create a Formula across Sheets and or Files

How to work with Dates

How to work with a Large Set of Data

Restrict and Protect in Excel

More awesome formulas and reports to make your life easy

Working with IF Conditions and Conditional Formatting in Excel

Paste Special, Find & Replace, Go to Special

How to use $, Vlookup and Xlookup in Excel

Reporting using Pivot Tables, Slicers and Pivot Charts

A Drop of Excel - the most essentials that anyone must know
at
UDEMY
Faculty details

Rushabh Shah

He trained 3000+ Working professionals and Management students in Excel and other areas and also have an experience of 12+ years of multi-functional experience in the fields of Corporate Training, Information Technology, Digital Marketing, Business Analysis, Performance Management Systems, Sales Operations.