Complete EXCEL POWER QUERY and VBA

GENERAL CONTENT TUITION FEE TRAINERS PHOTOS

Overview

Computer skills, such as working with Microsoft software, is becoming increasingly important for office workers, especially for the accounting and auditing profession. To analyze data, they need advanced Excel skills with extensive software such as Power Query, Power BI, and VBA. Currently, there are many videos on Internet platforms teaching about these skills but you will find it difficult to get started because there are too many tutorials, and you cannot know the core knowledge needed for your job.

Who is entirely suitable for the training course

The course is aimed at those who want to equip yourself with the basic knowledge of Excel. Mainly, this course is intended for the following audiences:

Students looking for a comprehensive, engaging and interactive training method.
Administrative staff, administrators, marketing: Know how to use tools (MS Excel, Power BI) to view and design reports.
Students, fresher: Need to learn and improve knowledge.
People who have a passion for Microsoft products
People who do not have much knowledge to work with Excel software

Why should I take the course?

Purpose of the course

The goal of the “Complete Excel Training Course” course is to help learners upgrade their Excel skills to easily handle complex data. In addition, this course is aimed at capturing the Excel knowledge with a high level of expertise of the learners. Through this course, learners can easily manage and control documents. This will give learners an intuitive view from the data and provide effective ways to solve the problem.

Why should you join the course “Complete Excel Training Course” at BAC center?

The "Complete Advanced Computer Skills" course will equip you with ALL the following aspects:

Understand the types of data you encounter when working in the fields of Accounting - Auditing - Finance - Investment
Practice directly on datasets in the above industries, exposed to difficult data
Understand the basics of working with Excel and Google Sheets
Implement ways to automate data with Power Query, VBA
Easy to visualize data with diagrams
Perform dynamic reports with Pivot Tables and Power BI from simple to complex
Easy to pass exams with national computer certificates

In addition, BAC center will also provide flexible learning methods (At fixed locations such as BAC centers or partners’ company; Online or a combination of both Online and Offline) to help students acquire knowledge in the easiest and most convenient way.

Learners will also receive UNLIMITED support when encountering difficult problems in future work. BAC team will find flexible and creative ways to solve your problems and continuously update these issues in the curriculum.

What will you get after the course?

After graduating this course, students will be extremely flexible and have 3 times higher guaranteed performance before starting the course. Learners will have to perform intensive tasks and apply the skills learned in the course. Learners will be able to handle all kinds of big data in accounting - auditing and finance disciplines in an extremely flexible way; generate eye-catching reports and be highly automated. Anyone regardless of field, or department can take the course to improve your office computer skills. Trainees will be able to adapt their learned skills expertly into solving difficult tasks and improve work efficiency. In addition, this course will be a good foundation to help students have a different perspective to organize the data around them logically and improve work performance.

How are course designed?

The course will last 8 sessions - 16 hours and learners will learn the theory and practice of reporting.

In addition, the course can be customized into short-term 1-2 day training for the business, which focuses on the main parts and key parts and problems that employees often face.

Class Information:

Study location: 6th floor - Thien Phuoc 1 Building, 244 Cong Quynh, Ward Pham Ngu Lao, District 1, City. HCM. Or the specific location will be announced before the school starts.
Teaching language: Vietnamese
Document: English
Handouts: Hard copy (NO soft copy), application forms (soft copy IIBA/BAC standard).

Student Requirements

Attend the course at the right place, time and schedule as specified.
Observe classroom rules.
Have a spirit of cooperation, participate in lesson construction, work in groups with class members and lecturers.

Contact detail

Điện thoại tư vấn If you have any question, please feel free to contact us via:
Phone: (84) 909 310 768 | (84) 903 746 294
Email: info@bacs.vn | bac.trainingba@gmail.com

Contents of this course include:

Session 1: Full control of Excel and its limitations
Session 2: Use Excel's tricks to deal with difficult data and its limitations. Introduction to Power Query for data automation
Session 3: Use Power Query to solve situations that normal tricks can't handle
Session 4: Topics on DAX and some difficult data types that need to be cleaned – Part 1
Session 5: Topics on DAX and some difficult data types that need to be cleaned – Part 2
Session 6: Time Intelligence and DAX Measures in Power BI
Session 7: Visualize data with Power BI
Session 8: Decorating the charts and summarizing

