Microsoft Office Excel intro

Short course

In Belfast City

£ 100 + VAT

Description

  • Type

    Short course

  • Location

    Belfast city (Northern Ireland)

  • Duration

    1 Day

Suitable for: Our 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.

Facilities

Location

Start date

Belfast City (County Antrim)
8-10 Amelia Street, BT2 7GS

Start date

On request

About this course

A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Office

Course programme

Benefits
At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch.

Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable.

After completing this course you will be prepared to attend our Advanced MS Excel training course.

Course Content

Screen Tour

  • Toolbars & Menu Bar
  • Sheets

Basic File Operations

  • Open, Close
  • Save & Save As
  • Print & Print Preview
  • Set Print Area

Formulae & Functions

  • Operators & Precedence
  • Standard Functions (Sum, Average, Max, Min, Etc)
  • Replicate Command (Use With Formula/ Functions, Fill
  • Formats/ Series/ Trends, Days, Etc)

Cell References

  • Absolute
  • Relative

Range Names

  • Create New, Modify Existing
  • Use With Formula

Toolbars

  • Customise Existing
  • Create New

Sorting Data

  • Header Row
  • Ascending/ Descending Order
  • Use First Key Sort Order (For Custom Lists)

Format Cells

  • Text & Numerical (Data)
  • Patterns & Borders, Alignment
  • Wrap Text, Centre Across Selection
  • Merge Cells

Spreadsheet Operations

  • Split & Freeze Window
  • Insert/Delete Rows & Columns
  • Adjust Row & Column Height/ Width

Charts

  • Embedded Chart
  • Sheet Chart
  • Options (Titles, Legends, Data Labels, Data Table, Etc)

Customising Page Setup

  • Orientation & Margins
  • Headers & Footers
  • Gridlines, Titles & Page Order
  • Scale Print
  • Set Row & Column Headings
  • Split Screen

Sheet Operations

  • Insert & Rename
  • Rename
  • Copy/ Move Within Current File And To External Files
  • Group Sheets (Select Adjacent & Non-Adjacent Sheets)
  • Link Worksheets Within A Single File
  • Link Worksheets to External Files

Security

  • Protect Cell Ranges
  • Password Protect Files

Microsoft Office Excel intro

£ 100 + VAT