Apps 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.
Apps 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.
Apps 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.
Apps 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.
Apps 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.
Apps 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.
Apps 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.
Apps How to Make a Pie Chart in Excel Learn everything about creating and formatting a Pie chart in Excel.
Apps 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.
Apps 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.
Apps 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.
Apps 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.
