How to Copy a Formula in Excel
Learn how to copy formula to multiple cells, down a column, to non-adjacent cells, copy formulas with absolute or mixed cell references, and more.
Microsoft Excel
How to Convert Time to Decimal in Excel
Convert time to decimal in Excel - by using arithmetic calculations or CONVERT function or Excel Time functions (HOUR, MINUTE, and SECOND).
How to Convert Text to Date in Excel
There are many ways to convert dates formatted as text into actual dates in Excel and this tutorial aims to explore them all.
How to Convert Text to Number in Excel
There are five different ways you can convert numbers that are formatted as text into actual numbers in Excel.
How to Create Gauge Chart in Excel
Since Excel doesn’t offer built-in support for Gauge Chart/Speedometer, you need to create one by combining a doughnut chart and a pie chart.
How to Use COUNTIF in Excel
Excel COUNTIF function allows you to count the number of cells that meet specific criteria or conditions in the given range.
How to Get Today's Date in Excel
Use TODAY and NOW function to get dynamic current date and time, and use keyboard shortcuts to get static date and time.
How to Use 'Not Equal To' in Excel
In Excel, the ‘not equal to’ operator checks if two values are not equal to each other. It can also be combined with conditional functions to automate data calculations.
How to Create a CAGR Formula in Excel
Learn how you can calculate Compound Annual Growth Rate (CAGR) in Excel using operators or different Excel functions.
How to Double Space on Google Docs
You can easily add 'Double Spaces' to any document on Google Docs using the 'Line spacing' tool. Here's a quick guide to using it.
How to Extract Substring in Excel
Using the Excel TEXT functions LEFT, RIGHT, and MID, you can extract a substring from the left, right, or middle of a text string.
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.
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.