Course details
Learn the essentials of Microsoft Excel Analytics through this step-by-step course. The Data Analytics with Microsoft Excel course takes you through the basics of Excel Analytics, but also introduces some more advanced topics like advanced filters, pivot charts and pivot tables. The course also learns you some, shortcuts, tips and tricks for improving your productivity in working with Excel.
Learn to build a dashboard from scratch!
Shorcuts can boost your productivity up to 5X.. and improve improve your efficiency in building dashboards!
The course contains training materials, where you can practice, apply your knowledge and build a dashboard from scratch. The training materials are provided in an Excel file that you can download to your computer. Each module also ends with a short quiz and there is a final quiz at the end of the course.
Good luck and hope you enjoy the course.
Pre-requisites:
- Some basic knowledge of Microsoft Excel Analytics
Course content:
The course consists of the following modules:
- Introduction, shortcuts, tips & tricks!
- Excel Basic Formulas: COUNT, COUNTIF(S), SUM, SUMIF(S), AVERAGE, VLOOKUP, IF(S), INDEX/MATCH, CONCATENATE, TRIM
- Conditional Formatting and Cell Formatting
- Charts and Tables
- Sorting and Filtering
- Pivot Charts and Pivot Tables
- Final Quiz
Who should follow this course?
- You should take this course if you want to learn the essentials of Microsoft Excel from scratch.
- This is not a course for advanced Excel users, but for novice users that would like to broaden their knowledge of Excel.
- This is an ideal course for novice Excel users that would like to take their Excel skills to the next level.
- Professionals that would like to get a good knowledge of Excel, as part of their employers learning program.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel 2016 Beginners Adams AcademyUSD 25
USD 480Duration: Upto 18 Hours - Microsoft Excel Certification Level 3 Courses Distance Learning Ltd.USD 50
USD 100Duration: Upto 10 Hours