A Drop of Excel - 04 | How to create Formulas and work with various Functions in Excel
Let us now learn about,
- Difference between formula and function in Excel
- How to create a formula
- What are the parts of a function in Excel
- SUM, MAX, MIN, AVERAGE, COUNT, COUNTA, COUNTBLANK, ROUND, CEILING, FLOOR functions
- Measure versus Calculated column
* Example file link
drive.google.com/file/d/1AnwA...
\ Previous video: • A Drop of Excel - 03 |...
/ Understanding of the data being used in the examples: • A Drop of Excel | Unde...
Related Videos/Posts
- 18 Most Useful Excel shortcuts -- • 18 Most Useful Excel S...
- Get Sum, Count, Max, Min, Average in Excel without using any formulas -- • Get Sum, Count, Max, M...
Пікірлер: 5
it's amazing, really helpful
@Excelrush
3 жыл бұрын
Thank you!
Great Going ! Very Nice !
Again a silly question! In the beginning of the video, while explaining sum function, you said, write sum and hit tab then automatically bracket opens and 'sum' becomes"SUM". however in my MacBook air when I pressed 'tab' it showed error "#NAME?". Another question, for practice should I enter a set of data myself and go ahead.. But I really enjoy your way of teaching, its so lucid and fundamental, I am unlearning what I had learnt. Thank you so much.
@Excelrush
3 жыл бұрын
Tab won't work on MAC. For practice, yes that will be the best. Great to know it's helping!!