Excel VBA

What is Excel VBA?

VBA in Excel stands for Visual Basic for Applications. The programming language can be used to create useful Excel tools to automate recurring tasks. Excel’s VBA programming is one of the easiest ways to exchange Excel data with other Office applications such as Word or PowerPoint. Learn all the basics in our VBA tutorial.

Creating macros in Word

Word Macros: How to Create Macros in Word

Anyone who writes on a computer will regularly use Word, the word processing program from the software giant Microsoft. To simplify working with this Office application, operating steps and program commands can be automated by creating and executing “Word macros”. Read on to find out everything you need to know about macros in Word.

Word: Footnotes and Endnotes

Inserting footnotes and endnotes in Word

When you insert footnotes and endnotes in Microsoft Word, you’re able to provide supplemental context by explaining technical terms, commenting on paragraphs or adding citations to sources. These comments don’t disrupt the flow of the text because they are separate sections within a document. At the same time, they allow the reader to look up a respective passage where necessary. We’ll show you...

PowerPoint Speaker Notes

PowerPoint speaker notes: this is how you use the practical help feature

A PowerPoint presentation provides visual support for your talk or presentation. In order to avoid stumbles during a presentation, the application comes with an excellent support tool: PowerPoint speaker notes. These are not visible to listeners and assist you during the presentation. We explain how you can insert, display, and hide PowerPoint speaker notes and apply all the necessary settings to...

Histogram in Excel

Make a histogram with Excel

A histogram represents the frequency of measured data, making this chart an important tool for statistics. With a bar chart, it’s easy to read which areas are high-frequency and which ones aren’t. There’s no need use extra software to create a pictorial representation like this, because a histogram can be made using Excel.

Percentage formula in Excel

Using the percentage formula in Excel

Want to know how to calculate percentages in Excel? With the most important formulas for calculating percentages in Excel, the process is a cinch. In this article, you’ll learn how to calculate percentages of totals and growth rates, and how to figure out proportions and totals based on percentages. We’ll also give you tips on increasing and decreasing numbers by percentages.

Google Sheets keyboard shortcuts

Google Sheets – keyboard shortcuts at a glance

Google Sheets has a wide range of practical keyboard shortcuts that allow you to create and edit your spreadsheets more efficiently. In this article, we’ve put together an overview of the most useful keyboard shortcuts for Google Sheets. In addition, we show you how to access a list of all keyboard shortcuts and enable compatible shortcuts.

How to make a PowerPoint into a video

How to make a PowerPoint into a video – step-by-step instructions

Creating a PowerPoint video is anything but complicated. A finished PowerPoint presentation can be turned into a video in just a few steps and then be uploaded, and shared as a video on social media such as Facebook or YouTube. This guide will show you how to quickly and easily design and export a PowerPoint to video.

Word: Create a Table in Word

Word table: Creating a table in Microsoft Word

In Word, tables prove useful in the most diverse situations, and you have several options for creating them. You can either use the table templates provided by the Microsoft tool, or you can design your own. This enables you to improve your reports, invoices or the performance of household tasks. Even data from Excel can be integrated as a table into a Word file.

Google Sheets – VLOOKUP

Effectively work in Google Sheets with the VLOOKUP formula

VLOOKUP in Google Sheets is a practical formula for quickly finding corresponding values for a search query. Google Sheets automatically searches for the value of a search key in a column. Users can define which columns should be systematically searched from top to bottom. The VLOOKUP formula in Google Sheets saves a huge amount of time.


Wait! We’ve got something for you!
Get your .co.uk domain for just £1/1st year.

Enter the web address of your choice in the search bar to check its availability.
12 months for £1
then £10/year