In this session, Jon Palmer reviews Excel Tips & Shortcuts. This session will cover some useful keyboard shortcuts, how to work with the ribbon, entering data, basic calculations and functions, conditional formatting,…
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!
In this session, Jon Palmer reviews Excel Tips & Shortcuts. This session will cover some useful keyboard shortcuts, how to work with the ribbon, entering data, basic calculations and functions, conditional formatting,…
In this session, James Yoder reviews how to use PivotTables. The lesson delves into some best practices for building a PivotTable. It also covers how to format, configure, and analyze…
Vince Bulatao teaches us the various uses for Microsoft Forms. Vince’s session will explain what Microsoft Forms is and its common uses, (surveys, quizzes, polls, etc.) demonstrate how to create, share,…
Jon Palmer guides us on Dealing with Data Using Power Query. Jon will review automating reports, combining data from multiple sheets, utiliizing data from two sources, and merging and organizing data. Jon…
Bryan Brownlow speaks on Part 2 of joining datasets. Bryan will review Lookup tables, Fact tables, VLOOKUP, and Match Index in Excel as well as how to use these tools to your…
Bryan Brownlow speaks on joining datasets. Bryan gives an overview of Lookup tables, Fact tables, VLOOKUP, and Match Index in Excel as well as how to use these tools to your advantage.…
This month, James Yoder guides us through Excel's What-If Analysis tools. With the start of the new fiscal year comes new budget parameters, new spending plans, and the like. Excel's What-If Analysis tools can be…
Welcome to August's session, "Drawing with Data: How to Elevate Power BI Dashboard Design.” This month, Jackie Elfe teaches how to “dress” your data well in Power BI. While carefully prepared data is…
Pamela Dvirnak presents “Power Pointers by Pam–How to Razzle Dazzle ‘Em!” Pam shares her powerful PowerPointers on how to make presentations more engaging. Learn some of the new PowerPoint (PP)…
Darrell Schwerman speaks on MS Access and Power Query. Learn how to Shape your data by learning the nuances of these Microsoft Products! Darrell has been with Teksouth since February…
