This month, DeAndre Hayward will demonstrate how to use Power Query to combine multiple files and utilize the merge method. With Power Query, you can combine various files with the same schema into…

This month, Pamela Dvirnak will demonstrate Automation with Excel Pivot Tables! A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and…

This month, James Yoder will provide a demonstration on Power BI Basics. Learn how to navigate Power BI and use it to its maximum potential. https://youtu.be/-IiHpA4lwL0

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…