EXCEL INTERMEDIATE 2010 LEVEL 2
Sales Ended
EXCEL INTERMEDIATE 2010 LEVEL 2

Event Information

Share this event

Date and Time

Location

Location

Rombourne Business Centre

Merlin House

Langstone Business Park

Newport

NP18 2HJ

United Kingdom

View Map

Friends Who Are Going
Event description

Description

COURSE OUTLINE
Excel Intermediate

This comprehensive course in Excel teaches participants how to manipulate a spreadsheet using a variety of techniques, including filtering and using Excel as a database.

This 1-day Excel Intermediate course will assist delegates to develop their skills in modifying and manipulating professional looking spreadsheets

Course Content:

  • Using AutoFill to enter data quickly
  • Entering ranges of dates or numbers
  • Create / edit / delete a Custom List
  • Using copy, cut and paste
  • Using paste special & paste link
  • Performing formulas quickly & correctly
  • Replicate a formula using AutoFill
  • Using MIN, MAX, COUNT & AVERAGE
  • Format cells as a date, currency, %,decimal places
  • Adding Borders
  • Formatting text colour, size and style
  • Aligning text and text at a angle
  • Applying text wrapping – merging cells
  • Setting up conditional formatting
  • Multiple conditional formatting options
  • Removing conditional formatting
  • Naming/Inserting/Deleting/Changing Order or worksheets
  • Moving sheets to new/other worksheets
  • Use the Zoom facility
  • Entering dates and times correctly
  • Formatting dates and times
  • Calculating with dates and times
  • Inserting multiple rows and columns
  • Freezing rows and columns
  • Creating headers and footers
  • Entering and formatting text
  • Entering / Deleting Comments
  • Viewing / Printing Comments
  • Repeating title rows at top of page
  • Printing gridlines and row /column headings
  • Setting up a database - database concepts
  • Filtering data - further filtering options
  • Using IF statements for True / False results
  • Add or remove a chart title / data labels
  • Moving / Resizing a chart
  • Change a chart’s colours
  • Changing the chart type
  • Saving a workbook/ as a new name
  • Save as a new file format or template

Who should attend?

This course is designed for any delegates who have attended the Excel foundation course or have relevant business experience, and would like to learn how to improve their skills in modifying and manipulating a spreadsheet.

Share with friends

Date and Time

Location

Rombourne Business Centre

Merlin House

Langstone Business Park

Newport

NP18 2HJ

United Kingdom

View Map

Save This Event

Event Saved