What will i learn?
- Banish your “phobia” for MS Excel for good.
- Conduct insightful analysis of small or large data sets.
- Build a dashboard to monitor your or your company's performance
- Present your work beautifully be it in a table, scatter, radar or pie chart.
Curriculum for this course
37 Lessons
03:59:03 Hours
Level 1
14 Lessons
01:41:38 Hours
- Finance Functions - Time Value Of Money 00:09:01
- IRR and NPV Function 00:07:25
- Creating A Simple Loan Amortization Schedule 00:00:08
- Using The IF Function 00:09:56
- Nesting IF With Other Logical Functions 00:06:28
- Making Calculations With Dates 00:07:42
- Introduction To Vlookup 00:06:44
- More Practical Vlookup 00:12:30
- Hlookup And Lookup Function 00:07:00
- Index And Match Function 00:10:05
- Running Scenarios with the Index Function 00:05:16
- Bank Reconciliation Using Excel Text Functions 00:07:20
- Using Excel Functions To Get The Top N performance 00:04:59
- Powerful Excel Indirect Reference Function 00:07:04
Level 2
17 Lessons
01:48:34 Hours
- Creating Hyperlinks And Data Validation 00:08:45
- Performing Data Consolidation 00:06:45
- Splitting Data Into Multiple Columns 00:03:51
- Using The Flash Fill Data Tools Command 00:02:43
- Removing Duplicates 00:02:00
- What-If-Analysis-Data Tables 00:08:48
- What-if-Analysis- Goal Seek 00:07:56
- What-If-Analysis-Scenario Manager 00:09:48
- What-if-Analysis - Solver 00:12:44
- Using Advanced Filters On Excel Tables 00:06:17
- Introduction To Excel Charts 00:06:34
- Designing And Formatting Chart Elements 00:08:14
- Working With Pivot Tables 00:09:48
- Working With Dates On A Pivot Table 00:03:21
- Getting Data From Access Into Excel 00:03:48
- Get External Data From A Text File And The Web 00:04:15
- Embedding MS Word Data into Excel 00:02:57
Level 3- Introduction to Macros
6 Lessons
00:28:51 Hours
- Introduction To Macros 00:04:26
- Recording Macros With Absolute And Relative Reference 00:09:36
- Creating A Format Macro 00:05:19
- Tour Of The VBA Editor 00:03:21
- Adding Macros To The Ribbon 00:06:09
- Macros Test File .
Requirements
- A laptop with a version of Microsoft Excel (any version from 2010 to 2016 or Microsoft 365)
- Some work-related projects to which you can readily apply what you learn. (optional)
+ View more
Description
Our Excel courses are designed to help you use Excel to analyze data on any level. Whether you're just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, and charts, these courses will help you unlock the maximum potential of this popular data-analysis program
As you participate in the Data Mastery Course (With MS Excel), it will clear away the pain of stumbling through their daily tasks. You will start with the basics, building a solid foundation that will give them further knowledge as they progress into intermediate and advanced level topics.
+ View more
Other related courses
04:20:18 Hours
Updated Thu, 10-Jun-2021
5
₦5,000
About the instructor
- 1 Reviews
- 71 Students
- 9 Courses
Student feedback
Reviews
Write a public review