Copyright. 2019. Nievgen Management Consultancy
www.nievgen.com | firstname.lastname@example.org
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
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
Training Manual, Nievgen Certificate of Course Completion, Mock Exams
Sheena Malate, PMP®, PMI-ACP®
+63 917 5639796