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!
Data Validation
What is it? And why do we use it?
Spreadsheets are already organized in a grid of columns and rows. A spreadsheet is a digital representation of a ledger sheet. Because spreadsheets are organized in such a way, they are very popularly used to organize all manner of data.
What is Data Validation?
Simply put, data validation allows the creator/author of the spreadsheet to establish “rules” for the entry of data into columns/rows/cells to limit data entry errors and enforce the “type” of data permitted in a particular area of the spreadsheet. Phew! Sounds complicated, doesn’t it? It doesn’t necessarily need to be.
Why do we use Data Validation?
Excel data validation is a useful tool when sharing workbooks with multiple users; especially if the users are varied in their Excel experience. Essentially, data validation permits you to enforce data integrity and limit data entry errors therefore making your spreadsheets foolproof! There are eight (8) validation options for users to set for any cell:
- Any Value: If any value is allowed, This is the default option for all cells on a spreadsheet.
- Whole Number: A whole number is simply any positive number that does not include a fractional or decimal.
- Decimal: Like whole numbers, except it converts numbers to decimal values.
- List/Drop-Down: Adds a drop-down list in the selected cells using a list that you added yourself in the settings area of the List dialog box. You can manually type the list in using a comma (,) as a separator between all options in the list. Or, you can have the list somewhere on the spreadsheet and use cell references for the list options.
- Dates: You can provide a specific date range to be used.
- Time: You can provide a specified time range to be used.
- Text length: Sets a specified character length – including spaces to restrict the amount of data that can be entered into the specified cells or range.
- Custom: Permits you to use a custom formula (format) to validate data For example, you can format the cells to permit only uppercase characters, or even show an alert if a user inputs a date beyond 30 days from the current date.
Data Validation is offered as part of our Excel Level 3 class. If you would 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!
WesternTS Travels! All too often we hear from businesses, and organizations that they are too remote and no trainer will come to them. Well...Western Training Solutions travels to you! Office Refresher 2025 Working for a school board is a lot of work. Having value - added training offered at your location of work, is priceless! WesternTS journeyed to Norway House in August to refresh the their school division's staff. The requested topics took two days and everyone walked away with new tips and tricks, new skills, and a clearer understanding of how some of the software actually works. Topics covered in those two days included: Using Outlook efficiently and understanding Email Etiquette Using Word's efficiencies to work smarter and not harder AI in the workplace Microsoft Forms Excel efficiencies and using introductory to intermediate skills in spreadsheets It was a packed two days but everyone learned something new and felt refreshed and ready to begin the new school year. Western Training Solutions was happy to accommodate the training. Getting to know amazing people and organizations is an added bonus for all involved! Plus, if you've never been to Norway House you're missing out on one of the most picturesque places on the planet. It is truly lovely and historic. If you are tired of hearing your location is too remote? That your group isn't large enough? Think you have to resort to "Webinars" or pre-recorded lessons from sites with no actual person to ask questions of? Stop the hamster wheel! Hop off and call 204-837-4776 or email sales@westernts.ca to discuss your training needs. We look forward to hearing from you & seeing you in class!
Employee Training Ready to turn your team into productivity superheroes? Employee training is your secret cape. From onboarding (Think: rocket launcher for rookies) to mastering tech tricks, honing those people skills, wrangling compliance rules, and becoming product wizards—training isn’t just a checkbox. It’s how organizations shape legends, not just employees. Technical Training: In 2025, employees require technical training to keep pace with rapid technological changes, close skills gaps, and increase productivity and innovation. Such training also improves job satisfaction, confidence, retention, and helps organisations attract top talent in a competitive market. According to a Talent Canada May 2025 survey, Canadians are more likely to stay with an organization that invests in their training / upgrading / upskilling / reskilling. Keeping your talent skilled in today's ever-changing tech world is a challenge. Yearly training will ensure that existing employees are educated in new tech and are on-par with new hires, fresh from school. Call 204-837-4776 or email sales@westernts.ca to discuss your training needs. We look forward to seeing you in class!
Webinars Failing You? Need a Live Person to Answer Questions? We've Got YOU! According to Co-Pilot, Microsoft's version of AI (Artificial Intelligence): Adults in 2025 learn best through experiential learning and by connecting new information to their existing experiences and goals. They benefit from self-directed, flexible, and relevant learning opportunities that involve active participation , problem-solving , and collaboration , often using digital platforms and microlearning for accessibility and skill-building. Has your work tried to send you to e-learning platforms with endless video's demonstrating what you can do with new skills but there is no interaction? You're left with more questions than solutions and feel that you've wasted your time? We understand. We, at Western Training Solutions have been training people in the skills they need in the workplace for a very long time. Our " About Us " page tells how Western Training Solutions started during the pandemic. However, the owners, have been working in the "adult learning" world for more than 40 years combined. WTS understands that adults, for the most part, learn by doing. NOT WATCHING. If watching were the solution then YouTube and Google would be the de-facto go-to for all things learning. The fact that it isn't, demonstrates that it's lacking where the majority of adults are concerned. All this to say...We've got you! Call Sales 1-204-837-4776 or email sales@westernts.ca for course information, to ask questions about skills you are missing and want, or to just find out more. No question is too small. Thank you for your interest in training with Western Training Solutions. We look forward to seeing you in class!