What you'll learn
- Advanced formulas and functions (lookup, logical, statistical)
- PivotTables and PivotCharts for data summarisation
- Data validation, conditional formatting and analysis tools
- Dashboard and report building in Excel
Short Term Courses
A one-month course covering advanced formulas, functions, PivotTables and data analysis tools in Excel 2019.
Advanced Excel 2019 builds on basic spreadsheet skills to cover advanced formulas and functions, data analysis, PivotTables and charting — practical skills for reporting, budgeting and data-driven office roles.
Advanced formulas and functions (lookup, logical, statistical)
PivotTables and PivotCharts for data summarisation
Data validation, conditional formatting and analysis tools
Dashboard and report building in Excel
Two closely related fields with different day-to-day work, different tools, and different starting points for beginners.
The practical, employer-relevant skills that consistently separate job-ready graduates from those who struggle to find their first tech role.
Career pathways
Explore the skills published for this programme and the areas of work they may support. These are potential directions, not employment or placement guarantees.
Tools you'll use
Data, analytics and AI-related technology work
Based on the programme information currently published. It is not a guarantee of employment, salary or placement.
Hands-on training in Word, Excel, PowerPoint and Outlook for everyday office productivity and document automation.
Entry requirements, fees and intake dates are confirmed by the admissions team, so check the admissions page or contact the academy before you apply. Not sure whether a short course or a longer programme suits you? Compare them in Short Course or Diploma? How to Choose the Right Programme Length, or browse the full course catalogue.
A four-month course covering database design, SQL querying and data management using SQL Server 2016.
Aptech Certified Nxt Generation Professional (ACNPRO): a shared foundation in Excel, Python, R and large data management, branching into Data Science, AI & Machine Learning, or Software Testing — each ending in a Professional Diploma.