Home » Blog » Page 33
Microsoft Excel Guides
Google Sheet guides
Productivity resources
In today’s tutorial we’ll learn how to insert a header in Google Sheets. Google Sheets are different from Excel in that Google Sheets don’t have a visible header in any […]
In spreadsheet applications, it is a frequent practice to include new text in cells as a way of updating information without replacing the entire cell content. When dealing with text […]
In this tutorial we will learn how to add leading zeros in Microsoft Excel using the CONCATENATE function. Adding leading zeros to a number in Excel is a straightforward process. […]
In this tutorial we will learn how to add data in a Pivot Table in Microsoft Excel. It’s a straightforward process to include additional information in a pivot table. By […]
In this tutorial we will learn how to add Axis titles in Google Sheets. Adding descriptive and meaningful axis titles in Google Sheets is simple and can be done by […]
Adding a character to a text string in Microsoft Excel can be useful for formatting or manipulating data. Adding characters may be used as a delimiter for data that needs […]
Today, in this step-by-step tutorial, you will be learning how to change cell colors in Excel. Here, we have a data set above of a flower store showing sales of […]
In Microsoft Excel, wrap text is a feature that allows text within a cell to be displayed on multiple lines, rather than being restricted to a single line that is […]
In this tutorial we will learn how to separate by comma in excel. To comma Separate data we use the Text to Column function from the Data tab. By using […]
Google Sheets conditional formatting is a feature to automatically change the font properties of a specific cell, row, column, and even the background colour of the cell, based on rules […]
While we are working with dates in excel, often we have to add or subtract the dates from each other. Sometimes we want to calculate a specific date (past or […]
Autofill is a useful feature in Microsoft Excel that enables users to quickly and easily fill cells with a series of data. This feature is particularly useful for entering recurring […]
In Google Sheets, you can hide rows to temporarily remove them from view. This can be useful when working with large data sets, as it allows you to focus on […]
In this tutorial we will learn how to trace dependents to another tab in Microsoft Excel. Tracing dependents in Excel can also be used to track dependencies between cells in […]
Hyperlinks in Microsoft Excel are clickable objects that allow you to quickly navigate to another location within your worksheet, to another worksheet within the same workbook, or to an external […]
