MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 20 lectures (5 hour, 14 mins) | Size: 3.15 GB
The course was created with Microsoft Excel 2019, however, it was carefully created to work in Excel 2010, 2013, 2016 and 2017.
What you'll learn
Gain Microsoft Excel Mastery for Data Analysis
Navigate, Format and Manage Data in Excel's Workbook and Worksheets
Understand the use of basic Formulas and Functions
Advanced Formulas and Functions
Conditional Analysis and Mathematical Operations
Financial and Statistical Analysis
Use of all Matching and Lookup Formulas
Make Excel's Formulas Error-free
So, a basic understanding of Excel will do.
This course aims to provide the student with the requisite knowledge to master Microsoft Excel for data analysis in all areas. Thus, you will be able to enter and edit worksheet data, perform basic worksheet operations, format the worksheets, and even customize the Excel's user interface.
The course provides great insight into using Excel for perfog mathematical operations, manipulating texts, working with dates and , using matching and lookup formulas, perfog conditional, financial, and statistical analysis. You will learn how to use advanced formulas and functions for working with the above operations and also make your work in Excel error-free.
Who this course is for:
Bners and Intermediate Users of Excel
Students who wish to master Microsoft Excel for data analysis