Excel OFFSET Function for Dashboard and To Automatically Create a Report

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

[@deepakchauhan4974]

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]

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

[@exceltipsandtricksbyankitk4546]

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

[@Innozant]

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

[@adhishratan6208]

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]

Thanks Adhish Ji I🙏❤️

[@jayantabhattacharyya628]

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]

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

[@kkrcreationstatus6583]

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]

❤️👍

[@a2intertainer748]

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

[@yogeshrao5924]

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

[@Innozant]

God bless you..keep learning

[@Vinmam1231]

You are bahubali of excel sir... 👌

[@Innozant]

❤️ hahaha

[@situsahoo2482]

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

[@Innozant]

Thanks Situ ❤️🙏

[@RajuSingh-df8hv]

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.

[@amitchaudhary5034]

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]

Thanks dear..sayad next video me hoga dear

[@shubhamdeshwal8740]

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))

[@pawanverma7220]

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

[@Innozant]

Yes pAwan Ji👍♥️

[@kishorpanara4191]

Nice sir aapne date ko Dynamic kiya hai

[@Innozant]

👍❤️good

[@tejpalsain1507]

Very good and knowledgeable. Thanks sir

[@Innozant]

Thanks Tejpal Ji🙏❤️

[@arunkumarsinghark3024]

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

[@PoonamKumari-le5od]

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.

[@naeemulhassan1426]

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

[@sajankumarshah299]

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

[@Innozant]

👍❤️Good Sajan

[@Manojyadavdipl]

Good sir

[@ArmanKhan-iq3ji]

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

[@Innozant]

Thanks Arman Khan Sahab❤️🙏

[@ashishmehrotra7308]

Thanks - nice videos

[@amitazad7]

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]

Very true 👍♥️♥️

[@amritathakur2036]

Muje ni aaya smj

[@kinghundred]

very superb sir

[@marzia7946]

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

[@madurgababueducationS60]

🕉nice. all advance excel formulaS uplood korun .

[@Innozant]

Already uploaded all advanced concepts

[@kunalsharma2661]

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

[@Innozant]

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

[@user-ey2sg4dj8c]

Offset dashboard function ke bad ka function bataye sir

[@ravi.mahour]

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

[@Santosh_Bora]

Sir ek complete video dropdown or privot table par banaeye pleade

[@Innozant]

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

[@tejpalsain1507]

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

[@Innozant]

👍♥️♥️

[@PiyushPankajJr]

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

[@Innozant]

👍♥️

[@jaynarayan1963]

Very much for offset

[@poojarathod4100]

Sir month copy krte time same hi value aari he

[@pradeeppatwal6564]

Sum the value from Jan to May

[@rjvandan]

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

[@aijazali5217]

gajjab

[@Innozant]

Thanks Aijaz sahab

[@mahaboobhossain5076]

Total sum annualy each year brother

[@zzzzz644]

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]

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

[@bajrangrathi8406]

Nice trick

[@Innozant]

Thanks Rathi Sahab 🙏❤️

[@VishalKumar-fj7qm]

Sir first example me height and witdh q nhi liya

[@surojitsadhukhan1419]

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]

Yes you are 👍♥️

[@ramseshu110]

Nice sir 👍

[@Innozant]

Thanks Ram

[@abusiddik8265]

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

[@Innozant]

👍👍♥️

[@satishojha6240]

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]

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

[@satishojha6240]

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

[@pramodbhatt6906]

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]

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

[@mahaboobhossain5076]

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

[@Innozant]

sumproduct to khud hi array function h Hossain sahab..

[@pawanwakale8801]

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]

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]

Jan to may ka sum

[@ravishukla02]

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

[@ravi.mahour]

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

[@Innozant]

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

[@ravi.mahour]

@@Innozant Okay Sir, Thank You Sir 😊

[@pratikkarkera8211]

EXAMPLE 3 MAI AAP JO MONTH SELECT KAROGE, USSE EK MONTH PEHELE TAK KA SUM COUNT HOGA

[@Innozant]

Ok..aap practice kar rahe haij example ki

[@pratikkarkera8211]

@@Innozant haa sir practice chalu hai.. And happy guru purnima sir🎉

[@Innozant]

Thanks

[@Santosh_Bora]

Complete video drop-down

[@Innozant]

♥️👍

[@adhishratan6208]

Sir ek questions tha ??

[@Innozant]

Puchiye question?❤️

[@adhishratan6208]

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

[@mudassirpirzada7855]

video is blur...

[@Innozant]

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

[@mohitchauhan7808]

👍👍👍👍👍

[@Innozant]

Thanks Mohit ❤️

[@amritathakur2036]

Muje samjh ni aaya last mai

[@Innozant]

Ek baar phir se dekhiye Amrita offset ka concept sequence me lookup and reference playlist se