FULL TUITION FEE: 7,300,000 VND

The tuition fee includes materials and certification.
Materials are included notebook or/and pen.
Tuition fee IS EXEMPT from value added tax (VAT).

DISCOUNT POLICY

10% discount on tuition fee if the students register for the course and payment is received ten days in advance.

PAYMENT

Students can choose 1 of the following payment methods:

Payment in cash

BAC TRAINING AND CONSULTANCY JOINT STOCK COMPANY

Headquarter: 6th Floor, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCMC.
Branch: 11th Floor, 39B Truong Son Street, Ward 4, Tan Binh District, HCMC.
Email: info@bacs.vn or bac.trainingba@gmail.com
Hotline: (84) 909 310 768 | (84) 903 746 294

Payment by cards

BAC accepts new payment method: Convenient payment using mPOS device:

Payment by swiping ATM and international cards directly at the BAC office.
Payment by Internet Banking / Mobile Banking / Electronic Wallet (E-Wallet) / QR-code.
Easy payments from anywhere with the payment link.
Payment by credit card, installment with 0% interest.

Fee: card fees MUST BE PAID by the customer when paying by card. The consultant will estimate the card fee according to the fee schedule given by mPOS and provide a concrete estimate for the student to consider before paying. For additional details on how to incorporate the mPOS payment solution, please visit this link.

Payment by Transfer

Account 1: Tien Phong Bank
- Account number: 01236879001
- Account name: CTY CO PHAN DAO TAO VA TU VAN BAC
- Tân Bình Branch

NOTES:

Students shall complete the payment in advance, and not later than the opening session. BAC does not accept any payment after the opening day.
Exceptions: In cases of faulty payment process or students have committed to pay tuition fee after the opening day, BAC will accept as exceptions.

OTHER PROVISIONS

Reserve registered courses

After register and pay the tuition fee for the course, if students can not join the course, they should have an official notification to BAC before the opening session. In this case, students will be reserved tuition and join the next course or switch to another BAC course in suitable requirements.

Opening Schedule Changes

In case of course could not start on schedule, BAC will send an email to inform the student of the expected opening day.
If the new opening schedule is suitable for students' needs, BAC will reserve tuition fee. Students will continue to participate in the course.
If the new opening schedule does not meet students' needs, BAC will refund the tuition fee.

Refund Policy

Tuition fees ARE NOT REFUNDED.
In case of our student cannot join the new class schedule due to a change from BAC in terms of changing the course opening schedule, that student will be refunded the tuition by BAC according to the following process:
- Students can receive a refund by transfer or in cash.
- After the two sides have officially confirmed the cancellation of the course, the entire tuition will be refunded to students by BAC within a maximum of 3 working days.
- Students must return the receipt of tuition to BAC to complete the refund procedure.

Any information or support related to payment - PLEASE CONTACT US VIA:

Hotline: 0903 746 294 or Email: phungtran@bacs.vn.

Nguyen Ky Quan

Head Teacher for TOEIC, IELTS, Power BI & Excel

Mr. Nguyen Ky Quan graduated with a bachelor's degree in Corporate Finance from the University of Economics Ho Chi Minh City. When he was in school, he excellently won many prestigious awards such as "Second Prize of Akkology-Prestigious prize for students in Finance and Accounting" & "First prize in Research awards: UEH500 and Young Economics".

After graduation, he started working as an Audit Assurance Associate at Ernst & Young Limited and Vice Head of Finance at Hotdeal.vn. Although his working time is not quite long, he has proficiently applied skills to serve the job by his hard effort and the willingness to learn. For example, he has Presentation and Persuasive Speaking skills; Analytical and Decision-making skills; Managerial Mindset; skills to understand financial, accounting information parameters and auditing; and especially Advanced Office Softwares Competency (Power BI & Excel)