1420 Northbrook Dr. Suite 220 Gardendale, AL 35071

Tips and Tricks

Useful shortcuts and lesser-known features in Microsoft Office and Power BI

From the minds and experience of our experts

When you have supported the DoD FM community for as long as Teksouth, you learn a thing or two about the tricks of the trade and the tools of choice.  This is where we will share a few of those tips and tricks as a way of saying “thank you” for the confidence and trust you have placed in Teksouth for all these years.

Click on the month in white below to view the lessons!

November 2025: New Functions in Excel

by Milan Ballard | | Tips and Tricks

Learn about new and exciting functions in Microsoft Excel.In this one-hour session, you will discover how these powerful tools can help you wrangle your data with less effort and more…

October 2025: Excel & Power Query: From Messy to Magic

by Milan Ballard | | Tips and Tricks

Take messy data from multiple sources, clean it with Power Query, and build a simple dashboard in Excel.In this training, you will learn how to:Use Excel functions to shape dataUse…

August 2025: Turn Raw Data into Wow Dashboards

by Milan Ballard | | Tips and Tricks

Turn Raw Data into “Wow” Dashboards — in ~60 MinutesIf your spreadsheets are bursting with numbers but short on insight, this fast-paced session is for you. Join our Microsoft Certified…

July 2025: Part 2 – Using Power Query to Reshape and Clean Your Data

by Milan Ballard | | Tips and Tricks

In this session, Jon Palmer teaches Part 2: Using Power Query to Reshape and Clean Your Data.Tune in as Jon Palmer shows you how to use one of Excel’s most…

May 2025: Using Power Query to Reshape and Clean Your Data

by Milan Ballard | | Tips and Tricks

In this session, Jon Palmer teaches Using Power Query to Reshape and Clean Your Data.Tune in as Jon Palmer shows you how to use one of Excel’s most powerful components,…

April 2025: From Data to Presentations: How to Save Time and Reduce Frustration with Automatically Updating Presentations

by Milan Ballard | | Tips and Tricks

In this session, Rich Brooks teaches From Data to Presentations: How to Save Time and Reduce Frustration with Automatically Updating Presentations.Join us and elevate your skills to the next level!https://youtu.be/3dsyup4SZxI

February 2025: Excel Cells, Tables, Pivot Tables, and Power BI

by Milan Ballard | | Tips and Tricks

In this session, Rich Brooks teaches Excel Cells, Tables, Pivot Tables, and Power BI.Join us and elevate your skills to the next level!https://youtu.be/TAY0kBjStUA

January 2025: Power Query

by Milan Ballard | | Tips and Tricks

In this session, Jon Palmer teaches Power Query Troubleshooting Errors and Data Cleaning in Power BI/Power Query. Join us and elevate your skills to the next level!https://youtu.be/9NzHiM4EZXI

December 2024: Microsoft Excel

by Milan Ballard | | Tips and Tricks

In this session, Bryan Brownlow teaches Excel Collaboration Environment – Benefits, Drawbacks, and Best Practices. Join us and elevate your Excel skills to the next level!https://youtu.be/S6WVjsfEtz0

October 2024: Microsoft Excel

by Milan Ballard | | Tips and Tricks

In this session, Jon Palmer covers fun tips in Microsoft Excel, including:Excel functions for data cleanupEasily clear blank rows in dataFilling in missing data from the rows aboveCool checkbox tipsJoin…

Can’t get enough Tips and Tricks?

Consider enrolling your team in a Dashboard University™ Course. Our expert trainers will travel to your location and train up to 20 members of your team. Your team will come out with skills they can apply immediately and earn credits towards their FM Certification. Click “Visit DBU” to learn more.