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!

October Tips and Tricks: Microsoft OneNote

by Teksouth | | Tips and Tricks

Tune in as Ed Fritts trains on Microsoft OneNote! You’ll learn everything to know to increase your efficiency and make the most of this powerful software. Click HERE to view…

September Tips and Tricks: Microsoft Teams

by Teksouth | | Tips and Tricks

Tune in as Ed Fritts trains on Microsoft Teams for DoD Environments. You’ll learn everything to know to increase your efficiency and make the most of this powerful software. Click…

August 2021 Tips and Tricks – VBA

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.Tune in as Ed Fritts trains…

July 2021 Tips and Tricks – Power Pivot

by Teksouth | | Tips and Tricks

Tune in as Ed Fritts trains o n Power Query (Uses M language), Power Pivot uses Data Analytics Expression (DAX functions), Data Model, and OnLine Analytical Processing (OLAP) Pivot Table.…

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…

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.