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!
Excel Arrays management functions
2023, Jul 31The array represents in some way the basic material of the data project. During the different steps of the project the user will have to sort, merge, analyze different sets of data often as group of array. Using Excel in a first approach, here are some useful functions to manage Array objects in Excel.
Manage Excel workbooks with VBA
2023, Jul 20Data collection is an important step of each data project.
To perform each time the adequate analysis it's important to have access to a data toolbox, enabling the automation of some tasks related to data consolidation for example.
To help building an Excel toolbox on this matter, a few VBA code examples aimed to automate Excel workbooks management.
Example of VBA custom Excel function
2023, Jun 03Some data tools are more at ease when data is imported with flat/text file format.
It can be for example interesting to extract a list of Ids or codes from excel, store them in an flat file to be able to import/ use these codes in another tool later.
Here's a quick view on a VBA custom function designed to write a value (text, number, etc.) to text file.
Counting rows in Excel
2023, Feb 05It's good to have in mind the dimension of the data of the project. It helps computing basic statistics on the data quality for example, like computing the percentage of missing data per column.
An example of a custom VBA function, aimed at counting the number of rows in a given excel range.
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.
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.0071 seconds -