Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
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
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
What you'll learn?
- all basics , advanced and professional topics of ms excel covered
Course Overview
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
Pre-requisites
- a desire to learn new skills
Target Audience
- a compulsion course for all students and working professionals
Curriculum 42 Lectures 02:11:58
-
Section 1 : Microsoft Excel - Basics to advanced and Professional
- 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
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?
