Sparen Sie 47%
WGS Career Academy

Microsoft Excel 2010 – Interactive Training Programme (Basic, Intermediate & Advanced)

WGS Career Academy
Online
Emagister-Preis

86 € 46 
*Orientierungspreis
Originalpreis in GBP:
£ 75  £ 40

Wichtige informationen

Tipologie Kurs
Niveau Intermediate
Methodologie Online
Unterrichtsstunden 35h
Dauer 1
Beginn nach Wahl
Online Campus Ja
Beratungsservice Ja
Virtueller Unterricht Ja
  • Kurs
  • Intermediate
  • Online
  • 35h
  • Dauer:
    1
  • Beginn:
    nach Wahl
  • Online Campus
  • Beratungsservice
  • Virtueller Unterricht
Beschreibung

Grow yourself and your career by completing this comprehensive course in using Excel 2010. This step-by-step course takes novice Excel users and teaches them how to build professional quality spreadsheets with which to capture, manipulate and report on data.

In just three modules learners will move from understanding the basic principles of Excel 2010, to mastering the most advanced concepts.

Wichtige informationen
Welche Ziele verfolgt der Kurs?

The Microsoft Excel 2010 Online Training course is split into three sections – Basic, Intermediate and Advanced. Starting gently with the basics of understanding the Excel interface, training quickly moves on to cover:

Entering and editing data.
Creating formulae to perform automated calculations.
Preparing and printing spreadsheets.
Inserting pivot tables to provide additional analytical potential.
Copying and pasting data, and inserting other data types (such as images) into a sheet.
Moving on, the Intermediate modules cover several topics including:

Creating a sparkline.
Editing and auditing formulae to ensure they are delivering accurate calculation results.
Sorting and filtering data to display pertinent information more quickly.
Creating and managing charts.
Using multiple workbooks to manage separate, but related data.
Freezing panes and autosizing columns to improve data display.

Ist dieser Kurs für mich?

Professionals who need to learn how to create and manage spreadsheets using Microsoft Excel 2010 to track and report data.
Employees who want to expand their knowledge of the Microsoft Office suite of applications.
Individuals who would like to learn and apply some of the more advanced Excel techniques to help them be more productive.
Individuals who would like to build their own spreadsheets for use at home or at work.
This self-study approach allows students to work at their own pace, as and when suits them – all they need is an Internet-connected computer.

Students can also use the social networking platform to share tips and advice with other learners, or to ask for help should they encounter problems whilst completing exercises.

Preis für Emagister-Nutzer:

Voraussetzungen: Internet Explorer 8 or above Google Chrome Safari 6 or above Mozilla Firefox

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

Was lernen Sie in diesem Kurs?

Excel
Excel for Accounting
Microsoft Excel
Spreadsheet
Excel Formula
Excel Sheet
Microsoft excel training
MS Excel
Entering Data
Cells
Selected Data

Themenkreis

Units of Study

Basic
  • Introduction
  • Create a New Blank Spreadsheet
  • Opening an Existing Workbook
  • Entering Data into Cells
  • Changing Cells
  • Centre the Selected Data
  • Create a Formula
  • Selecting Cells
  • Summing Cells
  • Change the Page Orientation
  • View in Print Preview
  • Print the Spreadsheet
  • Insert a Pivot Table
  • Copy and Paste
  • Insert an Image
Intermediate
  • Create a Sparkline
  • Filtering data
  • Naming a Range
  • Autosize a Column
  • Editing Formulae
  • Formula Auditing
  • Calculate the Average
  • Sorting
  • Freeze Panes
  • Creating a Chart
  • Scenarios
  • Changing Chart Type
  • Merge and Centre
  • Switch to another workbook
  • Moving and Copying Cells
Advanced
  • VLOOKUP function
  • Paste Special (Transpose Values)
  • Working with XML Data
  • Mark the Workbook as Final and Read Only
  • Import Text
  • Deleting Duplicate Records
  • Grouping Data
  • Conditional Formatting
  • Password Protect a Workbook.