Virtual Executive Assistant with Strong Spreadsheet Skills (Required Skills Assessment)

Posted yesterday

Worldwide

Summary

READ THIS FIRST: Only proposals that include our completed skills assessment will be reviewed. Details below. Proposals without a working video link will be declined without being read. We're a US-based consumer products company (fishing tackle, e-commerce and retail). Our CEO needs a sharp, detail-oriented virtual assistant for approximately 20 hours per week, with room to grow. What you'll own: - Executive admin support: inbox triage, calendar management, scheduling across US time zones, travel booking, expense tracking, and document organization in Google Drive - Data and reporting support: maintaining spreadsheets, pulling and formatting recurring reports, order and inventory data entry, and keeping pipeline trackers up to date Tools we use: Google Workspace (Gmail, Calendar, Drive, Sheets), Slack, Shopify. Experience with any of these is a plus. Strong Google Sheets or Excel skills are non-negotiable, which is why we ask every candidate to complete a short assessment before we review anything else. REQUIRED SKILLS ASSESSMENT (5-10 minutes of work, unlimited prep time): 1. Open the spreadsheet here: https://drive.google.com/file/d/1R_DiAp6wkcoL73Ra0-siiR4-7qtwzdG2/view 2. Make your own copy or download it. 3. Review the Instructions tab. There are 4 tasks: three PivotTables and one VLOOKUP. 4. Record your screen with audio while you complete the tasks. Narrate what you're doing and why. Recording must be 10 minutes or less. Most people finish in 5 to 8. 5. Upload the recording to Loom, Google Drive (set to "Anyone with the link"), or YouTube (unlisted). 6. In your proposal, paste (a) the public link to your video and (b) a view-only link to your completed spreadsheet. Disqualifiers: no publicly accessible video link, tasks not completed, or video longer than 10 minutes. Retakes are fine; submit one final version. We review every submission that follows the instructions. This assessment is our first interview, so treat it like one. Requirements: - Excellent written English - Strong Google Sheets / Excel: PivotTables, VLOOKUP, clean formatting - Reliable internet and a quiet environment for calls - Available for at least 3 hours of overlap with US Central Time - High attention to detail. To show us you read this far, begin your proposal with the word TACKLE.

  • Less than 30 hrs/week
    Hourly
  • 6+ months
    Duration
  • Intermediate
    Experience Level
  • $8.00

    -

    $12.00

    Hourly
  • Remote Job
  • Ongoing project
    Project Type
Skills and Expertise
Mandatory skills
Google Sheets
Microsoft Excel
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:7 hours ago
  • Interviewing:
    2
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Sep 27, 2023
  • United States
    Boston6:57 AM
  • $15K total spent
    9 hires, 6 active
  • 1,785 hours
  • Retail & Consumer Goods
    Mid-sized company (10-99 people)

Explore similar jobs on Upwork

Social Media Marketing
Social Media Management
Graphic Design
Video Editing
Content Strategy
Digital Marketing
Social Media Account Setup
Social Media Marketing
Facebook
Twitter/X Marketing
Internet Marketing
TikTok
TikTok Marketing
Instagram
Reddit
Reddit Marketing
SEO Backlinking
SEO Keyword Research
Marketing Strategy

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo