### Author's posts

If you are working on a workbook containing confidential data, you need to anonymise your data if you are collaborating with other people. The technique is not really complex but you have to respect the following steps. The initial document Imagine you are a journalist and you receive the following file in your mailbox (it’s all …

## Date Format in Excel

What is a date in Excel? In Excel, you can display the same date in many different ways just by changing the date format. Dates are whole numbers Usually when you insert a date in a cell it is displayed in the format dd/mm/yyyy. Now if you change the cell’s format to Standard, the cell …

## Move and Copy worksheets quickly

In Excel, there are a lot of tips and tricks to move or copy a worksheet. Here are some examples: Move sheets in a workbook To move a worksheet within a workbook, you just have to: Click on the tab of the worksheet you want to move Hold and drag your mouse Release the mouse button …

## Inspect a Formula with F9

In Excel, you can scan part of your formula with the shortcut F9 When use the F9 shortcut? Let’s say you have a complex formula with a lots of VLOOKUP, INDEX, MATCH, references. But the result returned is not correct and you need to find the reason. Tips: To display your formula on multiple rows, …

## Convert Latitude and Longitude

Nowadays, GPS localization is common. Some apps use decimal format (48.85833) while others return the coordinates in degrees, minutes and seconds (48°51’29.99”). In this article I will show you how to convert from one format to the other and vice-versa. Add GPS coordinates to address If you are looking to add GPS coordinates to an address, please …

## Keep your Last Updated Data

Keep the last updated row Let’s start from a file storing customer information. Some customers have multiple records in the file, as a new record was created each time they changed their address or phone number. How do you keep only the last updated row? Remove duplicates not applicable With a such file, you can’t …

## What is a Logical Test in Excel

When should you create a logical test? Creating a logical test is THE starting point for these 3 important functions in Excel: IF COUNTIFS SUMIFS What it a logical test Logical tests are everywhere. Is my salary higher than my colleague’s? Is my rent higher than my neighbour’s? Is the quantity in stock larger now …

## The Correct Value for a Week Number

The function WEEKNUM In Excel, to return the week number of a date you have the function WEEKNUM. =WEEKNUM(Date) Easy ? Sure ? 🙄🤔 Well in fact, it’s not so simple. It depends if you are in USA or in another country. The rule of calculation for the week is different between the USA and the …