Recent Posts

Learn Microsoft Excel Dashboard with Advanced Formulas and Macros: Excel Dashboard Training is very useful program for those who want to learn or improve their knowledge on Excel Dashboard. Participants will learn how to present and analyze their data using… Read More ›

MS Excel Training for Corporate Professionals: In this competitive world, good knowledge of Microsoft Excel can help you to grow faster. Our Program – MS Excel Training for Corporate Professionals is a must do program for all who work in… Read More ›

Excel Formula to calculate Last Working Day of the Month: It is simple in Excel to calculate Last Day of the Month with the help of EOMONTH Formula. However, it is slightly tricky to figure out Last WORKING Day of… Read More ›

Excel Exact Formula is Case-Sensitive. Learn how to do Case-Insensitive Match. Exact Function is one of the Case-Sensitive Formulas in Excel. In this Post we will see how we can do case-Insensitive match between two text strings. Case-Insensitive Match is… Read More ›

Learn How to use Excel Mid Formula: As name depicts, Mid Function is used to extract the characters from middle of the formula. Excel Mid Formula extracts the specified number of characters from specified position. Mid Function Syntax: Mid(text, start_num,… Read More ›

Learn How to use Excel Left Formula: Excel Left Formula extracts the specified number of characters from the left hand side of a cell. It is used to remove unwanted characters from Right Side of a cell. Left Function Syntax:… Read More ›

Learn How to use Excel Right Formula: Excel Right Formula extracts the specified number of characters from right hand side of a cell. In other words, it extract data from the the end of a text string. It is used… Read More ›

Learn How to use Excel Exact Formula: Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences. Exact Function works with Text… Read More ›

Learn How to use Excel Hlookup Formula: In Excel HLOOKUP formula, H stands for Horizontal and LOOKUP means lookup. Hlookup is used to lookup values in a data table where lookup_value resides. Lets see Hlookup syntax and an example to… Read More ›

Learn How to use Excel Vlookup Formula: In Excel VLOOKUP formula, V stands for Vertical and LOOKUP means lookup. Vlookup is used to lookup values in a data table where lookup_value resides. Lets see Vlookup syntax and an example to… Read More ›

Clients & Participants Testimonials

Read our participants Testimonials on MS Excel Training. Our Clients inspires us everyday that they have been benefited immensely from our Trainings and Workshops. Read on what corporates have got to say about us.