Complete Excel Tutorial in 7 hours in 2024 | Learn Microsoft Excel
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/acade...
Earn a prestigious Data Science certificate from MIT Professional Education. Enroll now and elevate your skills! https://www.mygreatlearning.com/mit-d...
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-pr...
🏁 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/acade...
⚡ 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: / greatlearningofficial
✅ LinkedIn: / verification
✅ Follow our Blog: https://glacad.me/GL_Blog
Watch video Complete Excel Tutorial in 7 hours in 2024 | Learn Microsoft Excel online without registration, duration hours minute second in high quality. This video was added by user Great Learning 09 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 306,872 once and liked it 13 thousand people.