No video :(

Excel OFFSET Function for Dashboard and To Automatically Create a Report

Подписаться 152 тыс.

Просмотров 23 тыс.

50% 1

Learn how offset function used to populate dashboard data and how it is used to automatically create a report
Excel Lookup Functions Playlist Link- • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#offsetdynamic #offsetdynamicreference#Innozant #misinterviewquestions#msexcel

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 100

@a2intertainer748 11 месяцев назад

Sir.. the formula return the sum of January to select date month value. Am I right sir ?

@deepakchauhan4974 3 года назад

So nice sir, i have recently started watching your videos, and i dont feel need of any teacher, i wish to all series, please keep posting your videos, please dont ever stop posting sir,

@Innozant 3 года назад

Don't worry..will Never stop your learning.🙏❤️

@jayantabhattacharyya628 3 года назад

Dear Sir, As per your assignment, It changes the month dynamically and gives sum of total months before target month i.e. if you select 6/1/2020 It will sum months from JAN to MAY. Again I witnessed a very important tutorial. Thanks Jayanta Bhattacharyya.

@Innozant 3 года назад

Absolutely Right Jayanta ❤️👍 Thanks for your love and support 🙏👍

@RajuSingh-df8hv 4 месяца назад

Respected Sir, you have calculated the total sales of each month of each product which is up till end of the day of previous month from the month given in current cell.

@arunkumarsinghark3024 Год назад

Sir, Productivity Report smart और auto तरीके से बनाना सिखाए please Employee Productivity Report With dashboard, Target Work, Completion Work, Dashboard View, Productivity With Graph

@exceltipsandtricksbyankitk4546 3 года назад

Without seeing full video I downloaded it. Because we know will be the best content.

@Innozant 3 года назад

Hahaha Love you for your trust Guruji..Lekin RU-vid me hi Dekh liya Karen to jyada Acha Hoga na ..🙏❤️❤️❤️

@adhishratan6208 3 года назад

Awesome sir mere ko abhi apse judhe huye thoda hi time hua hai but Mene apse bhut kuch Sikhe... Liya thanks you so much sir ❤️❤️

@Innozant 3 года назад

Thanks Adhish Ji I🙏❤️

@shubhamdeshwal8740 2 года назад

No. of days in a month aise jyada sahi niklega, koi format bhi change karne ki jarurat nahi. =day(eomonth(date(year($C$2),Month(Datevalue(1&B5)),1)0))

@yogeshrao5924 2 месяца назад

First wala Offset or Index match dono se ho jayega charan sparsh gurujii 😊mein bhi apka shisy hu

@Innozant 2 месяца назад

God bless you..keep learning

@kkrcreationstatus6583 2 года назад

Ye assignment ke through apne hamse question kiya hai ki Jo current date hai , uske pahle hamne usi saal ke last months mein kitna sales kiya hai ek product ka.. Thanks, sir for your teaching.

@Innozant 2 года назад

❤️👍

@naeemulhassan1426 5 месяцев назад

Dear sir. Your 3 years ago uploaded tutorial video regarding offset function. I done practice of dynamic heights plus as well dynamic weight. But result not came when horizontally culums base plus.plz breaf easy way to understand. Awaiting reply plz..Naeem

@Vinmam1231 2 года назад

You are bahubali of excel sir... 👌

@Innozant 2 года назад

❤️ hahaha

@PoonamKumari-le5od 2 года назад

B6 ko referance Maan ke, 400 ko Row , column & hieght le kar width me currant date ke month se one month ko less karke Jo Jan to may me value hai us value ko sum karke display kiye ho sir.

@user-ey2sg4dj8c Год назад

Offset dashboard function ke bad ka function bataye sir

@pawanverma7220 3 года назад

Video Is So Nice. Sir, Combo Box Works Like Match Function.

@Innozant 3 года назад

Yes pAwan Ji👍♥️

@situsahoo2482 3 года назад

Nice video.Sir.its really helpful for everyone.day to day office .🙏🙏❤️❤️.

@Innozant 3 года назад

Thanks Situ ❤️🙏

@ravi.mahour 3 года назад

In the last Question, We have to calculate SUM from First Month to one month before of month which we will select.

@kishorpanara4191 3 года назад

Nice sir aapne date ko Dynamic kiya hai

@Innozant 3 года назад

👍❤️good

@amitchaudhary5034 3 года назад

sir thank you so much for giving us such amazing classes thank you so much, sir question apne phocha tha oska is video me oska jawab hai ki....jo date ap waha likhe os month tak ke se ek extra month tak ka sum aa jaye os product ka...

@Innozant 3 года назад

Thanks dear..sayad next video me hoga dear

@sajankumarshah299 3 года назад

Sir Aap nai Pichle saal ka same year ka value kya tha yah batane ka kosis kr rahe hI

@Innozant 3 года назад

👍❤️Good Sajan

@marzia7946 11 месяцев назад

Sir the link provided for the practice file isn’t working

@kunalsharma2661 3 года назад

Sir agr koi tableau or power bi m se koi 1 krta h to ky usse pehle VBA bhi sikhna compulsory h ?

@Innozant 3 года назад

Nk dear ..Vba autamtion ke lkue use..aur wo dono data visualizatiom tool hain.

@Manojyadavdipl Год назад

Good sir

@tejpalsain1507 3 года назад

Very good and knowledgeable. Thanks sir

@Innozant 3 года назад

Thanks Tejpal Ji🙏❤️

@pradeeppatwal6564 2 года назад

Sum the value from Jan to May

@madurgababueducationS60 2 года назад

🕉nice. all advance excel formulaS uplood korun .

@Innozant 2 года назад

Already uploaded all advanced concepts

@poojarathod4100 Год назад

Sir month copy krte time same hi value aari he

@ArmanKhan-iq3ji 3 года назад

Wow Sir thank u for sharing this wonderful video it's help me lot😊

@Innozant 3 года назад

Thanks Arman Khan Sahab❤️🙏

@surojitsadhukhan1419 3 года назад

In an Example 3 Sheet, You are using offset function for calculating total number of month wise... Like if you entered June Date in Date cell (B2) its calculating YTD total from Jan to May. Am I right sir?

@Innozant 3 года назад

Yes you are 👍♥️

@amitazad7 3 года назад

Dear Sir, This formula in N6:N9 cell gives the sum of sales from January to the month of date of cell(B2) You have already taught us such use of offset in dashboard series for the graphical presentation. Thanks a lot!

@Innozant 3 года назад

Very true 👍♥️♥️

@amritathakur2036 Год назад

Muje ni aaya smj

@Santosh_Bora 3 года назад

Sir ek complete video dropdown or privot table par banaeye pleade

@Innozant 3 года назад

❤️🙏Pivot Table Ka Complete playlist already hai dear .aur Dashboard series dekhiye usne kaafi detail me bataya gya hai drop-down ke baare me

@kinghundred 3 года назад

very superb sir

@ashishmehrotra7308 2 года назад

Thanks - nice videos

@rjvandan 3 года назад

Hi, There is an issue if we choose Jan 2020 then there is an error in YTD cells Please help

@PiyushPankajJr 3 года назад

Kisi month ke pehle tk ki total sales find krne ke liye yaha aapne width me month ka formula use kiya hai.

@Innozant 3 года назад

👍♥️

@mahaboobhossain5076 3 года назад

Total sum annualy each year brother

@pramodbhatt6906 3 года назад

Sir, I have an querry in Offset function; Example In My data A1 till A4 is value & i want to Sum A1 & A3 & then A2 & A4 Whenever i will paste my data from A5 same calculation should be happed. Sir How to use Dynamic offset here. I will wait for your prompt response....

@pramodbhatt6906 3 года назад

Sum of A1 & A3 output in Different Column and Sum of A2 & A4 output in Different Column

@VishalKumar-fj7qm Год назад

Sir first example me height and witdh q nhi liya

@abusiddik8265 3 года назад

Sir, the total up to the month before the date you gave in B2 cell

@Innozant 3 года назад

👍👍♥️

@tejpalsain1507 3 года назад

इसमे BE सेल में जो डेट लिखेंगे उससे मंथ उठाकर नीचे रेंज में जहाँ तक वो मंथ हैं वहाँ तक सम कर देगा। जनवरी से b2 सेल के मंथ तक सम हो रहा है

@Innozant 3 года назад

👍♥️♥️

@jaynarayan1963 3 года назад

Very much for offset

@mahaboobhossain5076 3 года назад

Brother I need array functions of sumproduct,sum,choose of excel

@Innozant 3 года назад

sumproduct to khud hi array function h Hossain sahab..

@zzzzz644 3 года назад

Very informative, love your videos your subscriber, the way you teach with great patience and passion can be seen through your videos. But one question regarding (Report Title) in this video, how you converted DECEMBER into DAYS (the last one) and also how month formula is used in ROW argument in OFFSET formula used in REPORT TITLE. Want to know. Please help!!!

@Innozant 3 года назад

Thanks..already applied formula is there.kundly check video

@satishojha6240 3 года назад

Sir agar current date change karegaye tho ytd bhi change hoga apne ne date ko dynamic banaya hai. Agar galt hai tho comment mai bataye ga sir kaha galti kar raha hu. Thanku 🙏🙏🙏🙏

@Innozant 3 года назад

Bht hadd tak Sahi Hain aap..Rhoda SA aur explanation ki umeed aapse 👍❤️🙏

@satishojha6240 3 года назад

@@Innozant ok sir thanku again to support me i try for better explanation in next time.

@ravishukla02 2 года назад

Assignment Ans: Running Total on the basis of the selected date (Month)

@aijazali5217 3 года назад

gajjab

@Innozant 3 года назад

Thanks Aijaz sahab

@bajrangrathi8406 3 года назад

Nice trick

@Innozant 3 года назад

Thanks Rathi Sahab 🙏❤️

@ramseshu110 3 года назад

Nice sir 👍

@Innozant 3 года назад

Thanks Ram

@pawanwakale8801 2 года назад

Sir apne table chart create kiya tha isme aur bad me cost ko delete kiya tha toh sir humare isme revenue ,cost and income show karta hai par check box nhi dhikha raha ,how to solve it ,help

@pawanwakale8801 2 года назад

Sir aur ek doubt apne dashboard ka example liya usme output me jab ata hai Aprilsales report (31 days) ,, matlab aprilsales joint ho ke ata humne bich me " " pass kiya toh bhi kuch change nhi dhika raha woh bata raha

@user-gk4us8ml6t 11 месяцев назад

Jan to may ka sum

@ravi.mahour 3 года назад

Manually Days count krne ki jagah yaha =DAY(DATE(YEAR($C$2),ROWS($F$4:F5),1)-1) use kr skte h Sir 🙂

@Innozant 3 года назад

Haan kyu nhi...formula jitna optimize ho wo acha h

@ravi.mahour 3 года назад

@@Innozant Okay Sir, Thank You Sir 😊

@Santosh_Bora 3 года назад

Complete video drop-down

@Innozant 3 года назад

♥️👍

@mudassirpirzada7855 3 года назад

video is blur...

@Innozant 3 года назад

Blur ? Not posbl..may b your internet is slow dear 🙏❤️

@mohitchauhan7808 3 года назад

👍👍👍👍👍

@Innozant 3 года назад

Thanks Mohit ❤️

@adhishratan6208 3 года назад

Sir ek questions tha ??

@Innozant 3 года назад

Puchiye question?❤️

@adhishratan6208 3 года назад

DATA LEFT MID RIGHT Ram Is a good boy Ram Is a good boy he is the honest man he is the honest man naresh kumar is a very good Boy naresh kimar is a very good boy left right mid nikalna hai mid nhi aa raha aur right space Find nhi ho raha kese hoga sir