EZ Excel with Zen

15/08/2021

Having problem with extra spaces in your files? Watch this video to help you.

Removing extra spaces in your file is not a problem anymore. Watch the video to guide you with this issue.

15/08/2021

Understand the difference between SUMIF & SUMIFS

This will help you to capture the total amount on a given data with single and multiple condition/criteria)

15/08/2021

Capture the End of Month using EOMONTH formula.

This will guide you how to capture the last and first day of the month in a faster way. Remember, MS Excel functions are helpful to avoid manual intervention...

06/06/2021

This video will help you convert numbers to words using SPELLNUMBER function. However, we need a code to activate these function.You may use the link below f...

16/05/2021

https://youtu.be/-Tn_0yoANJQ

This will help you identify the day and month in a particular date and convert it to words.

12/05/2021

Learn how to use Vlookup formula with multiple scenarios

08/05/2021

https://youtu.be/zWZ1l1maB-I

This is a continuation of the COUNTIFS formula but dealing with ranges.

13/12/2020

Understand the basic terminologies and parts of Excel spreadsheet window.

This video is to guide the beginners to be familiarized with the parts and terminologies in Excel spreadsheet.Please don't forget to subscribe and share to y...

21/11/2020

Present your report in an organize manner using MS Excel "Group" function.

17/11/2020

How to create drop down list.

This will guide you to avoid data errors or formatting issues in your file. To know more about Excel, please visit my Channel: https://www.youtube.com/channe...

14/11/2020

How to consolidate your data from various sources using Traditional way (linking of cell reference) and MS Excel built in function "CONSOLIDATE".

14/11/2020

Consolidation of data..

How to consolidate your data from various sources using Traditional way (linking of cell reference) and MS Excel built in function "CONSOLIDATE".

14/11/2020

How to manage ERROR in your MS Excel Formula? Please watch below video.

Know how to use IF & IFERROR formula and learn how to make it easy.

13/11/2020

Restrict others from viewing or modifying your confidential files with a Password.

Simple guide on how to Protect your workbook/Excel Files with Password, thus restricting others in opening or modifying your file.

02/11/2020

To avoid irrelevant changes, movement or deletion in your files, we need to protect specific cells or the entire worksheet itself. This video will guide you ...

01/11/2020

Learn the function of excel command "Sort" and how to perform it using multiple criteria

01/11/2020

A simple guide to copy and paste data from a particular cell/source to another destination using various Paste Special options.