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!

May 2022: Microsoft Teams

by Teksouth | | Tips and Tricks

This month, Teksouth’s Jon Palmer provides a comprehensive look at the impressive features of MS Teams. Brush up on your skills and maximize the value of this amazing tool! Download…

March 2022: Using Wild Cards in VLOOKUP

by Teksouth | | Tips and Tricks

This month, we will be showcasing one of our best financial management tools: using Wild Cards within VLookup. Helping you build out an access database, you’ll then be able to…

February 2022: Visual Basic Applications “VBA”

by Teksouth | | Tips and Tricks

This month’s Tips and Tricks showcases the power of Microsoft Excel’s Visual Basic for Applications, or VBA. Learn how to design your OWN dashboard to help improve the efficiency of…

January 2022: Microsoft Excel’s “IF” Function

by Teksouth | | Tips and Tricks

This month’s Tips and Tricks showcases the power of Microsoft Excel’s “IF” Function, one of the most popular functions in Excel! Learn from FM Analyst Subject Matter Expert, Ed Fritts,…

December Tips & Tricks: Top Tips for FM’ers 2021

by Teksouth | | Tips and Tricks

This month, Ed Fritts covers the top tips of 2021- you do not want to miss this session!  Learn the most valuable and time-saving tools and tips currently available within…

November 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…

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.…

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.