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
Gold Balloons and 2026 Wishing everyone Happy New Year
By Christina Bower-Arsenault January 6, 2026
Let The Work of 2026 Begin How can it already be January 6th?! I was wa rned when I was wee (little) that as I got older that time has a way of speeding up! Boy! Were they right! Here we are in the first full work week of 2026 and it already feels like an out of control locomotive!! What are your goals for 2026? Not ones to actually buy into "New Years Resolutions" - we at Western Training Solutions usually look at what we see as trending or up and coming in the world of end-user technology to prepare and be ahead of the curve! This year, as last year proved - we are concentrating on AI - in particular - Copilot (Microsoft's version of Generative AI) Look out for new " Power Hour " sessions on using Copilot with M365 and what it can do, and what it can't! As always, Western Training Solutions has your backs. We're doing the work, so you don't have to. We look forward to seeing you in classes / sessions in 2026. Here's to Success for All in 2026 from Your Friends at Western Training Solutions
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!~
More Posts