Hellow guys, Welcome to my website, and you are watching Complete Excel Tutorial in 7 hours in 2024 | Learn Microsoft Excel. and this vIdeo is uploaded by Great Learning at 2024-08-09T05:32:00-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Complete Excel Tutorial in 7 hours in 2024 | Learn Microsoft Excel |
| Video Uploader | Video From Great Learning |
| Upload Date | This Video Uploaded At 09-08-2024 12:32:00 |
| Video Discription | Learn Excel with our complete A-Z tutorial in just 8 hours! We start with the basics and guide you through everything from navigating the Excel worksheet to essential formulas and functions. Learn advanced techniques like VLOOKUP, Power Query, and data analytics. We’ll also show you how to format, visualize, and create dashboards, plus explore applications for budgeting and financial management. Join this free course to start practicing Data Analytics with Excel. Learn the key phases of a Data Analytics project, master Data Cleaning techniques, and explore various Excel functions that enhance data analysis. Enroll now and receive a certificate upon completion! https://www.mygreatlearning.com/academy/learn-for-free/courses/data-analytics-using-excel?utm_source=CPV_YT&utm_medium=Desc&utm_campaign=CmpltExclTut8hrs_2024 Earn a prestigious Data Science certificate from MIT Professional Education. Enroll now and elevate your skills! https://www.mygreatlearning.com/mit-data-science-program?utm_source=CPV_YT&utm_medium=PPDesc1&utm_campaign=CmpltExclTut8hrs_2024 Build your career with the Executive PG Program in Management. Specialize in Business Analytics, Operations, or Marketing. Enroll now and advance your future! https://www.mygreatlearning.com/pg-program-management-executive?utm_source=CPV_YT&utm_medium=PPDesc2&utm_campaign=CmpltExclTut8hrs_2024 🏁 Topics Covered: 00:00:00 - Beginning 00:01:31 - Introduction to Excel 00:07:53 - Cell referencing 00:14:00 - What is a Formula in Excel 00:15:46 - How to enter a formula 00:40:56 - Precedence order of operations 00:19:55 - Smallest and Largest Value 00:22:33 - Function in workbook 00:35:18 - Multiple Values at once 00:37:45 - How to Enter Copy Edit and Hide a Formula 00:44:55 - Precedence order of operations 00:43:42 - Tables and Borders in Excel 00:49:32 - Date and Time Function in Excel 01:02:27 - Introduction to Conditional Formatting - Formatting in Excel 01:12:16 - Cells that Contain 01:18:13 - Greater than 01:20:37 - Top Bottom Values 01:23:00 - Unique and Similar Values 01:25:04 - Data Bars 01:27:20 - Color Scales 01:30:33 - Icon Sets 01:32:52 - Formula Based 01:35:28 - More Rule Types 01:41:50 - Google Sheets 01:42:15 - Color Scales in Google Sheets 01:45:10 - What is VLOOKUP 01:47:15 - VLOOKUP Function in the Same Sheet 01:51:21 - VLOOKUP Function in a Different Sheet 01:53:19 - VLOOKUP Function in a Different Workbook 01:55:27 - Copy VLOOKUP Function 01:58:26 - Lookup Functions 02:07:25 - Introduction to Power Query in Excel 02:19:07 - Understanding Functions for Power Query 02:28:51 - Data Transfering and Cleaning 02:45:54 - Power Query Dashboard Overview 03:05:43 - Introduction to Data Analytics 03:07:50 - Phases of Data Analytics Project 03:10:50 - Data Cleaning 03:16:03 - Data Validation 03:24:54 - Sort and Filter 03:30:41 - Data Visualisation Using Excel 03:46:34 - Introduction to Graphs and Charts in Excel 03:47:14 - Insert Slicer 03:49:14 - Style Options 03:49:55 - Refresh 03:51:05 - Various Tools 03:52:56 - Pivot Table and Its Importance 03:54:50 - How to Create a Pivot Table 04:00:11 - Pivot Tables in Excel 04:01:29 - Change Data Source 04:02:59 - Introduction to Budgeting 04:20:55 - Budget Categories and Budgeting Methods 04:30:48 - Types of Financial Goals 04:49:49 - Creating Budget using Excel 04:57:06 - Introduction to Savings and Investments 05:04:55 - Tips to Avoid Debts 05:14:23 - Introduction to AI 05:23:18 - Introduction to ChatGPT 05:30:42 - Understanding Excel Using ChatGPT 05:41:02 - Generating Excel Functions Using ChatGPT 05:56:33 - Preparation of Financial Statements using ChatGPT 06:14:39 - Dashboard Analysis using ChatGPT 06:37:43 - Interpretations of Financial Reports using ChatGPT 06:47:12 - Basic Level Tips 06:47:31 - Intermediate Level Tips 06:47:58 - Advanced Level Tips #excel #exceltutorial #exceltricks 🔥1000+ Free Courses With Free Certificates: https://www.mygreatlearning.com/academy?utm_source=CPV_YT&utm_medium=Desc&utm_campaign=YTVids2024 ⚡ About Great Learning Academy: Visit Great Learning Academy to get access to 1000+ free courses with free certificates on Data Science, Data Analytics, Digital Marketing, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development, and many more. These courses are supplemented with free projects, assignments, datasets, and quizzes. At the end of the course, you can earn a certificate of completion for free. 🔹 For more updates on courses and tips follow us on: ✅ Telegram: https://t.me/GreatLearningAcademy ✅ Facebook: https://www.facebook.com/GreatLearningOfficial/ ✅ LinkedIn: https://www.linkedin.com/school/great-learning/mycompany/verification/ ✅ Follow our Blog: https://glacad.me/GL_Blog |
| Category | Education |
| Tags | Excel Tutorial | Excel for Fresher | Excel Full Course | PowerQuery | Vlookup | Vlookup in Excel | Conditional Formatting | Pivot tables | excel vlookup | vlookup hlookup in excel | vlookup function | ms excel tutorial | advanced excel tutorial | excel tips and tricks | how to use vlookup | excel | advanced excel full course | excel tutorials | vlookup tutorial | excel courses online | advanced excel | excel conditional formatting | conditional formatting in excel | power query | great learning |
