Do print settings for multiple worksheets in one go

At times there is a need to do print settings for multiple worksheets in one go. It is time consuming to do it manually for each sheet. There is a trick to do it at once for all the sheets… Read More ›

Recent Posts

  • Excel Dashboard Training

    Excel Dashboard Training

    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 ›

  • Advanced MS Excel Training

    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 ›

  • Last Working Day of the Month

    Tips & Tricks

    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 ›

  • Case-Insensitive Match

    Tips & Tricks

    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 ›

  • Excel Mid Formula

    Mid Function

    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 ›

  • Excel Left Formula

    Left Function

    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 ›

  • Excel Right Formula

    Right Function

    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 ›

  • Excel Exact Formula

    Exact Function

    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 ›

  • Excel Hlookup Formula

    Hlookup Function

    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 ›

  • Excel Vlookup Formula

    Vlookup Function

    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 ›