- Introduction
- SUM & 3D Formulas
- MAX & MIN
- IF Function
- LOOKUP Function
- XLOOKUP Function
- Creat a Unique List
- Transpose Data
- Text To Column
- Conclusion
- Bonus
In This course you will :
Learn How to ------->
- Use Functions : What is the syntaxe of Functions.
- What Function to use : In generale a Function always had the name of what you want to do (U are searching for the maximum amount in a list of data then the Function called Max).
- When and how to use it : What is the purpose of each Function.
_______________________________________________________________________________________________
The Functions i included here are :
Of course its impossible to talk about all the function that Exce offer to use,but i tried to show the most used ones and in addition i tried to add some Features and technics may be usefull when you deal with Data.
You will have a lot of practice alongside with the videos,so keep practicing in each seasion.
You will see :
SUM Function.
3D Formulas.
MAX & MIN & IF & IFS (the last one availaible in the new version and the 365 version).
The Lookups Functions : LOOKUP & XLOOKUP ( i did not talk about VLOOKUP & HLOOKUP they are old and had a lot of limitation)
I did not include the INDEX & MATCH but i invite you to learn them.
How to creat a unique list.
How to Transpose your data.
How to separate a text in a cell to many columns.
----------------------------------------------------------------------------------------------> Enroll To the course now and learn all of that.
The Journey of Deep Learning: Past and present
Learn how to make easy parametric wardrobe create in Revit Family
Become a successful & Exceptional leader and professional by learning to manage Emotions
Learn How to Create Your Short Story from Scratch & Avoid the Mistakes Made by Amateurs.
Hey there, Let's start with a small talking about why I am here.
When I discovered for the first time that Excel can do more than it shows, I was surprised, I had the tool for a long time installed in my PC but never used it to do something more than basics calculation, and some charts that had no meaning or beautiful style, so I am here to share this knowledge with u and go the next level using Excel.