Working With Numbers and Diagram Using Microsoft Excel 2013

Posted in Kursus Pelbagai Pekej

Course: Working With Numbers and Diagram Using Microsoft Excel 2013

Pre-Requisite: Delegates should have attended or familiar with Excel Introduction Course

Duration: 3 Days

Course Outline:

Performing Calculations

Create Worksheet Formulas

Insert Functions

Reuse Formulas

Basic Formulas

Create Formula

Basic Steps for Creating Formulas

Auto Sum

Borders and Shading

Manual Formula

Creating Advanced Formulas

Use Range Names in Formulas

Use Specialized Functions

Use Array Formulas

Analysing Data with Functions and Conditional Formatting

Analyse Data by Using Text and Logical Functions

Apply Advanced Conditional Formatting

Organizing and Analysing Datasets and Tables

Create and Modify Tables

Sort Data

Filter Data

Use SUBTOTAL and Database Functions

Visualizing Data with Basic Charts

Creating Charts using the Chart Wizards

Editing and Formatting Charts

Printing Charts

Using the Drawing Toolbar

Analysing Data with PivotTables, Slicers, and PivotCharts

Create a PivotTable

Analyse PivotTable Data

Present Data with PivotCharts

Filter Data by Using Slicers