MICROSOFT EXCEL - INTERMEDIATE

MICROSOFT EXCEL - INTERMEDIATE

分类: Microsoft Excel 当前有货
欲了解更多详情,请游览我们的官方网站 iconictraining.com.my

详情

Microsoft Excel - Intermediate

Course Duration: 2 Days

Who is this course for?

This course is intended for participants who wish to gain more knowledge from the foundation level of Excel. For participants who are working with lots of formulas and creates report to understand the necessary techniques on how an electronic spreadsheet works.

Pre-requisites

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

Benefits

Upon completion of this program, participants should be able to:

Key Content

Unit 1: Performing Calculations

Topic A - Reuse Formulas

Unit 2: Creating Advanced Formulas

Topic A - Apply Range Names

Unit 3: Worksing with Functions

Topic A - Using Statistical Function Topic B - Using Mathematical Function Topic C - Using Logical Function Topic D - Using Database Function

Unit 4: Organizing Worksheet Data with Tables

Topic A - Create and Modify Tables Topic B - Sort and Filter Data Topic C - Use Subtotal and Database Functions to Calculate Data Topic D - Data Validation

Unit 5: Visualizing Data as a Graphics

Topic A - Conditional Formatting Topic B - Create Charts Topic C: Modify and Format Charts Topic D: Adding Sparklines Topic E: Editing Sparklines

Unit 6: Managing Views

Topic A - Working with Different Views Topic B - Managing Multiple Windows

Methodology

Informative presentation, group discussion and presentation, handson practical session

 

 

更多 Iconic Training Solutions Sdn Bhd 相关资料
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd Experiential Learning & Soft Skills Training Courses Malaysia, Best Software Provider Kuala Lumpur (KL), Leadership Enhancement Program Selangor ~ Iconic Training Solutions Sdn Bhd