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
The course was created with Microsoft Excel 2019, however, it was carefully created to work in Excel 2010, 2013, 2016 and 2017. 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 performing mathematical operations, manipulating texts, working with dates and time, using matching and lookup formulas, performing 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:
Beginners and Intermediate Users of Excel
Students who wish to master Microsoft Excel for data analysis
I am a professional teacher with natural aptitude for imparting knowledge. I am also a quantitative data analyst and an expert at using various software for data analysis which include Microsoft Excel, Python, R, SPSS, STATA and Eviews. I am most passionate about skills development and the need for digital innovation.