Excel Foundation English spoken

Code:
6-ex001M/EN
Prijs:
242,50 EUR per deelnemer ()
Plaats:
Middelburg, Rotterdam, Eindhoven, Breda, Terneuzen, Bergen op Zoom
Groep:
Deelnemer
Niveau:
Beginner

Omschrijving

Microsoft Excel 2013 Foundation

 

Content:

See below

Method: 

This is a classroom led course. the instructor will clarify Excel with examples, The attendee will have the opportunity to make exercises and to ask questions.

Duur:

1 day

Location:

This training is regulary held in many of our locations. For groups (from 4 persons up) it is beneficial to organise an incompany training. Please contact us for our offer

Remarks:

We provide laptops with the correct version of the software

 


Getting started with Excel 2013

  • Starting Excel 2013 using windows 7 (or previous versions)
  • Selecting the blank worksheet template
  • The Excel 2013 cell referencing system
  • Entering numbers and text
  • Default text and number alignment
  • Summing a column of numbers
  • Entering a date
  • Worksheets and workbooks
  • Saving a workbook to your hard disk
  • Closing a workbook
  • Creating a new workbook
  • Opening a workbook
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type
  • Getting help within Excel 2013
  • Searching for online help
  • Alt key help

Excel 2013 selection techniques

  • Why are selection techniques important?
  • Selecting a cell
  • Selecting a range of connecting cells
  • Selecting a range of non-connecting cells
  • Selecting the entire worksheet
  • Selecting a row
  • Selecting a range of connecting rows
  • Selecting a range of non-connected rows
  • Selecting a column
  • Selecting a range of connecting columns
  • Selecting a range of non-connecting columns
  • Recommended techniques when creating or editing lists

Manipulating rows and columns within Excel 2013

  • Inserting rows into a worksheet
  • Inserting columns into a worksheet
  • Deleting rows within a worksheet
  • Deleting columns within a worksheet
  • Modifying column widths
  • Modifying column widths using ‘drag and drop’
  • Automatically resizing the column width to fit contents
  • Modifying row heights

Manipulating cells and cell content within Excel 2013

  • Copying a cell or range contents within a workbook
  • Deleting cell contents
  • Moving the contents of a cell or range within a workbook
  • Editing cell content
  • Undo and redo
  • Copying data between worksheets (within the same workbook)
  • Moving data between worksheets (within the same workbook)
  • Moving data worksheets (between different workbooks)
  • Copying data between worksheets (in different workbooks)
  • AutoFill
  • Copying a data range using AutoFill

Sorting a cell range

  • Searching and replacing data

Excel 2013 worksheets

  • Switching between worksheets
  • Renaming a worksheet
  • Recommended techniques with naming worksheets
  • Inserting a new worksheet
  • Deleting a worksheet
  • Copying a worksheet within a workbook
  • Moving a worksheet within a workbook
  • Copying or moving worksheets between workbooks

Font formatting within Excel 2013

  • Font formatting options
  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour

Alignment formatting within Excel 2013

  • Horizontally aligning contents in a cell range
  • Centring a title over a cell range
  • Cell orientation
  • Text wrapping within a cell
  • Aligning cell contents vertically
  • Format painter

Number formatting within Excel 2013

  • Number formatting
  • Decimal point display
  • Applying and removing comma style formatting (to indicate thousands)
  • Currency symbol
  • Date styles
  • Percentages

Freezing row and column titles within Excel 2013

  • Freezing row and column titles

Excel 2013 formulas

  • Creating formulas
  • The easy way to create formulas
  • Copying formulas
  • Operators
  • Using operators in formulas
  • Formula error messages
  • Relative cell referencing within formulas
  • Absolute cell referencing within formulas

Excel 2013 functions

  • What are functions?
  • Common functions
  • Sum function
  • Average function
  • Max function
  • Min function
  • Count function
  • The counta function
  • The countblank function
  • What are ‘if functions’?
  • Using the if function

Excel 2013 charts

  • Inserting a column chart
  • Inserting a line chart
  • Inserting a bar chart
  • Inserting a pie chart
  • Resizing a chart
  • Deleting a chart
  • Chart title or labels
  • Changing the column, bar, line or pie slice colours in a chart
  • Modifying the legend fill colour
  • Changing the chart type
  • Modifying charts using the design tab
  • Modifying the chart title
  • Modifying the chart axis
  • Modifying the chart legend
  • Modifying chart data labels
  • Displaying chart data tables
  • Modifying chart gridlines
  • Copying and moving charts within a worksheet
  • Copying and moving charts between worksheets
  • Copying and moving charts between workbooks

Customising Excel 2013

  • Modifying basic Excel options



Geeft u zich op voor de lijst van geïnteresseerden!

Voor deze activiteit zijn nog geen tijden bekend.
indien u zich voor de activiteit interesseerd, kunt U zich opgeven in de lijst voor geïnteresseerden. U krijgt dan bericht, zodra er een tijd voor de activiteit is vastgelegd.

Deelnemersgegevens

Contactgegevens

* noodzakelijke informatie

Categorie