#1 MIS Report | Excel Reporting and Analysis Skills | Accountants

  Рет қаралды 37,988

Accounts Advice

Accounts Advice

Күн бұрын

#accountsadvice #todiyapatel #misreport
Register for Certified Business Accountant Course Job Support: hubs.la/Q02BdY5j0
------------------------------------------------------------------------------------------------
Practice file for MIS Part 1:- (Under Accounts format tab you will get the file) diyapatel.myinstamojo.com/
Download Automated Excel Bundle formats:- diyapatel.myinstamojo.com/
Video to understand how Excel format will work- • Premium Bundle Excel T...
------------------------------------------------------------------------------------------------
Timestamp:-
0:00 Introduction
0:34 What is MIS
1:14 Excel tools for an accountant
1:39 Data for MIS
3:29 Subtotal
4:38 Slicer
6:03 Odin school course
7:20 Aging analysis
10:24 monthly billing
11:28 quarterly billing
13:04 GST billing
14:09 Product-wise analysis
16:12 Formatting of report
Learn how to create an effective MIS report using Excel tools. We'll cover slicers, pivot tables and building a comprehensive dashboard. Plus, discover key presentation skills for reporting and analysis to impress management. Essential skills for accountants.
-------------------------------------------------------------------------------
Connect with us:-
Whatsaap Group:- whatsapp.com/channel/0029Va5r...
Accounting Solutions 4U:- / @accountingsolutions4u
Accounts advice:- / @accountsadvice
Our Website: Home | todiyapatel.com
Instagram:- / todiyapatel
Facebook:- / todiyapatel
Twitter:- Accounting Sulutions 4U (@todiyapatel) on X
Telegram:- t.me/todiyapatel
Business query:-infoacsolutions4u@gmail.com
---------------------------------------------------------------------
Download Excel formats:-
Store Link- Accounting solutions 4U
----------------------------------------------------------------------
✔️Free Courses:-
GST Basic to advance course
• GST Course(Basic to ad...
TDS Basic to advance course
• TDS Course Free (Tax D...
Tally Basic to the Advance course:-
• Tally Prime
Payroll Management course( Salary Management) in Tally Prime
• Payroll Process(Course)
Tally Prime Advance features
• Tally Prime Advance fe...
Construction Accounting In tally Prime
• Construction Accounting
#misreport #excelreporting #reportingandanalysis #accountantskills #excelforaccountants #dataanalysis #pivottables #vlookup #exceldashboard #financialreporting #managementinformationsystem #exceltips #slicerinexcel #exceltutorials #businessintelligence
---------------------------------------------------------------------
My Recommended Products [I will only share what I love💜 here]
▶️ My Phone for recording : amzn.eu/d/5tKPc0S
▶️ My laptop: amzn.eu/d/e7zgZEw
▶️ My Mic: amzn.eu/d/hXiS3xA
▶️ My studio lights: amzn.eu/d/ivllSYe
▶️ Visit my store for sudio setup: www.amazon.in/shop/todiyapatel
DISCLAIMER: Please note that some links included in this description may be affiliate links. If you choose to make a purchase through these links, I may earn a small commission at no extra cost to you. Your support is greatly appreciated as it allows me to continue creating free content for you every week!
All opinions expressed on my channel are solely my own and should not be considered as financial or professional advice.

Пікірлер: 94
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
Our Hero Product - imojo.in/V996EE Our Excel Product Store link - diyapatel.myinstamojo.com/
@b.k.choudhary1057
@b.k.choudhary1057 16 күн бұрын
Sabse best video on excel MIS specially Pivot Table, Slicer, Subtotal etc...
@dineshprajapati1552
@dineshprajapati1552 21 күн бұрын
Thank ma'am for adding value in our life
@davendersharma3417
@davendersharma3417 9 күн бұрын
Very welldone mam, aap bhut achaa kaam ker rehe ho keep it up 👍👍👍
@user-rb7od6hl7j
@user-rb7od6hl7j 21 күн бұрын
Dhanyavaad ma'am
@shabbirbagawan7013
@shabbirbagawan7013 16 күн бұрын
Thank You Ma'am
@mr.pavanvlogindia8646
@mr.pavanvlogindia8646 8 күн бұрын
You are super ma'am...thank you so much ❤
@kuntaldutta7841
@kuntaldutta7841 20 күн бұрын
Very nice 👌 👍
@mr__Bhavesh
@mr__Bhavesh 21 күн бұрын
Your videos always helpfull for me to learn something new in the Accounting field Thanks Mam❤😊
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
My pleasure 😊
@Singhsushma98
@Singhsushma98 21 күн бұрын
Thank you you simple explanation of concepts enhancing our knowledge
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
It's my pleasure
@stutigor4069
@stutigor4069 21 күн бұрын
Thank you mem
@hardikhatri9265
@hardikhatri9265 21 күн бұрын
Excellent information to learn. Thnks for sharing
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
Glad it was helpful!
@kashishprajapati846
@kashishprajapati846 21 күн бұрын
Amazing video ma'am. Thank you soo much.
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
Most welcome 😊
@hunttech8712
@hunttech8712 20 күн бұрын
Thank you so much your video are very helpfull gain in knowledge in accountancy for all studenta
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
It's my pleasure
@shahzadkhan3324
@shahzadkhan3324 12 күн бұрын
My laptop in Excel subtotal formula is not working why? Please reply
@rahulpatil-nc6wr
@rahulpatil-nc6wr 21 күн бұрын
Thank you so much Diya Mam Really Helpfull video for Me🙂👍
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
My pleasure 😊
@sumitsahu1783
@sumitsahu1783 21 күн бұрын
Thankyou for considering this....❤ Pls make these reports also.... demand report, financial statement analysis report, sales report, MIS reports in accounts, budget reports, forecast report , profit report, summary report, cost reports, production report, inventory report, abnormal loss report, income statement report, trend report, orders in hand report, fund statement report, cash flow statement report, management control report, financial reports, predictive reports, reports on the ideal time....exception reports, budgeted & actual profit report, decision making report, sales of 1 product vs another report..... Variance analysis....
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
will be covered everything... :)
@sumitsahu1783
@sumitsahu1783 21 күн бұрын
❤😊
@accountsacholic530
@accountsacholic530 20 күн бұрын
Thank you so much Mam its really very helpful for newbie
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
Most welcome 😊
@khatri2009
@khatri2009 20 күн бұрын
Thanks mam for useful information.
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
Most welcome 😊
@jaydip1486
@jaydip1486 8 күн бұрын
Hi, can you add video of how to prepare financial statements in excel detail
@unbeatablethought7980
@unbeatablethought7980 21 күн бұрын
Bahoot badiya Mam, Mujhe essi he class ka wait tha, Am working Gurgaon currently.
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
great happy learning...
@user-lf7lx2iu2c
@user-lf7lx2iu2c 17 күн бұрын
Hlo bro gurgaon m kha job krte ho m bhii accounting job krta hu yhii
@pramod76783
@pramod76783 16 күн бұрын
mam apne jo today ka formula lagya hai usme date roj change hoti hai automatic? jaise ager kise ka 29 days due hai or apne excel file save kar kai logout kar diya fir next day dubra khola to usme 28 days due show hoga Today ke formula se ?
@israrmulla8672
@israrmulla8672 19 күн бұрын
Mam slicer lagane ke bad mera totale change nahi ho raha (costumer or category wise change nahi ho raha subtotal hi reh ta hai )
@asif_chouhanproduction415
@asif_chouhanproduction415 21 күн бұрын
Respected madam. Keep doing good
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
Thank you, I will
@AccountingFunda-oo2og
@AccountingFunda-oo2og 15 күн бұрын
Di aur bhi report ke video plz
@AmitKumar-mg9zj
@AmitKumar-mg9zj 19 күн бұрын
Superb 👍👍👍👍
@AccountsAdvice
@AccountsAdvice 19 күн бұрын
Many many thanks
@satishghagare
@satishghagare 9 күн бұрын
Kitne % changes me sell kiye or fir buy kis rules se kare
@azharkhan187
@azharkhan187 21 күн бұрын
Ma'am me trading Company proprietorship company hai kya isme accountant future hai
@avijitdey9229
@avijitdey9229 21 күн бұрын
Aur mam bol Rahe hai Ismain eksath one party or multiple party ka hisab rakh sakte hai?
@kuntaldutta7841
@kuntaldutta7841 20 күн бұрын
CMA course pe upor details video kariye
@user-lf1nf7zt3u
@user-lf1nf7zt3u 21 күн бұрын
Thank youu so much dear mam❤️🫶🏻
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
My pleasure 😊
@nikunj5656
@nikunj5656 13 күн бұрын
No file in description
@vikasgoswami4082
@vikasgoswami4082 15 күн бұрын
Advance tax pr bhi video bana dijiye
@santanugarai2247
@santanugarai2247 20 күн бұрын
Very nice
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
Thanks
@saikumarjoharapuram3230
@saikumarjoharapuram3230 20 күн бұрын
Madam I'm article student my senior is so irritated with me he is not teaching any GST works to me so I'm planning to buy GST filing classes of yours ma'am is this helpful for me mam to learn complete GST works ma'am ❤❤
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
All the best. we have free courses on youtube only.,. check playlist of GST course and TDS course.. Must watch and learn..
@Patildsg
@Patildsg 14 күн бұрын
Ma'am, Practice file Download nahi ho raha hai
@chintu_Kumar_7645
@chintu_Kumar_7645 9 күн бұрын
Please mam ek aisa video bna dijiye Jis me sara kuchh bta dijiye ki accountant kaise bne😢
@rohanbansode413
@rohanbansode413 19 күн бұрын
Mam plz make video for semi qualified ca job opportunity plz
@musafir9210
@musafir9210 19 күн бұрын
Please mention your experience and salary as a accountant here, so we can get idea where we are and what need to be done for growth.
@avijitdey9229
@avijitdey9229 21 күн бұрын
Mam excel tools jo banya Tha accounting ka uska demo dekh sakte hai kya ?
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
ye series me cover karenge
@thedreamers4892
@thedreamers4892 18 күн бұрын
Ma'am over priced h 😢 Pls koi coupon / offer btaiye
@pramodpatil3106
@pramodpatil3106 9 күн бұрын
Hi Diya i want advice for accounts job please reply
@dholurajnikant7529
@dholurajnikant7529 8 күн бұрын
Tally me se Direct Excel Sheet me link kaise karte hai.
@Thecomputereducation2530
@Thecomputereducation2530 8 күн бұрын
Madam Excel practice sheet kha milegi
@Shivaleela.D.gowdar
@Shivaleela.D.gowdar 19 күн бұрын
Which accounting course is best with job placement guarantee ma'am
@shahzadkhan3324
@shahzadkhan3324 18 күн бұрын
Hello mam, I download your MIS report.but in my laptop due days it's different show. Why? Please tell My laptop date dd/mm/yyyy.
@mayurkapadia1985
@mayurkapadia1985 14 күн бұрын
Where is download link for MIS FILE
@chandanprajapati482
@chandanprajapati482 15 күн бұрын
Odin school se business accountant ka course karne par kitni salary mil sakti after 4 year of experience
@SARWANKUMAR-sr6ip
@SARWANKUMAR-sr6ip 20 күн бұрын
Me Sarwan Kumar Jo rajasthan se hun pls tallyprim ki ek hull video bnao with GST,TDS,tcs filing process and payroll ki
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
check this video description.
@vipinmalaviya873
@vipinmalaviya873 20 күн бұрын
In my Excel, Slicer is not there. Which Excel version you are using
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
2013
@ajitdodhiya4972
@ajitdodhiya4972 21 күн бұрын
Pls sand me tally prime full course link
@AccountsAdvice
@AccountsAdvice 21 күн бұрын
check description
@sbk1314
@sbk1314 19 күн бұрын
Can you please share me any vedio about budget forecaste, Because I want to do work on this subject in a new company and I don't know anything about it. So please share me
@AccountsAdvice
@AccountsAdvice 19 күн бұрын
i have not made but we will be covering budget in this series.
@sbk1314
@sbk1314 18 күн бұрын
okay thank you
@tausifshaikh747
@tausifshaikh747 21 күн бұрын
Didi kahi account job ki vacancy hai kya Mumbai ma
@brstmvlog8173
@brstmvlog8173 19 күн бұрын
Ahmedabad and gandhingar me bhut job hai accountant ka
@mr__Bhavesh
@mr__Bhavesh 21 күн бұрын
I am also working as a Account executive in manufacturing industry....but mam I want to do MBA in finance so can i do it for grow in corporate life.....?
@vishalgupta7163
@vishalgupta7163 21 күн бұрын
Konsi company me ho
@tonystark_adhp
@tonystark_adhp 21 күн бұрын
What is your salary as an account executive ?
@shailenderkumar6949
@shailenderkumar6949 19 күн бұрын
18k​@@tonystark_adhp
@rupakadhikari3369
@rupakadhikari3369 17 күн бұрын
F
@aniruddhamallick3314
@aniruddhamallick3314 14 күн бұрын
Not doing MBA finance, taken other specialisation
@suraj-pg2rd
@suraj-pg2rd 20 күн бұрын
Practice file download nhi ho rhi ???
@AccountsAdvice
@AccountsAdvice 20 күн бұрын
Store pe.. Accounts formats tab me practice file he
@suraj-pg2rd
@suraj-pg2rd 18 күн бұрын
OK THANK YOU VERY MUCH
@himanshubohra5038
@himanshubohra5038 13 күн бұрын
Thumbnail false😢
@amitagarwal2405
@amitagarwal2405 20 күн бұрын
Very nicece reporting please share your email
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 336 М.
Luck Decides My Future Again 🍀🍀🍀 #katebrush #shorts
00:19
Kate Brush
Рет қаралды 8 МЛН
12 Most Useful Excel Formulas and Functions | Excel Formulas in Hindi
46:45
Make your Income Tax ZERO! | Ultimate Tax Saving Masterclass | LLA
46:54
Labour Law Advisor
Рет қаралды 341 М.
Don't need to remember Excel formulas from now | Excel using A.I
10:53
Consolidation in Excel (Hindi) | How to Consolidate Data in Excel
6:32
PowerEx by Jitendra
Рет қаралды 300 М.