Перейти к содержимому

MS Excel Full Course Basic to Advance in One Shot | MS Excel Tutorial for Beginners | CTA

Computer Tech Academy

0:00 / 0:00

MS Excel Full Course Basic to Advance in One Shot | MS Excel Tutorial for Beginners | CTA

66 707 просмотров · 7 дн. назад
Computer Tech Academy
509 тыс. подписчиков
66 707 просмотров · 7 дн. назад
📝 Course Enquiry: 👉 https://forms.gle/9oCgiEvqWdxNk2FP9 WhatsApp Channel: https://whatsapp.com/channel/0029VbAy... For Admission / Fee Details Call / WhatsApp: 8448085412 Enquiry on Call Between Monday to Saturday (9am to 6pm) 📊 MS Excel Full Course Basic to Advanced in One Shot | MS Excel Tutorial for Beginners | Computer Tech Academy Want to learn Microsoft Excel from basic to advanced level in one complete video? 🚀 This MS Excel Full Course in One Shot is specially designed for beginners, students, working professionals, and anyone who wants to improve their Excel skills for office work, data analysis, and career growth. 📌 What You Will Learn in This MS Excel Full Course: 00:00 Introduction to MS Excel 01:09 Excel Workbook & Interface 01:54 Rows, Columns, Cells & Cell Address 02:40 Data Entry & Formatting 10:38 Text to Columns & Find/Replace 18:07 Remove Duplicates 20:00 UNIQUE Function & Drop-Down Lists 21:53 Transpose 23:55 Freeze Panes 26:04 Conditional Formatting 29:18 Filtering Data 32:30 Text Functions 41:36 CONCAT, UPPER, LOWER & TEXTJOIN 45:40 Text to Columns 46:29 Basic Excel Formulas 49:48 AVERAGE, MAX & MIN 54:33 COUNTIF & SUMIF 58:28 SUMIF/COUNTIF Summary 1:22:16 SORT & SORTBY 1:44:22 IF Function 1:47:46 AND & OR Functions 1:57:21 IFS Function 2:03:16 VLOOKUP 2:10:04 HLOOKUP 2:14:55 XLOOKUP 2:35:08 Date & Time Functions 3:00:05 Excel Errors & Error Handling 3:11:53 Pivot Tables & Data Analysis 3:30:22 Conditional Formatting — Highlight Data 3:33:16 Highlight Specific Values 3:34:41 Highlight Duplicate Values 3:36:05 Highlight Dates — Today, Tomorrow & Last 7 Days 3:39:01 Highlight Top & Bottom Values 3:41:15 Above Average & Below Average 3:41:47 Data Bars 3:43:34 Icon Sets 3:45:13 Color Scales 3:46:42 Manage Conditional Formatting Rules 3:48:08 Data Validation — Introduction 3:48:40 Data Validation Practical Example 3:49:24 Data Validation Settings 3:50:27 Drop-down List — Gender 3:51:52 Age Validation 3:52:56 Department Drop-down List 3:53:51 Date Validation 3:55:43 Mobile Number Validation 3:56:43 Salary Validation 3:57:43 Active/Inactive Drop-down List 3:58:16 Input Message 3:59:57 Error Alert 4:03:15 Ignore Blank & Invalid Data 4:04:46 Data Validation — Final Summary 4:05:07 Outro 🎯 Who Should Watch This Course? 🔹 Beginners who want to learn Excel from scratch 🔹 Students preparing for jobs and competitive exams 🔹 Freshers looking to improve their employability 🔹 Office employees who work with spreadsheets and reports 🔹 Accountants, MIS Executives, and Data Analysts 🔹 Anyone preparing for MS Excel interviews #MSExcel #ExcelFullCourse #ExcelTutorial #ExcelForBeginners #AdvancedExcel #MicrosoftExcel #ExcelTraining #ComputerTechAcademy #ExcelFormulas #LearnExcel ============================================= Computer Tech Academy: ============================================= 1. MS Excel One Shot in Just 2 Hrs.: 👉    • Видео   2. MS PowerPoint One Shot: 👉    • MS PowerPoint (PPT) Full Course in One Sho...   3. MS Excel One Shot in Just 60 Min: 👉    • Видео   4. MS Word One Shot in 60 Min: 👉    • MS Word Full Course in Just 90 Minutes | M...   5. Tally Prime with GST One Shot 3Hrs: 👉    • Tally Prime with GST Full Course in Just 3...   ================================================================== Tally Prime Playlist:    • #0 Tally Prime with GST: Introduction | Fu...   ================================================================== Watch Our Popular Video: 1. 5 Best Account Job Skills: 👉    • #51 Tally Prime | How to add Freight Charg...   2. Journal Voucher: 👉    • #10 Tally Prime: Journal Voucher in Tally ...   3. Tally Audit: 👉    • #48 Tally Prime | Data Auditing in Tally P...   4. Payroll: 👉    • Tally ERP.9 Part-17 | Payroll | How to Mak...   =================================================================== Don’t forget to like, share, and subscribe for more insightful career guidance! Join Our Social Media Channels: Facebook: 👉   / computertechacademy   Instagram: 👉   / computertechacademyofficial   Telegram: 👉 https://t.me/ComputerTechAcademy ===================================================== Recommendations for Students: Laptop: https://amzn.to/4ydFRdu Mobile Under 12000: https://link.amazon/B06trzpTn Mobile Under 21000: https://link.amazon/B03jB03vl Mobile Under 31000: https://link.amazon/B02yhUQrS USB C Hub Under 1000: https://link.amazon/B02LXG2PU USB C Hub Under 500: https://link.amazon/B02LXG2PU Wireless Keyboard Mouse: https://link.amazon/B02LXG2PU Wired Keyboard Mouse: https://link.amazon/B0j1RWUjo Microphone: https://link.amazon/B09PQbTyC Bluetooth Headphone: https://link.amazon/B0b22vsty