Print Only Visible Data in Excel
Excel allows us multiple and various options for preparing our data for printing. We can change the layout of the data that will…
Author: Harun Spahic
Insert File Name in Excel Footer
Everything that we do in Excel can be manipulated. There almost does not exist an option that you can think of, that cannot…
Use R1C1 Reference Style in Excel
The standard way to reference cells is the A1 style. With this style, we use letters to reference a column, and a number…
Merge and Center Data in Excel
Excel has a lot of built-in functions that can help us with a better visual representation of our data. One of those options…
Print Excel Sheet on A4
Just as there are multiple ways to manipulate the data in Excel, we also have ways to manipulate the look of our data…
Use SUMIF with Wildcard Characters in Excel
The SUMIF formula in Excel is simple to use. It is very intuitive for every user. It has three parameters: range, criteria, and…
Random Question Generator in Excel
We can use Excel for many purposes that would not come to your mind when we first tackle a certain issue. In the…
Select Visible Cells Only Using VBA
Visual Basic for Applications (VBA) allows users to simplify every step of the process in Excel. We can benefit from it by automating…
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 &…
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…
