filmov
tv
Excel Full Course - in 2 hours | Microsoft Excel Tutorial for Beginners | Free Certification 2023
![preview_player](https://i.ytimg.com/vi/MMQJ-ySgGn0/maxresdefault.jpg)
Показать описание
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:
Комментарии