Excel – Beginners to Advance and Data Analytics
- Lectures: 44
- Video: 8.5 hours
- Skill level: All Levels
- Instructor: Analytics Leap
- Last updated: 7/2018
Watch this free Udemy video course and Quickly learn A-Z of Excel 2016, Formats, Pivots, Excel Charts, Excel Functions, Excel VBA and Data Analysis in Excel
- Basic computer knowledge and Ms Excel
This course is your complete guide to mastering Microsoft Excel. This course covers all aspects of working on Excel, starting from basic concepts like what are worksheets, rows, columns, tables and then moving onto different Formats in Excel and Conditional Formatting where we have covered all the different scenarios which one can think of. We then move onto more intermediate topics in Excel like Functions where we discuss Statistical, Math, Text, Logical, Lookup functions in MS Excel. We then discuss Data Protection and Validation which everyone uses to protect data from other users.
We then move onto more advanced topics of Pivot tables in which we discuss unique features of a pivot table and have a case study for you to understand how Pivot tables are used in real life. In Charts we cover distinct types of charts, how to do trend analysis using charts, sparkline charts and then move onto more statistical concepts which are essential for a data analyst – “what if” analysis, data interpretation using Data Analysis toolbox within Excel and finally VBA where we learn basics of VBA, how to create custom functions using VBA and finally a UserForm which will help you is automating your work!
Note: Please let us know whether Udemy coupon code worked for you or not in the comment section below. Also, if you took this Udemy course, share feedback about the course with our users. Thank you~