DSS are looking for an experienced Virtual Assistant with expert-level Excel skills, strong Google Drive knowledge, and confidence using ChatGPT or other AI tools.
Hours:
Part-time, 4 hours per day, Monday to Friday.
Must be flexible to work within Australian time-zone requirements.
Advanced Excel
- XLOOKUP / VLOOKUP
- INDEX / MATCH
- IF, SUMIFS, COUNTIFS
- PivotTables and PivotCharts
- Conditional formatting
- Data validation and drop-down lists
- Dashboards and KPI trackers
- Cleaning and organising large datasets
- Cross-sheet formulas
- Automated trackers and registers
- Error checking and formula troubleshooting
- Advanced filtering and reporting
- Power Query, Macros or VBA highly regarded
Google Workspace
- Google Sheets
- Google Drive organisation
- Shared folders and permissions
- File management and naming systems
- Google Docs
- Converting between Excel and Google Sheets
AI Skills
- ChatGPT or similar AI platforms
- Creating effective prompts
- Data analysis
- Excel formula assistance
- Research and summarising
- Creating reports, templates and checklists
- Reviewing AI output for accuracy
You must be highly organised, accurate, reliable, able to work independently and confident handling complex spreadsheets and business information.
When applying, please briefly describe your Excel experience, the most advanced spreadsheet you have created, your AI experience, and your availability to work Australian hours.
Please start your application with: “EXCEL EXPERT”