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.
Excel Pivot Tables
2018, Jun 12Taking 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.
Among the easy access tools to do that, here's a quick introduction to Excel pivot tables, a powerful tool to build a quick and flexible overview of the data you're working on.
tags: Excel feature productivity
Some useful Excel functions
2017, Oct 09Excel useful functions that every person interested in data analysis should know and some enhancements that can improve data toolbox.
Conditional functions are an example of this useful functions, but do you know that you can create your own with a few lines of code ?.
tags: Excel functions 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.0066 seconds -