Microsoft Excel Guides

Google Sheet guides

Productivity resources

How to search for special characters in Excel

This dataset contains information about individuals’ IDs, names, occupations, and salaries. It includes names with special characters from various languages and scripts, such as diacritics, non-Latin characters, and symbols, adding […]

How to run a script in Google Sheets

In this tutorial, we will explore how to create a line chart using app script code for a dataset that includes sales data for three products: Product A, Product B, […]

How to round to the nearest dollar in Excel

Rounding off dollars ensures that the figures are accurate and don’t contain decimals that can cause discrepancies in financial calculations. Rounding off dollars can help to maintain consistency in financial […]

How to save a file if you want it to be compatible with older versions of Microsoft Excel

Suppose we encounter a situation where we need to distribute an Excel file to an individual who is using an earlier version of Excel. Our objective is to save the […]

How to calculate Wednesdays in 2015

The provided dataset presents the meeting schedule for the ABC Chain of companies throughout the year 2015. The dataset includes information about the various departments within the company, their corresponding […]

How do I get my toolbar back in Excel?

In this tutorial, we will explore a scenario where we encounter a missing toolbar while working on an Excel file. We will discover how to restore the toolbar and regain […]

How to zoom in on a graph in Excel

Zooming in a graph refers to the act of increasing the magnification or scaling of the graph to focus on a specific region of interest. It allows you to enlarge […]

How to X out a cell in Google Sheets.

Google Sheets is a robust spreadsheet application that gives users the ability to easily organize, analyze, and manipulate data. There are workarounds to get the required result even though Google […]

How to write ratios in Excel.

We will use a sample data set with two columns, Column A and Column B, to demonstrate ratio calculations. The values in Column B correspond to the denominator, while those […]

How to Unformat Cells in Excel.

Let’s consider a sample data set containing sales data for various products in various regions for the sake of this demonstration. Columns like Product Name, Region, Units Sold, and Total […]

How to undo text to columns in Excel.

Microsoft Excel is an effective spreadsheet program that enables users to efficiently organize, analyze, and manipulate data. The Text to Columns function, which divides cell contents into multiple columns based […]

How to turn off extended selection in Excel

In today’s tutorial, we will explore a useful technique for enhancing navigation across a worksheet. We’ll learn how to check whether the extended selection feature is enabled and, if so, […]

How to turn off data validation in Excel.

This step-by-step tutorial will show you how to disable data validation in Excel. Here, we have a sample data set. It consists of columns such as Product ID, Product Name, […]

How to turn data into a table form in Excel.

Let’s use a data set that details a company’s sales for the purposes of this demonstration. The information is broken down into columns for “Product Name,” “Price,” “Quantity Sold,” and […]

How to sum unique values in Excel.

Suppose you have an Excel sheet containing the following column: Product, and Sales Amount. In this tutorial, we will explore various methods to sum unique values in Excel and demonstrate […]
1 … 5 6 7 8 9 … 98