Microsoft® Excel – Basic

SCHEDULE

No schedule at the moment

If you have three or more candidates or you would like to run this course as an in-house programme, please contact us.

Course Pre-requisites

This programme is designed for delegates who have basic knowledge of using a computer. They should be comfortable in using the keyboard, mouse and Start menu. Knowledge of how to use a web browser is beneficial, although not a requirement. No previous experience with other versions of Microsoft Excel is necessary.

Overview

Microsoft Excel is a powerful and easy-to-use spread sheet programme. This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting.

Objectives

  • Identify the elements of the Excel interface
  • Learn how to create a basic worksheet
  • Know where to find help system in Microsoft Excel
  • Create formulas and insert functions in a worksheet
  • Insert, manipulate and delegate cells, columns and rows
  • Learn how to search, replace and manipulate data
  • Explore different formatting options – modify fonts, add borders, apply formats and styles
  • Define the basic page layout for a workbook
  • Refine the page layout and apply print options
  • Learn how to manage large workbooks
  • Be able to customer excel environment

Course content

Below is an example of the course content. The content can be ‘tailored’ to meet the exact requirements of the client.

Day One

Getting started with Microsoft Excel
  • Elements of the Excel interface
  • Creating basic worksheets and workbooks
  • Using the help system
Performing calculations
  • Creating formulas in a worksheet
  • Insert functions in a worksheet
  • Reuse formulas
Modifying a worksheet
  • Entering and revising data
  • Moving data within a workbook
  • Finding and replacing data
  • Correcting and expanding upon worksheet data
  • Defining excel tables
Managing large workbooks
  • Format worksheet tabs
  • Manage worksheets
  • Manage the view of worksheets and workbooks

Day Two

Formatting a worksheet
  • Modify fonts
  • Add borders and colour to cells
  • Align cell contents
  • Formatting cells
  • Applying workbook themes and excel table styles
  • Add images to a worksheet
Printing workbook contents
  • Adding Headers and Footers to Printed Pages
  • Preparing Worksheets for Printing
  • Printing Worksheets
  • Printing Parts of Worksheets
  • Printing Charts
Customising the Excel environment
  • Zooming in on a worksheet
  • Arranging multiple workbook windows
  • Adding buttons to the quick access toolbar
  • Customising the ribbon
  • Maximising usable space in the programme window

METHODOLOGY OF TRAINING

The foundation of our training is anchored in activity-based experiential learning. This methodology takes into consideration different learning and communication styles, and more importantly language and cultural differences. It is through active participation that the adoption and application of theory is expedited.

Our training team pays careful attention to planning and designing effective instructional methods essential for the transfer of knowledge. It is the creative skill of our management trainers and consultants that reveal untapped skills of the delegates through:

    • Practical sessions
    • Individual and syndicate activities
    • Individual and group tasks
    • Case studies
    • Role plays
    • Audio and video evaluation
    • Action planning
    • Experiential learning games
    • Presentations
    • Assessments

 

Recent Post

callback request

Your Name

Contact Number

Company

Location

Email

How did you hear about us?


Abu Dhabi

P.O. Box 44705, Abu Dhabi,
United Arab Emirates
Phone: +971 2 6740340
Fax: +971 2 6743554

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE

Dubai

P.O. Box 334058, Dubai,
United Arab Emirates
Phone: +971 4 2566414
Fax: +971 4 2566424

Tax Registration Number:
100003031000003
for VAT purposes, only in the UAE