Microsoft Excel Foundation – Part 1

Dorset based half-day Training Course

Basepoint-Meeting room

To use a spreadsheet to enter, edit and organise numerical and other data

Who is this course designed for?

Aimed at new users of Excel. During this course you will learn essential Excel skills to be able to enter, manage and edit your data. You will learn how to create and modify simple formulas and functions and also be taught many of the time saving shortcuts.

Price: £99 + VAT

Contact Us:

01202 788277

Next Date: TBA

Click here to book

About your Trainer: Claire

What is in the Course?

  • Excel essentials: Understanding essential elements of the Excel workspace; using various keyboard shortcuts to select and navigate; understanding help; filling cells with series of data; inserting/deleting cells.
  • Entering and editing data: Entering data into existing spreadsheets; inserting information into single and multiple cells; clearing and editing cell contents; replicating data; using find and replace;
  • Storing and retrieving: Saving, opening, closing and finding workbooks; opening and saving .csv file formats, importing and exporting; using templates; working with file properties; setting password protection.
  • Structuring a workbook: Creating a new spreadsheet; adding and deleting rows and columns; inserting worksheets; hiding and protecting cells
  • Creating Simple Formulas and functions: Creating formulas to divide, multiply, add and subtract; using common functions including SUM; understanding absolute and relative cell references; using auditing tools to check formulas and functions

What are the Course Outcomes?

To use a spreadsheet to enter, edit and organise numerical and other data. You will learn how to:

  • identify what numerical and other information is needed and how the spreadsheet should be structured
  • enter and edit numerical and other data accurately
  • store and retrieve spreadsheet files effectively
  • use functions and formulas to meet calculation requirements
  • check for errors and accuracy of numbers, formulas and text