EXC19I : Microsoft Excel 2019 Intermediate
Course Price
RM 300 (excluding 6% SST)
Duration: 1 days/8 hours
(9:00AM - 5:00PM)
Overview
This Intermediate Microsoft Excel training class is designed for students to gain the skills necessary to work with formulas, functions, worksheets and tables.
Price
RM300 (excluding 6% SST)
Fee including:
-
Materials
-
Trained by Certified trainers
+
-
This training is suitable for intermediate of Excel 2019 user and is recommended for uers to already have the basic knowledge of Excel 2019 usage.
+
-
The inquiry process comprises three simple steps.
-
Submit Inquiry- Tell us a bit about yourself and the questions you want to enquire about. Use our CHAT feature or submit an enquiry form. You can also WhatsApp us on +601112216870 (Mr Vaheed)
-
Reviewing–Your questions will be processed and answered within a day or two
-
Response–Answers will typically be sent through email. However, you may tell us the option you prefer us to contact you in
+
-
-
Physical Classroom Training (Malaysia)
-
On-site Company Training (Malaysia)
-
Online Training via Microsoft Teams/ZOOM. (Malaysia and International)
+
-
Module 1: Working with Formulas
Module 2: Working with Functions (I)
Module 3: Working with Functions (II)
-
Using Statistical functions: AVERAGEIF, COUNTIF
-
Using Lookup Functions: VLOOKUP ,HLOOKUP, LOOKUP
-
Using Text functions: TEXTJOIN, CONCAT
-
Using Statistical Functions: MAXIFS and MINIFS
Module 4: Auditing Worksheets
-
Tracing Formula Precedents and Dependents
-
Showing Formulas
-
Evaluating Formulas
-
Using Error Option Buttons
-
Running an Error Check
Module 5: Working with Table
-
Converting Data in range as a Table
-
Total the Data in Table
-
Removing Duplicates from Table
-
Using Sort and Filter
WHY NEXPERTS ACADEMY
- CERTIFIED TRAINERS
- HIGHLY EXPERIENCED
WITH INTERVIEW PREPARATION
- 24/7 SUPPORT
- LIFETIME ACCESS TO
RECORDED SESSIONS
- FLEXIBLE SCHEDULE
