Paris - Alexandre III bridge with Eiffel tower in the background

Realce.net

Coding, ML, tech musings and inspiration from Paris



 

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!

 

Coding

Excel Pivot Tables

2018, Jun 12

Taking 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 


Coding

Filtering data in Excel

2010, Dec 21

Taking 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