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

Browse Library

Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee

It Includes

  • Get Full Access to the platform
  • Access to 16000+ online courses
  • Play & Pause Course Viewing
  • Attend weekly live webinar
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Cancel Anytime
$29
  • all basics , advanced and professional topics of ms excel covered

This course will provide you everything you need to know about Microsoft Excel.

You can learn Microsoft Excel easily and quickly if it is taught correctly. Developed by a Chartered Accountant having 12+ year of experience, this course provides comprehensive coverage on Microsoft Excel. .

In only nine hours of videos, provided to you in 99 separate video lectures so that no one video is too long, you will learn all of the following about Microsoft Excel:

  • Basic Formatting & Editing

  • Paste Special

  • Some Special Features

  • Cell Referencing in Excel

  • Text Function

  • Basic Excel Formula & functions

  • Advanced Excel Formula & functions

  • Formula (Auditing) Checking in Excel

  • Data Protection in Excel

  • Merge multiple files in one click

  • Basic and advanced Pivot

  • Charts and Graphs in Excel

  • Slicer (advanced filter for presentation)

  • Shapes and Smart art

  • How to Prepare Dashboard

  • What if analysis

  • Important Shortcuts in Excel

  • Macro for Non Technical People

  • Macro - How to record

  • Macro - How to create button to run

  • Macro - Editing and Debugging

  • Macro - Relative reference

Apart from above, we will be learning lots of other features during this entire course.

  • Basic Excel Formula & functions

  • Advanced Excel Formula & functions

  • Formula (Auditing) Checking in Excel

  • Data Protection in Excel

  • Merge multiple files in one click

  • Basic and advanced Pivot

  • Charts and Graphs in Excel

  • Slicer (advanced filter for presentation)

  • Shapes and Smart art

  • How to Prepare Dashboard

  • What if analysis

  • Important Shortcuts in Excel

  • Macro for Non Technical People

 

What Will I Get ?

  • To make you excel in MS Excel

Requirements

  • a desire to learn new skills

  • a desire to learn new skills
  • a compulsion course for all students and working professionals
View More...
  • Section 1 : Microsoft Excel - Basics to advanced and Professional 42 Lectures 02:11:58

    • Lecture 1 :
    • 1 How to Start MS Excel - Open Close , Preview Functionalities Preview
    • Lecture 2 :
    • 2 Sum Functionality in MS Excel
    • Lecture 3 :
    • 3 Subtraction Functionality in MS Excel
    • Lecture 4 :
    • 4 Multiplication Functionality in MS Excel
    • Lecture 5 :
    • 4A Percentage Functionality in MS Excel
    • Lecture 6 :
    • 4B Division Functionality in MS Excel
    • Lecture 7 :
    • 4C Count Functionality in MS Excel
    • Lecture 8 :
    • 4D Date & Time Functionality in MS Excel
    • Lecture 9 :
    • 5. Learn How to Create Tabs, Groups and add Tools to it in MS Excel
    • Lecture 10 :
    • 6. Excel - Editing Data I over writing I editing I find & replace I undo & redo
    • Lecture 11 :
    • 7. MS Excel - Home Tab - Group Clip Board Explained - Copy, Cut, Paste, Copy as
    • Lecture 12 :
    • 8. MS Excel - Home Tab - Font Group Explained - Font Size, Font Face Style, Bold
    • Lecture 13 :
    • 9. Home Tab - Alignmnet Group Explained - Merge, Wrap Text, Alignments & more
    • Lecture 14 :
    • 10. Characteristics of a cell explained in Ms Excel
    • Lecture 15 :
    • 11. Speak Cells - on Enter, by Rows, By Columns, Stop Speaking Cells I Microsfot
    • Lecture 16 :
    • 12. Text to columns Explained in Ms Excel
    • Lecture 17 :
    • 13. MS Excel - Comments - add, edit, delete & Show all
    • Lecture 18 :
    • 14. MS Excel - Fill Series - with formatting, without formatting & more
    • Lecture 19 :
    • 15. Fill Series - Advance Fill - Numbers, Months, Daya, Custom List Edit & Add,
    • Lecture 20 :
    • 16. Fill Series - Flash Fill
    • Lecture 21 :
    • 17. MS Excel - How to Hind and Unhide Rows, Columns, Sheets
    • Lecture 22 :
    • 18. Freeze Panes - Top Row, Columns & Multiple Rows & Columns in Hindi
    • Lecture 23 :
    • 19. MS Excel - Filters - Learn How to Use Filter to anylise a Big Data in Hindi
    • Lecture 24 :
    • 20. MS Excel - Split Sheet Window
    • Lecture 25 :
    • 22. MS Excel - Working with Sheets
    • Lecture 26 :
    • 23. MS Excel - View Sheets Side by Side from One Excel File
    • Lecture 27 :
    • 25. MS Excel - Sheet & Cells Protection
    • Lecture 28 :
    • 26. MS Excel - Create & Remove Drop Down List in Hindi
    • Lecture 29 :
    • 27. Concatenate - Join Multiple Text Strings into ONE
    • Lecture 30 :
    • 28. MS Excel - Trim Functions - Remove unnecessary Elements from strings in Hind
    • Lecture 31 :
    • 29. MS Excel - Print Formulas Left, Right, Middle
    • Lecture 32 :
    • 30. MS Excel - Date Related Fromulas
    • Lecture 33 :
    • 31. MS Excel - Hyper Links - Cell to Sheet, Website, Existing File, Create New D
    • Lecture 34 :
    • 33. MS Excel - Page Header & Footer I Add Page Numbers, Logo, Report Name, Date,
    • Lecture 35 :
    • 34. Conditional Formatting in hindi
    • Lecture 36 :
    • 39. MS Excel - Import Data from Text Document - with Auto Refresh in Hindi
    • Lecture 37 :
    • 41. MS Excel - Format Multiple Sheets at a time
    • Lecture 38 :
    • 42. MS Excel 3d Sum
    • Lecture 39 :
    • 43. MS Excel - Consolidate ( 3d Sum extension)
    • Lecture 40 :
    • 45. MS Excel - Bar Code I Install Bar code font I Generate Bar Codes in Hindi
    • Lecture 41 :
    • 48. Logical Functions - Logical Test I Boolean Expression I TRUE or FALSE I Comp
    • Lecture 42 :
    • 24. MS Excel - Workbook Protection - Learn how to setup a Password to open Excel
  • 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?
  • vba-web-connect-ms-office-to-the-web

    VBA WEB - Connect MS Office to the ...

    By : Daniele Protti

    Lecture 223 Intermediate Level 19:38:23
  • excel-vba-from-beginner-to-expert

    Excel VBA from Beginner to Expert

    By : Daniele Protti

    Lecture 66 Beginner Level 4:48:51
  • mastering-office-365

    Mastering Office 365

    By : Chip Reaves

    Lecture 70 Beginner Level 11:35:57
  • excel-tips-and-tricks

    Excel tips and Tricks

    By : Muhammad Ali Yasin

    Lecture 16 Beginner Level 0:38:20
  • microsoft-powerpoint-2016-self-publishing-ebook-book-covers

    Microsoft PowerPoint 2016 Self-publ...

    By : Brian Jackson

    Lecture 34 Beginner Level 4:41:46
  • powerpoint-2013-2016-beginner-to-advanced-with-animation

    PowerPoint 2013/2016 Beginner to Ad...

    By : Brian Jackson

    Lecture 114 Beginner Level 10:27:34
Signup & Continue Checkout
By signing up, you agree to our Terms of Use and Privacy Policy
Create New Password
Enter your email address and we'll send you a link to reset your password.