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