Excel Full Course - in 2 hours | Microsoft Excel Tutorial for Beginners | Free Certification 2023

preview_player
Показать описание

This Excel Full Course offers a beginner level guide to Mastering Microsoft Excel for Data Analysis and Presentation. Excel is a powerful tool for organising, analysing, and presenting data. It can help you save time, make informed decisions, and increase efficiency in both personal and professional settings.

---------------------------------------------
Become a full-stack Data Scientist 🔥
---------------------------------------------
- with 50+ Industry Projects
- 1:1 Mentorship Sessions
- Personalised Learning Path
- Dedicated Interview Preparation & Placement Support

---------------------------------------------
Learning Roadmaps 🔥
---------------------------------------------

---------------------------------------------
Free Certification Courses 🔥
---------------------------------------------

------------------
Sections 🔥
------------------
0:00:00 Introduction to the Course
0:02:52 Excel Formulas
0:09:48 Cell Referencing
0:15:09 Paint Special & Format Painter
0:21:40 DATE & TIME Functions
0:32:51 Text: CONCATENATE
0:41:51 Text: FIND & SEARCH
0:48:19 Text: REPLACE & SUBSTITUTE
0:56:04 Text: TEXT & VALUE Functions
0:58:45 Math: SUM, PRODUCT, SQRT
1:02:22 Math: ROUND & SUMIF Functions
1:08:38 Finance: Present / Future Value
1:12:54 Finance: NPV & IRR
1:20:57 Finance: PMT, RATE & NPER
1:27:47 VLOOKUP & HLOOKUP
1:33:44 MATCH Function
1:40:24 INDEX Function
1:45:10 Logical: AND, OR, NOT
1:53:41 Logical: IF & NESTED IF
1:59:23 Statistics: COUNT & COUNTIF
2:07:13 MEAN, QUARTILE, CORRELATION

Stay on top of your industry by interacting with us on our social channels:

Рекомендации по теме
Комментарии
Автор

Book FREE 1:1 Mentorship for Gen AI / Data Science

Analyticsvidhya
Автор

Thank you so much for your willingness to educate us. I am happy to have landed on a good channel like this one.
Your teaching is very good ❣

ainomugishaannitah
Автор

Thank you so much, Sir. m from Lahore Pak nd I learn a lot of

shanabid_
Автор

Can you explain how to calculate Sum of Total payout for both Admin and HR or any two or more departments together in one Function

wdqtqlf
Автор

I am not able to download the course material. the jotform has expired

wdqtqlf
Автор

I am not being able to download the certificate after completing the course from website.

bittu_ds
Автор

Hello sir, how to find proper answer in bonus ??

khushalichauhan