Microsoft 365 for Everyday Broadcast Work

Use it for: program preparation, copy checks or a shift checklist. This lesson uses the in-cell Checkbox feature in current Microsoft 365 Excel, rather than older Developer-tab form controls.

1. In row 2, enter these headers: B2: Program or Task; C2: Assets; D2: Metadata; E2: Copy; F2: Timing; G2: Approved; H2: Progress. Add your first task in B3 and additional tasks in the rows below.
2. Select the task cells in columns C through G, for example C3:G12. Choose Insert → Checkbox. If Checkbox is unavailable, check your Excel version and updates; this lesson requires that feature.
3. Check a box when that step is complete. Checked cells have the value TRUE; unchecked cells have the value FALSE.
4. In H3, enter this formula to show one solid block per completed step:

   =REPT("█",COUNTIF(C3:G3,TRUE))

   COUNTIF counts the checked cells in C3:G3. REPT repeats the block that many times. Three completed steps produce three blocks; all five produce five.

5. Press Enter. Select H3 and drag its bottom-right fill handle down through your task rows. Each row’s formula will use that row’s checkboxes. Widen column H and optionally make the text green.
6. For a numeric percentage, add a Percent complete header in I2, enter the formula below in I3 and format it as Percentage. Fill it down as well:

   =COUNTIF(C3:G3,TRUE)/COLUMNS(C3:G3)

   For five steps, three checked boxes equal 60%. If you change the step columns, update both formulas’ ranges.

7. Test the tracker by checking and unchecking a box. Confirm the blocks and percentage update, then save the workbook.

The block indicator is text, not a conditional-formatting data bar. It measures completed checklist items; it does not measure time spent or verify that a task was performed correctly. Some regional Excel settings use semicolons instead of commas in formulas.

Microsoft: in-cell checkboxes ↗ · REPT reference ↗ · COUNTIF reference ↗

Use it for: bringing an accessible published schedule or resource table into Excel without pasting a jumble of text. These steps describe Excel for Windows desktop; connector availability varies by platform and version.

1. Open the source page in your browser and copy its full URL. The video uses a weather table; the same approach can work with a readable broadcast schedule table.
2. Open a workbook and choose Data → From Web. Depending on your ribbon, use Data → Get Data → From Other Sources → From Web.
3. Paste the page URL, select OK and provide any connection details requested for that source.
4. In Navigator, select the suggested tables one at a time and inspect their previews. Choose the table containing the rows and columns you need.
5. Choose Transform Data to remove unwanted columns, promote the correct headers and set data types. Keep House IDs as Text and check date/time formats before loading.
6. Choose Close & Load after transforming, or Load directly from Navigator if the preview is already correct. Excel places the results in a table.
7. To request updated data later, choose Data → Refresh All. Check the source date and row count after each refresh. Refresh is requested by you here; this is not an automatically live schedule.

Some websites do not expose usable tables, require sign-in, or load their content in a way this connector cannot read. If no useful table appears, use the source’s CSV/Excel export or, where available, Add Table Using Examples. Website layout changes can break an existing query.

Microsoft: import data with the Web connector ↗

Build on the checkbox lesson: use one row for each program episode or movie version intended for a particular channel, platform and airing. Separate rows when versions, rights or destinations differ, so one checked box does not imply that every version is ready.

1. Set up your program tracker

In row 2, enter these columns. Put your first program record in row 3.

Select C3:I12 for ten program rows, then choose Insert → Checkbox. Use the same in-cell Checkbox feature described in the earlier lesson.

2. Define what each completed stage means

Check a stage only after its owner has verified the applicable requirements. The checklist records decisions; it does not perform those checks for you.

These are example completion criteria. Use your operation’s approved specifications and sign-off rules. Work can happen in parallel; checking a stage does not automatically approve the next stage or authorize transmission.

3. Update the formulas for seven stages

In J3, enter:

=REPT("█",COUNTIF(C3:I3,TRUE))

In K3, enter the following and format the cell as Percentage:

=COUNTIF(C3:I3,TRUE)/COLUMNS(C3:I3)

Fill both formulas down through the program rows. Seven checked stages produce seven blocks and 100%. Each stage contributes equally; this percentage is not a risk score or an on-air approval.

4. Try a fictional program example

Mountain Stories · Episode 104 · Broadcast version TV-PG · 22:00 · Asset MS104-TV · Linear Channel A · planned October 20, 2026, 7:00 p.m. America/Denver. These are sample values, not a real program or rights record.

Rights, metadata, versions, media QA and format have been verified. Commercials/barter and scheduling remain unchecked. The tracker shows five blocks and 71% when the percentage is displayed with no decimal places.

In Open issue / Next action, write: “Required barter spot has not been received; confirm its media ID and duration before finalizing the log.” Assign an action owner and due time. When the spot is received and its obligations are verified, check Commercials / Barter: progress becomes six blocks and 86%. After the schedule/log is reviewed and recorded, check Scheduling: progress becomes seven blocks and 100%.

5. Use it for the daily handoff

Select the complete tracker range and use Ctrl+T to make a table. Confirm it has headers. Filter Percent complete below 100%, then filter Action owner or sort the due times to find the next work. Keep the version, destination and evidence visible during review. If a version changes or a rights/QA issue reopens, clear the affected checkboxes and update the next action.

For larger operations, keep a separate stage-detail sheet with one record per program/version and stage, including owner, status, reviewed date and evidence. The compact tracker can serve as the overview.