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 – 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

Excel can automatically add decimal points to your numbers

by Teksouth | | Tips and Tricks

Let's say you are adding a bunch of numbers with decimal points. Wouldn't it be nice if Excel could just automatically add the decimal points for us? One less keystroke…

Screen Recordings in PowerPoint

by Teksouth | | Tips and Tricks

We’ll show how to use Office “2013 PowerPoint Screen Recording” similar to Windows 7 Problem Steps Recorder (PSR). It’s a great tool for doing Standard Operating Procedures (SOP) at your…

2019 PDI – Excel Power Pivot and Power BI

by Teksouth | | Tips and Tricks

Teksouth's Ben Cella discusses Power Pivot and Power BI to help you succeed in a world of data overload.https://amym97.sg-host.com/wp-content/uploads/2019/11/2019-PDI-Analytics.mp4

Only Display What it Sees for Graphs (video tutorial)

by Teksouth | | Tips and Tricks

Ed Fritts walks you through the process of creating graphs for only what is shown on the screen. https://amym97.sg-host.com/wp-content/uploads/2019/11/1_Charts_Synopsis.mp4https://amym97.sg-host.com/wp-content/uploads/2019/11/2_Create_Macro.mp4https://amym97.sg-host.com/wp-content/uploads/2019/11/3_Assign_Macro_To_Button.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.