Microsoft Excel Foundation – Part 2

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 that have attended the Microsoft Excel Foundation Part 1 course, or who already have these skills. In this course you will learn the essential skills to manage lists of data, combine data from multiple worksheets and workbooks and how to print. You will also learn how to display your data using an array or formatting tools and chart options.

Price: £99 + VAT

Contact Us:

01202 788277

Next Date: TBA

Click here to book

About your Trainer: Claire

What is in the Course?

  • Working with lists: Entering lists of data, navigating and selecting; understanding data validation; sorting and filtering data; applying and displaying subtotals.
  • Combining and linking data: Linking data from worksheets and other source, managing links; creating shared workbooks; modifying and merging multiple copies of a shared workbook.
  • Formatting a worksheet: Formatting text and numbers, applying percentages and decimal places; adding borders and shading; changing column widths and row heights; merging and aligning cells.
  • Creating and modifying charts: Creating a chart and identifying appropriate chart types; using the chart toolbar; adding and removing data; formatting chart elements; working with chart elements and locations; printing a chart.
  • Printing: Setting print areas; spell checking; using page break preview and print preview; changing page setup; working with headers and footers; changing page orientation and size; printing.

What are the Course Outcomes?

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

  • Summarise and display data effectively
  • Apply formatting to cells, rows and columns
  • Combine and link data across worksheets
  • Identify which chart or graph type to use and how to format it
  • Select and use page layout features and print data