How to Enable Macros in Excel
By default, Excel disables all macros to protect you from malicious viruses. But you can enable macros to automate repetitive tasks in Excel.
Microsoft Excel
How to Use VLOOKUP in Excel
VLOOKUP function in Excel looks for a value in a range of cells, then it returns a value that’s in the same row as the value you’re looking for.
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.
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.
How to Multiply in Excel
Create a formula for multiplying cells, ranges, or entire columns. Multiply in Excel by using the multiplication symbol (*) or the PRODUCT function.
How to Subtract in Excel
Easily subtract data in0between cells, columns, and rows in Excel using the '-' and '=' operators in various formulas.
How to Make a Graph in Excel
Organize a spreadsheet full of data into a chart/graph in Excel and improve your visuals and reporting using the instructions on this page.
How to Merge and Combine Cells in Excel
This tutorial explains various methods of merging/combining two or more cells in Excel. It also demonstrates different techniques to combine data from multiple cells without losing data using the Ampersand (&) operator or the CONCAT function.