New

Microsoft Excel 2010 Essentials

Difficulty
Rating
1days
Duration
480,00 
+ VAT
Time: 10:30 - 17:30
Location:
The chosen training includes following dates:
When paid with Sovelto Access -credits, you will be charged the corresponding amount of credits to the Euro-price. Please contact sales: 020 7776 670 or myyntipalvelu@sovelto.fi for exact amount of credits in your case.

Register before
Spoken language: English

We are sorry, but the course is already full, please try with another date or location.

Or contact sales: +358 20 7776 670 or myyntipalvelu@sovelto.fi

New

Overview

In this course you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. This course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

Objectives

  • Create a basic worksheet by using Microsoft Office Excel 2010.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Format a worksheet.
  • Print the content of an Excel workbook.
  • Manage an Excel workbook.

Outline

Module 1: Getting Started with Excel 2010

  • What is Excel?
  • Excel and the Excel Environment
  • Navigating and Selecting Cells in Worksheets
  • Creating a New Workbook
  • Saving Your Work
  • Opening and Closing Workbooks
  • Using Help

Module 2: Using Formulas and Functions

  • Create Formulas
  • AutoCalculate
  • Insert Functions
  • Using AutoSum
  • Copying a Formula
  • Creating an Absolute Formula

Module 3: Formatting an Excel Worksheet

  • Font Group
  • Add Borders and Colours to Cells
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries
  • Format Painter

Module 4: Modifying a Workbook

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo Commands
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Module 5: Managing Worksheets and Workbooks

  • Managing Worksheets
  • Freeze Rows and Columns
  • Split Screen
  • Arrange All Command
  • View Side by Side
  • New Window Command

Module 6: Printing Options

  • Print Preview
  • Print Worksheets
  • Page Setup
  • Print Titles
  • Page Layout View

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with Windows – minimise, maximise, open and close

 

Places left:
No participant limit
many
480,00  + VAT