Filter by Subcategory
Computer Skills
MS Excel Level 1 BTCS*0101*600
with Michael Stephens
Rusty or new to Microsoft Excel? In this 7-hour in-person class in our hands-on computer lab, learn to create and format worksheets that contain calculations with formulas and functions, including the importance of using proper reference types. Moving and copying data correctly, manipulating data, chart creation, and various other tips and tricks are also covered. 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. Gain the confidence to build, repair and upgrade spreadsheets. Participants leave this course with a new or increased love of Excel, a powerful and legendary data tool.
Will run
Introduction to AI BTCS*0110*600
with Michael Stephens
In this 7-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.
Will run
MS Excel Level 2 BTCS*0102*600
with Michael Stephens
Feel comfortable with Excel basics but want to advance to an intermediate level? In this 7-hour in-person class in our hands-on computer lab, you'll learn advanced tools for analysis, organization and presentation of more complex data. Practice using more elaborate functions, creating ranges and tables, data validation, conditional formatting and advanced charts. A highlight is learning to wield the popular and powerful feature of PivotTables, a highly effective tool for dynamic data summarization. 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 1 is strongly recommended but not required.
MS Excel Level 3 BTCS*0103*600
with Michael Stephens
Ready to scale the ladder to Excel Expert heights? In this 7-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 presentation. Practice logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved date, time, text, and other functions. Learn about importing external data via Power Pivot, exporting data, What-If Analysis and automating repetitive tasks with 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 1 and 2 are strongly recommended but not required.
MS 365 Copilot AI Essentials BTCS*0115*600
with Michael Stephens
New to Microsoft 365 Copilot AI? This 4-hour, in-person class held in our hands-on computer lab provides an introduction to Copilot and its integration with Word, Excel, PowerPoint, Outlook, Teams and other apps. Learn how Copilot assists you with streamlining workflows, supporting communication and decision-making. You’ll learn the difference between the basic version bundled with Office 365 and the advanced features of the additional cost version, Copilot Studio. Review practical use cases, learn techniques for crafting prompts, and practice using Copilot to summarize documents, generate content, analyze data, and automate tasks. Walk away with the confidence that you’re ready to use Copilot to help you at work and home. “Intro to AI” is recommended but not required.
MS Excel Level 1 BTCS*0101*601
with Michael Stephens
Rusty or new to Microsoft Excel? In this 7-hour in-person class in our hands-on computer lab, learn to create and format worksheets that contain calculations with formulas and functions, including the importance of using proper reference types. Moving and copying data correctly, manipulating data, chart creation, and various other tips and tricks are also covered. 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. Gain the confidence to build, repair and upgrade spreadsheets. Participants leave this course with a new or increased love of Excel, a powerful and legendary data tool.
Google Workspace BTCS*0125*600
with Michael Stephens
Interested in using Google Workspace for personal or business tasks with little prior experience? This 7-hour in-person course covers the essentials of Google Workspace, highlighting differences between Free and Paid versions. You'll participate in hands-on computer lab sessions with the Free Edition's core apps Gmail, Chat, Meet, Docs, Sheets, Slides, Forms, Keep, and Sites. By course end, you'll be able to use Google Workspace for file creation, data organization, communication, and collaboration. Books are included. A Gmail account is required for practice activities.
MS Excel: AI Assist BTCS*0107*600
with Michael Stephens
Already fairly Excel savvy? It's time for the next era: leveraging AI tools to help you build, repair and upgrade your spreadsheets. In this 4-hour in-person class in our hands-on computer lab, learn how to use Copilot, ChatGPT and Gemini to both assist and teach you how to make your Excel and Google Sheets more powerful and productive. Learn to correctly prompt AI to build accurate and more complex formulas, tables, graphs and conditional formatting. Also, learn to oversee and audit the work your AI assistant performs, because it's not perfect...yet. Excel levels 1 through 3, PivotTables and PowerPivot courses are strongly recommended, but not required. The more you know about Excel, the better you can ensure AI tools work for, not against your worksheets.