Roem Ltd Software Training and Support: Microsoft Excel - Intermediate/Advanced (Affordable, guaranteed to run and fun!)


Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Intermediate/Advanced course is to broaden your knowledge of Excel. This practical course allows you to appreciate the full potential of Excel. You will be encouraged to discuss your individual requirements relevant to your work.

Dates Friday, July 26, 2019 - Download as vCalendar
Venue Sun House, 23 Queen Edith's Way, Cambridge
Contact Name Karen Roem
Email karen@roem.co.uk
Contact Phone 01223214177
Website Event website

Event details:

Microsoft® Excel® Intermediate/Advanced - course outline

Microsoft Excel is a widely used, powerful spreadsheet package. The primary objective of this one-day Intermediate/Advanced course is to broaden your knowledge of Excel. This practical course allows you to appreciate the full potential of Excel. You will be encouraged to discuss your individual requirements relevant to your work. By the end of the course you will be competent with the following skills:

Intermediate and advanced editing and formatting techniques

  • finding and replacing specific formatting in a worksheet
  • using options in the paste special dialog box
  • using alignment options in the format cells dialog box
  • inserting a hyperlink into a worksheet
  • inserting comments into a worksheet

Advanced data entry techniques

  • restricting cell entries to specific numbers, dates or times
  • restricting cell entries to specific entries in a list
  • applying conditional formatting to a worksheet

Using absolute cell references

  • entering an absolute column and absolute row cell reference into a formula
  • entering an absolute column or absolute row cell reference into a formula

Using logical functions

  • using the IF function, nesting IF functions
  • using the AND and OR functions

Creating a chart

  • what is a chart? plotting a chart
  • modifying and enhancing a chart
  • previewing and printing a chart
  • including non-contiguous data ranges in a chart

Working with a table

  • what is a table? sorting the records of a table
  • filtering the records of a table
  • specifying a range of values as criteria for a filter operation
  • adding subtotals to a table

Analyzing worksheet data

  • creating a pivottable report
  • resetting the summary function in a pivottable report
  • creating a pivotchart report 

Naming ranges

  • defining a range name
  • using a range name in a formula
  • selecting a named range

Using LOOKUP functions

  • using the VLOOKUP function
  • using the HLOOKUP function

Linking worksheets within a workbook

  • renaming worksheets in a workbook
  • moving the cell pointer from one worksheet to another
  • inserting and deleting worksheets
  • entering a formula to link related worksheets in a workbook
  • formatting multiple worksheets in one operation
  • previewing and printing multiple worksheets in one operation

Linking multiple workbooks

  • entering a formula to link multiple workbooks
  • creating a workspace

Controlling the worksheet display

  • splitting the workbook window into panes, freezing window panes
  • hiding rows and columns of a worksheet
  • opening a new workbook / arranging open workbook windows

This course outline is a guide. All our courses can be tailored to customer requirements.

Target audience 
This course is aimed at anyone who has some experience of Excel and wishes to examine some of the more advanced features.

Assumed knowledge 
Delegates should be familiar with the basics of Excel, either from attending our Introduction Course or knowledge gained from their own experience.

Price
£225 (10% discount for Cambridge Network members)

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.