Course curriculum
Four levels, a clear path through
Every learner starts where they are. Move from Beginners through to Expert at your own pace.
📘
Introduction to Spreadsheet Basics
- Understanding the purpose and use of spreadsheets
- Exploring the Excel interface and navigation
- Introduction to basic spreadsheet terminology
📙
Data Entry and Formatting
- Entering data efficiently into Excel
- Formatting cells, text, and numbers
- Basic formula creation and usage
📗
Basic Functions and Formulas
- Introduction to essential Excel functions (SUM, AVERAGE, COUNT)
- Creating basic formulas for calculations
- Understanding cell references and ranges
📕
Introduction to Charts and Graphs
- Creating simple charts and graphs in Excel
- Understanding chart types and when to use them
- Customizing charts for visual impact
📘
Advanced Formulas and Functions
- Exploring intermediate functions (VLOOKUP, IF statements)
- Using logical functions for data analysis
- Combining multiple functions for complex calculations
📙
Data Analysis and PivotTables
- Introduction to data analysis tools in Excel
- Creating PivotTables for summarizing and analyzing data
- Understanding data filtering and sorting techniques
📗
Advanced Data Visualization
- Creating dynamic and interactive charts
- Using advanced chart features and options
- Visualizing trends and patterns in data
📕
Collaborative Excel Workbooks
- Understanding workbook sharing and collaboration
- Version control and tracking changes in shared workbooks
- Effective communication and collaboration using Excel
📘
Macros and Automation
- Introduction to Excel macros for task automation
- Creating and running simple macros
- Automating repetitive tasks in Excel
📙
Advanced Data Analysis
- Using advanced statistical functions in Excel
- Performing scenario analysis and goal seeking
- Data forecasting and trend analysis techniques
📗
Database Management in Excel
- Understanding database concepts in Excel
- Creating and managing databases with Excel
- Advanced filtering and data retrieval techniques
📕
Financial Modeling in Excel
- Building financial models using Excel
- Performing financial analysis and scenario modeling
- Understanding and using financial functions in Excel
📘
Business Intelligence with Power BI
- Introduction to Power BI for advanced data visualization
- Creating interactive dashboards and reports
- Integration of Excel with Power BI for comprehensive analytics
📙
Excel for Decision Support
- Using Excel for decision support and strategic planning
- Scenario modeling for business decisions
- Risk analysis and sensitivity analysis in Excel
📗
Advanced Excel Automation
- Advanced techniques for Excel automation and scripting
- Integration with external data sources and APIs
- Customizing Excel solutions for complex business needs
📕
Professional Excel Applications
- Developing custom applications using Excel
- Creating user forms and interactive interfaces
- Building professional-grade solutions for diverse business needs
Explore more
Quick links
ℹ️
About Us
Learn more about AAIS and the services we offer.
🧑🏫
Teach at AAIS
Explore teaching opportunities and join our tutor network.
✉️
Contact Us
Reach out to us for enquiries and support.
📄
Terms & Conditions
Read our policies for classes, bookings and payments.
🔒
Privacy Policy
Learn how we protect your personal information.
Ready to Experience a Class Before You Begin?
Book a FREE 30-Minute Trial Class in your chosen subject. Meet your tutor, experience the teaching style, and explore how AAIS works before you get started.
✓ 30-Minute Free Trial
✓ Meet Your Tutor
✓ Experience the Class
BOOK YOUR FREE TRIAL CLASS →
Fill in your details to request your free trial class. Our team will contact you to confirm the arrangements.