Browse Library

Learn MS Excel From Basic to Advance

Enhance Your Skill With Excel.

Instructed by Ashwini Bissa

7 days left at this price!
$35
Get single Course Access
$35
It Includes
  • Get access to this course only
  • Lifetime Course Access
  • Play & Pause Videos
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Download Course for Offline Viewing
  • Inlcudes Real Projects
  • Free Instructor Support
Want to Learn more? Get access to all marketplace courses starting at $19/mo/ month
  • 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.

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!

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

Section 1 : Introduction To MS Excel

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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!
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • 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 certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Ashwini Bissa,

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...
odoo-purchases-sales-inventory-with-accounting-modules

Odoo: Purchases, Sales, Inventory w...

By : Quantic Statistics R spatial analysis

Lecture 13

how-to-carry-out-term-loan-appraisal-as-banker

How to carry out Term Loan Appraisa...

By : CA N Raja Natarajan

Lecture 39

hotel-management-course-analyse-financial-statements-and-performance

Hotel Management Course - Analyse f...

By : Manish Gupta

Lecture 34

accounting-basics-in-66-minutes

Accounting Basics in 66 Minutes

By : CA N Raja Natarajan

Lecture 13

how-to-carry-out-financial-analysis-as-a-banker

How to carry out Financial Analysis...

By : CA N Raja Natarajan

Lecture 25

advanced-capital-budgeting-improve-long-term-roi

Advanced Capital Budgeting: Improve...

By : Blair Cook

Lecture 7

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Forget Password