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!

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

October Tips and Tricks – Intro to PowerBI

by Teksouth | | Tips and Tricks

Teksouth's Morgan Smith gives you an overview of Microsoft PowerBI.  Please note:  The Desktop version of Power BI is included with your Microsoft Enterprise Agreement.  If it is not currently…

August Tips and Tricks – On Point: Maximizing PowerPoint

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts (and Bob Jackson) share PowerPoint Tips and Tricks to improve efficiency and keep your audience engaged.  The presentation starts at 2:53. https://amym97.sg-host.com/wp-content/uploads/2020/08/2020-08-20-08.58-August-Tips-and-Tricks-_On-Point_-Maximizing-PowerPoint_.mp4

July Tips and Tricks – 4-Star Scorecard

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares the 4-Star Scorecard. All of the files, including step-by-step videos are included in the package.  Once the .zip folder has downloaded, click "extract" and you will…

June Tips and Tricks – Dashboards

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares dashboarding basics. All of the files, including step-by-step videos are included in the package.  Once the .zip folder has downloaded, click “extract” and you will easily…

May Tips and Tricks – Pivot Tables

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares the real power of Pivot Tables. All of the files, including step-by-step videos are included in the package.  Once the .zip folder has downloaded, click “extract”…

April Virtual Tips and Tricks with Ed Fritts

by Teksouth | | Tips and Tricks

Teksouth's Ed Fritts shares time saving and efficiency enhancing tips and tricks for Microsoft Windows. Download the Federal Data Strategy 2020 Action Plan https://amym97.sg-host.com/wp-content/uploads/2020/04/2020-04-16-10.00-April-Virtual-Tips-and-Tricks-with-Teksouth_s-Ed-Frits.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.