Understanding Conditional Formatting in Excel
Learn what is Conditional Formatting in Excel and how to use it. This is very useful and must learn tool in Microsoft Excel.
Microsoft Excel
learn Microsoft Excel formulas, functions, tips and tricks.
Use VLOOKUP and COLUMNS Function together in Excel
Learn the combination of VLOOKUP and COLUMNS function to get data from one workbook to another.
Auto Highlight Row Based on Value in a Cell of Column in Excel
Learn how to automatically highlight the row based on value in a cell of a column in Microsoft Excel.
Sales Target vs Achievement and Growth Over Last Year (%) Calculation in Excel
Learn how to calculate Sales Target vs Achievement % and Growth % over last year in Microsoft Excel.
Excel Calendar Template 2025
Download Excel calendar template 2025. This is very useful for organizing events and scheduling the things.
SWITCH Function in Excel: A Detailed Guide
Learn how to use the SWITCH Function in Excel. This is very powerful function which can be used as an alternative to IFS or Nested IF.
RANDBETWEEN Function in Excel
Learn how to use the RANDBETWEEN function in Excel. It is a powerful function which has great application in different field.
Spellnumber Function in Excel
Learn how to create and use Spell Number in Excel. This Converts the numeric values to word or spelling format.
TRUNC Function in Excel
Learn how to use TRUNC function in Excel to truncate numbers without rounding.
Rank Function in Excel
Learn how to use Rank Function in Excel. Also learn combination of Rank + Countif to ignore the tie values.
VBA Tutorial for Beginners
Learn Microsoft Visual Basic for Applications (VBA). This is the beginner’s tutorial, where you will learn the basics of VBA to start the journey of Excel automation.
Important Formulas for the Beginners in Learning MS Excel
In this article, you will learn 10 very useful Excel functions specially for the beginners in learning Excel.
Top 50 Most Useful Excel Shortcut Keys to Boost Your Productivity
Learn to use Top 50 most useful Keyboard Shortcut keys for Microsoft Excel. Using these will boost your productivity at work by saving lots of time.
How to Sort Data in Excel Using Custom List
Learn how to sort data in Excel using custom list. This allows you to sort or arrange data according to your specific criteria.
How to Display Numbers in Thousand(K), Million (M) or Billion(B) Format in Excel
How to display numbers in Thousand(K), Million(M) or Billion(B) format in MS Excel.