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.
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.
Content