Productivity

Complete sales analysis workbook

Category: Productivity
Platform: Windows
Length: 21 min
Resolution: 1920 × 1080
Software: Microsoft Excel

Samples play on a computer

21min

280clicks

324keys

Microsoft Excel · Windows

00:00 / 21:12

Events1,054

00:01.784Typed"PRODUCT("

00:09.066KeyI

00:11.468Typed"H2,I2,"

00:20.099Key1

00:21.842Key-

00:24.421Typed"J2"

00:25.828KeyEnter

00:27.789Click1024, 385

00:28.322Move1024, 386 → 1142, 407

00:29.239Move1140, 407 → 1119, 407

00:30.093Click1119, 407

00:30.166Drag1120, 407 → 1083, 987

00:31.739Drag1083, 988 → 1083, 999

00:32.247Drag1085, 1002 → 1084, 1031

00:32.738Drag1084, 1029 → 1103, 949

00:34.422Move1099, 949 → 1227, 768

00:35.069Click1227, 768

00:35.290Move1226, 768 → 1122, 713

00:35.786ScrollUp

00:36.243Move1122, 712 → 1064, 384

00:37.601Click1064, 384

00:37.790Move1064, 384 → 1065, 392

00:38.405Click1065, 392

00:38.516Drag1066, 395 → 1030, 1002

00:39.851Drag1030, 1003 → 1030, 1024

00:40.365Drag1030, 1021 → 1046, 943

00:41.602Move1046, 941 → 1009, 198

00:43.204Move1009, 198 → 1009, 209

00:43.804Click1009, 209

00:45.464AppMicrosoft Excel

00:46.088Move1008, 210 → 98, 458

00:47.609Click98, 458

00:49.413Move98, 459 → 110, 483

00:50.015Click110, 483

00:50.951Move110, 482 → 580, 972

00:52.496Click580, 972

00:53.015Move583, 971 → 1176, 393

00:55.188Move1173, 388 → 1164, 388

00:56.236Click1164, 388

00:56.553Move1165, 386 → 1165, 385

Loading events

Narration121

