Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Expense Report: Category Totals and MileageLabFree
  2. Timesheet: Turning Clock Times into HoursLab Locked
  3. Contact List Cleanup: TRIM, PROPER and Joining NamesLab Locked
  4. Deadlines in Workdays: WORKDAY and NETWORKDAYSLab Locked
  5. Attendance Tracker: Counting Codes with COUNTIFLab Locked
  6. Supplier Quotes: Best Price and Who Offers ItLab Locked
  7. Petty Cash Log: Running Balance and Cash CountLab Locked
  8. Meeting Rooms: Bookings, Hours and UtilisationLab Locked
  9. Business Trip Budget: Totals and an Approval CheckLab Locked
  10. Event Budget: Per-Guest Costs, Contingency and Cost per HeadLab Locked
  11. Vacation Planner: Leave Days, Balances and ChecksLab Locked
  12. Mid-Course Project: Office Cost Dashboard with Totals, Chart and HighlightsLab Locked
  13. Office Supplies: Months of Cover, Reorder Flags and the Order ListLab Locked
  14. Purchase Order Log: Open, Overdue and Received OrdersLab Locked
  15. Staff Directory: Extensions, Rooms and Reverse Lookups with XLOOKUPLab Locked
  16. Name Lists: Splitting “Last, First”, Building Emails and InitialsLab Locked
  17. Mileage Log: Miles per Person and Month with SUMIFS and a Two-Tier RateLab Locked
  18. Sharing Office Costs: Recharging Rent and Services to TeamsLab Locked
  19. Service Contracts: Term Ends, Notice Deadlines and Renewal AlertsLab Locked
  20. Final Project: Year-End Office Budget Review – Variances, Status and a Budget vs Actual ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy