Excel 2013 for Beginners

Excel 2013 for Beginners

Duration:

3 Days
12 hours
7th, 8th and 9th of December 2017
From 10 AM : 2 PM

Requirements before you study this program:

1- Good Knowledge for MS windows
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 use backend
•    Working with cells
•    Working with spreadsheets & workbooks
•    Create and manage Tables
•    Sorting & Filtering
•    Printing worksheets

Outline:

-    Make a Start with Excel

o    A first look at Excel
o    Excel Rows and Columns
o    Enter text and numbers in a Cell
o    How to Edit text in a Cell
o    How to Centre text and numbers
o    Font Formatting
o    How to change the color of a Cell
o    How to Save your work in Excel
o    How to Merge Cells

-    Worksheet Basics

o    Rename Worksheet
o    Insert New Worksheet
o    Delete Worksheet
o    Copy worksheet
o    Move Worksheet
o    Change Worksheet Color
o    Grouping & Ungrouping Worksheets

-    Tables

o    Format data as table
o    Add Row – Column
o    Change Table Style
o    Table Style Options
o    Remove Table

-    Sorting & Filtering Data

o    Types of Sorting
o    Sort Sheet
o    Sort Range
o    Custom Sort
o    Sort By Cell Format
o    Sorting Levels
o    Filter Data
o    Apply Multiple Filters
o    Clear a Filter
o    Advanced Filtering

-    Printing Workbooks

o    Print Pane
o    Print a Workbook
o    Print Area
o    Pages
o    Orientation

-    A more complex spreadsheet

o    How to use AutoFill in Excel
o    Entering Simple Addition Formula
o    The SUM Function in Excel
o    The SUM Function Continued
o    Copy and Paste
o    How to use Paste Special
o    How to Multiply
o    How to Add a Comment to a Cell

-    Formulas in Excel

o    The SUM Function
o    How to Multiply in Excel
o    Subtract and Divide
o    Combining the Arithmetic Operators

-    Functions

o    The Average Function
o    The Date Function
o    Time Functions in Excel

Where:

Egyptian Council, Dokki

Registration fee:

500 LE instead of 600 until 30th of November 2017

Registration fee including:

Attending the Course
Tea & Coffee
Attendance certificate

For registration:

37 Mosadak St, floor# 6 - Dokki, Giza - Egypt.
Tel: +2 (010) 2048 3878
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