Master Excel in One Video Part 2 is Here - Dashboard, Pivot, Power Query & AI β Become a Pro
- https://www.youtube.com/watch?v=ihs5Yajk9Vs
π Excel Basics to Advanced β Full Marathon! π
π₯ Complete Excel Course in One Video! From Basics to Advanced, this marathon covers everything you need to master Excel like a pro. Whether you're a beginner or want to level up your Excel skills, this video is for you!
Part 2 ( Excel with AI) will Coming Soon....
β
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 30% OFF on ALL Courses
π Use Coupon Code: SPECIAL30 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 804949888 (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! π
βββββββββββββββββββββββ
π Don't Miss Out! π
π₯ Grab the offer NOW & invest in your future!
π Click the link & enroll today!
βββββββββββββββββββββββ
Time Stamps:
0:00:00-0:23:06 - Interface Overview
0:23:06-0:27:53 - Workbook and Worksheet
0:27:53-0:33:17 - Save File
0:33:17-0:41:24 - Movement Shortcut Keys
0:41:24-0:44:19 - Data Entry Shortcuts
0:44:19-0:47:13 - Data Entry
0:47:13-0:54:45 - Selection (With Shortcut Keys)
0:54:45-1:00:45 - Adjustments of cell ,column,rows
1:00:45-1:19:35 - Basic Formatting (With Shotcut Keys)
1:19:35-1:33:33 - Advance Formatting ( Wrap and Shrink )
1:33:33-1:38:38 - Clipboard Group
1:38:38-1:43:05 - Miscellineous Features
1:43:05-1:59:48 - Basics of Formulas ( Sum Formula with Shortcut )
1:59:48-2:06:45 - Subtract,Multiply, Divide
2:06:45-2:15:41 - Number Format
2:15:41-2:24:14 - Custom date Format
2:24:14-2:43:39 - Conditional Formatting
2:43:39-2:54:11 - Table Creation vs Normal Data Entry
2:54:11-2:56:57 - Table Slicers
2:56:57-3:01:22 - Cell Style
3:01:22-3:04:25 - Format
3:04:25-3:08:22 - Move or Copy Sheet
3:08:22-3:11:27 - Protect Sheet
3:11:27-3:31:04 - Fill Series (Linear, Growth, Date)
3:31:04-3:45:31 - Filters
3:45:31-3:49:43 - Sorting (normal + Custom )
3:49:43-4:24:56 - Go to and Go to Special
4:24:56-4:43:07 - Paste Special
4:43:07-4:52:02 - Find and Replace
4:52:02-5:01:35 - Statistical Formulas (Sum, Average, Maximum, Minimum, Count, CountA, CountBlank)
5:01:35-5:25:38 - Cell Referencing ( Relative, Absolute , Mixed)
5:25:38-5:32:06 - Text Formulas (Left,Right,Mid)
5:32:06-5:33:45 - length formula
5:33:45-5:35:16 - Trim Formula
5:35:16-5:37:46 - Lower, Upper, Proper Formula
5:37:46-5:42:50 - Text Join Formula
5:42:50-5:47:58 - Flashfill
5:47:58-5:50:45 - Text Formula
5:50:45-5:53:35 - Substitute Formula
5:53:35-5:56:27 - Current date and time (Formula and shortcut)
5:56:27-5:58:19 - Day,Month,Year Formula
5:58:19-6:00:14 - Days Formula
6:00:14-6:03:00 - Days360 Formula
6:03:00-6:08:56 - Networkdays
6:08:56-6:11:00 - Networkdays.INTL
6:11:00-6:16:08 - Edate
6:16:08-6:18:21 - Eomonth
6:18:21-6:22:40 - Workday Formula
6:22:40-6:24:27 - Workday.intl Formula
6:24:27-6:26:10 - Time Formulas (Hour,Minute,Seconds)
6:26:10-6:39:54 - If Formula
6:39:54-6:46:00 - And or Formulas
6:46:00-6:53:18 - Rank Formula
6:53:18-6:59:44 - Round,Roundup,Round down
6:59:44-7:03:20 - Is Number, Is text, is formula, is even. Is logical, is error, is err
7:03:20-7:13:51 - Sumif Formula
7:13:51-7:20:14 - Average if, Count if
7:20:14-7:23:26 - Basic of Insert Tab
7:23:26-7:38:23 - Illustration Group
7:38:23-7:42:18 - Sparkline Group
7:42:18-7:46:27 - Hyperlink
7:46:27-7:51:06 - Comment, notes
7:51:06-8:15:10 - Pagelayout tab
8:15:10-8:22:18 - Review Tab and Draw Tab
8:22:18-8:26:38 - view tab
8:26:38-8:33:27 - Chat GPT + Formula
8:33:27-8:45:36 - ifs,sumifs,subtotal
8:45:36-9:14:58 - Vlookup
9:14:58-9:28:56 - Xlookup,filter,index match, large, small, pmt, ipmt,ppmt,pmt,dget,dsum
#ExcelMastery #SAPTraining #TallyExpert #LearnWithUs #AccountingCourses #FinanceSkills #CareerGrowth #SuccessKiHoli #ExcelVali #AdvExcelFree #anjnicomputereducation#excelsolutions #explorepage #beautiful #nature #travel #follow #happy #instadaily #cute #style #tbt #summer #repost #beauty #instalike #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorial