Excel Tutorial
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts

Author: Tomasz Decker

Spreadsheet and Python enthusiast.

Change Commas to Dots and Vice Versa in Excel

The majority of English-speaking countries, including Australia, the UK, and the USA, use commas to separate groups of thousands and dots to separate…

Posted On 20 Dec5 Jan

Select Only the Visible Cells in Excel

When we work with an Excel spreadsheet, sometimes some columns are becoming too wide to fit on the screen or maybe there are…

Posted On 4 Apr7 Jan

Change the Axis Scale in an Excel Chart

Excel’s charts are impressive, but some of the automated features in Excel may not be ideal for your specific needs. For this reason,…

Posted On 7 Mar5 Jan

Change Horizontal Axis Values in Excel

In this tutorial, I’m going to show you how to change data labels on the x-axis in Excel charts. This procedure is a…

Posted On 7 Mar5 Jan

Open CSV Files Safely with Excel

The CSV file format is a common data storage format that is used to store tabular data. It is often used for exchanging…

Posted On 4 Mar7 Jan

Convert HEX Values in Excel

Every day we deal with numbers with decimal notation, but there can be these rare occasions when we need to use other systems,…

Posted On 24 Feb4 Jan

Save Excel Sheet as a CSV file with UTF-8 encoding

In Excel, you can save a spreadsheet as a CSV file directly from the Excel menu. Saving it in Excel 2016, 2019, 2021,…

Posted On 19 Feb7 Jan

Calculate the Amount of Time Between Two Dates in Excel

If you want to calculate the time between two dates, you have to remember that’s a bit more complicated than calculating the difference…

Posted On 17 Feb4 Jan

Repeat Excel Spreadsheet Column Headings at Top of Page

If you have a long list of data that spans multiple pages, you can print column headers with the first part of the…

Posted On 16 Feb7 Jan

Freeze or Fix Column or Row Headings in Excel

When you have to work with a large Excel spreadsheet, you can easily lose track of exactly what kind of information is included…

Posted On 15 Feb5 Jan

Posts navigation

1 2 3 … 73 Next
200+ Excel Interview Questions
  • English
  • .
  • Polski
  • |
  • About
  • |
  • Contact Us
© 2023 OfficeTuts. All Rights Reserved.
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts