Microsoft Excel Mastery + Complete Formulas & Functions
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
Requirements
- 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.
Description
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
Course content
- Preview01:21
- Preview21:32
- Preview25:59
- 18:38Working with Formulas and Functions
- 06:09Entering Formulas in Excel
- 10:04Cell References (Absolute, Relative, Mixed References)
- 05:00Using Formulas in Tables
- 06:50Excel's Error-Values
- 27:44Mathematical Operations in Excel (Calculating Percentages)
- 18:43Mathematical Operations in Excel (Rounding Numbers)
- 07:36Mathematical Operations in Excel (Counting and Conversion Formulas)
- 25:49Formulas for Manipulating Texts
- 18:01Working with Formulas for Dates and Times
- 14:15Conditional Analysis (Simple and Multiple Conditions)
- 13:46Conditional Analysis (Summing and Averaging)
- 25:09Matching and Lookup Formulas
- 25:05Financial Analysis I
- 18:09Financial Analysis II
- 03:54Financial Forecasting
- 20:47Statistical Analysis
Instructor
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.