Excel Tutorials
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts

Author: Tomasz Decker

Spreadsheet and Python enthusiast.

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 Apr4 Apr

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 Mar7 Mar

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 Mar7 Mar

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 Mar4 Mar

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 Feb24 Feb

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 Feb19 Feb

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 Feb25 Feb

Repeat Excel Spreadsheet Column Headings at Top of Page

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

Posted On 16 Feb16 Feb

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 Feb15 Feb

Format Numbers in Thousands and Millions in Excel

When you are dealing with large numbers where precision is less important than readability, there are a few methods you can use to…

Posted On 1 Feb4 Apr

Posts navigation

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