Fundamental Excel

Duration

  • 2 Sessions * 5 Hours = 10 Hours
  • This course spans 2 sessions, each lasting 5 hours, providing 10 hours

Location:

  • Elegant business solutions (EBS) training Academy – Nasr City.

Course Versions and Schedules:

  • Start date:

This course is available in two versions to accommodate diverse preferences and schedules:

Online Version:

  • Schedule: 2 days Per week
  • Time: 6:30 PM – 9:30 PM (Cairo Time)
  • Format: Online sessions for remote learning and interaction.

In-Person Version at the EBS Center’s Headquarters:

  • Schedule: Fridays and Saturdays
  • Time: 9:00 AM – 3:00 PM Or 3:00 PM – 8:00 PM (Cairo Time)
  • Location: EBS Training Academy
  • Format: Face-to-face sessions, providing a collaborative and immersive learning experience.

Learning Objectives

  • Indicate the names and functions of the Excel interface components.
  • Enter and edit data.
  • Format data and cells.
  • Construct formulas, including the use of built-in functions, and relative and absolute references.
  • Create and modify charts.
  • Preview and print worksheets.

Target Audience

  • All Entry levels
  • Preparing Introduction to MS Excel
  • How to open? 
  • Interface.  Main Menu “Data” – New bar “Formula bar”
  • Defining Workbook, Worksheets, Columns, Rows, Cells and
  • How to add & remove toolbars.
  • How to Navigate & Select?  “By using Mouse & Keyboard”
  • Data entry, Data types (Text, Numbers, Formula) and Editing.
  • How to resizing Columns & Rows.
  • Insert Columns, Rows.
  • How to change sheet direction.
  • Save & Save as.
  • Close and Exit.  (Alt + F4) (Ctrl + W)
  • Format Sheet, Column and row.
  • Copy, Cut and Paste.
  • Fill handle (Filling data Text, Numbers, Date and Time).
  • Format Cell.
  • Cell Reference, Relative Reference and Absolute Reference.
  • Functions (AutoSum, Sum, Count, Average, Max, Min, IF)
  • Checking for Errors Values (#NAME? #REF! #VALUE!)
  • Sort and Filter.
  • Freezing Panes.
  • Insert chart.
  • Header and Footer- Page Setup – Print Preview – Print (Ctrl + P).

Make Your Booking Now...

Certified Workshop

Thank You For Booking

Fundamental Excel

We will contact you soon as possible..