How to Save Google Slides as PDF

Sometimes you may want to save your Google Slides presentation in PDF format. It can be useful for sending it by email, having it as a backup, publishing it on a website, or for some other reason. This tutorial shows you how to save Google Slides as a PDF document.

3 Methods of saving Google Slides as a PDF

  • Download option on the File tab
  • Email option on the File tab
  • Print settings and preview option on the File tab

Note: All the methods will remove all transitions, animations, and comments. They will also replace videos with images or frames hyperlinked to the video files.

Let us begin.

Read more

How to Change Bullet Colors in Slides

We use bullets in Google Slides to organize our ideas. We can change the color of the bullets to increase their visibility. This makes the presentation more readable. This tutorial explains how to change bullet colors in Google Slides.

2 Methods of changing bullet colors in Google Slides:

  • Change the theme
  • Use the Text Color tool

Let us begin.

Read more

How to Create an Index in MS Word

Many books contain an index at the end. This helps in easily locating words, keywords, and phrases in the book. MS Word offers a simple method of adding an index in a document. 

In this tutorial, we will show you how to:

  • Select References for an Index Entry
  • Insert the Index
  • Update the Index

We will use simple, step-by-step instructions for creating an index in MS Word.

Let us begin.

Read more

How to Switch Columns in MS Excel

You may need to switch columns in your MS Excel spreadsheet to re-organize the data. Let us walk you through the methods to swap columns without disturbing your data.

3 Methods of switching columns in Microsoft Excel

  • Cut and Paste Option
  • Drag and Drop Option
  • Duplicate a Column before Swapping

So let’s get started.

Read more

How to Make a Signup Sheet in MS Word

The best way to get information about attending visitors or guests at an event, is to use a signup sheet in MS Word. 

Signees can provide information on a signup sheet so that you have an accurate headcount. It also makes organization and planning easier.

See how to make a signup sheet in Microsoft Word with simple, step-by-step instructions.

Let us begin.

Read more

How to Remove a Dropdown List in MS Excel

MS Excel’s dropdown lists are useful for creating quizzes, order forms, surveys, and more. A dropdown list makes data entry easy by making your spreadsheet dynamic. 

The list is a set of predefined values. It provides a simple way to choose from a list of choices. If you no longer need the dropdown list in your spreadsheet, you can remove it. There are several options to remove dropdown lists, which we will explain step by step.

3 Methods to remove a dropdown list in Microsoft Excel:

  • Using Data Validation Dialog Box
  • Using Clear All Button
  • Copy-Paste Option

Let us begin.

Read more

How to Make a Word Cloud in MS Excel

Word Cloud is a visual representation of keywords and tags used in a selection of text. You can use word clouds to show the prominence of some words over others. Typically, words used more often will be bigger than other words in the word cloud in MS Excel.

To create a word cloud you need to install Excel add-ons or use word cloud tools. There are many word cloud generators to choose from. You can choose from free or premium versions. 

Each word cloud generator has its own unique design and customization options. Some of the known word cloud generators are:

  • TagCrowd,
  • MonkeyLearn Word Cloud generator,
  • WordClouds.com
  • Bjorn’s Word Clouds, and more.

In this tutorial, we will use WordClouds.com to generate the word cloud from an Excel file. It is free to use. It offers a variety of themes, formatting options, colors, fonts, sizes, and custom shapes to create impressive word art. 

You can manually edit your word list. Another interesting feature is that you can analyze web pages, by pasting a URL into the source field. Doing so helps you identify the keywords used by your competitors. 

Read more

How to Remove All Hyperlinks in MS Excel

MS Excel inserts a hyperlink when you enter an email address, file location, or website address in a cell. Sometimes these hyperlinks are helpful and sometimes not. Microsoft Excel provides various methods to remove unwanted hyperlinks. We will explain how you can remove all the hyperlinks or groups of hyperlinks.

4 Methods to remove hyperlinks in Microsoft Excel

  • Menu Options 
  • Turn Off Automatic Hyperlink Conversion 
  • Clear Option
  • Select One or More Cells to Remove Hyperlinks

We will also explain how to edit existing hyperlinks.

Let us begin.

Read more

How to Create a Scatter Plot in MS Excel

A scatter plot in MS Excel is also known as an XY chart. A Scatter plot represents the relationship between two separate sets of numbers. 

The horizontal and vertical axis comprises numerical data only, but can also represent date values. The data in the left column appears on the X-axis and the data in the right column appears on the Y-axis. 

When to use a scatter plot:

  • With two sets of numerical data.
  • To determine the relation between the two variables.
  • To include date and hour values in your source data.
  • To show a non-linear pattern.

This tutorial will guide you through the steps to create and customize a scatter plot in Microsoft Excel.

Read more

How to Create a Line Chart in MS Excel

A line chart in MS Excel contains two or more individual data points connected by lines. The data points represent a series of information. It explains the relationship between the X-axis and the Y-axis on the graph. A line chart is ideal for describing the relationship between two entities. For example – Sales and Demand or Profit and Loss. 

Line charts are easy to read. It distributes the category data along a horizontal axis and the numerical value along the vertical axis. 

When to Use a Line Chart? 

The line chart is a simple chart. It is crucial to understand when to use it efficiently to display your data. Use a line chart when you want to:

  • Display trends in your data at regular intervals or over time. 
  • Your data has non-numeric values.
  • Use text to display values like months, quarters, or years.
  • Use numerical labels to display a time interval like years.
  • Display time scales like the number of days, months, and years. 

Read more