How to enter and edit Excel Formulas - Back to Basics

[@MDSameerhaidar]

Sir my english is very weak but your way of speaking English helps me 😊

[@charudattakulkarni9799]

Nice Video sir. Solid observations and tips.

[@ryan19899]

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

[@efficiency365]

Thanks @ryan19899
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc

[@finiteloops8610]

As a longtime Excel user I had low expectations. However, was surprised to learn a lot. Thanks!

[@efficiency365]

Thanks @finiteloops8610
There are thousands of features. We use very few of them.
Huge scope for enhancing whatever you do.
Check out my other best practices videos as well.
Task Management Best Practices - ua-cam.com/video/DJcxPtu-rcg/v-deo.html
Efficient Tasks Management using the New Planner 2024 - ua-cam.com/video/kgxqzDirw1o/v-deo.html
Microsoft Teams Meetings - 16 Best Practices - ua-cam.com/video/l3Bvq-I0hy4/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.

[@MuhammadSadiq-ye5lc]

Sir superb way of teaching.

[@efficiency365]

Thanks @MuhammadSadiq-ye5lc for the feedback.
You may also like these Word related videos:
Word top 10 settings - ua-cam.com/video/_8r7vNrqh34/v-deo.html
Word Tables - 8 ways to create: ua-cam.com/video/X-G8bZVCGBk/v-deo.html
Word Tables - 13 problems solved: ua-cam.com/video/y5IblpvN_Jg/v-deo.html
Word Styles - ua-cam.com/video/7f_aOgsvKA0/v-deo.html
Handing long, complex word documents - ua-cam.com/video/9jrYJHQ7YmQ/v-deo.html
Thanks.

[@CARohanAgarwal]

Nice one

[@efficiency365]

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

[@CARohanAgarwal]

@@efficiency365 Agree 💯!

[@ravitejabusetty]

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

[@efficiency365]

Thanks @ravitejabusetty
Check out my other best practices videos as well.
Efficient Tasks Management - ua-cam.com/video/vLFpWVfUfQ8/v-deo.html
Teams Meeting - Agenda, Action Points, Notes - ua-cam.com/video/k0t8_mNkMDw/v-deo.html
Microsoft Teams - 15 Best Practices - ua-cam.com/video/W8Ufx_znKxI/v-deo.html
OneDrive Best Practices Part 1 - ua-cam.com/video/D7ZrfphW4vo/v-deo.html Part 2 - ua-cam.com/video/nFx6YQxc-b4/v-deo.html
Smart and Effective Email - 5 powerful ways - ua-cam.com/video/6NEFSMqHgQE/v-deo.html
Outlook Calendar Best Practices : Part 1 - ua-cam.com/video/GzsQnecjAQo/v-deo.html and Part 2 - ua-cam.com/video/padKH8ys5Cs/v-deo.html
OneNote - Best Practices - ua-cam.com/video/m-4AY1cMi8s/v-deo.html
Microsoft 365 Best Practices - ua-cam.com/video/kVC_YcL5ObU/v-deo.html
Cheers. Doc.

[@akshayshah6093]

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

[@efficiency365]

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

[@canirmalchoudhary8173]

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]

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.

[@jkumar8590]

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]

Yes. Working on it. Delayed from my side.