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

Author: Harun Spahic

Calculate Percentiles from Mean & Standard Deviation in Excel

Excel is one of the best tools devised for various calculations. Formulas in Excel are grouped into multiple subcategories: mathematical, financial, date &…

Posted On 20 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

Find the Maximum and Minimum Value in the Range in VBA

In terms of the things that we can work on, we can observe Visual Basic for Applications (VBA) as an extension of Excel….

Posted On 19 Jan19 Jan

Detect If Range Is Empty in VBA

Just as with everything in Excel, there is always a way to simplify and make your life easier with Visual Basic for Applications…

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

The If Statement is Based on the Cell Color in Excel

Excel has a lot of options for formatting and highlighting certain cells in our range, table, or data set. We can use also…

Posted On 28 Dec3 Jan

Match Date to a Range of Dates and Times in Excel

There are numerous tools at our disposal when it comes to extracting data. Excel is undoubtedly one of the best of them. If…

Posted On 28 Dec4 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 … 21 Next
200+ Excel Interview Questions
  • English
  • .
  • Polski
  • |
  • About
  • |
  • Contact Us
© 2023 OfficeTuts. All Rights Reserved.
  • Formulas
  • Examples
  • VBA
  • Functions
  • Shortcuts