00:00
Entered the beginning of a PRODUCT formula in cell K2, typing `=PRODUCT(` and starting the first argument.
Calculate the revenue value for the first spreadsheet row.
00:09
Continued editing the PRODUCT formula in K2, entering and correcting cell references and moving through the function arguments.
Build a formula for the first row's revenue calculation.
00:18
Added the remaining arguments and completed the formula in K2, then confirmed it; Excel displayed 123500 in the Revenue_KES column.
Calculate first-row revenue using units, unit price, and the discount adjustment.
00:28
Dragged the fill handle to copy the revenue formula down the Revenue_KES column, populating the visible rows, then selected the column's values.
Apply the revenue calculation to the other sales records.
00:45
Opened Format Cells for the selected revenue values and chose the Currency category with Ksh as the symbol.
Format the revenue figures as Kenyan shilling currency.
00:52
Returned to the worksheet with the revenue values displayed in Ksh currency, then selected a small range in the Cost_KES column.
Continue working in the cost column after formatting the revenue values.
01:04
Selected the Currency category in the Format Cells dialog for the selected Cost_KES and Profit_KES columns, then clicked the dialog’s lower button to apply the formatting.
Set a currency number format for the selected cost and profit columns.
01:11
Returned to the worksheet, selected the first Cost_KES cell, and began entering a formula with an equals sign followed later by the letter H.
Start calculating the first row’s cost from worksheet data.
01:22
Continued editing the formula in L2, entered 2 after the existing equals sign and H reference, then deleted two characters and began typing P.
Construct a formula for the first row’s cost.
01:33
Typed R and O to extend the formula text to =PRO, then pressed Tab and entered H2 followed by a colon while continuing the formula.
Build a PRODUCT formula using the row’s worksheet values.
01:44
Added I2 to the formula range, closed the parenthesis, and pressed Enter to commit it in L2.
Calculate the first row’s Cost_KES value from H2 through I2.
01:51
Clicked the Profit_KES cell M2, then clicked back on the completed Cost_KES cell L2.
Move between the first-row profit and cost cells in the worksheet.
02:00
Dragged the fill handle down the Cost_KES column to copy the formula from L2 through the remaining data rows.
Calculate cost values for each sales record.
02:10
Finished extending the Cost_KES formula through the final row, then scrolled through the worksheet and selected the Profit_KES column to begin a formula.
Complete cost calculations and prepare the profit calculation column.
02:20
Typed a cell reference and a minus sign while editing the formula in the first Profit_KES cell.
Set up a profit calculation using the revenue and cost values.
02:29
Entered `K2` to complete the formula as `=L2-K2`, pressed Enter, and dragged the fill handle down the Profit_KES column.
Calculate profit values across the sales records.
02:41
Clicked worksheet cells and scrolled through the filled Profit_KES results, then selected the profit formula cell again.
Review the calculated profit values in the worksheet.
02:50
Clicked the first Profit_KES cell to edit its formula; the cell displayed `=L2-K2` with its referenced revenue cell highlighted.
Inspect or adjust the profit calculation formula.
03:02
Scrolled through the worksheet, clicked cell G30, and typed 75 into it.
Enter 75 in a cell below the existing data.
03:12
Scrolled back up to the top rows of the table and selected cell M2 in the Profit_KES column.
Navigate to the first profit cell in the table.
03:22
Clicked the M2 formula and edited its ending, first typing a closing parenthesis; then clicked the adjacent K2 cell and typed an opening parenthesis.
Modify the formula in the first profit cell.
03:31
Continued editing the M2 formula by adding a multiplication operator and a space, then scrolled the worksheet slightly.
Extend the profit calculation formula.
03:42
Typed a dollar sign and the cell reference G30 into the unfinished formula.
Reference the value entered in G30 in the profit formula.
03:52
Pressed Enter to apply the formula, scrolled through the table, and clicked the resulting profit cell.
Calculate the profit value using the referenced cell.
04:03
Clicked the Cost_KES cell L2 to edit its formula, then clicked within the referenced Units and Unit_Price_KES cells, leaving `=PRODUCT(H2:I2)` in edit mode.
Edit the cost calculation for the first order.
04:12
Clicked and dragged around the Units cell H2 while the Cost_KES formula remained in edit mode.
Adjust or confirm the cell reference in the cost formula.
04:19
Typed an asterisk and then a dollar sign into the active Cost_KES formula.
Continue editing the cost calculation formula.
04:29
Typed `G30` after the asterisk and dollar sign, then pressed Enter to commit the formula.
Complete and enter the edited cost formula.
04:38
Repeatedly clicked the Undo control on the Quick Access Toolbar, reverting the formula edit and then undoing additional changes; the worksheet shifted to show later order rows and Profit_KES values.
Undo the recent spreadsheet edits.
04:48
Continued clicking Undo, then scrolled down the worksheet; the view returned to the top order rows with Cost_KES values visible in column L and the corresponding later Profit_KES entries cleared.
Continue reverting spreadsheet changes and inspect the worksheet.
05:00
Switched to the Excel workbook, scrolled the sheet, and selected cell A28 before beginning to enter a decimal value.
Enter a value in the blank cell below the data table.
05:10
Completed the entry in A28 as 0.5, then scrolled down and back through the worksheet while leaving that cell selected.
Set a numeric value in A28 and review the worksheet.
05:20
Scrolled back to the top of the table and selected cell L2 in the Cost_KES column, where the formula bar showed =PRODUCT(H2:I2).
Work on the cost calculation in the first data row.
05:29
Edited the formula in L2 by appending a multiplication operator, a dollar sign, and the reference A28, then pressed Enter.
Use the value in A28 in the Cost_KES calculation.
05:38
Clicked L2 to inspect its calculated value, then clicked it again to return to formula editing; the window was briefly resized.
Check and revise the first Cost_KES formula.
05:49
Edited the formula in L2, removed several characters, and pressed Enter to leave the cell. Clicked L2 again to inspect its result, then right-clicked near the worksheet's right edge.
Finalize and check the Cost_KES formula in the first data row.
06:06
Switched to Excel and right-clicked in the Cost_KES column, opening its context menu; then clicked back in the worksheet.
Work with the Cost_KES column in the order worksheet.
06:15
Dismissed the context menu, then selected cells in the Cost_KES column and entered a product formula in the first data cell; the cell displayed Ksh 130,000.00.
Populate cost values in the worksheet.
06:24
Entered numeric values in successive Cost_KES cells, confirming entries and moving down the column; the first displayed cost changed to Ksh 93,600.00 and another cell showed 3888.
Fill cost amounts for the next order rows.
06:36
Confirmed the prior entry, then typed and confirmed 48960 in the next Cost_KES cell; Excel displayed it as Ksh 48,960.00.
Continue entering cost amounts for the order rows.
06:46
Typed and corrected a value in the next Cost_KES cell, then confirmed the entry and began typing the following row's value.
Continue filling the Cost_KES column.
06:58
Completed the value in L6 as 32400 and pressed Enter, then entered 46 in the next Cost_KES cell.
Continue entering cost amounts for subsequent orders.
07:08
Entered 800 in the Cost_KES cell for order 1008, pressed Enter to move to the next row, and typed 73440 for order 1009.
Fill the Cost_KES values for successive order records.
07:17
Committed 25920 in the Cost_KES cell for order 1009, then moved down and entered 25920 for order 1010.
Continue filling Cost_KES values in the order table.
07:26
Entered 30240 and 54000 in successive Cost_KES cells for orders 1011 and 1012, then began typing 6 in the cell for order 1013.
Continue populating the Cost_KES column for the orders.
07:37
Completed the Cost_KES entry of 63360 for order 1013, then pressed Enter to advance to the next row.
Finish entering the cost value and move to the next order.
07:49
Entered 9360 in the Cost_KES cell for order 1014 and pressed Enter to move to the next row.
Populate the next order's Cost_KES value.
07:58
Entered 36720, 12960, and 20160 into successive Cost_KES cells for orders 1015 through 1017, advancing between rows with Enter.
Continue populating Cost_KES values in the order table.
08:10
Entered 140400 in the Cost_KES cell for row 18, moved to the next row, and began entering 43200 in row 19.
Fill the Cost_KES values for successive order records.
08:21
Completed 43200 in row 19, entered 47520 in row 20, then entered 61200 in row 21 and began the next value.
Continue populating the Cost_KES column.

