How to Create Labels in Word from an Excel List

You can use Microsoft Excel to organize a mailing list. You can then mail merge this list using Word to generate and print mailing labels. We recommend using Excel to make the list, as it has better organizing capabilities and can better maintain data than a Word table can.

To make the list in Excel, you must create column headers. Place the headers in the first row of each column. Insert data in the list according to the header in each column.

We will show you in simple, easy steps how to create mailing labels in Word from an Excel list.

Let us begin.

Read more

How to Make a Grid in Word

Microsoft Word is not limited to text-based documents alone. It is also possible to set up a grid in Word. You may want a grid paper for a complex mathematical chart. Grid papers are also great for bulleted journals for personal planning. The best thing is, you do not need complicated training for creating grids. 

5 ways of making grids in Word using simple, easy stepwise instructions:

  • Using Grid Lines
  • Using Fill Effects
  • Using Lines
  • Using Rectangles
  • Using Tables

Let us begin.

Read more

How to Add Borders to Slides in PowerPoint

You may be looking for a way to enhance your PowerPoint slides. One would be adding an eye-catching border to make your slide look refined and spectacular.

Borders also make your slides look more organized. While thin borders give the slide a design appeal, broad or pictorial borders will emphasize its definition.

There are two ways you can add borders to slides:

  • Using shapes
  • Using online pictures

We will show you both methods using simple, step-wise instructions.

Let us begin.

Read more

How to Add Alt Text to an Object in MS PowerPoint

A sight-impaired person needs a screen reader to read out a description of the objects on the computer screen. If your MS PowerPoint slide has an object, you can add alternative text or alt text to it. This helps the screen reader, as they are not sophisticated enough to understand what the object represents.

When adding alt text, you can do it in two ways:

  • Automatically generate the alt text
  • Manually generate the alt text

We will show you in simple, step-by-step instructions how to add alt text to an image in Microsoft PowerPoint.

Let us begin.

Read more

How to Create a Pie Chart in MS Excel

A pie chart illustrates the distribution of your data in the form of a slice in a circle. Each slice represents a percentage of the whole. It means the data in the chart will always add up to 100%. Pie charts use one data series, and display the contribution of each value to a total. 

When to Use a Pie Chart in Microsoft Excel

  • When the data comprises distinctive parts
  • To compare categories
  • To represent percentages at a set point in time
  • To show how 100% divided up into a few shares

You cannot plot a pie chart with continuous data. For example, you cannot plot a pie chart for age, height, and body weight. 

In this pie chart tutorial, you will learn how to make a pie chart in Microsoft Excel. You will also learn to customize the chart, explode or rotate a pie chart, and much more.

So let us get started.

Read more

How to Create a Bar Graph in MS Excel

A bar graph is a visual representation of data using vertical and horizontal bars in a graph. It helps compare data values. You can compare various data sets, survey results, variables, and values. You can also compare the number of trades executed in a day and more. 

Bar graphs show the relationship of the data using the Y-axis (values) and the X-axis (categories). Bar graphs are a commonly used method of data representation by various industries.

When to Use a Bar Graph?

  • To present small data sets 
  • You want to compare different variables and values
  • To display survey results
  • To compare various sets of data
  • To show categories and sub-categories
  • When you have large text labels

In this tutorial, you will learn how to make, sort and customize a bar graph in MS Excel. 

Read more

How to Create a Word Cloud in Google Slides

A word cloud allows you to visualize a grouping of frequently used words within a body of text. You can then detect the major themes within the text. Google Slides does not have a built-in option for creating word clouds. This tutorial shows you how to create a word cloud in Google Slides using an online word cloud generator.

2 Steps to creating a word cloud in Google Slides

  • Generate a word cloud online
  • Insert the word cloud image into a Google Slide

Let us begin.

Read more

How to Change the Bullet Color in MS PowerPoint

You may need to present your points in the form of bullets in your slide. But unless the bullets are in contrast with the background, they may not be visible. To increase the contrast, it may be necessary to change their color. 

Fortunately, changing the color of bullets is a simple task in Microsoft PowerPoint. You can have:

  • Bullets of different colors
  • All bullets of the same color

We will show you simple, step-by-step instructions on how you can change the color of bullets.

Let us begin.

Read more

How to Change Hyperlink Color in PowerPoint

Did you know it’s possible to change hyperlink colors in your PowerPoint presentation? You may want the hyperlink color to match the theme or your slide design. Or, to increase the contrast to improve the visibility.

We will show in simple, step-by-step instructions how to change the hyperlink color in a PowerPoint presentation. 

Two Methods to change hyperlink color in Powerpoint

  • Change individual hyperlink color.
  • Change the color of hyperlink text throughout the presentation.

Let us begin.

Read more

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