How to Use Function Wizard in Excel
Excel’s Insert Function provides the user with a list of all possible Excel functions and makes them easy to implement.
Microsoft Excel
102 posts
How to Use Track Changes in Excel
Use the Track Changes feature in Excel to know who made changes to the workbook, the changes they made, and whether or not to accept them.
How to Print Labels from Excel
If you want to print mailing labels from an address list that you maintain in an Excel spreadsheet, you can use Microsoft Word mail merge.
How to Create a Formula in Excel
In this article, you will learn how to write a formula in Excel using constant and operators, cell references, and pointing methods.
How to Use TRIM Function in Excel
You can remove the spaces on the left and right of the text and within the text of the text string using Excel’s TRIM function.
How to Make a Scatter Plot in Excel
Learn how to make a scatter chart in Excel to find the correlation between two variables, i.e. how one variable is affected by the other.
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.
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.