Microsoft Office Training Limited

      Microsoft Excel Introduction

      Microsoft Office Training Limited
      En London (England)

      $ 6,586
      *Precio Orientativo
      Importe original en GBP:
      £ 275

      Información importante

      Tipología Curso
      Nivel Beginner
      Metodología In company
      Lugar London (England)
      Inicio Fechas a escoger
      • Curso
      • Beginner
      • In company
      • London (England)
      • Inicio:
        Fechas a escoger
      Descripción

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

      The introduction course will give you the basics that you need to be able to use Microsoft Excel at a basic level.

      Información importante
      ¿Esta formación es para mí?

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

      Requisitos: General knowledge of the Windows OS

      Instalaciones (1) y fechas
      Dónde se imparte y en qué fechas
      Inicio Ubicación
      Fechas a escoger
      London
      70 Clifton Street, EC2A 4HB , London, England
      Ver mapa
      Inicio Fechas a escoger
      Ubicación
      London
      70 Clifton Street, EC2A 4HB , London, England
      Ver mapa

      ¿Qué aprendes en este curso?

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

      Programa académico

      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

      Información adicional

      £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