View our latest articles

How to Convert a PDF to Word (From Canva)

Written by John Gleave in Word Training Videos Last Updated December 4, 2023

In this Microsoft Word training video, we’ll show you how to Convert a PDF to a Word document. To demonstrate, we’ll be downloading a PDF template from Canva, and editing the it within Microsoft Word. We’ll also show you how to save the document as a JPG or PNG when you’ve finished working on it.

What is a PDF file?

A PDF (Portable Document Format) file is a file format developed by Adobe that preserves the original formatting, fonts, images, and layout of a document, regardless of the software or hardware used to view or print it. PDF files are widely used for sharing documents over the internet and for printing documents that need to be reproduced accurately.

Key features of PDF files include:

  1. Platform Independence
    PDFs can be viewed on any device or operating system, maintaining consistent formatting.
  2. Security
    PDFs can be password-protected or encrypted to control access to sensitive information.
  3. Compression
    PDFs can compress text and images, reducing file size without significant loss of quality.
  4. Interactive Elements
    PDFs can contain hyperlinks, forms, multimedia elements, and other interactive features.
  5. Printability
    PDFs are designed for high-quality printing, ensuring that a document looks the same on paper as it does on a screen.

To view and create PDF files, various software tools and applications are available, ranging from Adobe Acrobat (the official software from Adobe) to free alternatives like Adobe Reader, Foxit Reader, and others. Many word processors and document creation tools also support exporting documents to the PDF format.

Resources

Canva:
https://canva.com

Photopea:
https://photopea.com

Bing Image:
https://bing.com/create

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

Written by John Gleave in Word Training Videos Last Updated November 23, 2023


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)

Written by John Gleave in Teams Training Videos Last Updated November 23, 2023

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

Written by John Gleave in Word Training Videos Last Updated November 23, 2023

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

Written by John Gleave in Excel Training Videos Last Updated November 22, 2023

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

Written by John Gleave in Word Training Videos Last Updated November 22, 2023

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/