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.
Microsoft Excel
109 posts
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 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.