Microsoft Power BI - Getting Started

Thursday, November 13, 2025
Time: 10:00 AM PST | 01:00 PM EST
Duration: 60 Minutes
IMG Tom Chandler
Id: 90922
Live
Session
$119.00
Single Attendee
$249.00
Group Attendees
Recorded
Session
$159.00
Single Attendee
$359.00
Group Attendees
Combo
Live+Recorded
$249.00
Single Attendee
$549.00
Group Attendees

Overview:

Have you ever received a spreadsheet where users entered a date in a phone number column? Or maybe they entered an employee's birthdate with the current year? Or did then misspell a state abbreviation? Did you know you can prevent these errors using Excel's Data Validation feature. That is what this course is all about.

Whether you are a new Excel user, a data analyst, spreadsheet guru, business professional, or simply someone looking to create more user-friendly Excel files, this course will provide you with the knowledge and tools you need to validate the data and make the spreadsheet more user friendly.

Areas Covered in the Session:

  • What is Data Validation?
  • What are the benefits of using Data Validation?
  • How can I insist that a user enter a whole numbers, decimals, dates, times?
  • How can I set up rules such as no negative numbers, or no future dates?
  • How can I display and restrict inputs to values in a dropdown menu?
  • How can I create a dependent drop down (e.g. Category - Subcategory)
  • How can I reject malformed phone numbers, SSN, and zip codes?
  • How can I set up a rule based on a formula?
  • How can I display an input prompt so users know what to enter?
  • How can I display a friendly message when a user enters invalid data?
  • How can I mark data that is invalid?

Who Will Benefit:

  • Office Workers
  • Administrators
  • Data Analysts
  • Managers of All Levels
  • Business Owners
  • CEO's
  • CFO's
  • CTO's
  • Salespeople
  • Trainers
  • Bankers
  • Anybody who needs to enhance their spreadsheets to collect more accurate data. 

Speaker Profile

Tom Chandler is the founder, principal trainer and consultant of TechMentors, LLC. TechMentors’ mission is to help people and businesses get more out of technology through training, consulting, and programming.

Tom has been a full-time computer trainer, consultant and programmer since 1996. He has developed desktop solutions for multiple organizations including Stanford Medical Center, Visa, Genentech, Blue Shield, Seagate, and the City of San Jose. He has also taught hundreds of students in basic- through advanced-level classes. His specialties include database design with Microsoft SQL Server and Microsoft Access, Business Intelligence with Microsoft Power BI, and Microsoft 365 desktop applications including Excel, Word, PowerPoint, OneNote, Publisher, and Outlook.

Tom has a bachelor’s degree in finance from Brigham Young University, and an MBA in IT Management from Wester Governor University.