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 &…
Author: Harun Spahic
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…
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….
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…
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…
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…
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…
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,…
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…
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…
