Microsoft Excel Guides

Google Sheet guides

Productivity resources

How to apply conditional formatting to multiple sheets in Microsoft Excel

Conditional formatting in Excel is a powerful tool that allows users to format cells based on specific criteria or conditions. This feature can highlight data that meet certain thresholds, such […]

How to add a range in Google Sheets

In Google Sheets, a range refers to a group of cells within a spreadsheet that is selected together. Adding a range allows you to perform various tasks, such as applying […]

How to add a plus sign in Microsoft Excel 

Adding a plus sign is a frequently performed task in Microsoft Excel. It is typically used to include country codes when noting employee contact numbers in many organizations. Additionally, the […]

How do you split cells in Google Sheets?

Splitting cells in Google Sheets is the process of separating the content of a single cell into multiple cells, based on a specified delimiter such as a comma or a […]

How to rotate text in Microsoft Excel

Rotating text in Excel refers to changing the orientation of text within a cell or a range of cells. This feature allows users to display the text vertically or at […]

How to get a date to automatically update in Microsoft Excel

Updating dates is an important tool in Excel. It is useful in many essential tasks i.e for tracking important events and deadlines, performing date-based calculations, and creating dynamic charts that […]

How to upload an Excel file to Google Drive 

Uploading an Excel file to Google Drive means that you are storing a copy of the file on Google’s servers so that it can be accessed and managed through your […]

How to unprotect cells in Google Sheets

Unprotecting a cell in Google Sheets refers to removing the protection that prevents users from editing or modifying certain cells within a spreadsheet. Unprotecting cells can be useful when creating […]

How to turn off the scientific notation in Microsoft Excel

Scientific notation is a way to represent very large or very small numbers in Excel. In Excel, scientific notation is denoted by using the letter “E” to represent “x10^”. Excel […]

How to swap columns in Google Sheets

Swapping columns in Excel means changing the position of two columns in a worksheet. This feature is helpful in many ways. It can improve data analysis by making it easier […]

How to sum highlighted cells in Microsoft Excel

“Sum highlighted cells” usually refers to the process of adding up the values of cells that have been visually selected or highlighted in a spreadsheet or table. This is a […]

How to set the default font in Google Sheets

In this tutorial, we will learn how to set the default font in Google Sheets. In Google Sheets, you can set a default font that will be automatically applied to […]

How to separate city and state in Microsoft Excel

Separating city and state in Excel refers to the process of separating the city and state information that is combined in a single cell into two separate cells. This can […]

How to Select two columns in Microsoft Excel that are not next to each other

Selecting two cells that are not next to each other means choosing two cells in Excel that are not adjacent or located next to each other. This functionality is helpful […]

How to select specific cells in the Microsoft Excel formula

Selecting specific cells in an Excel formula means you are specifying which cells or ranges of cells you want to include in your formula calculation. This means that you can […]
1 … 22 23 24 25 26 … 98