I am Anil Dhawan, a passionate and an Excel-holic guy, founded this blog to share Excel Tips & Tricks regularly. I have given 12+ years to industry as Data Person and now aiming to share my knowledge to maximum people to help them to learn Excel with ease and become awesome at their profession. Click to know more about me.
One of the new function introduced to the “Logical” group, is IFS function. It is a great replacement for Nested IF conditions which consumes less time and much easier to read with multiple statements.
A useful tutorial to explore the functionality of OFFSET function from basics. OFFSET is a one of the great addition to Excel functions to build a dynamic range for features like Data Validation, Charts, Pivot Tables etc.
Excel EOMONTH function returns end of the month’s date after adding a specified number of months. Use EOMONTH to get the number of days in the particular month from an initial date or find out the last weekday in a month.
A quick tip on inserting special It is used to display characters which are almost impossible to enter using a standard keyboard. Using CHAR function, you can return a character specified by a code number.