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!

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

Chart Changes

by Teksouth | | Tips and Tricks

EXCEL 2013 has drastically changed the way of making charts.  We’ll show you the new way. View the .pdf

Flash Fill

by Teksouth | | Tips and Tricks

Excel 2013’s great new Flash Fill feature gives you the ability to take a part of the data entered into one column of a worksheet table and enter just that…

Conditional Formatting

by Teksouth | | Tips and Tricks

Conditional Formatting is a powerful tool and we hope to explain how it works and benefit FMers. View the .pdf 

Excel Slicers

by Teksouth | | Tips and Tricks

Excel 2013’s great new Slicer feature in a formatted table is great.  It gives you the ability to filter quickly without using the down arrows and it displays all that…

Ed Fritts’ Excel Function Keys Shortcuts

by Teksouth | | Tips and Tricks

View Ed Fritts' much requested Excel function key cheat sheet. View the .pdf 

How to Change Jump Lists In Windows 10

by Teksouth | | Tips and Tricks

Increasing the number of items in your Jump List can same time and effort.View the .pdf 

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.