training@nievgen.com
+63 917 5639796 | +63 2 89876138
Copyright. 2019. Nievgen Management Consultancy
www.nievgen.com | training@nievgen.com
www.nievgen.com | training@nievgen.com
ADVANCED MS EXCEL AND ACCESS
Course Code: EXAC
Group: IT, Microsoft
Offer: Corporate & Public Course
Type: Practical Course
Description: The Advanced MS Excel and Access Course (Macros, VBA, SQL) aims to provide clients with the necessary knowledge, skills, tools and techniques in using Excel’s advanced formulas and functions, financial functions, pivot tables, macros, VBA and Access database, queries and forms to provide solutions for client’s needs in operations and management.
Instructor Led: Three (3) Days, 24 Hours - Classroom
Online Courseware: None
Topics:
AEXL-01. Use Excel advanced formulas and functions.
AEXL-02. Use Excel financial functions.
AEXL-03. Use Excel Pivot tables.
AEXL-04. Create Excel Macros.
AEXL-05. Use and apply VBA in Excel.
AACC-06. Create databases and tables in MS Access.
AACC-07. Learn and use SQL to build queries on database.
AACC-08. Design forms in MS Access
AACC-09. Create reports in MS Access.
AACC-10. Interface and build solutions using Excel and Access.
AACC-11. Use MS Access to build dashboards for Excel.
AACC-12. Apply MS Access advanced tips and tricks.
Software Tools & Other Reqts:
MS Excel, MS Access
Instruction Model:
Instructor Led,
90% Activities
10% Presentation
Inclusion:
Training Manual, Nievgen Certificate of Course Completion, Mock Exams
Instructor:
Sheena Malate, PMP®, PMI-ACP®
Jethro Malate
Training Fee:
PHP 15,000.00
Group: IT, Microsoft
Offer: Corporate & Public Course
Type: Practical Course
Description: The Advanced MS Excel and Access Course (Macros, VBA, SQL) aims to provide clients with the necessary knowledge, skills, tools and techniques in using Excel’s advanced formulas and functions, financial functions, pivot tables, macros, VBA and Access database, queries and forms to provide solutions for client’s needs in operations and management.
Instructor Led: Three (3) Days, 24 Hours - Classroom
Online Courseware: None
Topics:
AEXL-01. Use Excel advanced formulas and functions.
AEXL-02. Use Excel financial functions.
AEXL-03. Use Excel Pivot tables.
AEXL-04. Create Excel Macros.
AEXL-05. Use and apply VBA in Excel.
AACC-06. Create databases and tables in MS Access.
AACC-07. Learn and use SQL to build queries on database.
AACC-08. Design forms in MS Access
AACC-09. Create reports in MS Access.
AACC-10. Interface and build solutions using Excel and Access.
AACC-11. Use MS Access to build dashboards for Excel.
AACC-12. Apply MS Access advanced tips and tricks.
Software Tools & Other Reqts:
MS Excel, MS Access
Instruction Model:
Instructor Led,
90% Activities
10% Presentation
Inclusion:
Training Manual, Nievgen Certificate of Course Completion, Mock Exams
Instructor:
Sheena Malate, PMP®, PMI-ACP®
Jethro Malate
Training Fee:
PHP 15,000.00
- COURSES OFFERED
- Certified Project Management Specialist
- Certified Agile Scrum Master Course
- Prince2(R) Project Management
- Certified Professional Manager Course
- Strategic Planning & Management
- Quality Management Systems
- Professional Risk Manager Course
- Certified Quality Manager Course
- Certified Reliability Specialist
- Certificate in Applied Statistics
- Certified Lean Six Sigma Yellow Belt
- Certified Lean Six Sigma Green Belt
- Certified Lean Six Sigma Black Belt
- Accelerated LSS Green + Black Belt
- Certified LSS Master Black Belt
- Certificate in Leadership & Management
- Advanced Certificate in Leadership
- Certificate in Human Resource Management
- Professional HR Certification Course
- IT Governance and Service Management I
- Construction Management Professional
- PHP & MySQL
- Certified Full Stack Development Course
- Advanced MS Excel & Access
- Other Trainings Offered