Visual Basic for Applications VBA for Microsoft Excel Advanced Techniques

Add a header to begin generating the table of contents

Visual Basic for Applications VBA for Microsoft Excel Advanced Techniques

This hands-on series covers these eight topics:

Cohort Analysis. Practice Cohort Analysis in VBA during this first topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

From Wikipedia:

Cohort analysis is a subset of behavioral analytics that takes the data from a given data set and rather than looking at all users as one unit, it breaks them into related groups for analysis.

These related groups, or cohorts, usually share common characteristics or experiences within a defined time-span.
Data Tables Multiplication.

Practice performing data tables multiplication in VBA during this second topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.
Ranges using VBA.

Practice working with ranges using VBA during this third topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

Workbook-level Events using VBA.

Create workbook-level events using VBA during this fourth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

Additional Events using VBA.

Create additional events such as sheet-level events using VBA during this fifth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

VBA Advanced Filters.

Apply advanced filters in VBA during this sixth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

Follow along with Hassan in this hands-on session.

VBA Pivot Table Macro.

Create a macro to build pivot tables in VBA during this seventh topic in the Visual Basic for Applications (VBA) for Microsoft Excel series.

Follow along with Hassan in this hands-on session.

Charts using VBA. Create charts using VBA during this eighth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.