How to enter and edit Excel Formulas

No video

How to enter and edit Excel Formulas - Back to Basics

Рет қаралды 1,205

11 ай бұрын

Learn how to enter and edit #formulas in #Excel.
Time saving and efficient methods of adding parameters, selecting ranges, auto-completing function names and more.
Contents 📚
00:15 - How to start typing a formula
00:28 - Excel modes in status bar
00:36 - Ready mode
00:43 - Enter mode
00:55 - Point mode
01:18 - Enter to finish
01:44 - Edit using F2
02:22 - Point mode in Edit mode
04:03 - Look at status while editing formulas
04:33 - Order of execution
05:32 - Autocomplete functions and column names
06:09 - Edit in cell or formula bar
06:28 - Select parameter inside a formula
07:35 - Move formula tooltip
07:56 - Instant Function help
Related videos 📺
Excel Best Practices - Data Management - Part 1 of 3 - 2023 - • Excel Best Practices -...
Excel Best Practices - Part 2 of 3 - Formulas - 2023 - • Excel Best Practices -...
Excel Best Practices - Part 3 of 3 - Analytics - 2023 - • Excel Best Practices -...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency36...
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)

Пікірлер: 16

@charudattakulkarni9799 11 ай бұрын

Nice Video sir. Solid observations and tips.

@ryan19899 8 ай бұрын

Using Excel since the past 15 years. Yet I learnt so many things from this video. Fantastic job Doctor.

@efficiency365 8 ай бұрын

Thanks @ryan19899 Check out my popular Excel videos How to enter and edit Excel Formulas - Back to Basics - kzfaq.info/get/bejne/qNp0n7KDsdPOnHk.html Excel Green Marks - Error Checking - Best Practices - kzfaq.info/get/bejne/jst8p8-ryZ_Qgo0.html Excel Best Practices - Part 1 of 3 - Data Management - kzfaq.info/get/bejne/qNiPZMuSm82anJc.html Excel Best Practices - Part 2 of 3 - Formulas - kzfaq.info/get/bejne/oeCPraSnsq-ycZ8.html Excel Best Practices - Part 3 of 3 - Analytics - kzfaq.info/get/bejne/gLSCaNypxLbLZHU.html 10 Excel Settings You Must CHANGE! - kzfaq.info/get/bejne/rL6ipbuVsN-udp8.html Automatic data clean up with Excel Flash Fill - kzfaq.info/get/bejne/hJmgktuQ0b64j5c.html Instant Excel Audit, Comparison and Analysis - Inquire - kzfaq.info/get/bejne/maqUqbiL3bW5mac.html Six powerful Excel Navigation Shortcuts - kzfaq.info/get/bejne/mLhdrLCTrLbVZWQ.html Handle millions of rows in Excel - Slow to fast - kzfaq.info/get/bejne/b5mYatWD2LKqZ40.html Convert crosstab to tabular - Unpivot - Excel Power Query - kzfaq.info/get/bejne/o7qkgteLrZPSfoE.html Cheers. Doc

@ravitejabusetty 11 ай бұрын

thanks sir for all the videos been using excel and formulas since ages never observed these

@efficiency365 11 ай бұрын

Thanks @ravitejabusetty Check out my other best practices videos as well. Efficient Tasks Management - kzfaq.info/get/bejne/rLJ2o7qHy7vKgWw.html Teams Meeting - Agenda, Action Points, Notes - kzfaq.info/get/bejne/oZaka8Kes9GxdKs.html Microsoft Teams - 15 Best Practices - kzfaq.info/get/bejne/jZ6FmduQ39SvqH0.html OneDrive Best Practices Part 1 - kzfaq.info/get/bejne/ep2Kpcmhzb2YpqM.html Part 2 - kzfaq.info/get/bejne/pKyoabyC3cmRkmg.html Smart and Effective Email - 5 powerful ways - kzfaq.info/get/bejne/bLR1ebZ-1q7LgXk.html Outlook Calendar Best Practices : Part 1 - kzfaq.info/get/bejne/feCjhNGWyNClgaM.html and Part 2 - kzfaq.info/get/bejne/pseUfqtp3tmZc6c.html OneNote - Best Practices - kzfaq.info/get/bejne/o5NkdLxiyLPNaKc.html Microsoft 365 Best Practices - kzfaq.info/get/bejne/obxzkryUsZuzkok.html Cheers. Doc.

@MuhammadSadiq-ye5lc 11 ай бұрын

Sir superb way of teaching.

@efficiency365 11 ай бұрын

Thanks @MuhammadSadiq-ye5lc for the feedback. You may also like these Word related videos: Word top 10 settings - kzfaq.info/get/bejne/lZ6iatl_19fMY2g.html Word Tables - 8 ways to create: kzfaq.info/get/bejne/jpN3a8WLu6mrcp8.html Word Tables - 13 problems solved: kzfaq.info/get/bejne/r5t5lc-h27TDeps.html Word Styles - kzfaq.info/get/bejne/bcyPlLKY2NyvcWQ.html Handing long, complex word documents - kzfaq.info/get/bejne/b9CijK15tp29nYU.html Thanks.

@CARohanAgarwal 11 ай бұрын

Nice one

@efficiency365 11 ай бұрын

Many small, simple things make a big and long-lasting difference.

@CARohanAgarwal 11 ай бұрын

@@efficiency365 Agree 💯!

@canirmalchoudhary8173 11 ай бұрын

F2 key is very useful especially editing formula in Name Manager and Conditional formatting dialogue box. One thing is that parameters with square bracket are optional.

@efficiency365 11 ай бұрын

F2 very useful. And very often not understood correctly. Will create a course on how to learn Function syntax soon. People don't learn syntax. Just look at the sample and do the common / default things. That way, other parameters and optional parameters remain unknown. The most damage in the world is probably inflicted by [range_lookup] parameter in VLOOKUP - most people don't have clarity about it. I have seen people omit it and then think, am I getting what I want? If not put 1... ha ha.

@akshayshah6093 11 ай бұрын

Hello Sir, Can you make a video for Web Based Excel.

@efficiency365 11 ай бұрын

Sure. Added to my topic list. Coming soon. Thanks.

@jkumar8590 6 ай бұрын

Simply mind boggling. Lot of videos. Unfortunately v r not able to learn in a structured manner in the absence course like pivot table. Pl structure and encapsulate and offer to us as affordable course, which will democratise excel in an efficient manner.

@efficiency365 6 ай бұрын

Yes. Working on it. Delayed from my side.