Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Course overview

This course covers all the fundamental skills required to create and format spreadsheets, automate spreadsheets with formulas and prepare spreadsheets for printing.

Course duration

1 day

Delivery method

Flexible (Online/Classroom)

Costs

Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Suitable for

Those who need to be able to create, edit and format Microsoft Excel spreadsheets.

Learning outcomes

After attending this course, delegates will be able to create, format and edit Microsoft Excel spreadsheets. They will be able to create basic calculations and formulas.

Course content

Spreadsheet Basics:

  • Spreadsheet concepts.
  • Exploring the Excel window.
  • Working with the ribbon and commands.

Navigating, Selecting and Entering Data:

  • Creating, saving, opening and closing spreadsheets.
  • Moving around a spreadsheet.
  • Entering, editing and deleting data.
  • Using Auto Fill and Flash Fill.
  • Creating custom lists.

Editing Data, Columns and Rows:

  • Inserting and navigating worksheets.
  • Inserting and deleting rows and columns.
  • Adjusting column widths and row heights.
  • Showing and hiding columns and rows.
  • Cut, copy and paste techniques.

Formatting:

  • Formatting text and sizes.
  • Aligning text horizontally and vertically in cells.
  • Applying number and date formats.
  • Formatting cells with background colours and borders.

Basic Formulae and Functions:

  • Using formulas to add, subtract, divide and multiply numbers.
  • Using the AutoSum function.
  • Working with relative and absolute cell references.

Data Lists Essentials:

  • Introducing data lists.
  • Freezing worksheet titles.
  • Sorting a list of data.
  • Filtering data using Auto Filter. 

Page Setup and Printing:

  • Using print preview.
  • Changing page layouts.
  • Changing and applying print options.

Course requirements

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. 

Attendees must have the following equipment to attend this training remotely:

  • PC or laptop with a microphone and speakers (webcam is preferred but not essential).
  • Access to the internet and web browser application (e.g. Google Chrome).
  • Microsoft Excel installed on the PC or laptop.
  • An email account for file sharing.
  • A second screen is ideal but not essential.

 


For more information about this course please contact us.


Queens Court Regent Street Barnsley South Yorkshire S70 2EG
Tel: 01226 216760 | Email: info@ind-training.co.uk | www.independenttrainingservices.co.uk

These course details were downloaded on 22/06/2021

https://www.independenttrainingservices.co.uk/courses-new/it-and-digital-skills/other/microsoft-excel-fundamentals/

Enquire Now