[FREE Excel Course] Lesson 9 - Excel Formula Basics

In this video of this Free Excel Training, you will learn how to get started with Excel formulas.

This video covers the following topics:

-- Constituents of Excel formula
-- Operators in formulas
-- Entering a formula in Excel
-- Editing a formula
-- Absolute/relative cell references
-- Copying/pasting formulas in Excel, and
-- Formula auditing and debugging.

This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.



⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[yousifabdulla]

I cannot thank you enough Sumit for sharing your great effort for free!

[matteobiancardi]

The best Excel tutorial I have found on Youtube, while the others are too slow and usually not too deep. Great job!

[wayneedmondson]

Hi Sumit.. thanks for this video. Good review of operators, order of operations, editing abs/rel ref and audit/debugging. Thanks for sharing this series for free. Thumbs up!

[RamS-ycxv]

thanks a lot sumit sir...I am a student going to class 11 and I thought I could spend this lockdown in a useful way by learning excel...and your videos are so useful.

[NehaRana-jx]

Thanks Sumit for an insightful session. I came to know order of precedence first time and it really helps my concepts in excel. Keep inspiring and keep sharing more such tricks for excel.

[rutujatanajibangale]

Thank you for sharing such wonderful explanation of each context of excel ❤

[VarunGoyal]

Thanks a lot Sumit. Concepts are explained deeply and so easily by you. Your videos are always clean with no time wasted on any rubbish. I have not found such an excellent course on youtube. I think your videos deserve many more views & likes. Thanks for the effort.

[amiraboodi]

the topic of "relative, absolute, and mixed referencing" was new for me. also, auditing and debugging formulas are very helpful. thank you very much. I enjoyed it a lot.

[shithila]

Thank you for sharing your knowledge. Your explanation and teaching techniques are great and easy to understand.

[HalfdecayOfUranium]

Thank you very much! The lesson helped me a lot!

[ahmadshahkabeeri]

Thanks a million from your great effort for free

[shaitansingh]

Hi submit your videos are very good .

[bhoopalijoshi]

Thank you very much for your channel, your videos and your efforts. The videos are so deep and thoughtful, that one can really become an expert in excel by studying, practicing and applying them. The channel is greatly useful for me, I keep referring to your videos for my daily excel queries. Thanks again!

[dheerajkushwaha]

Thank you sir, 😊 Very easy to understand your English and excel topics

[mohanvaze]

One of the best part so far. Thank you so much. Just one small observation, it seems that "Copying/Pasting formula" is missing in the video. Please check. Best regards

[sahibakhan]

can you please make a video on where we can practice these formulas free

[bhavikjain]

Hi Sumit, thank you for this video but when i press Shift + F3, the insert function box doesn't pops up and i am using Excel 2007

[garimachadha]

Sir pls guide me from where can I download the training file