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!

June 2021 Tips and Tricks – Power Query

by Teksouth | | Tips and Tricks

Tune in as Ed Fritts discusses one of the most powerful, yet least-used tools for handling raw data, that already exists on your desktop. Power Query, one of Microsoft’s Business…

T&T: Data Maturity Edition – Episode 2

by Teksouth | | Tips and Tricks

“What Ifs?” for the Coast GuardBob Jackson discusses a use case for large data sets in the Coast Guard to enable proactive resource deployment. Want to see where your organization’s data…

May 2021 Tips and Tricks – Data Sets

by Teksouth | | Tips and Tricks

To help support Crosswinds' and learn more about their efforts to raise awareness about mental, emotional, and moral trauma associated with military service, please click HERE.Teksouth's Ed Fritts takes his gloves off…

T&T: Data Maturity Edition – Episode 1

by Teksouth | | Tips and Tricks

Paving the Way for Safer Roads with the Department of Transportation  In the series premiere of Tips & Tricks: Data Maturity Edition, Teksouth's Bob Jackson shares lessons learned from a state…

April 2021 Tips and Tricks – F Key Functions

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares some incredibly useful formulas and formatting tips to help streamline your data management. We will show three options of using and learning the Office 365 “Sequence” Function, showcase the…

March 2021 Tips and Tricks – XLOOKUP

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares some incredibly useful formulas and formatting tips to help streamline your data management. You will learn another great option of your mouse, how to add filters to your values…

February 2021 Tips and Tricks – MS 365

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares some incredibly useful formulas and formatting tips to help streamline your data management. You will learn powerful features of the windows key, formatting shortcuts for excel…

January 2021 Tips and Tricks – Pivot Tables

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares some incredibly useful formulas and formatting tips to help streamline your data management. You will learn how to format tables, edit and replace characters for corrected…

December Tips and Tricks – (Data) Bucket List

by Teksouth | | Tips and Tricks

Rich Brooks shows you  some magical formulas and operations in Excel, Power Query, Pivot Tables, and Power BI to categorize Date Buckets of Data. What he teaches is applicable to…

November Tips and Tricks – VLOOKUP and Power Query

by Teksouth | | Tips and Tricks

Teksouth's Rich Brooks takes you through VLOOKUP and Power Query. https://amym97.sg-host.com/wp-content/uploads/2020/11/2020-11-19-09.01-November-Tips-and-Tricks.mp4

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.