In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI’s powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Discussion Leader: Bryan Smith
AI for CPAs- How it Works and How to Apply It (LITE01/26)
Demystify the complex world of generative AI in this informative session designed specifically for CPAs. We’ll break down the nuts and bolts of how generative AI works, making the technical aspects accessible and relevant. Equip yourself with the foundational knowledge to leverage AI in your practice or business. Discussion Leader: John Higgins
Technology Excel (LITE62/20)
Microsoft Excel offers a wide range of solutions for your common data input requirements, and now tech guru and SCACPA CEO Chris Jenkins gives you the keys in this very applicable course.
Become familiar with these powerful features:
Auto Fill (a command smart enough to figure out almost any series of data you want to continue)
Quick Analysis (adds graphical elements to better describe your data)
Flash Fill (allows you to take two adjoining cells and combine them in a third)
Text to Columns (used to split data into multiple columns)
This is a must-attend for anyone looking to excel in Excel!
Discussion Leader: Chris Jenkins
Techie Bytes- Remote Work (LIOT16/23)
This session will review the newest tech for mobile employees. Participants will gain knowledge about both hardware and software solutions for mobile employees. Discussion Leader: Chris Jenkins
TechieBytes – Getting the Most from Adobe Acrobat (LIOT12/23)
This session is designed to be hands on, and we will explore the common and not so common features within Adobe Acrobat. Participants will leave this session with the skills needed to master Adobe Acrobat.
Microsoft 365 vs. Google Workspace: Which one is best for Accounting Firms (LIOT08/23)
Microsoft 365 and Google Workspace are two of the most popular choices, but which one is best for you? In this course, we will compare and contrast Microsoft 365 and Google Workspace to help you better understand the capabilities of each platform. Discussion Leader: Josh MacFarland
Power BI Basics (LIOT07/23, LIOT05/24)
We will learn how to connect to external data sources, format data in Power Query and create Visualizations in Power BI Reports. Discussion Leader: Chris D. Jenkins
TechieBytes- What’s New with Microsoft (LIOT04/23)
In this session we will explore new offering and updates in Microsoft Products. Topics include new features in Windows 11, Updates to Office 365, and more. Participants will leave this course with an understanding of current Microsoft enhancements as well as those yet to come. Discussion Leader: Christopher Jenkins
LICATE02 Excel – Working with Macros and Forms
Do less and get more, participants will gain an understanding of excel macros and form controls.
Enabling and examining Macros
Setting Macro Security
Triggering macros actions
Inserting Form Controls and setting properties
Excel Analyzing Data (LICATE01)
Microsoft Excel offers a wide range of solutions for your common data input requirements. Join SCACPA CEO Chris Jenkins as he gives you the keys in this very applicable course.
Building on the skills of our previous sessions, participants will gain insights into basic data analysis using Microsoft Excel. This course also covers connecting to 3rd Party data sources.
Using the Quick Analysis
Finding solutions using solver
Exploring data connectors
Discussion Leader: Chris Jenkins