Excel – Create and add a custom Ribbon Tab (Menu)

Adding a custom tab into a specific Office document (2007+ documents) can be very useful if we need to transport, with the document, custom VBA/macro codes. Read More …

Python – Pandas – Converting XLSX to Dictionary (key and values)

During data import process in a Jupyter Notebook, using Python and Pandas module for data science, we would need to manipulate or import directly an Excel file into a notebook and transfor all the data into a dictionary, so in this article we will focus on this particular need. Read More …

Powershell – Get Permissions on folders and/or files

Sometimes it is useful to get permissions (NTFS and/or Share) on Windows systems (Server and/or Client). The following Powershell code will generate, in the same folder in which is saved the ps1 file (once the below code is copied and saved on the system as ps1 file), a CSV file which will include all the permissions (subfolders included) set in that moment. Read More …

Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …