Create Report from Multiple Sheets using Sumifs & Indirect! Super Advance Formula in Excel!
Вставка
- Опубліковано 10 лют 2025
- Link to Register for the POWER BI Webinar by CA Amit Jain
bit.ly/3TPU3Gn
Visit my Website for educations courses
www.bizwiz.co....
Hi Friends
In this video, I am Sharing how you can create dynamic reports from multiple sheets suing advanced Formulas Like Sumifs and Indirect
The practice file can be downloaded from below link:
www.bizwiz.co....
#excel #advanced #excelshortcuts #excelshortcutsinhindi #excelshortcutkeys #excelexpert #exceltricks #excelshortsvideo #excelshortsvideo #excelexpert #exceltutorial #youtube #excelonline #hiddenfunctions #pivot #analytics #presentation
Products I use and recommend:
Below links may be affiliate links, which means I may earn a commission if you click on the link and make a purchase. I only share products or services that I have used or researched and believe will be of value to my audience.
Tukzer Gel Mouse Pad Wrist Rest Memory-Foam Ergonomic Mousepad
amzn.to/41Hin04
BenQ GW2780 27 inch (68 cm) 1920 x 1080 Pixels IPS Full HD Ultra-Slim Bezel Monitor
amzn.to/3osjHpe
WeCool S4 Selfie Stick, Bluetooth Selfie Stick with Light 6 Shades
amzn.to/3USkwns
Neewer Camera Photo Video Lightning Kit:
amzn.to/41ldAS9
Subscribe UA-cam Shorts Channel
/ @bizwizshorts
Follow Instagram
/ bizwiz.co.in
Follow LinkedIn CA AMIT Jain
www.linkedin.com/in/ca-amit-jain-34802431
for Business inquiries & Collaborations email: support@bizwiz.co.in
Great video. The step-by-step instructions were incredibly easy to follow, and I was able to apply what I learned right away. Really grateful to have watched this.
Wonderful
I have always struggled with complex data in excel. I think I have got a way out through this video. The advanced formula shared in this video is powerful and enables creation of reports effortless. Watch this everyone. Thanks Amit Sir
This video by Amit Sir is an absolute lifesaver! I've struggled with this in the past, but now I now feel confident in my ability to create comprehensive reports quickly and efficiently.
You're the wonderful teacher sir I learned lot from your videos thanks lot sir
Plz play with VBA codes also,
B11:B300=Date F11:F300=company G11:G300=product name M11:M300=quantity. Multiple sheets 1 October 2023 कितना पेंसिल Sale किया, 2 October कितने बुक Sale किया है Excel formula (example: 250 sheets)