Learn Data Analysis with Microsoft Excel - Complete Course

Complete Data Analysis course with Microsoft Excel

Created by : Rated :4.5 680 views

Last Updated: 2024-02-28 10:02:32 English Course Type: Self Learning

Most common Excel functions used in the office
How to apply the skills in data analysis, grade responses or polls, and prepare results.
How to perform basic financial analysis as an accountant/finance secretary
How to simplify voluminous entries using automated forms
How to design a loan management system.
How to Analyze Data using Pivot Table & Power Query
Design Interactive Dashboards
Work o end-to-end Projects as a Data Analyst

Welcome to the Data Analysis with Microsoft Excel course! This comprehensive course is divided into four distinct classes: The Beginners, Intermediate, Advance and Application class respectively , featuring a total of 30 well-simplified and detailed lessons. Get ready to unlock the full potential of Microsoft Excel!

Course Highlights:

In this course, you will embark on a journey from the beginner level to becoming proficient in Excel, with a focus on practical applications. Here’s what you’ll learn:

The Basics of Microsoft Excel: Learn the basic Microsoft Excel interface.

Maintaining Large Data Sets: Discover appropriate skills to analyze and simplify voluminous data.

Basic and Complex Excel Functions: Learn basic, advance and complex Excel functions for data analysis and computational purposes.

Analyzing Academic, and Financial Reports: Discover how to analyze academics reports, sales records and also perform financial analysis using Excel functions.

Designing Dynamic Database Systems: Create dynamic and automated database systems using simple Excel tricks.

Creating Dynamic Reports, Visualizations & Dashboards: Create dynamics reports, visualizations and create interactive dashboards.

Excel Projects: Learn how to execute projects from end-to-end using the learned skills, hence developing your own project portfolios.

Why Choose This Course?

Self-Paced Learning: Fit it into your schedule

Beginner-Friendly: No prior coding experience is required

Expert-Led Instruction: Learn from experienced professionals

Hands-On Exercises: Apply skills with real-world examples

Lifetime Access: Refresh your knowledge anytime

Limited-Time Offer:

Invest in Your Future! Don’t miss out on this opportunity.

Hurry, offer ends soon!

A Laptop/Desktop computer
Microsoft Excel Application

Data Analyst
Sales Analyst
Business/Financial Analyst
Educator
Human Resource Managers
Microsoft Excel Enthusiast

Section 1 : Beginner Class 16 Lectures 04:55:01
Lecture 1 :
1.1 Introduction to Excel Preview
Lecture 2 :
1.2 Excel-Formatting
Lecture 3 :
1.3 Conditional Formatting-1
Lecture 4 :
1.4 Conditional Formatting-2
Lecture 5 :
1.5 Formulas Function -1
Lecture 6 :
1.6 Formulas function-2(Result Analysis)
Lecture 7 :
1.8 Data validation Drop down
Lecture 8 :
1.9 Header and Footer
Lecture 9 :
1.10 Protecting Sheet
Lecture 10 :
1.11 How to Unlock Protected Sheet
Lecture 11 :
1.12 Automated Calculator
Lecture 12 :
1.13 Consolidation
Lecture 13 :
1.14 Charts
Lecture 14 :
1.15 Progress Bar Chart
Lecture 15 :
1.16 Print Setup
Lecture 16 :
1.7 Formulas & Functions 3
Section 2 : Advance Class 18 Lectures 05:37:57
Lecture 1 :
2.17 Sorting
Lecture 2 :
2.18 Basic Filter
Lecture 3 :
2.19 Advance Filter
Lecture 4 :
2.20 Logical Function(AND)
Lecture 5 :
2.21 Logical Function(Text)
Lecture 6 :
2.22 Advance Data Validation (Dropdown list)
Lecture 7 :
2.23 H-Lookup
Lecture 8 :
2.24 V-Lookup
Lecture 9 :
2.25 DataBase System
Lecture 10 :
2.26 Pivot table - 1
Lecture 11 :
2.27 Pivot Table 2
Lecture 12 :
2.28 Pivot table 3
Lecture 13 :
2.29 Power Query 1(Text Dates)
Lecture 14 :
2.30 Power Query (Finance)
Lecture 15 :
2.31 Power Query(Web, Dashboad,Slicer)
Lecture 16 :
2.32 Covid-19 Analysis
Lecture 17 :
2.33 Data Collection(Google form)
Lecture 18 :
2.34 Sales Dashboard
Section 3 : Application Class 10 Lectures 02:45:49
Lecture 1 :
3.35 Automated Data Entry Form
Lecture 2 :
3.36 Attendance Register(Clock In Clock Out)
Lecture 3 :
3.37 Salary Sheet with Excel
Lecture 4 :
3.38 Gantt Chart
Lecture 5 :
3.39 Simple Compound Interest
Lecture 6 :
3.40 Loan Payment
Lecture 7 :
3.41 Drop Down List (3)
Lecture 8 :
3.42 Loan Management System(Data Base)
Lecture 9 :
3.43 Loan Management System(Payment Page)
Lecture 10 :
3.44 Loan Management System (Home Page)
Section 4 : Capstone Project 2 Lectures 00:45:40
Lecture 1 :
Tunia Technologies 1
Lecture 2 :
Tunia Technologies 2
Section 5 : Practice Exercises & Course Review 1 Lectures 00:00:33
Lecture 1 :
Practice Exercises

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

AWESOME EMMANUEL,

3542 Course Views

5 Courses

My name is Awesome Emmanuel. I'm a British Council certified instructor based in Lagos, Nigeria. A data analyst/database administrator with over 6 years of active industrial work experience. A seasoned and resourceful ICT Tech-skill instructor, Data analyst consultant, Edu-Tech consultant and a web developer with great flair for providing soft and digital ICT skills.