Microsoft Office Training Limited

Microsoft Excel Introduction - In-company / Bespoke

Microsoft Office Training Limited
Inhouse

467 
*Orientierungspreis
Originalpreis in GBP:
£ 400

Wichtige informationen

Tipologie Kurs
Niveau Intermediate
Methodologie Inhouse
Dauer 1 Day
Beginn nach Wahl
  • Kurs
  • Intermediate
  • Inhouse
  • Dauer:
    1 Day
  • Beginn:
    nach Wahl
Beschreibung

This course aims to provide delegates with a foundation for Excel knowledge and skills.

The intermediate course will give you the tools you need to be able to use Microsoft Excel at an intermediate level.

Wichtige informationen
Ist dieser Kurs für mich?

All users who want to master the main features of Microsoft Excel

Voraussetzungen: General knowledge of the Windows OS

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Inhouse
Beginn nach Wahl
Lage
Inhouse

Was lernen Sie in diesem Kurs?

Excel
Options
Microsoft Excel
Database
Microsoft excel training
MS Excel
Formatting
Excel Formulas
Excel Tables
Text Functions
Date Functions
Quick Analysis
Calculated columns
Converting Tables

Themenkreis

What is Excel?

The Excel Interface

  • Ribbon, Tabs and Groups
  • Microsoft Office Backstage view

Working with Workbooks

  • Create a blank Workbook
  • Create a Workbook using a Template
  • Opening and saving Files

Working with worksheets

  • Worksheet navigation
  • Select one or multiple Worksheets
  • Insert, Move, Copy or Delete a Worksheet

Working with Cells, Rows & Columns

  • Cell References
  • How to select cells or ranges
  • Different types of data
  • Move, Copy and Delete cells
  • Pasting Options
  • Find and Replace
  • Working with Rows and Columns

Overview of formulas in Excel

  • Autocalculation
  • The parts of an Excel formula
  • Using calculation operators in Excel formulas
  • The difference between Absolute, Relative and Mixed references
  • Using Excel functions; Sum, Average, Max and Min

Cell Formatting

  • Font Format options
  • Number Format options
  • Change the Fill and Borders
  • Cell Alignment

An Introduction to Charts

  • Create a simple Chart
  • Format your chart

Page Layout and Print

  • Page Layout and Page Break View
  • Change the Page Orientation
  • Set Page Margins
  • Headers and Footers in a worksheet
  • Print a worksheet or workbook

Zusätzliche Informationen

£400 per day for one-to-one training £550 per day for groups of up to 8 people Course tailoring at no extra cost. Discounts for Nonprofits/Charities and Governmental Organizations