This workshop is an introduction to working with data in Excel. Students will learn spreadsheet terminology, the basics of the Excel interface, how to create and edit spreadsheets, and how to generate charts and graphs …
Excel
Excel 2: Boost Your Excel IQ: Mastering Functions
This workshop expands on the material in Excel 1 and introduces a wider array of built-in functions to make working with data easier. Topics include: Logical functions including COUNT and COUNTIF Lookup, array, and summary …
Excel 2: Data-Driven Excel: Unlocking Insights with Analysis Tools and Techniques
This workshop introduces more advanced analysis tools that can be used to summarize data, perform complex calculations, and maximize the computing power of Microsoft Excel. Topics covered: Input Tables Subtotal Goal Seek Solver Analysis ToolPak
Excel 3: Macros and VBA
This workshop covers the basics of automating excel with macros using Visual Basic for Applications (VBA). This course will utilize Excel but the knowledge can easily transfer to other programs that have VBA capabilities. This …
Excel 2: Painting with Numbers: Visualizing Data with Excel
This workshop introduces visual formatting options options to make your data and spreadsheets presentable. It also introduces many useful features that allow you to look at your quantitative data in a more visual and qualitative …