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

Category: examples

Using a Dynamic Range With VLOOKUP in Excel

Sometimes we may need to use the VLOOKUP function when we expect additional rows or columns to be added to the data; therefore,…

Posted On 30 Jan30 Jan

Custom Data Labels in Excel Chart

Data labels help point out information for a series of data points and make the chart more understandable. Therefore, you may want to…

Posted On 23 Jan23 Jan

Move X-Axis to the Bottom of a Graph in Excel

Sometimes when we create a graph in Excel, and the Y-axis has both positive and negative values, the X-axis appears in the middle…

Posted On 20 Jan20 Jan

Get the Size of the Range in Excel

Excel can be very helpful in terms of analytics, extraction, and presentation of data. It can also be very informative when we want…

Posted On 19 Jan19 Jan

Add Cells Across Multiple Spreadsheets in Excel

Excel cells can communicate with each other in the same sheet, through various sheets, and across multiple workbooks. This can be very useful…

Posted On 10 Jan10 Jan

Replace Special Characters in Excel

Sometimes when we import data into Excel, it may come with unnecessary special characters. We may need to replace the special characters with…

Posted On 10 Jan10 Jan

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

Align Header and Footer in Excel

Just like in Microsoft Office Word, we have options to manipulate the header and footer in Excel as well. In the example below,…

Posted On 20 Dec5 Jan

Change the Axis Range in Excel Charts

Excel Charts are one of the most widely used tools to visually present data. With everything that we do on it, changes can…

Posted On 20 Dec5 Jan

Setting Upper and Lower Limits in Excel Charts

Charts in Excel are one of the best tools for visually presenting data. In some instances, we want to have upper and lower…

Posted On 20 Dec7 Jan

Posts navigation

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