How to Create Pivot Table in Excel
Excel's Pivot table is one of the most powerful tools that can help you summarize and analyze large datasets in an efficient manner.
Raj Kumar
306 posts
How to Convert Kg to Lbs in Excel
This tutorial will demonstrate how to convert values given in kilograms (Kg) to pounds (Lbs) or vice versa in Excel.
How to Use Conditional Formatting to Highlight Information in Excel
Conditional formatting allows you to highlight important data and apply specific formatting to cells that meet certain criteria.
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.
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 Use Linux Terminal in Windows 10
You can now access most of the Linux command-line utilities and applications on top of Windows 10 OS using Windows Subsystem for Linux (WSL).
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.