Data Analytics Free Courses - For Beginners 🔥 Data Analyst Career Path & Crash Course [Tutorials Updated 2023] - Excel Full Course - in 2 hours | Microsoft Excel Tutorial for Beginners | Free Certification 2023

✅ Free MS Excel Certificate Here 🔗 https://bit.ly/46KJw53 ✅ Download Course Material here 🔗 https://bit.ly/40nYX0O 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 🔥 --------------------------------------------- Enroll in our Certified AI & ML BlackBelt Plus Program 🔗 https://bit.ly/40Aa71g - with 50+ Industry Projects - 1:1 Mentorship Sessions - Personalised Learning Path - Dedicated Interview Preparation & Placement Support --------------------------------------------- Learning Roadmaps 🔥 --------------------------------------------- Roadmap to become a Data Scientist: https://www.youtube.com/watch?v=KC9Z60Bu1Q4 Roadmap to become a Data Analyst: https://www.youtube.com/watch?v=1YNOf3XTjbY Roadmap to become a Data Engineer: https://www.youtube.com/watch?v=SiuS5O724aE --------------------------------------------- Free Certification Courses 🔥 --------------------------------------------- 1️⃣ Python Full Course 🔗 https://youtu.be/6sLkF-F9Oh0 2️⃣ SQL Full Course 🔗 https://youtu.be/_H4h-tWvuxs 3️⃣ Excel Full Course 🔗 https://youtu.be/MMQJ-ySgGn0 For more such in-depth FREE Courses, subscribe to our channel: https://www.youtube.com/c/Analyticsvidhya ------------------ 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: Follow us on Instagram: https://www.instagram.com/analytics_vidhya/ Like us on Facebook: https://www.facebook.com/AnalyticsVidhya/ Follow us on Twitter: https://twitter.com/AnalyticsVidhya Follow us on LinkedIn:https://www.linkedin.com/company/analytics-vidhya