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.
Microsoft Excel
learn Microsoft Excel formulas, functions, tips and tricks.
Spellnumber VBA Code for Qatari Riyal and Dirham
Get the VBA code required for converting the numeric value of Qatari Riyal and Dirhams to spelling in Microsoft Excel.
VBA Code for Converting Numeric Indian Rupees and Paise to Words
Get the VBA code required to create spellnumber function for Indian Rupees and Paise.
How to Calculate Percentage of Total Sales in Excel
Learn How to Calculate the Percentage of Total Sales in Microsoft Excel.
Spellnumber Code for Omani Riyal and Baisa | Convert Omani Riyal to Spelling in Excel
Learn how to convert Omani Riyal and Baisa to Spelling format in Microsoft Excel and get the VBA code.
How to Make Search Bar in Excel for All Column Search
Learn how to make advanced search bar in Excel. By using this search bar, you can find out the information across every column.
How to Get Detailed List of Files from a Folder in PC
Learn how to get the details of files from a folder in PC to an Excel sheet.
How to Freeze Top Row or Any Other N Number of Rows in Excel
Learn how to freeze the top row or any other number of rows in Excel.
How to SUM Numbers by Cell Background Color in Excel
Learn how to calculate the SUM of numbers based on cell background color in Excel.
Automatically Extract Entire Row Data to New Sheet When Clicked in Excel
Learn how to auto extract the entire row data to a new sheet based on cell click event.
Excel Practice Workbook Downloads and Video Tutorials – Spreadsheet Power
Download the practice workbooks to learn Microsoft Excel.
Find Out Which Numbers Add Up to a Total in Excel
Find out which numbers adds up to a specific total in Microsoft Excel. We will use here two methods, solver and VBA.
How to Use IF Function in Excel
Learn how to use the IF function in Excel. This is a logical function to test condition and do calculation based on TRUE and FALSE results.
How to Make Drop Down Menu in Excel
Learn the step-by-step process of creating a drop-down list menu in Excel. This is used to pick up a value to be entered in a cell from a list.
How to Calculate CAGR in Microsoft Excel
Learn how to calculate the CAGR (Compound Annual Growth Rate) in Microsoft Excel.