#
Learn & Build RSS

## Dealing with Horrible Data in Excel

How to deal with misaligned data full of empty rows and columns in Excel

## Calculate Moving Average of Last 5 Rows in Excel

Video shows you how to calculate the moving average of last five numbers in an Excel column

## Chart Trick in Excel

Applicable if your x-axis is numbers

## Insert Hyperlinks in Excel

How to add hyperlinks to urls and files in Excel

## Parse or Extract Text Components out of Strings in Excel

Separate individual text entities into separate cells

## Look Up Next Bigger Value in Excel

How to get Excel to deliver the next bigger value of a certain input

## HTML Tutorial Part 1

First instalment of HTML Tutorials

## Repeat Titles in Each Page in Excel

Have your table titles appear on each page you print

## Fix Columns and Rows in Excel

Keeping in big tables the headers and left rows always visible

## Motor Selection in Excel

Build an engine selection application in Excel

## Hide Zero Values in Spreadsheets

Video shows how to render your tables more readable by hiding zero and even negative values

## Sorting in Spreadsheets

How to sort data in applications such as Excel and what to look out for

## Shopping List using Vlookups

Tutorial shows the main two ways of using Vlookups

## Multilingual Spreadsheets

Create spreadsheets able to depict data labels in multiple languages

## Time in Spreadsheets

How to master time calculations in spreadsheets

## Avoid using constants in your spreadsheet calculations

Always use cell references, as these can be easily updated

## Learn the difference between RAM and a computer's hard disk

Video uses a kitchen analogy to easily explain the concepts involved

## Calculate a Person's age in Excel, Openoffice or Libreoffice

Use built-in functions to calculate the age solely from a person's birth date