Training Course: Advanced MS-Excel 

Bethlehem University / About Bethlehem University / Bethlehem University News / Training Course: Advanced MS-Excel 
  • 06 Feb
  • 2024

Objectives:

Introduce advanced features of MS-Excel and teach participants how to efficiently work on multiple sheets and to use several advanced features of the software to manage large amount of data, automate Excel sheets to handle users interactions more cleverly and quickly create summary reports to represent

information in various forms.

Topics:

  • General Excel Review
  • Absolute Cell Reference
  • IF Function and Nested IF Statement
  • Vertical and Horizontal Lookup
  • Conditional Formatting
  • Subtotals
  • Data Validation
  • Paste Special
  • Pivot Table
  • Goal Seek
  • Security: Cell, Sheet, File Protection
  • Link Sheets, Sheets Commands, 3D Ref.
  • Hyperlinks
  • Date Calculations
  • Formula Auditing
  • Scenarios
  • Macros
  • T-Account Example
  • Data Import from Text Files
  • Customize Toolbars
    • Place: Bethlehem University                                           – Fuglister Lab
      • Instructor: Mr. Johnny Bassous

Duration:

The training will start on Friday, February 16th, 2024 for 20 hours (8 sessions) according to the following schedule:

DateDayTimeRoom
16/2/2024Friday4:00-6:30Fuglister
20/2/2024Tuesday4:00-6:30Fuglister
23/2/2024Friday4:00-6:30Fuglister
27/2/2024Tuesday4:00-6:30Fuglister
1/3/2024Friday4:00-6:30Fuglister
5/3/2024Tuesday4:00-6:30Fuglister
8/3/2024Friday4:00-6:30Fuglister
12/3/2024Tuesday4:00-6:30Fuglister

Course fee: NIS 380 per participant, to be paid upon registration, which covers training materials and a Certificate of Completion that will be granted to participants at the end of the course.

For Registration: the participant has to fill in the attached Application for Admission and submit it to the ICP by February 13th, 2024 at the latest.