Formulas in Excel | Vlookup & Hlookup | String Function, Text function (Session-7)

Free online learning Session on Advance Excel & Basics of Data Analysis.

Hey Guys,
This was the Seventh Session of our online Excel learning course, hope you had learned a lot from this session.
Link of this video and excel sheet will be provided to you at your registered e-mail address and mobile number.


Excel Sheet Link:-
https://drive.google.com/file/d/1jTIn0BMUlDTp4pkbPa5UjGKr8ydlPqQx/view?usp=sharingb

What will you Learn ?

Session 1:-
Introduction to MS Excel
Basics of Excel
Marksheet
Sum Function
Min Function
Max Function
If Condition
Rank Function
Merge & Unmerge
Alignment
and Much More...

Video Link:-
https://www.youtube.com/watch?v=uba69BuA42g

Session 2:-
Purchase Sheet
Data Formatting
Number Formats
Data Presentation in excel
Home Tab Tools

Video Link:-
https://www.youtube.com/watch?v=7_yJy7X63pw&t=848s

Session 3:-
Sales Sheet
Conditional Formatting
Data Analysis
Data Labels
Data Sorting
Data Filtering
Advance Filters

Video Link:-
https://www.youtube.com/watch?v=v9Ce2AmeyJc&t=382s

Session 4:-
Salary Sheet
Attendance Sheet
Charts
Graphs
Pie Charts
Bar Graphs
Line Charts

Video Link:-
https://www.youtube.com/watch?v=IrVWbAqslRU&t=736s

Session 5:-
Advance Excel
Data Validation in Excel
Data List
Data Filtering & Sorting
Auto Filters
Advance Filters

Video Link:-
https://www.youtube.com/watch?v=5k1GHtU_jL8&t=64s

Session 6:-
Pivot Table
Pivot Charts
Grouping
Subtotals
Subtotals in Excel
Data Analysis
Lab Exercise

Video Link:-
https://www.youtube.com/watch?v=qsppAlPyGGA&t=284s

Session 7:-
Formulas in Excel
Functions in Excel
Vlookup in Excel
Hlookup in Excel
String Functions
Text functions

Video Link:-
https://www.youtube.com/watch?v=MXFBv2LV8ao&t=673s

Session 8:-
Index Function in Excel
Match Function in Excel
Date & Time Functions
Large Function
Small Function

Video Link:-
https://www.youtube.com/watch?v=oLtP2k1-vBY&t=634s

Session 9:-
Mean Function
Median Function
Mode Function
Correlation Coefficient
Analysis Tool Pak
Histogram
Lab Exercise

Video Link:-
https://youtu.be/N3EbBZRS5bc

Session 10:-
What-If-Analysis Tool
Goal Seek
Scenario Manager
Solver Tool in Excel
Lab Exercise


About Us:-
Future Vision Computer Institute was founded in 2006 with the mission of providing best quality Computer education to our students. Thousands of students have already got trained professionally and made their career successfully in the past.
Our Tutor Mr. Siddharth Parakh also have teaching experience of 15 years in the Computer Education, so you will get professional advice and guidance throughout the course.

Website link:-
http://www.futurevisioncomputers.com


Tags:-
online learning,
online learning excel,
online learning excel spreadsheets,
learn advanced excel,
learning advanced excel online,
best online excel learning,
free online excel learning courses,
learning advanced excel online free,
online excel learning website,
learn advanced excel online in hindi,
learn advanced excel and vba online,
learn basic and advanced excel online,
online learning free,
online learning excel free,
future vision,
future vision computers,