1420 Northbrook Dr. Suite 220 Gardendale, AL 35071

November 2023: Joining Datasets Part 1

| Tips and Tricks

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.…

October 2023: Excel What-If Analysis Tools

| Tips and Tricks

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…

August 2023: Drawing with Data – How to Elevate Power BI Dashboard Design

| Tips and Tricks

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…

July 2023: MS PowerPoint – How to Razzle Dazzle ‘Em!

| Tips and Tricks

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)…

June 2023: MS Access & Power Query

| Tips and Tricks

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…

May 2023: New Functions in Excel

| Tips and Tricks

Rich Brooks speaks on some of the new useful functions in Excel. The class covers the CONCAT, TEXT JOIN, SWITCH, UNIQUE, and FILTER functions. Learn how to manipulate and organize…

April 2023: Microsoft Teams

| Tips and Tricks

James Yoder demonstrates the newer functionalities of Microsoft Teams. From basic features to lesser-known capabilities, James will show how to navigate these functions so you can reach peak productivity while…