Excel for Office Administrators & Assistants: 20 Everyday Office Tasks
20 hands-on labs for office managers, admins and assistants: expense reports, timesheets, contact list cleanup, workday deadlines, attendance, supplier quotes, petty cash, room bookings, travel and event budgets, vacation planning and a cost dashboard – plus supply reorder lists, a purchase order log, staff directory lookups, name and email lists, a mileage log with a two-tier rate, shared cost recharges, contract notice deadlines and a year-end budget review. Every cell checked instantly.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
Excel for Office Administrators & Assistants turns the tasks that land on an office desk every week into 20 interactive labs. You total expense reports with SUMIF and calculate mileage, turn clock times into hours, clean contact lists, count workday deadlines with WORKDAY and NETWORKDAYS, track attendance, compare supplier quotes, keep a petty cash book, measure meeting room use and plan trip, event and vacation budgets. The second half goes further: a supplies list with months of cover and min/max reorder quantities, a purchase order log with overdue flags, staff directory lookups with XLOOKUP, splitting “Last, First” names into emails and initials, a mileage log with SUMIFS and a two-tier rate, recharging rent and services to teams, contract notice deadlines with EDATE and a year-end budget vs actual review with a chart. Every answer is checked instantly.
Lessons
- Expense Report: Category Totals and MileageFree
- Timesheet: Turning Clock Times into Hours Locked
- Contact List Cleanup: TRIM, PROPER and Joining Names Locked
- Deadlines in Workdays: WORKDAY and NETWORKDAYS Locked
- Attendance Tracker: Counting Codes with COUNTIF Locked
- Supplier Quotes: Best Price and Who Offers It Locked
- Petty Cash Log: Running Balance and Cash Count Locked
- Meeting Rooms: Bookings, Hours and Utilisation Locked
- Business Trip Budget: Totals and an Approval Check Locked
- Event Budget: Per-Guest Costs, Contingency and Cost per Head Locked
- Vacation Planner: Leave Days, Balances and Checks Locked
- Mid-Course Project: Office Cost Dashboard with Totals, Chart and Highlights Locked
- Office Supplies: Months of Cover, Reorder Flags and the Order List Locked
- Purchase Order Log: Open, Overdue and Received Orders Locked
- Staff Directory: Extensions, Rooms and Reverse Lookups with XLOOKUP Locked
- Name Lists: Splitting “Last, First”, Building Emails and Initials Locked
- Mileage Log: Miles per Person and Month with SUMIFS and a Two-Tier Rate Locked
- Sharing Office Costs: Recharging Rent and Services to Teams Locked
- Service Contracts: Term Ends, Notice Deadlines and Renewal Alerts Locked
- Final Project: Year-End Office Budget Review – Variances, Status and a Budget vs Actual Chart Locked
Learner reviews
Be the first to review this course.