About this course

Course type Essentials
Course code DMEX11L1
Duration 1 Day

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft Excel for Mac 2011 to manage, edit, and print data.

Target Audience:


This course is intended for individuals who want to gain basic knowledge of working on Excel.

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate the Finder, files and folders
  • Work with applications - minimise, maximise, open and close

Delegates will learn how to

At the end of this course you will be able to:

  • Create a basic worksheet by using Microsoft Excel for Mac 2011
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet
  • Modify the appearance of data within a worksheet
  • Manage Excel workbooks
  • Print the content of an Excel worksheet

Outline

Lesson 1: Getting Started with Excel

  • Topic 1A: Identify the Elements of the Excel Interface
  • Topic 1B: Navigate and Select Cells in Worksheets
  • Topic 1C: Customise the Excel Interface
  • Topic 1D: Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  • Topic 2A: Create Formulas in a Worksheet
  • Topic 2B: Insert Functions in a Worksheet
  • Topic 2C: Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Topic 3A: Edit Worksheet Data
  • Topic 3B: Find and Replace Data
  • Topic 3C: Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  • Topic 4A: Apply Font Properties
  • Topic 4B: Add Borders and Colours to Cells
  • Topic 4C: Align Content in a Cell
  • Topic 4D: Apply Number Formatting
  • Topic 4E: Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  • Topic 5A: Manage Worksheets
  • Topic 5B: View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
  • Topic 6A: Define the Page Layout
  • Topic 6B: Print a Workbook
Essentials

1 Day

Duration
Microsoft Excel
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.