Microsoft Excel

By default, Excel disables all macros to protect you from malicious viruses. But you can enable macros to automate repetitive tasks 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…

Learn how to transpose data in Excel and quickly shift the orientation of your columns and rows on a worksheet.

With VAR.S and VAR.P functions you can calculate sample variance and population variance from given data in Excel 2010 and later versions.

Learn how to use Excel’s AutoFit feature to automatically adjusts the column width or row height in a worksheet.

Learn everything about creating and formatting a Pie chart in Excel.

Learn how to split cells in Excel into multiple columns using Text to Columns feature, Flash Fill, or Excel formulas.

You can easily create a histogram using the Data Analysis ToolPak or the built-in histogram chart in Excel.

Learn how to unhide specific rows, all rows, specific columns, and all columns in Excel to reveal all the hidden data.

You can easily sort your Excel data by text, numbers, date and time, or by cell and font color on one or more columns…