Products
-
Excel, Accelerated: Combine row headers and subheaders
CourseTime: 1:15 | Would you like help naming row headers and subheaders? To learn how, watch the video and download the Excel template. Techniques: LEN, TRIM, CHOOSE, TEXTJOIN, Absolute referencing
$4.99
-
Excel, Accelerated: Name a cell according to the tab name
CourseTime: 1:29 | Would you like to name a cell according to the tab name? To learn how, watch the video and download the Excel template. Techniques: CELL, RIGHT, LEN, FIND, Group sheets, Ungroup sheets
$4.99
-
Excel, Accelerated: Summarize sales by state
CourseTime: 1:22 | Would you like to be able to summarize sales by state? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, Create and name a table
$4.99
-
Excel, Accelerated: Add a target trendline to a graph
CourseTime: 1:56 | Do you wonder how to a target trendline to a graph? If you would like to learn how, watch the video and download the Excel template. Techniques: COUNT, ROW(), ROW(reference), Create a line graph, Customize the graph title
$4.99
-
Excel, Accelerated: Create a checklist with conditional logic
CourseTime: 4:54 | Do you need help creating an in-cell dropdown list? If you would like to learn how, watch the video and download the Excel template. Techniques: Name a range, Name a module, Create a subroutine, If, Evaluate a cell value
$4.99
-
Excel, Accelerated: Clear a cell when a related column is marked complete
CourseTime: 1:18 | Do you need to manage a project status dashboard? If you would like to clear a cell when a different cell is marked complete, watch the video and download the Excel template. Techniques: DATE, IF, checkmark symbol
$4.99