Excel 2013 – Intermediate Level

Duration:

3 Days
12 hours
2nd, 3rd and 4th of November 2017
From 10 AM : 2 PM

Requirements before you study this program:

1- Good Knowledge for the basic Excel features.
2- Please bring your laptop at the time of the training, and be sure to install Excel 2013.

Program outcomes:

By the end of the program, the participants will be able to:
•    Know how to work with Charts & Sparklines.
•    Using Conditional Formatting
•    Creating PivotTables.
•    Know how to use most popular functions.
•    Using Data Validation

Outline:

  • Working with charts
    • Types of Charts
    • Identifying the parts of a chart
    • Chart tools

  • Working with Sparklines
    • What is sparkline?
    • Creating sparklines
    • Types of sparklines
    • Why use sparklines?
    • Display range

  • Using Conditional Formatting
    • Intro
    • Create a conditional formatting rule
    • Conditional formatting presets
    • Remove conditional formatting rules

  • Creating PivotTables
    • Intro
    • Using a PivotTable
    • Create a PivotTable
    • Add fields to the PivotTable
    • Pivoting data
    • Using report filters
    • Slicers
    • Using a PivotChart

  • Using What-If Analysis
    • Intro
    • Using Goal Seek
    • Using Scenario
    • Using Data table

  • Most popular formulas
    • Sum
    • Count
    • Counta
    • Len
    • Trim
    • Right, left, mid
    • Vlookup
    • If statement
    • Sumif, countif, averageif
    • Concatenate

  • Link Excel Spreadsheet Data
    • Link to a value inside same sheet
    • Link to a value inside another sheet on same worksheet
    • Link to a value inside to external worksheet

  • Data Validation
    • Whole Number
    • Decimal
    • List
    • Date
    • Time
    • Text Length

Where:

Egyptian Council, Dokki

Registration fee:

600 LE instead of 1000 until 26th of October 2017

Registration fee including:

Attending the workshop.
Coffee break.
Attendance certificate.

For registration:

37 Mosadak St, Floor# 6
Dokki - Giza, Egypt.
Tel/Fax: +2 (02) 3748 7742
Mob:+2 (010) 2048 3878
This email address is being protected from spambots. You need JavaScript enabled to view it.
www.egyptiancouncil.com
https://www.facebook.com/ECTD.EG

JoomShaper