This month, Rich Brooks provides a demonstration on several lookup functions within Microsoft’s Excel tool (VLOOKUP, XLOOKUP, and PQLOOKUP). Learn how to utilize Excel’s LOOKUP features to optimize your data…
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!
This month, Rich Brooks provides a demonstration on several lookup functions within Microsoft’s Excel tool (VLOOKUP, XLOOKUP, and PQLOOKUP). Learn how to utilize Excel’s LOOKUP features to optimize your data…
This month, Jackie Airhart is back with more on Power Query! Jackie will demonstrate how you can connect to multiple data sources to transform and shape your data. In addition…
This month, Jackie Airhart provides a demonstration of Excel’s Power Query Tool. Power Query is an embedded tool that automates repetitive data preparation tasks. Learn how to shift your mindset…
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…
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…
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…
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…
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,…
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…
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…
