Excel Zero to Hero Tutorial with AI ๐ | 18 Hours Detailed Tutorial
About this course
๐ฅ In this complete course, you will learn Excel fundamentals, interface, formatting, formulas, functions, data handling, charts, conditional formatting, sorting, filtering, data validation, text functions, logical functions, lookup functions, date and time functions, financial functions, Pivot Table...
๐ฅ In this complete course, you will learn Excel fundamentals, interface, formatting, formulas, functions, data handling, charts, conditional formatting, sorting, filtering, data validation, text functions, logical functions, lookup functions, date and time functions, financial functions, Pivot Tables, Pivot Charts, dashboards, what-if analysis, advanced data tools, printing setup, page layout, protection, automation basics, and many complex real-world Excel concepts in a step-by-step practical way. ๐Download practice stuff - "Kindly check PIN Comment" โ Advance Excel LIVE Course (Basic to Advance) - https://web.accountsexpertapp.com/new-courses/1 โ Checkout Our Website - https://web.accountsexpertapp.com/ โ Install our App from Playstore - https://play.google.com/store/apps/details?id=co.tarly.wugze โโโโโโโโโโโโโโโโโโโโโโโ ๐ ๐ฅ SALE IS LIVE! ๐ฅ ๐ ๐ฏ Flat 10% OFF on ALL Courses ๐ Use Coupon Code: WELCOME10 at checkout โณ HURRY! Limited Time Offer! โโโโโโโโโโโโโโโโโโโโโโโ ๐ How to Enroll? (Super Easy!) ๐ ๐ฒ Via App: Download Accounts Expert from Play Store ๐ฅ ๐ป Via Website: www.accountsexpertapp.com ๐ ๐ Call/WhatsApp: +91 8804949888 (Get Instant Support!) โ๐ฉ โโโโโโโโโโโโโโโโโโโโโโโ ๐ก What Do We Offer? ๐ก ๐น ๐ Advance Excel Live Course โ Master formulas, automation & data visualization like a PRO! ๐ฅ๐ ๐น ๐ข SAP Live Course โ Learn Enterprise Resource Planning (ERP) & boost your corporate career! ๐๐ผ ๐น ๐ Tally Live Course โ Become an expert in GST, accounting & business management! ๐๐ ๐ฏ And Many More! Upgrade your skills & level up your career today! ๐ โโโโโโโโโโโโโโโโโโโโโโโ โ TimeStamp : - 00:00:00- Introduction 00:03:24- Video Overview 00:11:25- What is Data & Its theory 00:19:51- Excel Version 00:24:50- Interface Overview 00:50:31- Movement Shortcut keys 01:04:26- Data Entry 01:25:40- formatting 02:13:23- number format 02:33:12- basic formulae 03:03:56- conditional formatting 03:23:37- A.I Conditional Formatting 03:29:20- Data Creation with A.I 03:31:22- Clipboard 03:36:57- filter 03:45:43- sorting 03:53:30- table creation 04:17:21- Fill Series 04:47:16- Go to special 05:15:03- Paste special 05:35:46- Find & Replace 05:48:29- Clear 05:53:47- Promtion Video 05:54:45- Cell Referencing 06:32:28- text formulas 07:29:24- Rand , Rand between , Rand Array 07:41:09- Large , Small 07:46:45- Round , Roundup , Round down,Int, Trunc 07:59:16- Floor , M round , Ceiling , Mod ,Abs , Power , Sqrt 08:03:42- Current Date & Time 08:11:06- Day , Month , Year , Date , Time , Hour , Minute , Second 08:20:39- Days, Days360, Netwrokdays, Networkdays.intl 08:32:28- Workday, Workday.intl 08:40:10- Edate, ,Eomonth 08:48:47- Datedif , Yearfrac 08:52:47- Weeknum , 08:56:55- IF - Logical formulae 09:22:33- And , Or , ,Nested If and , Nested If Or 09:35:20- IFS 09:41:41- Switch , Iferror , Ifna , Isblank , Isnumber , etc 09:51:58- Sumif ,Average if , Countif 10:14:06- Attendance Tracker Prep (Normal + 365) 10:23:55- Report Creation - Yearly , Monthly though Sumifs , Averageifs , Countifs 10:42:03- lookup & refrence formulas Theory 10:58:02- Theory of Vlookup 11:18:59- Various kind of Vlookup Practical application 11:31:52- Vlookup in multiple sheets & Workbooks 11:36:37- Multiple Values in Vlookup 11:39:00- Reverse Vlookup 11:47:13- Vlookup with true condition 11:49:54- Vlookup with dynamic heading (vlookup + match) 11:57:10- index , match , index + match 12:08:15- Hlookup 12:11:10- Xlookup & With Multiple Values 12:19:05- filter formula multiple conditions 12:27:28- Advance Filter Feature 12:32:02- Financial Formulas - Pmt , Ipmt , Ppmt 12:40:55- Vtsack ,Hstack , Sequence , Transpose , Remove duplicates ,free alternative of 365 12:47:26- Add Developer Tab in Excel 12:49:08- Add Addins in Excel - Formula ai aided tool Bar 12:52:35- Chat Bot Assistants , Prompt Creation 13:16:41- Formula Creation through ai, Copilot 13:21:14- Formula Creation through ai Claude 13:31:24- Pagelayout Tab- All Print Settings 13:44:55- View Tab- Freeze Panes , Views 13:51:41- Review Tab- Sheet Protection 13:56:54- Text To Columns 13:59:33- Data Validation 14:05:49- Consolidation 14:09:23- Power Query 14:23:26- Pivot Table Theory 14:29:54- Pivot Table Creation 14:35:46- Pivot Design Option 14:44:30- Pivot Table Options 14:53:51- Pivot Shows as option 14:59:48- Pivot Slicer 15:02:18- Pivot Timeline 15:05:03- Pivot Chart Element Theory 15:13:39- Bar / Column Chart 15:18:29- Line and Trend Chart 15:21:50- Pie/ Donut Chart 15:24:18- Funnel 15:27:20- Treemap / Sunburst Chart 15:31:08- Map / Radar Chart 15:36:13- Promotion Video 15:37:11- Dashboard Theory 15:42:58- Data Check Overview 15:46:53- Dashboard Creation Planning 15:53:51- KPI Creation 16:08:32- Visual Creation 16:22:42- Dashboard Creation 17:01:22- Report & Dashboard through claude 17:12:10- Prensentation through ai 17:23:33- Assignment Answers keys 17:31:15- Interview Questions 17:33:01- How to Download the Data
What learners say
AI summaryLearners overwhelmingly praise the course as a thorough, beginner-friendly, and high-quality resource that covers Excel from basics to advanced topics, often comparing it favorably to paid alternatives.
What learners praise
- Extremely detailed and in-depth coverage
- Clear, easy-to-understand explanations
- Valuable free alternative to expensive courses
- Helps build confidence and practical skills
AI-generated from 100 viewer comments on YouTube โ it summarizes outside comments and is not a CourseShelf review.
Community Reviews
Honest feedback from learners like you
Sign in to review this course.
No reviews yet for this course.