How to Search in All Sheets in Google Sheets
This tutorial demonstrates how to search for specific words and phrases across all sheets in Google Sheets using Find and Replace tool.
Raj Kumar
306 posts
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.
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 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.