Excel VBA BI
The Value of Excel for Payroll Professionals
Much water has flowed under the bridge since Dan Bricklin, a Harvard student, created the first spreadsheet in 1978, marketed as VisiCalc. He was closely followed by none other than Bill Gates in 1982 with Multiplan, which was a...
Invest in your professional future now
Join thousands of professionals who have chosen quality and excellence for their continued development.
Revamped version of our Word training
In response to the enthusiasm for our portal and the growing demand for Word training, we are thrilled to present a completely revamped version of our online Word training course.
1 – 2 – 3 GO let’s automate!
In a constantly evolving world, automation has become an essential lever for increasing business efficiency and productivity.
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...
News
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.
Welcome aboard!
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...