Filter by Subcategory
Workplace Technology
Excel II+PLUS BTCS*0114*601
with Michael Stephens
Want a top-up from Excel II, to reach the intermediate "Associate" level? In this 4-hour in-person class in our hands-on computer lab, you'll get started on learning to wield the popular and powerful feature of PivotTables, a highly effective tool for dynamic data summarization. Also, learn to extend your data visualizations with more advanced charting skills as well as collaborating with others, sharing but also protecting your hard work. Materials, practice files used during class and additional test worksheets with solutions are also provided for further practice. Excel II is strongly recommended but not required. (NOTE: If you are enrolled in either of our Excel Productivity Series, this is course three of six.)
Excel III BTCS*0103*601
with Michael Stephens
Ready to scale the data ladder to Excel "Expert" heights? In this 6-hour in-person class in our hands-on computer lab, you'll learn about Excel's most powerful and advanced tools for data analysis and visualization. Practice logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping and the much-beloved date, time, text functions. You'll be introduced to Power Pivot for external data sources, and macros. Coursebooks, practice files used during class and dozens of additional test worksheets with solutions are also provided for further practice, or even as templates in your future builds. Excel II+PLUS is strongly recommended but not required. (NOTE: If you are enrolled in our Excel Productivity Series: "Expert," this is course four of six.)
AI in Action: Working Smarter BTCS*0122*600
with Faculty
Now that participants understand the fundamentals,it's time to put AI to work. This highly interactive 6-hour session focuses on using AI to solve everyday workplace challenges. Participants will learn practical techniques to automate repetitive tasks, improve writing, organize information,analyze data, generate ideas, and create higher-quality work in less time. Attendees will leave with immediately applicable skills they can use the next day.
Advanced PivotTables/PivotCha BTCS*0116*601
with Michael Stephens
Got data? Sometimes it's hard to know where to start, especially when you have a lot of data. MS PivotTables (PTs) are a legendary Excel feature. Have you ever used them to summarize, analyze, explore, and present your data? They're highly flexible and adjustable with a few mouse drag 'n drops. In this 6-hour in-person class in our hands-on computer lab, learn about preparing raw data, creating PTs from multiple sources, summarizing, organizing, filtering and formatting PTs, followed by creating, manipulating and formatting their synchronized "sister" PivotCharts to visualize data. Excel II PLUS class got you started on PTs, but this is the Deep Dive. Leave with skills to take your pile of data, feed it into PTs and PCs and behold transformed, highly organized and invaluable data analysis. Books provided. While not required, completing Excel I, II, II+PLUS and III are recommended to get the most out of this course. (NOTE: If you are enrolled in our Excel Productivity Series: "Expert," this is course five of six.)
Connect, Collaborate, and Share BTCS*0126*600
with Faculty
Effective collaboration requires more than endless email chains and disconnected files. In this 6-hour session, participants learn how Teams and SharePoint work together to improve communication, document management, knowledge sharing, and project collaboration. Participants will discover how to organize information, collaborate in real time, reduce duplication, and create a more connected workplace.
Google Workspace I BTCS*0117*600
with Michael Stephens
Interested in using Google Workspace for a wide variety of personal and business tasks? This 4-hour in-person introductory course covers the essentials of Google Workspace and clarifies differences between Free and Paid versions. You'll participate in hands-on computer lab sessions with the Free Edition apps Drive, Gmail, Calendar, Tasks and Chat. By course end, you'll better understand what Google Workspace is and be able to use it for file creation, data organization and communication. A Gmail account is required for practice activities. (NOTE: If you are enrolled in our Google Workspace Productivity Series, this is course one of three.)
Intro to AI BTCS*0110*600
with Michael Stephens
In this 6-hour, in-person course, you will get an in-depth overview of the expansive field of Artificial Intelligence (AI), covering its principal branches and a range of practical applications suitable for both your personal and professional contexts. You'll examine the benefits and challenges associated with AI, including considerations of ethics and security. The curriculum includes an introduction to various AI tools, such as ChatGPT, Gemini, Copilot, and others. In our computer lab setting, try hands-on exercises focused on Gen(erative)AI, explore real-world use cases that enhance productivity in work and home settings, and learn fundamental concepts of Prompt Engineering. Explore the future trajectory of AI, as we prepare for its inevitable, further integration into our daily work and home lives. No prior knowledge of AI is required.
Excel for Accounting BTCS*0108*600
with Bridgette White
Spending too much on accounting software? Utilize Excel as a cost-effective alternative, as it offers robust features for accounting tasks. In this 6-hour, in-person course, you will learn how to use Excel for basic accounting, financial statements, statement of cash flows, bank reconciliation, payroll register, budgeting, and depreciation schedules. Through guided exercises and real-world scenarios, you will practice applying Excel tools to common accounting challenges. By the end of the course, you will be able to confidently use Excel to support everyday accounting tasks and produce clear, professional results. Basic to intermediate familiarity with Excel is recommended, but no advanced skills are required.