Welcome to Western Training Solutions blog! We regularly publish tips, tricks, and "What's New" information here and share it with anyone who is interested. Thanks for stopping by. We're glad you did!

Solver

Solver Excell Add-in Logo

What is the Excel Add-in, Solver?

Solver is a “What-If” analysis tool you can safely add to Excel. Using an “Objective cell” (a cell containing a formula) that is subject to constraints. (This is the tricky part – determining the constraints you are working under) The constraints / limits the values of other formula cells in a workbook. Using a group of cells called “Decision Variables” that are used in computing a formula in the objective or constraint cells. Solver will adjust the values in the decision variable cells to satisfy the limits on constraint cells and provide a result you’ve requested based on the constraints you’re working under.

Solver can determine the maximum or minimum value of one cell by changing other cells in a formula

You can use this add-in to determine capital budgets, expenditures, optimal production – all based on existing constraints.

 

Solver is available in Western Training Solutions, Excel Level 3. Ask your IT department if you are allowed to download this Excel add-in to your software. If you are, and you’d like to learn more -contact sales@westernts.ca or call or text to get more information on this exciting data tool that can make your life so much easier! 



See the Course
By Christina Bower-Arsenault December 22, 2025
Greetings of the Season Warm wishes filled with cheer, For moments wrapped in laughter And memories held dear. May your days be bright with kindness, Your nights be calm and clear, And may the spirit of the season Bring joy throughout the year. Here’s to peaceful little pauses, And to hearts that feel at ease— May the simple gifts around you Be the ones that truly please. Wishing you warmth and wonder, In all the days to come— May the season’s gentle magic Touch each and every one. Warm Wishes, Western Training Solutions
By Christina Bower-Arsenault October 31, 2025
H appy H alloween from WesternTS Friendly Reminders for Parents of Younger Children: Don't let your children get too far ahead of you while out trick-or-treating Using glow sticks to brighten up their costumes is useful Putting glow sticks in their plastic treat pumpkins help keep them easy to locate Remind the children that no candy or drinks get eaten before they are inspected at home Using personal trackers on your kids is perfectly acceptable in high traffic areas where you could lose them in the crowd! Enjoy the evening everyone. Stay safe! and if you're like we are at Western Training Solutions....we will be enjoying the Blue Jays playing their game tonight as well as enjoying handing out treats to the kids both young and older!! Afterall, is anyone too old to get a candy on Halloween? We don't think so. ~Happy Fight Night to one and all!~
By Christina Bower-Arsenault October 21, 2025
Speed Dating for Excel Micro-Courses Pressed for time? We get it—there’s never enough hours in the day. If you want to master Excel functions or boost your Excel skills without committing to a full-day of training, our Micro-Courses are for you. Contact us at sales@westernts.ca or 1-204-837-4776 to learn more and book your spot. Enjoy our everyday multi-class discount and pick up a new skill in just one hour with a live, interactive instructor. We look forward to seeing you in class! #Microcourses #speeddatingforexcel #westernts #westerntrainingsolutions #Worksmarternotharder #onehouroneskill
More Posts