All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
5 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.
$348 $244 a year Save 30%
5 days left at this price!
Buy Now
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
Buy Now
$244

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 :

  1. Section 1: Introduction to Excel (1 Lecture)
  2. Section 2: Maths Formulas & Functions ( 2 Lectures)
  3. Section 3: Text & Lookup Functions ( 2 Lectures)
  4. Section 4: Logical & Information Functions (2 Lectures)
  5. Section 5: Date & Time and Excel Formatting Skills (2 Lectures)
  6. Section 6: Advance Excel - Understanding Pivot table & Pivot Chart (1 Lecture)
  7. Section 7: Advance Excel - Chart Analysis (2 Lectures)
  8. 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!

See More

Pre-requisites

  • Excel 2007

Target Audience

  • This course can be taken by Students, Freshers, Professionals, Business Owners & Freelancer.
View More...

Curriculum 14 Lectures 00:24:50

  • Section 1 : Introduction To MS Excel 1 Lectures 00:00:01

    • Lecture 1 :
      • Before you began your excel journey, its important to get some basic understanding about the MS Excel 2007.

  • Section 2 : Maths Functions & Formulas 2 Lectures 00:11:16

    • Lecture 1 :
    • Excel Maths Functions & Formulas - Basic
      • In this lecture you will be learning the following topics: 1)Difference Between Formulas & Functions 2)Use of Paste Special 3)Basic Maths Functions & Formulas 4)Sum 5)Average 6)ABS 7)Sub-Total 8)Max 9)Min 10)Count 11)CountA 12)Rank 13)Percentile Happy Learning!
    • Lecture 2 :
    • Excel Maths Functions & Formulas - Advance
      • In This Session You will be learning three core maths functions, namely : 1)Averageif 2)Sumif 3)Countif Happy Learning!

  • Section 3 : Excel Text & Lookup Functions 2 Lectures 00:00:02

    • Lecture 1 :
    • Excel Text Function
      • In this session students will be learning below mention text functions: 1)Concatenate 2)Left 3)Right 4)Mid 5)Lower 6)Upper 7)Proper 8)Length 9)Trim Happy Learning!
    • Lecture 2 :
    • Excel Lookup Functions
      • In this session, students will be learning two main lookup functions: 1)Vlookup 2)Hlookup Happy Learning!

  • Section 4 : Excel Logical & Information Functions 2 Lectures 00:13:23

    • Lecture 1 :
    • Excel Logical Functions
      • In this session students will be learning below mention logical functions: 1)IF 2)OR 3)NOT 4)AND 5)Iferror Happy Learning!
    • Lecture 2 :
    • Excel Information Functions
      • In this Session students will be learning below mention Information functions: 1)Isblank 2)Isnumber 3)Istext 4)Isodd 5)Iseven 6)Isnontext Happy Learning!

  • Section 5 : Excel Date & Time and Excel Formatting 2 Lectures 00:00:03

    • Lecture 1 :
    • Excel Date, Time & Error Functions
      • In this session, students will be learning how to use Date & Time function in excel. Students will also be learning how to decode various forms of errors in excel while computing excel formulas. Happy Learning!
    • Lecture 2 :
    • Excel Formatting Skills
      • In this session, students will be learning how to use formatting skills and make their work more presentable. Following topics will be cover in this session: 1)Format 2)Merger 3)Themes 4)Built-In Features Happy Learning!

  • Section 6 : Advance Excel - Pivot Table & Chart 1 Lectures 00:00:01

    • Lecture 1 :
    • Advance Excel - Pivot Table & Pivot Chart
      • In this section of excel training, students will be understanding how to prepare a pivot table and pivot chart from excel.

  • Section 7 : Advance Excel - Chart Analysis 2 Lectures 00:00:02

    • Lecture 1 :
    • Advance Excel - Chart Analysis I
      • In This session, students will be learning all the basic understanding that is required to perform chart analysis.
    • Lecture 2 :
    • Advance Excel - Chart Analysis II
      • In this session, students will be learning how to prepare the following chart analysis: 1)Pie chart 2)Bar Chart 3)Line Chart Happy Learning!

  • Section 8 : Advance Excel - Data Validation & Report Making 2 Lectures 00:00:02

    • Lecture 1 :
    • Advance Excel - Data Validation
      • In this session, students will be learning how to validate the excel data with the help of the following excel skills: 1)Data Validation 2)Password Protection 3)Smart Art 4)Hyperlinking Happy Learning!
    • Lecture 2 :
    • Advance Excel - Preparing Excel Report
      • In this session, students will learn how to make excel reports and showcase their work in a professional manner! Happy Learning!

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

Ashwini Bissa,

7034 Course Views

1 Courses

Hello, My Name is Ashwini Kumar Bissa and I a Digital Marketing & Excel Trainer. I have worked with various companies in India and have got exposure in Marketing & Data Analysis for the last 9 yrs. Training is my passion and wants to help students across the globe in understanding "Digital Marketing"  & "Excel Skill". Looking forward to your feedback on my courses! Happy Learning!
View More...

Student Reviews 4.6

  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW

Students also bought

  • odoo-purchases-sales-inventory-with-accounting-modules

    Odoo: Purchases, Sales, Inventory w...

    By : Quantic Statistics R spatial analysis

    Lectures 13 Beginner 3:20:52
  • hotel-management-course-analyse-financial-statements-and-performance

    Hotel Management Course - Analyse f...

    By : Manish Gupta

    Lectures 34 Intermedite 2:58:18
  • how-to-carry-out-financial-analysis-as-a-banker

    How to carry out Financial Analysis...

    By : CA N Raja Natarajan

    Lectures 25 Intermedite 2:57:27
  • advanced-capital-budgeting-improve-long-term-roi

    Advanced Capital Budgeting: Improve...

    By : Blair Cook

    Lectures 7 Intermedite 0:54:52
  • envision-the-future-financial-modeling-using-excel

    Envision the Future: Financial Mode...

    By : Blair Cook

    Lectures 8 Intermedite 1:32:15
  • auditing-financing-statements

    Auditing Financing Statements

    By : Blair Cook

    Lectures 28 Beginner 3:52:1

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.