Microsoft Excel : Basic to advance in one course

Microsoft Excel : Basic to advance in one course

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.

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.

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

Url: View Details

What you will learn

• Basic excel functions
• Pivot table
• Vlookup Hlookup, shortcuts

Rating: 3.8

Level: All Levels

Duration: 39 mins

Instructor: Gaurav Tatwawadi