Excel Blog - Latest Excel tips, tutorials, and videos.

0 How to Calculate Square Root in Excel (Using Easy Formulas)

Append square root symbol to a value using ampersand

It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is to calculate the square root in Excel. And as I said, there are multiple ways you can do that in Excel (formulas, […]

0 Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds)

Convert Time to Decimal using the CONVERT function

By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one […]

0 How to Remove Time from Date/Timestamp in Excel (4 Easy Ways)

Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, there are also ways to edit and modify these. One common thing many people need to do often in […]

0 How to Assign a Macro to a Button in Excel (Easy Guide)

While there are many different ways to run a macro in Excel, none of those methods can be as easy and user-friendly as clicking on a button. And for that to work, you need to assign a macro to a button first. In this tutorial, I will show you a couple of ways to insert […]

5 How to Remove the First Character from a String in Excel (Quick & Easy)

Manually Enter the second value in the second adjacent cell

Working with text data would often require slicing and dicing it. And one such common thing people often have to do is to remove the first characters from a string in Excel. Suppose you have a dataset as shown below (in column A) and you want to remove only the first characters from each cell […]

0 How to Reference Another Sheet or Workbook in Excel (with Examples)

Create a new named range by specifying the name

To be able to reference cells and ranges is what makes any spreadsheet tool work. And Excel is the best and most powerful one out there. In this tutorial, I will cover all that you need to know about how to reference cells and ranges in Excel. Apart from the basic referencing on the same […]

0 Split Each Excel Sheet Into Separate Files (Step-by-Step)

Files after each sheet is split into separate file

Watch Video – How to Split Each Excel Sheet Into Separate Files If you have an Excel workbook with many worksheets, there is no easy way to split each of these sheets into separate Excel files and save separately. This could be needed when you sheets for different months or regions or products/clients and you […]

1 2 3 … 54 Next »