You have copied a cell and want to paste it to multiple other cells. Sounds easy, right? But what if you only want to paste this value to all visible cells? So that you skip all filtered out or hidden cells in-between? It’s also very easy but requires one more small step. Here is how… Continue reading Paste to Visible Cells Only: How to Skip Filtered Out Cells
You work with a table or PivotTable and have an issue: Only the first item is filled. The cells underneath are blank, indicating that the first cell should repeat. Here is how to easily fill down the first filled cell for all blank cells underneath. Example: Fill down empty cells with values from above Let’s… Continue reading How to Fill Down Empty Cells With Values From Above
In Mathematics, many Greek letters have meanings. For example, the delta symbol, or the sigma character. Also, with nowadays naming the COVID-19 variants after Greek letters, you might need to use them in Excel. Here are 5 simple methods of how to add them to Excel cells and to use them in Excel charts –… Continue reading Greek Letters: How to Insert Alpha, Delta, Omicron in Excel
Working with percent values in Excel is very easy and convenient. In some cases, however, you want to work with per mille values. My impression: It was not really considered when Excel was developed. In this article, you will find three main methods, each with different options to insert per mil (or: parts per thousand).
Harvey Balls are circles filled to some level with color. Or, as Wikipedia says, “are round ideograms used for visual communication of qualitative information”. If you want to use them in Excel, you have two options: Make them dynamic with conditional formatting rules or fix them by inserting them as characters. Here is how to… Continue reading Harvey Balls: How to Insert Filled Circles ഠ◔◑◕⬤ in Excel
The capital Greek letter Delta (∆) stands for difference or increment in Mathematics. In some cases, it would also help to use it in Excel: Instead of writing “Difference” or “Change”, you could simply insert the Delta sign. Here is how to do that in Windows and Mac!
You have created a nice dashboard in Excel? Or a beautiful Profit and Loss calculation? Now, you want to bring it to the next level: Insert the sum or total sign, the Greek character sigma: Σ. In general mathematics, uppercase Σ is used as an operator for summation. Here is how to quickly do this in Excel!
Let’s have some fun in Excel! You probably do your work with spreadsheets, but there are also ways of having fun in Excel. In this article, we introduce you to 6 fun applications for Microsoft Excel.
When it comes to presenting your Excel results beautifully, you might want to use check mark (or tick ) symbols or (as the opposite) “x” characters. Here is how to quickly do that – either inserting them directly into cell or returning them from an Excel formula.
Often, after working with Excel, you want to present your results in PowerPoint. The problem, especially when working internationally with different language settings involved: The proofing language often seems to have its own life. It’s often troublesome to continuously tell PowerPoint which language to use. Here are three simple (and two of them very fast)… Continue reading How to Change Proofing Language in the Whole PPT Presentation