08:34
Continued entering the next Cost_KES values, completing 51840 in row 22 and entering 50400 in row 23.
Fill costs for the next order records.
08:43
Committed the value in row 23, then entered 93600 in the Cost_KES cell for row 24.
Continue filling the Cost_KES column.
08:52
Entered 37800 in the Cost_KES cell for row 25 and scrolled the worksheet slightly downward.
Complete the next cost entry and view lower rows.
09:02
Selected the Profit_KES cell in row 2 and began typing a formula, entering an equals sign followed by K and 2.
Begin a formula in the Profit_KES column.
09:11
Entered a subtraction formula in M2 using the revenue and cost cells K2-L2, confirmed it to calculate the first profit value, then began dragging the fill handle to extend the formula.
Calculate profit from revenue minus cost in the worksheet.
09:22
Continued dragging the fill handle down the Profit_KES column to copy the formula into subsequent rows.
Fill profit calculations for the remaining order rows.
09:30
Scrolled slightly, selected the Payment_Status cell area, and began entering a value.
Set up payment-status entries in the worksheet.
09:40
Selected a seven-row range in the Payment_Status column, scrolled, and opened the Data tab.
Configure data validation for payment-status cells.
10:00
Opened the Data Validation dialog for the selected cells and opened the Allow list to choose a validation type.
Create a dropdown list for payment-status values.
10:08
Set Allow to List and typed “Paid, Pending” into the Source field.
Define the allowed payment-status dropdown options.
10:19
Edited the Data Validation list source for the Payment_Status cells, completing the entries as “Paid, Pending, Overdue,” then clicked OK to apply the dropdown list.
Set the allowed payment status options for the selected cells.
10:37
Opened the dropdown in the first Payment_Status cell and selected Paid, then opened the next row’s dropdown to continue entering statuses.
Populate payment statuses in the worksheet using the validation list.
10:47
Selected Pending for the third visible status row, then chose Paid from the dropdowns for the following rows.
Continue filling the Payment_Status column with dropdown selections.
10:58
Selected Overdue for the next status row and continued using the dropdown to enter statuses in the rows below.
Continue populating payment status values.
11:08
Selected Pending for the next status row, then chose Paid for the row beneath it and opened the following cell’s dropdown.
Fill consecutive Payment_Status cells from the allowed list.
11:18
Selected Overdue for the next status row and set the following row to Paid, then opened the dropdown in the next cell.
Continue entering payment statuses in the worksheet.
11:27
Opened successive dropdowns in the Payment_Status column and chose values for rows 14 and 15, leaving them set to Pending and Paid.
Populate payment statuses for the order records.
11:38
Opened the Payment_Status dropdown for row 16 and selected Paid.
Set the payment status for the next order record.
11:47
Selected the blank Payment_Status cell in row 17.
Continue editing payment statuses in the order table.
12:05
Opened the Payment_Status dropdown for row 17 and selected Overdue, then opened the dropdown for row 18 and selected Paid.
Fill in payment statuses for the next order records.
12:15
Continued working down the Payment_Status column through rows 19–21, opening dropdowns and choosing statuses; scrolled the worksheet slightly to reveal lower rows.
Continue entering payment statuses in the order table.
12:23
Clicked the blank Payment_Status cell in row 21.
Continue editing the order table's payment statuses.
12:35
Clicked through the status cells in column N, opening and dismissing their dropdown controls; the selected cell moved from N21 to N22, and N21 shows Paid.
Set or review payment-status values for the spreadsheet records.
12:43
Opened the status dropdowns for successive cells in column N and selected Paid for N22; then opened the dropdown for N23.
Continue setting payment statuses for the records.
12:53
Continued through the column N status dropdowns, selecting Overdue for N23 and Paid for N24, then opened the dropdown for N25.
Assign payment-status values to the remaining records.
13:01
Selected Paid in N25, then scrolled horizontally to the right side of the worksheet.
Complete the payment-status entry and view the adjacent delivery-status column.
13:10
Returned the worksheet view to the main data columns and selected O2 under Delivery_Status; the visible cells in that column remained blank.
Prepare to enter delivery-status values in the adjacent column.
13:22
Dragged to select the range in column O beneath Delivery_Status, extending the highlighted selection down the visible records.
Select delivery-status cells for a subsequent operation or entry.
13:31
Opened the Data Validation dialog for the selected Delivery_Status cells, changed Allow to List, and began entering the delivery-status options in the Source field.
Create a dropdown list of delivery statuses for the Delivery_Status column.
13:42
Continued typing the comma-separated options in the Source field, completing “Delivered” and beginning “In Transit.”
Define the available delivery-status choices in the validation list.
13:51
Finished entering the status options as “Delivered, In Transit, Delayed,” then clicked OK to apply the list validation.
Apply the delivery-status dropdown to the selected cells.
14:04
Opened the dropdown in the first Delivery_Status cell and selected Delivered, then opened the next row’s dropdown and selected Delivered as well.
Populate delivery-status values using the new dropdown list.
14:15
Selected In Transit for the next row, then chose Delivered for the following row and opened the dropdown in the next blank cell.
Continue assigning delivery statuses to the records.
14:25
Chose Delayed from the dropdown for the next row, then moved to the following blank Delivery_Status cell.
Continue filling delivery statuses from the dropdown list.
14:36
Opened the Delivery_Status dropdown for successive rows in the Excel sheet and selected values, including Delivered and In Transit; moved down to the next row.
Fill delivery-status entries for the sales records.
14:45
Continued selecting delivery statuses in successive rows, ending with Delayed in cell O11.
Continue filling delivery-status entries in the worksheet.
15:00
Selected Delivered for row 12 and continued down the Delivery_Status column to row 14, leaving the next cell active.
Continue entering delivery statuses for the records.
15:10
Selected In Transit for row 14, then continued through the next rows, entering Delivered for row 16 and moving to row 17.
Populate the remaining visible delivery-status cells.
15:20
Selected Delivered for the active Delivery_Status cell in row 16 and moved to row 17.
Continue filling the Delivery_Status column.
15:30
Opened the dropdown for row 18 in Delivery_Status and selected Delivered.
Enter the delivery status for the next sales record.
15:39
Selected successive cells in the Delivery_Status column and used their dropdown lists to set delivery values; the visible cell in row 20 changed to “In Transit.” Scrolled slightly downward.
Fill delivery statuses for the next sales records.
15:48
Continued selecting Delivery_Status cells and choosing values from their dropdown lists; row 21 shows “Delivered.”
Continue filling delivery statuses in the sales table.
15:58
Selected the next Delivery_Status cells and chose options from the dropdown list; row 23 shows “Delayed,” then opened the dropdown for row 24.
Continue assigning delivery statuses to sales records.
16:07
Chose “Delivered” for the open Delivery_Status dropdown in row 24, then selected “Delivered” for row 25. Right-clicked near the Sheet1 tab.
Complete delivery status entries for the remaining visible records and open sheet-tab options.
16:20
Opened and dismissed the Sheet1 tab context menu with right-clicks, then clicked within the worksheet.
Inspect sheet-tab options and return focus to the workbook.
16:26
Typed a new sheet-tab name, entering “Sales” and continuing with an underscore and additional characters while the tab name remained in edit mode.
Rename the worksheet tab.
16:36
Typed “ata” in the active Excel field, then clicked and dragged near the bottom of the worksheet. Excel switched to a Create Table dialog at the end of the span.
Create a table from the sales data.
16:48
Returned to the workbook, where the sales data appeared formatted as a table, then selected the Table Name field and typed “Sales.”
Name the newly created sales table.
16:59
Pressed Enter, scrolled slightly, and clicked the Sheet1 tab to open a blank worksheet. Brief application visibility changes occurred before Excel switched windows.
Move to a blank worksheet for dashboard work.
17:11
Clicked back into Excel and typed “Dashboard” to rename the blank worksheet tab.
Label the new worksheet for dashboard work.

Complete the sales-order workbook with calculated revenue, cost, and profit fields, validated order statuses, and PivotTable summaries.

Built a sales workbook with calculated revenue, cost, and profit, formatted currency fields, and added payment and delivery status dropdowns. Organized the data into a table and created PivotTables to summarize sales by product, category, region, customer, and payment status.

clip.mp4The screen recording49 MB events.jsonEvery input logged, synced to the video clock9 MB frame_events.jsonEvery input logged, synced per frame19 MB narration.jsonDescriptions of what happened, and why41 KB metadata.jsonThe session's facts2 KB

More from this set

All 21 samples →

Productivity · Windows20 min

Format heart disease dashboard

20 minPower BI Desktop

Power BI

Productivity · Windows38 min

Power BI Sales Report

38 minPower BI Desktop

Power BI

Video editing · Windows58 min

Resolve Sky Replacement

58 minDaVinci Resolve, Adobe Photoshop, Brave

DaVinci Resolve +2

All 21 samples→