Welcome to the Code playground
Note that any code featured on the realce.net website is provided "As is" without any warranty of any kind, express or implied.
In no event the authors or copyright holders be liable for any claim, damages or other liability arising from, out of or in connection with the use of this content.
Please, if you are not sure of what you are doing, ask a qualified person for help.
Thank you
Some Excel quick tips
2011, Aug 29Some VBA code to show how some tasks can be automated in Excel.
We'll start with some very simple, but still useful, tasks which require only a few lines of VBA code and will progressively add some capabilities, in order to build a automation toolbox for Excel.
Some handy Excel functions
2011, Jan 11We propose a review of a list of handy Excel functions that can help leverage on the Excel usage and inspire you to build additional functions or procedures later with the help of the VBA language.
tags: Excel functions productivity
Filtering data in Excel
2010, Dec 21Taking a close look at your data is a key step for your data project, as a part of the preprocessing activities which often represent 80% of the workload. At first, before looking at agregate data with pivot tables, it's good practice to start looking at raw data, making selections, trying to already detect the important features. For this kind of tasks, excel filters can be pretty useful!
tags: Excel feature productivity
Do you know BrowserShots.org ?
2007, Sep 01Very Very useful site for webmasters willing to have a look at their projects viewed across multiple browsers under multiple OSes. You only need to enter the url you're willing to test and then check the different browsers versions, grouped by OS.
Its name is quite easy to remember, but you can click browsershots.org.
The MaxIf function
2007, Jul 01If you work with data in Excel, you probably already used the functions SUMIF and COUNTIF. In this post, we show how to extend it with the function MaxIf, a function written in VBA that can also be very useful.
This development example shows how VBA can help developing a custom set of function for data analysis.
tags: VBA Excel productivity
Realce.net©2000-2026 -Mentions légales-Except where indicated, this work is licensed under CC BY-NC-SA 4.0
- Page rendered in 0.0079 seconds -