Excel Goal Seek Explained with Example
Goal Seek tool is in the Data Tab as a part of What-If Analysis in the Excel Ribbon.
Goal seek can be described as follows:
• It is the opposite of a formula: instead of finding the end result, you give it the end result and it gives you the input
The main advantage of this feature is that you don’t have to change your Excel formulas or turn a formula field to an input field.
Excel What If Analysis Playlist Link - • Excel What if Analysis
bit.ly/3v3IA8Y
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
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/innozantinfotech
#innozant #goalseek #whatifanalysis #excelgoalseeka #msexcel
Пікірлер: 30
This TOPIC was something NEW. Loved it!!!
Very simply and clearly explained
well explained
Brother ur amazing ❤…what a way of teaching 👍
@Innozant
Жыл бұрын
Thanks Manmeet.. Really means a lot to me
Really helpful topic.
@Innozant
3 жыл бұрын
Thanks Hemant ji,Hope you like the concept and learn from there
Super Function
Guruji, Multiple cell ke goal seek kaise select karne ka ?
Sir Input and Outputs main ky krna h
sir loan wagera m use hota hai or kise jaga pa nh
@Innozant
3 жыл бұрын
Haan banks me..loan calculatiojs ke liye aur bhinkais uses hain
Sir, let me tell u one thing the video is this much blurr that I can't see it even on 720p. So, it is a problem in ur video not in mine, it is proved. Wht to do now?
@Innozant
2 жыл бұрын
Saurabh ji.. i checked this video..it's working fine dear .
@saurabhrawat5942
2 жыл бұрын
@@Innozant ok sir, let me check again... That tym when I found it blurr, first, I checked my video quality, which was already at 720p. Then I checked comment section for ensuring tht is it the prob. in my phn or others r also raising the same thing as mine. But I got nothing like tht. So, I thought, to tell my query manually.
@saurabhrawat5942
2 жыл бұрын
Sir don't mind.
Sir goal seek may not have found solutions aisa kyu show ho raha hain maine pura sahi tarike se kiya hain phir bhi jo value hain -- 3300000 by changing cells main ye value aa raha hai
@Innozant
2 жыл бұрын
Jis cell mecirsor rakhke formula apply kar re hain usme koi formula mhi hai..plz check
Anyone can tell how monthly payments are calculated??!!
@Innozant
2 жыл бұрын
Using pmt
@Innozant
2 жыл бұрын
Using pmt
Sir , video is incomplete without seeing your face on screen ..that's where video is lacking & not ..... fulfilled .,...... ...so my request is please ...make videos like other video taking your face on screen ....... Thank you Lots of love & good wishes from WB 💢🙏❤️
@Innozant
2 жыл бұрын
Thanks dear for your love and respect,These videos are initial videos when I started channel.
@fl_d1043
2 жыл бұрын
@@Innozant oh sir , I could not understand........ 💢Thanks sir
Sir vba ki class kaise milegi
@Innozant
2 жыл бұрын
Kuch time baad starte karenge
kissi to you
@Innozant
3 жыл бұрын
hahaha 😀
sir yeh example practice kar rahe toh hume yeh message aa raha Cell must contain a formula
@Innozant
2 жыл бұрын
Haan aayega na ydi cell me formula nhi hoga aur aap goal seek apply krne ki koshish krenge to