Products
-
Excel Accelerated: Automatically check off each process step after a macro runs
CourseTime: 00:01:31 | Techniques: Checkbox character, use VBA to set a cell value | Do you need to visually keep track of your progress through a multi-macro process? Watch the video and download the Excel template to learn how.
$4.99
-
Excel Accelerated: Summarize allocated payroll without using a PivotTable
CourseTime: 00:01:56 | Techniques: GROUPBY, HSTACK, Create and name a table | Do you need to summarize your allocated payroll by G/L account and job without using a PivotTable? Watch the video and download the Excel template to learn how.
$4.99
-
Excel Accelerated: Summarize detailed data without using a PivotTable
CourseTime: 00:01:35 | Techniques: GROUPBY, Create and name a table | Do you need to summarize data but are tired of dealing with PivotTable problems? Watch the video and download the Excel template to learn how.
$4.99
-
Excel Accelerated: Make GROUPBY rows as flexible as a PivotTable
CourseTime: 00:01:27 | Techniques: GROUPBY, CHOOSECOLS, MATCH, In-cell drop-down list | Do you want to change the row headers in your GROUPBY data as quickly as you can in a PivotTable? Watch the video and download the Excel template to learn how.
$4.99
-
Excel Accelerated: Change column references from static to dynamic
CourseTime: 00:01:21 | Techniques: CHOOSECOLS, MATCH | Do you need to stay on top of selected columns in your source data even if they change position next time you use it? Watch the video and download the Excel template to learn how.
$4.99
-
Excel Accelerated: Eliminate unnecessary columns while preserving source data
CourseTime: 00:01:02 | Techniques: CHOOSECOLS, Create and name a table | Are you dealing with exports with way too many columns and just need to focus on a select few? Watch the video and download the Excel template to learn how.
$4.99