EXCEL EXPERT
Learn with Fobel Education
29 modules
MALAYALAM
Lifetime access
Unlock the full potential of Excel with this comprehensive course
Overview
This course covers both the basics and advanced features of Microsoft Excel. Whether you are new to Excel or want to enhance your existing skills, this course will provide a comprehensive understanding of the spreadsheet software. From creating basic formulas and formatting cells to using advanced functions and analyzing data, you will become proficient in Excel and be able to handle complex tasks with ease.
ALL CERTIFICATES BY FOBEL. ADDITIONAL CERTIFICATE AVAILABLE WITH EXTRA FEES FOR EXAMS.
Key Highlights
Learn fundamental Excel functions and formulas
Master data entry, formatting, and manipulation techniques
Create charts and visualizations to present data effectively
Utilize advanced features like PivotTables, macros, and conditional formatting
Discover time-saving tips and shortcuts for increased productivity
What you will learn
Learning Outcome 1
Understand the basic features of Microsoft Excel and its interface
Learning Outcome 2
Learn how to create and format spreadsheets for various purposes
Learning Outcome 3
Explore essential functions and formulas to perform calculations
Learning Outcome 4
Master data analysis and visualization techniques using charts
Learning Outcome 5
Unlock the power of PivotTables and conditional formatting for data analysis
Learning Outcome 6
Automate tasks and increase efficiency with macros
Learning Outcome 7
Discover time-saving tips and shortcuts for increased productivity
Modules
INTRODUCTION OF EXCEL
4 attachments • 38.69 mins
Introduction of Excel
2 pages
Recording - Excel Introduction
Recording - Excel Introduction Continuation
Recording - Customize Ribbons & Quick Access Toolbar
EXCEL SHORTCUT KEYS
BASIC FUNCTIONS OF EXCEL
2 attachments • 12.24 mins
MICROSOFT EXCEL
17 pages
BASIC FUNCTIONS IN EXCEL
IF FUNCTIONS
4 attachments • 6.56 mins
IF FUNCTION
IF FUNCTION QN 1
2 pages
IF FUNCTION QN 2
1 page
IF FUNCTION QN 3
2 pages
VLOOKUP & HLOOKUP FUNCTION
6 attachments • 13.73 mins
V LOOKUP, H LOOKUP & PRACTICAL
VLOOKUP FUNCTION QN1
2 pages
HLOOKUP QUUESTION 1
2 pages
RECORDING VLOOKUP FUNCTION QN 2
VLOOKUP QN 2
2 pages
VLOOKUP PRACTICAL 3
1 page
SUMIF & IFS FUNCTION
2 attachments • 7.05 mins
Recording - SUMIF AND IFS
PRACTICE QN
1 page
AVERAGE IF& IFS, COUNT IF&IFS
3 attachments • 6.2 mins
QUESTION
3 pages
PRACTICE QN IF & IFS
2 pages
Recording - AVERAGE IF & IFS, COUNT IF & IFS
NESTED IF
2 attachments • 3.63 mins
Recording - NESTED IF FUNCTION
PRACTICE QN
2 pages
AND, OR FUNCTION
2 attachments • 4.9 mins
Recording - AND , OR FUNCTION
PRACTICE QN
1 page
PIVOT TABLE
4 attachments • 6.61 mins
PIVOT TABLE IN EXCEL
PRACTICE QN 1
1 page
PRACTICE QN 2
1 page
PRACTICE QN 3
2 pages
CONSOLIDATION
2 attachments • 3.26 mins
CONSOLIDATION QUESTION
3 pages
CONSOLIDATION FUNCTION
INDEX MATCH FORMULA
3 attachments • 4.82 mins
INDEX & MATCH FORMULA IN EXCEL
PRACTICE QN 1
2 pages
PRACTICE QN 2
2 pages
TEXT BASED FORMULA
3 attachments • 10.3 mins
TEXT BASED FORMULA
3 pages
TEXT BASED FORMULAS IN EXCEL
FREEZ,FILTER,SUBTOTAL FUNCTION IN EXCEL
XLOOKUP FUNCTION
2 attachments • 2.48 mins
RECORDING XLOOKUP FUNCTION
PRACTICE QN 1
1 page
RIGHT , LEFT , MID FUNCTION
1 attachment • 4.8 mins
Recording - MID LEFT RIGHT
DATA VALIDATION
1 attachment • 18.5 mins
Recording - DATA VALIDATION
DATE FUNCTION
2 attachments • 9.43 mins
Recording - TODAY FUNCTION & DATED IF FUNCTION
Recording - NETWORKDAYS FUNCTION
TEXT FUNCTION
1 attachment • 5.18 mins
Recording - TEXT FUNCTION EXCEL
SEARCH,FIND,REPLACE,LEN FUNCTION
1 attachment • 5.48 mins
Recording - LEN ,SERCH, REPLACE, FIND FUNCTIONS
CONDITIONAL FORMATING
4 attachments • 16.71 mins
Recording - CONDITIONAL FORMATING
Recording - Conditional Formating
Recording - Conditional Formating
Recording - CONDITIONAL FORMATING 4
FLASH FILL
1 attachment • 4.96 mins
Recording - flash fill
NUMBER SERIES
1 attachment • 1.96 mins
Recording - NUMBER SERIES
REMOVING DUPLICATE DATA
1 attachment • 1.85 mins
Recording - REMOVING DUPLICATES DATA
CONCATENATE FUNCTION
1 attachment • 2.13 mins
Recording - CONCATANATE FUNCTION
PMT FUNCTION
1 attachment • 1.67 mins
Recording - PMT FUNCTION
PROTECT WORKBOOK
1 attachment • 5.13 mins
Recording - protect work book
GROUPING ANG UNGROUPING
1 attachment • 4.91 mins
Recording - MOVING OF SHEET
HYPERLINK
1 attachment • 5.51 mins
Recording - hyperlink
CHARTS
1 attachment • 22.4 mins
Recording - record section of charts
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with Fobel Education
Rate this Course
₹ 1999.00
₹4000
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
