MS Excel Essentials

Course Duration: 8 Hours Frequency of Lessons: 1 Day Course
Date: Call on 79888609 for
next available slot
Time: 8.00am - 4.45pm Tutor: Mr Matthew Xuereb
       
Description:
A MS Excel 2013 course covering all the essentials required to be able work fluently with MS Excel.
       
Course Program:
8.00 am Welcome Coffee & Course Registration
8.30 am Part 1: Excel Basics
  • What is Excel?
  • Familiarity witht he Excel Window
  • Creating and Saving a workbook
  • Manipulation Rows and Columns
  • Cell Alignment and Formatting
  • Text, Number and Currency formatting
  • The Replicate feature
  • Freezing of rows and columns
10.30 am Coffee Break
10.45 am Part 2: Excel Formulas
  • Creating a basic formula
  • The Auto Sum function
  • Basic functions (count, min, max, small, large, average)
  • The IF function
  • the fx (Insert Function) button
  • Cell Referencing
1.00 pm Light Lunch
2.00 pm Part 3: Excel Layouts
  • Sorting
  • Charts and Charts Formatting
  • Setting Headers and Footers
  • Customising the Page Layout
  • Previewing and Printing
  • Using Excel for Mail Merge
4.30 pm Concluding Remarks
       
Learning Material:
Full course notes are given printed to the students. Each student is also provided with a unique username that is used to access online self study material, video turorials and examples from our online learning system.
       
Certification: Upon completion of the course, students will be given a certificate of attendance.
   
Tuition Fee: € 175    
       
Call on 79888609 to apply for this course.