Hello !
Welcome to Realce.net
If you're interested in coding, you'll find here why we code with enthusiasm, exploring creativity with P5js coding, the power of Machine Learning algorithms with python, as well as improving productivity with VBA, and much more.
Scroll below to find out more about our recent highlights!
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
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.0089 seconds -