Category: Beginner

Convert address to GPS coordinates

It is possible to add GPS coordinates to a list of addresses. Our company can do this job for you. Convert GPS to mailing address But we can also do the opposite – return the mailing address of GPS coordinates. And we can send you the result. Price The price to do this job depends …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-address-to-gps-coordinates/

Convert YYYYMMDD to DD/MM/YYYY

This article will explain how to convert date YYYYMMDD to DD/MM/YYYY. You can use one of two techniques: Convert with formulas With this technique, you must extract each part of a date with the text functions. So if you have a YYYYYMMDD format to transform, here are the steps to follow. Step 1: Extract the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-date-yyyymmdd-to-dd-mm-yyyy-without-formula/

Convert roman numerals with Excel

This article will show you how easy it is to convert numbers to roman numerals, or vice versa, with Excel. Roman numerals Roman numerals are represented by combinations of letters I = 1 V = 5 X = 10 L = 50 C = 100 D = 500 M = 1000 To create a number, you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/convert-roman-numerals-with-excel/

Extract text without a formula

FlashFill

In Excel 2013 and later, you can extract text without a formula using Flash Fill. What is Flash Fill? FlashFill is a tool integrated into Excel, that runs in the background continuously. You don’t have to click anywhere on the ribbon to activate it. You just have to fill in what you want to extract. Extract …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/extract-text-without-formula/

Filter your data in Excel

One of the most useful tools you have in Excel is the Filter tool. You know that the filter is ON when you see arrows on the header of your table. Activate the Filter 1. Select one of the cells of your table 2. Activate the filter in the Data > Filter 3. Now you …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/filter-your-data-in-excel/

How does Excel deal with hours over 24

Excel doesn’t display hours over 24 by default. But, if you change one option in the number format, you can display hours over 24. Difference between hours and days in Excel Rule 1 : A whole number is a day Rule 2 : A decimal number, between 0 and 1, is a time Let’s consider …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/excel-hours-over-24/

Formulas to include or exclude tax

What is VAT? VAT (Value Added Tax) is a tax that is often added to goods or services. Each country or state defines it’s own VAT rates (in percent). For companies it is important to separate the price including and excluding VAT. Basic calculations in Excel If you have some problems with percentage calculations, have …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/the-formulas-to-include-or-exclude-tax/

Comma or Semicolon in an Excel formula

Why does Excel expect commas or semicolons to separate the parameters in a formula? The answer can be found in this article. Comma or semicolon ? If you read this article, it’s because one day you noticed that the separator between the parameters in any function is the comma sign or the semicolon. Sometimes the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/comma-or-semicolon-in-excel-formula/

Calculate Percentage Increase with Excel

Calculating the percentage increase between 2 values is very easy with Excel and doesn’t require a specific Excel function. Context to calculate percentage increase Let’s say you have your total sales for each month. The values look OK but you want to calculate the percentage increase (or decrease) between each month. Method to calculate the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/calculate-percentage-increase-with-excel/

Date format in Excel

In Excel, you can display the same date in many different ways just by changing the date format What is a date in Excel? Dates are whole numbers Usually, when you insert a date in a cell, you have this result Now, if you change the cell’s format to Standard, the cell displays 42370 Explanation …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/date-format-in-excel/