What will i learn?
- Conduct insightful analysis of small or large data sets
- Build a dashboard to monitor your or your company's performance.
- Banish your “phobia” for MS Excel for good
- Present your work beautifully be it in a table, scatter, radar or pie chart
Curriculum for this course
18 Lessons
01:46:28 Hours
Level 1
12 Lessons
00:54:41 Hours
- Introduction To Microsoft Excel 00:06:04
- Examining The Excel Ribbon 00:04:33
- Customizing Excel 00:03:10
- Saving A Workbook 00:02:54
- Planning Your Worksheets 00:05:59
- Worksheet Editing Techniques 00:05:27
- Basic Formatting 00:06:18
- Format As A Table 00:03:41
- Cell Style Formatting 00:01:14
- Conditional Formatting 00:02:58
- Worksheet-Level Protection 00:07:23
- Workbook -Level Protection 00:05:00
Level 2
6 Lessons
00:51:47 Hours
- Introduction To Formulas And Functions 00:10:15
- Understanding The Concept Of Reference 00:09:17
- Using Names In Formulas 00:03:10
- Sundry Maths And Stats Functions For Everyday Use 00:11:28
- SumIF-AvgIF-CountIf Functions 00:08:28
- Using The SumIFS Function 00:09:09
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
03:59:03 Hours
Updated Thu, 10-Jun-2021
4
₦5,000
About the instructor
- 1 Reviews
- 71 Students
- 9 Courses
Student feedback
Reviews
Write a public review