How to Use Excel Text Function
Use Excel TEXT function to convert any data (e.g., numbers, dates, etc.) into text, in a user-specified format.
Raj Kumar
How to Use CONCATENATE/CONCAT in Excel
This Excel tutorial explains how to use the CONCAT function and '&' operator to combine strings with syntax and examples.
How to Create Gantt Chart in Excel
Excel does not offer Gantt as a chart type, but with the help of this tutorial, you can easily create a Gantt chart from Bar chart.
How to Insert Check Mark (Tick) in Excel
You can easily insert a check mark in Excel using keyboard shortcuts, symbol dialog box, CHAR function, and Autocorrect.
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.
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.
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.