?Data Analyst Masters Program (Discount Code - YTBE15) - https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=7ny5ljw6NbI&utm_medium=DescriptionFirstFold&utm_source=Youtube
?IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=7ny5ljw6NbI&utm_medium=DescriptionFirstFold&utm_source=Youtube
?Purdue - Post Graduate Program in Data Analytics - https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=7ny5ljw6NbI&utm_medium=DescriptionFirstFold&utm_source=Youtube
?Caltech - Data Analytics Bootcamp (US Only) - https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=7ny5ljw6NbI&utm_medium=DescriptionFirstFold&utm_source=Youtube
?IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - https://www.simplilearn.com/iitg-generative-ai-data-analytics-program?utm_campaign=7ny5ljw6NbI&utm_medium=DescriptionFirstFold&utm_source=Youtube
This video on Advanced Excel Full Course by Simplilearn is a complete guide to mastering Excel for data analysis and advanced functionality. Starting with Excel basics, the course covers practical operations like changing text case, adding rows/columns, and comparing or converting rows and columns. Advanced formatting topics include grouping rows, freezing rows, merging cells, adding watermarks, and barcodes. Functional tutorials include using formulas like SUMIFS, calculating age/time differences, standard deviation, and performing round-offs. Designed for data analysts, the course wraps up with tutorials on top Excel projects to boost your skill set and portfolio.
The Advanced Excel Full course will cover the following topics
00:00:00 Introduction to Advanced Excel Full Course
00:03:55 What is Microsoft Excel
00:18:45 How To Change Lower Case To Upper Case In Excel?
00:19:58 How To Add Rows In Excel?
00:21:32 How To Add Columns In Excel?
00:24:29 How To Select Entire Column In Excel?
00:27:16 How to Compare Two Columns In Excel?
00:34:36 How To Convert Rows To Columns In Excel?
00:36:13 How to Group Rows in Excel?
00:37:55 How To Remove Blank Rows In Excel?
00:41:44 How To Freeze Row In Excel Tutorial
00:44:12 How to Convert Numbers to Words in Excel?
00:46:59 Combining Data From Multiple Cells In Excel
00:49:27 How To Merge Cells In Excel
00:54:12 How to Add Date in Excel?
00:55:48 How To Change Date Format In Excel (dd/mm/yyyy) To (mm/dd/yyyy)
00:59:55 How To Calculate Age In Excel From A Date Of Birth?
01:01:37 How To Calculate Time Difference in Excel?
01:03:15 DAX In Excel Explained
01:08:20 Checkboxes In Excel
01:12:31 How to Insert Excel in PPT?
01:14:40 How To Insert Image In Excel?
01:18:05 How To Insert PDF in Excel Sheet?
01:21:40 How To Convert PDF To Excel
01:26:05 How to Insert Tick Mark in Excel?
01:29:05 How to add Watermark in Excel?
01:32:00 How to Increase Cell Size in Excel?
01:34:50 How to create Barcode In Excel
01:38:08 Excel Flash Fill
01:43:00 How to Add Hyperlink In Excel
01:55:44 Excel Round-Off Formula
01:58:18 How To Calculate Standard Deviation In Excel?
02:04:50 Index Match In Excel
02:09:10 How to Sort by Date in Excel?
02:10:40 How to Use AutoSum In Excel
02:13:47 How To Sort Data In Excel?
02:44:46 Data Validation In Excel
02:44:50 How To Lock(Protect) Cells In Excel
03:17:55 How To Calculate Average In Excel?
03:18:43 Excel Print Page Setup
03:36:47 Page Break In Excel For Beginners
03:08:53 Conditional Formatting In Excel
03:41:56 How to Count Colored Cells in Excel?
03:47:54 DateDif In Excel Explained
03:51:08 Remove Duplicates In Excel
03:55:05 SUMIFS Formula in Excel
04:02:40 How To Create Pivot Tables In Excel
04:16:04 Charts In Excel
06:45:02 Time Series Analysis in Excel
07:37:00 Excel Dashboard Design
08:06:52 Descriptive statistics using excel
08:16:13 How To Use Copilot In Excel
08:39:59 10 important excel formulaes
08:40:09 Data Analytics using AI
09:18:09 Chatgpt and Excel with Data Analytics
09:36:29 Excel Dashboard Tutorial For Beginners
10:15:57 Excel Using ChatGPT
10:28:32 Top 10 Data Analyst Projects
⏩ Check out the Excel tutorial videos: https://www.youtube.com/watch?v=nPkmWE4JCfE&list=PLEiEAq2VkUUKf8aLrspLg3zuyJ5S-5K5S
#exceldataanalytics #exceltraining #excelformulasandfunctions #exceldatavisualization #excelcourse #simplilearn #simplilearn #advancedexcel #advancedexceltraining #advancedexceltricks #2025 #simplilearn
➡️ About Post Graduate Program In Data Analytics
Key Features
✅ Post Graduate Program certificate and Alumni Association membership
✅ Exclusive hackathons and Ask me Anything sessions by IBM
✅ 8X higher live interaction in live online classes by industry experts
? Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=7ny5ljw6NbI&utm_medium=Description&utm_source=youtube