Products
-
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
-
Excel, Accelerated: Allocate salaries
CourseTime: 4:07 | Do you need help job costing for professional services? If you would like to learn how, watch the video and download the Excel template. Techniques: XLOOKUP, ROUND, Create a PivotTable, Create and name a table, Format Painter
$4.99