Quality Dynamics Consultancy Sdn Bhd presents
Microsoft Excel - Intermediate
(by Mr. Chin Chee Chong )
objectives
At the end of this course, participants are expected to:1. Understand the Excel Tools to assist in building formulas
2. Create basic formulas and functions
3. Able to create and format charts
4. Work effectively with multiple sheets in workbooks
5. Use tools, copy and paste data in the format you want
6. Analyze and work with Excel list/database features
program content
Topic 1: Managing Worksheets and Workbooks1. Adjusting Zoom
2. Using Multiple Windows
3. To open multiple windows of several workbooks
4. Using Freeze Panes
5. Using Split Windows
6. Custom Views
7. Hiding and Un-hiding worksheets and workbooks
8. Working with Multiple Worksheets
9. Changing Worksheet Tab Colours
10. Inserting Worksheets
11. Moving Worksheets
12. Copying Worksheets
13. Deleting Worksheets
14. Grouping and Ungrouping Sheets
Topic 2: Functions & Formulas
1. Cell References: Relative, Absolute and Mixed
2. Inserting Static & Dynamic Dates and Times
3. Mathematical Functions with Maths Operators
4. SUM, AVERAGE, MAX, MIN, COUNT, COUNTA functions
5. SUMIF and COUNTIF Functions
Topic 3: Conditional Formatting
1. Applying Cell Highlighting
2. Applying Top & Bottom and Average Rules
3. Applying Data Bars, Colour Scales, and Icon Sets
4. Creating a Customised Rule with Formula Conditions
5. Editing Rules
6. Prioritizing Rules
7. Deleting Rules
Topic 4: Creating a Charts
1. What is a Chart?
2. Inserting a Chart
3. Elements of a Chart
4. Activating a Chart
5. Formatting a Chart
6. 3-D Charts
7. Adjust Chart Data
8. Saving a Chart Template
9. Working with Charts
methodology
Lecture, discussion, individual/group exercise, Question and Answerwho must attend
Existing Excel users with a good understanding of Excel basics who need to be more effective with Excel and automate reporting with functions and formulas etc.(KINDLY TAKE NOTE: PARTICIPANTS ARE REQUESTED TO BRING THEIR LAPTOP AND EQUIPPED WITH MICROSOFT EXCEL 2010 AND ABOVE VERSION)
RENTAL OF LAPTOP IS AVAILABLE UPON REQUEST.
investment fee / early bird by 15/11/2018
Standard: RM720.00 Nett PerDay / Not Available per participant
Group discount: Not Available / Not Available per participant for a minimum of 2 participants from the same company
(Fee inclusive of Refreshment, Buffet Lunch, Training Bag, Handouts, & Certificate of Completion) |
registration & payment
PROGRAMS ARE CLAIMABLE UNDER SBL SCHEME
Please register online through www.qdc.com.my or call 03-78054587 / 03-78044196. Our phone line operation hours are from 8:30am to 6:00pm from Monday to Friday.
All registration MUST be accompanied with PAYMENT.
Completed registration form with CHEQUES should be made in favor of "Quality Dynamics Consultancy Sdn Bhd" and sent to:
QUALITY DYNAMICS CONSULTANCY SDN BHD
No. 343, Block A, Kelana Centre Point, No.3 Jalan SS7/19,
Kelana Jaya, 47301 Petaling Jaya,
Selangor, Malaysia.
Tel : 03-78054587 / 03-78044196
Fax: 03-78054514
E-mail:
training@qdc.com.my
(
Wani/ Thang )
PSMB Reg: 620717-P
(FEE PAID IS NOT REFUNDABLE but replacement may be made at no additional cost. Quality Dynamics Consultancy Sdn Bhd reserves the right to cancel or reschedule the above course and shall inform participants of the changes)