Excel
Events
-
-
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 Power Pivot (Session 1 of 2)
OnlineVirtual EventLearn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft Excel (Microsoft 365…
-
Excel Power Pivot (Session 2 of 2)
OnlineLearn Data modeling and BI fundamentals using Excel, and is ideal for Analysts and staff working with large datasets. What You’ll Learn • Data modeling • Relationships • DAX calculations • Measures and KPIs • PivotTables from data models Software Requirements Microsoft Excel (Microsoft 365…
-
Excel Intermediate/Advanced (Session 1 of 2)
OnlineLearn High level Excel skills for analysis and reporting., and is ideal For Experience Excel users and analysts. What You’ll Learn • Advanced formulas and functions • Conditional formatting • Data validation • PivotTables and PivotCharts • Forecasting tools • Dashboards and slicers Software Requirements…
-
Excel Intermediate/Advanced (Session 2 of 2)
OnlineLearn High level Excel skills for analysis and reporting., and is ideal For Experience Excel users and analysts. What You’ll Learn • Advanced formulas and functions • Conditional formatting • Data validation • PivotTables and PivotCharts • Forecasting tools • Dashboards and slicers Software Requirements…
