training@nievgen.com
+63 917 5639796 | +63 2 89876138
Copyright. 2019. Nievgen Management Consultancy
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