Microsoft Excel
Events
-
-
Excel Power BI (Session 3 of 3)
OnlineIn this class, users will learn about and practice using Power BI. Users will learn how to: Connect to data sources. Perform data cleaning, profiling, and shaping. Visualize data with Power BI. Create interactive visualizations. Enhance reports and dashboards. Publish and share reports and dashboards. NOTE:…
-
Excel Macro and VBA (Session 1 of 2)
OnlineAdvance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual Basic for Applications (VBA) which allows you to customize Excel to…
-
Excel Macro and VBA (Session 2 of 2)
OnlineAdvance your Excel skills by learning VBA/Macros. In this class you will first become familiar with recording repetitive steps with Macros, then altering code, and learning about VBA scope. Then, you will experience Visual Basic for Applications (VBA) which allows you to customize Excel to…
-
-
Excel Power Pivot (Session 1 of 2)
OnlineAdvance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use DAX functions in PowerPivot. Distribute PowerPivot Data. Attendance is required for…
-
Excel Power Pivot (Session 2 of 2)
OnlineAdvance your Excel skills with learning Power Pivot. In this class you will: Become familiar with the PowerPivot application and import data. Manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data. Use DAX functions in PowerPivot. Distribute PowerPivot Data. Attendance is required for…
-
-
Excel: Introduction to Data Analysis Session 2
OnlineThis course is an essential Excel tools for data‑driven work, and is Ideal For Beginners to intermediate Excel users and administrative staff. What You’ll Learn Cleaning and preparing data Tables, sorting, and filtering Basic formulas Charts and visual summaries Intro to PivotTables Software Requirements Microsoft Excel (Microsoft…
-
-
Excel: Advanced Data Analysis (Session 1 of 2)
OnlineLearn advanced Excel methods for deeper insights, and is Ideal Intermediate Excel users and analysts. What You’ll Learn: • Advanced PivotTables • Lookup functions (XLOOKUP, INDEX/MATCH) • Trend and forecasting tools • Scenario analysis • Data modeling concepts Software Requirements Microsoft Excel (Microsoft 365 desktop version)…
-
Excel: Advanced Data Analysis Session 2
OnlineLearn advanced Excel methods for deeper insights, and is Ideal Intermediate Excel users and analysts. What You’ll Learn: • Advanced PivotTables • Lookup functions (XLOOKUP, INDEX/MATCH) • Trend and forecasting tools • Scenario analysis • Data modeling concepts Software Requirements Microsoft Excel (Microsoft 365 desktop version)…

