OneDrive for the web has a Dark Mode switch in its Settings pane. It changes OneDrive's colours for you only. I keep it off while capturing screenshots, so they match the light Microsoft 365 pages around them.

A folder keeps a project's files together in OneDrive. In the browser it takes three clicks: Create or upload → Folder, a name, and Create. This guide makes the Overtime folder that holds the old overtime timesheet in a tutorial series.

Before you add people to an app, check that there are licenses left to give them. Billing → Licenses in the Microsoft 365 admin center lists every product your organization has, with how many licenses are free and how many are in use.

A blocked account keeps everything, so letting someone back in is one checkbox in the Microsoft 365 admin center. This guide unblocks Leo Martin, whose sign-in had been blocked, and shows the message that says when he can sign in again.

Changing someone's manager in the Microsoft Entra admin center isn't quite the same as setting one for the first time. The current manager stays selected when you pick the new one, so you have to remove them in the same panel. This guide moves Aisha Khan from Daniel Brooks to Olivia Bennett.

A person's department in Microsoft 365 is a field on their profile in Microsoft Entra. Apps read it, so it has to be right when someone moves. This guide changes Olivia Bennett from Sales to Emergency Department, along with her job title, and checks the saved values.

The All users list in the Microsoft Entra admin center shows names and sign-in names, but not people's job titles or departments, or whether they can sign in. Manage view → Edit columns adds those columns, so you can check a whole team on one screen instead of opening each person.

I added a time to a date with =B6+TIME(1,0,0) and Excel showed 29/03/2026, with no 01:00. The time was in the cell: its Date format just didn't show times. Excel for the web's Number Format list has no date-and-time option, but the custom format dd/mm/yyyy hh:mm shows both.

I added up a timesheet's Time worked column with SUM and got 12:15. The shifts came to 60 hours 15 minutes. The total was right, but its format, hh:mm, shows a time of day, so it dropped every whole 24 hours. The custom format [h]:mm shows 60:15.

To turn each shift's time worked into decimal hours, I multiplied it by 24. Excel showed 12:00, 00:00 and 18:00 instead of 3.5, 4 and 3.75. The numbers were right. The new column had picked up a time format, and switching it to Number fixed it.