Quality Dynamics Consultancy Sdn Bhd presents
Microsoft Excel - Advanced
(by Mr. Chin Chee Chong )
objectives
1. Create and use defined names in a workbook2. Work with logical function in Excel
3. Use a variety of data validation techniques
4. Use a range of lookup and reference functions
5. Create summaries in your spreadsheets using subtotals
6. Use the Data consolidation feature to combine data from several workbooks
into one
7. Create and work with Scenarios and the Scenario Manager
8. Import data into Excel and Export date from Excel
9. Create and use a range of controls in a worksheet
10. Create recorded macros in Excel
11. Import Data in Excel and Export data from Excel
program content
Topic 1: Linking & Consolidate Data1. Linking and Consolidating Data
2. Linking Workbooks
3. Creating a Link Formula by Paste Link
4. Consolidating Data
5. Creating a 3-D Formula
Topic 2: Tables and Sorting
1. Managing Tables and Data
2. Tables Overview
3. Table Terms
4. Tips for Setting up a Table
5. Creating Tables
6. Sorting Data
7. Sorting Data: Sort Button
8. Sorting Data: Sort Dialog Box
9. To sort according to a custom list
10. To sort according to a formatting criterion
Topic 3: Data Management
1. Filtering Data
2. Using Table Filters
3. Using Custom Auto Filter
4. Turning off the Auto Filter
5. Advanced Filtering
6. Using Advanced Filter
7. Running an Advanced Filter
8. Turning off Advanced Filter
9. Copying an Advanced Filter to another Location
10. Sub-totals
11. Adding Sub-totals
12. Adjusting views and sub-totals
13. Removing Sub-totals
14. Re-sorting the Data
15. Data Validation
16. Dealing with Text Files
17. Text Format Files
18. Text To Column
Topic 4: What – If Analysis
1. What if Analysis
2. Creating Data Tables
3. Creating a One Input Data Table
4. Creating a Two-Input Data Table
5. Goal Seek
6. Scenario Manager
7. How to Create A Report from a Scenario
Topic 5: Using IF, VLOOKUP, HLOOKUP, Formula Auditing & Protections
1. Auditing a Worksheet
2. Tracing Formulas and Errors
3. Trace cells that provide data to a formula
4. Trace formulas that reference a particular cell
5. Watch Window
6. Protecting your files and worksheets
7. Protection Options
8. Looking & Unlocking Cells
9. Workbook Level Protection
10. Worksheet Level Protection
11. File Level Protection
Topic 6: Using Macros
1. Automating Excel with Macros
2. Creating & Recording a New Macro
3. Running a Macro
4. Suspending & running a Macro
5. Deleting a Macro
6. Saving a Workbook containing Macros
methodology
Lecture, discussion, individual/group exercise, Question and Answerwho must attend
Executives and non-executives who have an intermediate level of Excel knowledge.(KINDLY TAKE NOTE: PARTICIPANTS ARE REQUESTED TO BRING THEIR LAPTOP AND EQUIPPED WITH MICROSOFT EXCEL 2010 AND ABOVE VERSION)
investment fee / early bird by 08/08/2017
Standard: RM650.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)