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 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
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.0076 seconds -