ACE316 Intermediate Excel-ling
Program start date | Application deadline |
2024-10-05 | - |
Program Overview
This blended learning program in Excel Advanced Formulae and Analysis provides comprehensive training in advanced Excel techniques, including complex formulae, statistical functions, pivot tables, macros, and data manipulation. Graduates are well-prepared for careers in data analysis and reporting, such as Data Analyst, Business Analyst, and Financial Analyst. The course is offered in Nelson, New Zealand, for a fee of $77.00.
Program Outline
Outline:
Indicative course content:
- Assess knowledge and ability of formulae creation as a group
- Introduce progressively complex formulae iterations:
- Simple formulae
- Nested formulae
- Multi-sheet formulae
- AI-generated solutions
- Linked workbooks
- Linked external documents
- Use various statistical, logical, financial functions
- Record, edit and run macros in complex scenarios
- Basic relationship with database management including csv file importing and management
- Manipulation of data for mail merging
- Create and use templates
- Use Trace Precedents and Trace Dependents
Teaching:
- The course is delivered in a blended learning format, with a mix of online and face-to-face sessions.
- The online sessions are delivered via Moodle, the Institute's learning management system.
- The face-to-face sessions are held on Saturdays, from 9am to 1pm, in Room G101.
- The course is taught by experienced and qualified instructors.
Careers:
- Graduates of this course will be well-prepared for a variety of careers in the data analysis and reporting field.
- Some potential career paths include:
- Data Analyst
- Business Analyst
- Financial Analyst
- Market Research Analyst
- Statistician
Other:
- The course is designed to be challenging but rewarding, both personally and from a work perspective.
- Learners should have a good knowledge of basic Excel use including tables, templates, graphs, linking, formulae, and basic use of IF functions.
- The course is offered in Nelson, New Zealand.
- The course fee is $77.00.
- The course is 2 credits.
Nelson Marlborough Institute of Technology (NMIT)
Overview:
Nelson Marlborough Institute of Technology (NMIT) is a tertiary education institution located in the Top of the South region of New Zealand. NMIT offers a range of programs designed to prepare students for work and the world, with a focus on practical experience and flexible learning options.
Services Offered:
NMIT provides a variety of services to support student success, including:
Study Navigators:
Help students design a study journey that fits their individual needs and goals.Flexible Learning:
Offers on-campus, online, and on-the-job learning options to accommodate diverse student lifestyles.Foundation Pathways:
Provides foundation and pathway studies to help students gain direction and qualifications for their chosen career.School Pathways:
Offers practical experience on-campus or in workplaces, allowing students to complete NCEA at school simultaneously.Scholarships:
Provides financial assistance to help students cover the cost of their studies.eduroam:
Provides secure wireless internet access for students.Library:
Offers a range of resources and support services for students.Research:
Conducts research in various fields, contributing to knowledge and innovation.Business and Employers:
Provides resources and support for businesses and employers.Student Life and Campus Experience:
NMIT offers a vibrant campus experience with opportunities for students to engage in various activities and events. The institution has campuses across Te Tauihu, Top of the South, designed with the learner in mind and supported by learner services.
Key Reasons to Study There:
Practical Experience:
NMIT emphasizes practical experience, providing students with the skills and knowledge they need to succeed in their chosen field.Flexible Learning Options:
Offers a variety of learning options to accommodate diverse student needs and lifestyles.International Qualifications:
Provides internationally respected qualifications.Supportive Campus Environment:
Offers a supportive and welcoming campus environment with a range of services to support student success.Academic Programs:
NMIT offers a wide range of academic programs, including:
Nursing:
NMIT offers a Bachelor of Nursing program, with a focus on practical skills and real-world experience.Aviation Engineering:
NMIT offers a program in Aviation Engineering, providing students with the skills and knowledge they need to work in the aviation industry.Horticulture:
NMIT offers a program in Horticulture, providing students with the skills and knowledge they need to work in the horticulture industry.Organisational Management:
NMIT offers a Master of Applied Management program, providing students with the skills and knowledge they need to lead and manage organizations.Other:
NMIT is committed to providing students with the skills and knowledge they need to succeed in their chosen field. The institution is also committed to research and innovation, contributing to the development of new knowledge and technologies.
Student Life and Campus Experience:
While the context mentions campuses across Te Tauihu, it does not provide details about student life and campus experiences.Key Reasons to Study There:
The context mentions practical experience and flexible learning options, but it does not explicitly state these as key reasons to study at NMIT.Academic Programs:
The context mentions specific programs like Nursing, Aviation Engineering, Horticulture, and Organisational Management, but it does not provide a comprehensive outline of all academic programs offered.Entry Requirements:
Domestic Students:
- Age Requirement: Must be 16 years of age or older.
- ID Verification:
- New to NMIT: Provide a verified copy of ID upon application or National Student Number (NSN).
- Unverified NSN: Submit a verified copy of ID.
- Full-time Secondary School Students:
- Meet all of the following:
- 16 years of age or older
- Attend the course outside of normal school hours
- Obtain approval from school principal (or home school supervisor for homeschooled students)
- Email documents to enrolments@nmit.ac.nz
International Students:
- Residency: Must reside in New Zealand.
- ID Verification:
- New to NMIT: Provide a verified copy of ID including visa upon application or National Student Number (NSN).
- Unverified NSN: Submit a verified copy of ID.
- Insurance Requirement: Must pay for insurance to attend the course.