Filter by Subcategory
Computer Skills
Technology Power Hour Series BTCS*0500*550
with Michael Stephens
In this 5-part training, entrepreneurs and small business owners can learn how different programs and technologies can support their businesses. At the end of this series, business owners should have more technology tools to support their business operations.
Connected: Introduction to Home Networking and Security
with Bailey Larsen
Ever feel at the mercy of your internet provider when the WIFI goes down? Time to feel empowered! In this 4-hour in-person class held in our hands-on computer lab, we will give you a tour of your home networking hardware, followed by an explanation of best practices and securing human vulnerabilities, and we’ll finish up with VPNs and smart home devices. Course textbook is included.
MS Excel Level 1 BTCS*0101*603
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.
MS Excel PivotTables BTCS*0104*601
with Michael Stephens
Got data? "...sometimes it's hard to know where to start, especially when you have a lot of data." (Microsoft quote) 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 clicks. In this 4-hour in-person class, held 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. Leave with skills to take your pile of data and feed it into PTs and PCs for useful data analysis.Books provided. While not required, completing Excel Levels 1-3 are recommended to get the most out of this course.
Introduction to AI BTCS*0110*601
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 Power Pivot BTCS*0105*601
with Michael Stephens
Ready to "power-up" and perform more advanced data modeling and analytical capabilities beyond traditional PivotTables? This 4-hour in-person course offers comprehensive instruction in Excel's Power Pivot add-in. Conducted in our hands-on computer lab, you'll gain expertise in Power Pivot's mighty features for processing, transforming, and summarizing large datasets, including utilizing the Power Pivot Data Model. Key topics include navigating the Power Pivot interface, managing data relationships for dynamic reporting, creating calculated fields, columns, and KPIs, applying CUBE functions to access multidimensional database information, and an introduction to DAX date and time functions for advanced time-based calculations. Upon completion, you'll be more equipped to efficiently interpret complex data and deliver informative reports that support sound business decisions. Books provided. Prior completion of Excel Levels 1-3 and PivotTables are highly recommended to get the most out of this course, but not mandatory.
Excel AI Assist BTCS*0107*601
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.
Acrobat PRO BTCS*0130*600
with Michael Stephens
Ready to create, edit and turbo-charge PDFs with pro features? This comprehensive 7-hour in-person course, conducted in our hands-on computer lab, provides advanced training in Adobe Acrobat Professional. You'll develop proficiency in creating, editing, and combining PDFs; implementing advanced features such as bookmarks, links, buttons, multimedia elements, watermarks, comments, markup, shared reviews, interactive forms, digital signatures, security, conversions, and optimization. Course textbook is included. Must have access to an Acrobat Pro subscription, to use in class for learning activities.