This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
What you'll learn?
- Students will be able to do data anlysis & present their work in a professional manner with the help of Excel Skill. Also Excel will help students in enhancing their career prospect.
Course Overview
MS Excel is a "must-have" skill for any Student, professional or business person.
This Course of mine will help you to understand the excel from very basic, like what is excel, to the important excel formulas & functions, like Sum/Avg/Trim/Concatenate/Vlookup/Hlookup/Countif/If & more, to decoding excel errors to Excel formatting to advance concept like pivot table/pivot chart/hyperlinking/bar chart/pie chart/line chart to excel data validation to excel reporting.
My way of teaching is very simple & with examples which makes it easy to understand the subject.
The Course has 14 lectures which are split into 8 sections :
- Section 1: Introduction to Excel (1 Lecture)
- Section 2: Maths Formulas & Functions ( 2 Lectures)
- Section 3: Text & Lookup Functions ( 2 Lectures)
- Section 4: Logical & Information Functions (2 Lectures)
- Section 5: Date & Time and Excel Formatting Skills (2 Lectures)
- Section 6: Advance Excel - Understanding Pivot table & Pivot Chart (1 Lecture)
- Section 7: Advance Excel - Chart Analysis (2 Lectures)
- Section 8: Advance Excel - Data Validation & Preparing Reports in Excel (2 Lectures)
The total course duration is 5.5 hrs.
All The Best for your learning journey!
Happy Learning!
Pre-requisites
- Excel 2007
Target Audience
- This course can be taken by Students, Freshers, Professionals, Business Owners & Freelancer.
Curriculum 14 Lectures 00:24:50
-
Section 1 : Introduction To MS Excel
-
Section 2 : Maths Functions & Formulas
- Lecture 1 :
- Excel Maths Functions & Formulas - Basic
- Lecture 2 :
- Excel Maths Functions & Formulas - Advance
-
Section 3 : Excel Text & Lookup Functions
- Lecture 1 :
- Excel Text Function
- Lecture 2 :
- Excel Lookup Functions
-
Section 4 : Excel Logical & Information Functions
- Lecture 1 :
- Excel Logical Functions
- Lecture 2 :
- Excel Information Functions
-
Section 5 : Excel Date & Time and Excel Formatting
- Lecture 1 :
- Excel Date, Time & Error Functions
- Lecture 2 :
- Excel Formatting Skills
-
Section 6 : Advance Excel - Pivot Table & Chart
- Lecture 1 :
- Advance Excel - Pivot Table & Pivot Chart
-
Section 7 : Advance Excel - Chart Analysis
- Lecture 1 :
- Advance Excel - Chart Analysis I
- Lecture 2 :
- Advance Excel - Chart Analysis II
-
Section 8 : Advance Excel - Data Validation & Report Making
- Lecture 1 :
- Advance Excel - Data Validation
- Lecture 2 :
- Advance Excel - Preparing Excel Report
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
7594 Course Views
1 Courses