• Post category:StudyBullet-11
  • Reading time:3 mins read


Basic functions, advanced functions, look up functions, data analytics tool, formatting and shortcuts`

What you will learn

Basic excel functions

Pivot table

Vlookup Hlookup, shortcuts

Formatting, basics of VBA

Description

This course is tailored made for people who don’t know excel or have very basic knowledge. After completion of this course, the student will be able to do most of what excel can do. Please see the introduction video in which I have given lecture-wise what all topics would be covered in the course. The topics are:

  • Basic   Excel Lingo and  Predefined functions
  • Advanced  excel Function    (if, sum if, count if, financial functions, statistics functions)
  • Look up   functions    ( v lookup , h lookup)
  • Data   Analytics    ( goal seek, pivot table)
  • Formatting    (beautifying excel, macros,  simple shortcuts)

Excel is a very Important tool irrespective of the industry and this course can help anyone and everyone as in the end its all about data-keeping, its analytics, and insights. It can be useful for architects, project managers, product managers, finance graduates, filmmakers, executive producers, students and many more.


Get Instant Notification of New Courses on our Telegram channel.


This course will help you simplify the repetitive tasks as excel is a very important tool and this course will ensure you are at certain pedestal to start learning on your own using the internet. Microsoft Excel is one of the most powerful tools for data analysis, trading, dashboard making. This course does not cover macros in detail but in theory, you can use excel and create anything and everything as macros is sort of a programming tool in which you can code anything and VBA is the language used for it.

English
language

Content

Microsoft Excel

Introduction
Lecture 1
Lecture 2
Lecture 3
Lecture 4
Lecture 5