View our latest articles

How to Delete a Page in the Middle of a Word Document


If you find yourself needing to remove a page within your Word document, fear not, as we’ll be showing you all the ways to delete a page in this training video. Whether it’s through straightforward deletion commands, adjusting page breaks, or utilizing the navigation pane, our comprehensive guide ensures a hassle-free experience, empowering you to maintain the flow of your document.

How to Always Stay Available in Microsoft Teams (New)

In Classic Teams, you can keep yourself active and available using mouse simulators, such as Move Mouse. However, in the New Teams app, you can now set a duration for the “Available” status. In this Teams training video, we’ll show you how to enable the New Teams app, and how to keep yourself available for as long as you need.

However, if you want to learn how to stay active in Classic Teams, watch the video below: https://youtu.be/arRUA-kePyg

How to Change the Orientation of One Page in Microsoft Word

In this video, we’ll show you how to change the orientation (Portrait or Landscape) of one page in Microsoft Word. Please be aware that at the time of making this video, there is no similar functionality in the web version of Word, so you’ll need to use the desktop version on either a Mac or Windows device.

How to make a SEARCHABLE drop down list in Excel

In this Excel training video, we’ll take you through the process of constructing a searchable drop-down list in Microsoft Excel. Unlike conventional Excel drop-downs, this specialized feature works like a dynamic search bar, enabling you to swiftly locate specific worksheets within your workbook.

Navigating through numerous tabs at the bottom of your Excel interface can be cumbersome, and our tutorial addresses this challenge by introducing a streamlined solution that allows you to search for and link directly to the desired worksheet.

By the end of the video, you’ll not only have a newfound proficiency in implementing this advanced Excel feature but also a valuable tool to enhance your productivity, saving you time and effort when working with large and complex workbooks.

Resources

Steps to enable Developer in Excel (Windows):

  1. Go to “File” in the top left.
  2. Head down and click “More” then “Options.”
  3. Select “Customize Ribbon” in the left menu.
  4. Head to the Tabs list on the right and scroll down to “Developer.”
  5. Check the box next to “Developer.”
  6. Then hit “OK.”

Steps to enable Developer in Excel (Mac):

  1. Head to the top left of the screen and click “Excel.”
  2. Select “Preferences” from the dropdown.
  3. In Preferences, select “View.”
  4. In View, head down and check the box next to “Developer.”
  5. Finally, close the dialog box.

VBA code to grab all worksheets:

Sub Pages()
Dim ws As Worksheet
Dim wsList As Worksheet
Dim i As Integer

' Create a new worksheet to list sheet names
Set wsList = Worksheets.Add
wsList.Name = "SheetList"

' Set the starting row in the new worksheet
i = 1

' Loop through each worksheet and add its name to the list
For Each ws In Worksheets

wsList.Cells(i, 1).Value = ws.Name
i = i + 1

Next ws
End Sub

Formula to link search icon to worksheets:

=HYPERLINK("#'" & G2 & "'", "🔎")

How to make a Brochure in Microsoft Word

In this Word training video, we’ll guide you through the steps of making a trifold brochure in Microsoft Word. Our step-by-step demonstration focuses on using a template, which streamlines the process, and eliminates the need for excessive design skills. This guide is perfect for users of all experience levels, as our tutorial ensures that you can create a visually appealing and professionally formatted trifold brochure effortlessly.

Resources

If you’re looking for an even simpler way of making brochures, try Canva. Canva is an intuitive media creation tool with countless designs and templates for you to choose from:

https://www.canva.com/

How to add DOUBLE Spaces in Microsoft Word


In this Word training video we’ll show you how to add double spaces into your text in Microsoft Word. In this guide, you’ll learn how to add spaces to lines, paragraphs, words, and letters. Also, we’ll give you steps on how to do this in the Windows and Mac versions of Word.

Typography Terms

Line spacing

Line spacing refers to the spacing between lines, or the height of the space that separates lines of text.

Paragraph spacing

Paragraph spacing, like line spacing, refers to the space above and below the paragraph. But unlike line spacing, you can set different spacings for the top and bottom of a paragraph.

Word spacing

Word spacing refers to the space before and after a word. There isn’t a specific function to adjust the word spacing. However, you can create the effect by using find and replace to change single spaces to double spaces.

Kerning

Kerning refers to the spacing between letters.