How to Transpose in Excel
Learn how to transpose data in Excel and quickly shift the orientation of your columns and rows on a worksheet.
Microsoft Excel
109 posts
How to Calculate Variance in Excel
With VAR.S and VAR.P functions you can calculate sample variance and population variance from given data in Excel 2010 and later versions.
How to Autofit in Excel
Learn how to use Excel’s AutoFit feature to automatically adjusts the column width or row height in a worksheet.
How to Make a Pie Chart in Excel
Learn everything about creating and formatting a Pie chart in Excel.
How to Split Cells in Excel
Learn how to split cells in Excel into multiple columns using Text to Columns feature, Flash Fill, or Excel formulas.
How to Make a Histogram in Excel
You can easily create a histogram using the Data Analysis ToolPak or the built-in histogram chart in Excel.
How to Unhide Rows and Columns in Excel
Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.
How to Sort in Excel
You can easily sort your Excel data by text, numbers, date and time, or by cell and font color on one or more columns as well as rows.
How to Remove Password from an Excel Spreadsheet
Forgot password for your excel sheet? No problem, here's an easy trick to remove the password protection from your excel sheet.
How to Divide in Excel
In Excel, you can divide in a cell, cells, columns of cells, a range of cells by a constant number, and by using the QUOTIENT function.
How to Wrap Text in Excel
Microsoft Excel’s Wrap Text feature can wrap text so it appears on multiple lines in a cell, even if it overflows the cell boundary.
How to Create a Drop Down List in Excel
Create a drop-down list of items in Excel to make data entry easier, faster and error free. With Excel's Data Validation feature, you can easily create drop down lists to enter data on a worksheet or workbook.
How to Freeze Panes in Excel
Ensure certain cells remain visible as you scroll through the data in an Excel sheet by freezing either the top row or the first column or multiple rows and columns together.
How to Remove Duplicates in Excel
Find and remove duplicate data in your Excel sheet using these simple steps.
How to Lock Cells in Excel
Learn how to protect cells in Excel files, so people can't change certain cells or data.