Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
2 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
What you'll learn?
- 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
Course Overview
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.
Sign up to enroll now and start your journey to mastery!
Hurry, offer ends soon!
Pre-requisites
- A Laptop/Desktop computer
- Microsoft Excel Application
Target Audience
- Data Analyst
- Sales Analyst
- Business/Financial Analyst
- Educator
- Human Resource Managers
- Microsoft Excel Enthusiast
Curriculum 47 Lectures 14:05:00
-
Section 1 : Beginner Class
- 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
- 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
- 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
- Lecture 1 :
- Tunia Technologies 1
- Lecture 2 :
- Tunia Technologies 2
-
Section 5 : Practice Exercises & Course Review
- Lecture 1 :
- Practice Exercises
Our learners work at
Frequently Asked Questions
-
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?
Instructor
991 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.
View More...
