Excel VBA BI
When existing functions are no longer sufficient
The Visual Basic programming language allows us to create custom functions specific to our needs.
Have you ever been faced with wanting to use a function that is incompatible with your version of Excel?
Explore Power Apps
Power Apps is an attractive solution for businesses that need to capture data from multiple users simultaneously and dynamically. It allows great versatility in terms of accessibility from a computer, phone or tablet.
Excel 365 Dynamic matrix functions
Microsoft Excel has just added, since January 13, 2020, a series of revolutionary functions that will greatly simplify the creation of your various management reports as well as your dashboards. The big new feature is the introduction of...
Fuzzy Lookup Excel Complement
The FUZZY LOOKUP is an EXCEL complement (Add-In). The FUZZY LOOKUP allows fuzzy matching of text data in Excel. This is a very useful tool when the data is not normalized. This feature is very robust to a wide variety of errors, including...
Add images, icons in Excel with Microsoft 365
Microsoft 365 users can embed thousands of royalty-free images, icons, illustrations, and videos into their files. The good news is that Microsoft developers will be adding more and more content in the coming months. Under the Insert tab,...
Excel calculation mode
We know that Microsoft Excel has 2 calculation modes, Automatic and Manual. Automatic calculation The automatic calculation mode relaunches the workbook calculations when a value is modified in Excel as well as when a modification to the...
We wish you happy holidays
The SLV Expert team wishes you a happy holiday season with your cherished ones and may this new year be filled with joyfulness.
We are happy to have Marcel Dubé joining our team. Marcel has an extensive experience; he is an effective developer, great trainer, perseverant and rigorous.
Technological change at SLV Expert
The constant and rapid expansion of our services has the repercussion of always forcing us to improve our infrastructure.
The team welcomes a new member
As in other years, we always take advantage of the summer period to work on the content of the training courses, whether online, face-to-face or offline.
Automation with Excel VBA, BI in times of labor shortage
The year is coming to an end soon, it's time to get a small sample of a few mandates done by our developer and technical support team this year. A useful little summary for companies who want to have examples of concrete productivity...
SLV Mont-Tremblant weekend (October 2021)
It is always with renewed pleasure that the members of the SLV Expert team come together to do activities. This time, the place of our festivities was Mont-Tremblant. The 13 guests were received at the chic Westin Resort & Spa. The...
SLV Expert turns 15 and pays tribute to the team
Like many small businesses, SLV Expert was born in a basement and 15 years later, the business has flourished. I will always be grateful to all the companies who have given us their trust, to all the partners who have promoted our...