Microsoft Excel Intermediate – Part 1

Dorset based half-day Training Course

Basepoint-Meeting room

To use appropriate formulas and data analysis tools and techniques to summarise and display spreadsheet information

Who is this course designed for?

This course is designed for existing users of Excel who have attended the Microsoft Excel Foundation courses, or who already possess foundation skills. In this course, you will learn how to streamline your spreadsheets by using more powerful calculations. You will also learn how to structure your data more effectively.

Price: £99 + VAT

Contact Us:

01202 788277

Next Date: TBA

Click here to book

About your Trainer: Claire

What is in the Course?

  • Entering and editing data: Inserting data into single and multiple cells; clearing and editing cell contents; replicating data; using find and replace; adding data to a chart; inserting images.
  • Storing and retrieving: Saving, opening, closing and finding workbooks; opening and saving .csv file formats; saving templates.
  • Calculating with advanced formulas and functions: Review of simple formulas; setting up named ranges; creating logical and conditional functions; setting up lookup and reference functions; nesting formulas and functions; working with mathematical, statistical and financial functions; using auditing tools to validate formulas and functions and check for errors; revealing formulae; working with circular references; creating formulas and functions across multiple worksheets.
  • Structuring a workbook: Adding and deleting rows and columns; inserting worksheets; working with multiple workbooks and worksheets; using ranges; hiding and protecting cells and worksheets; moving/renaming/colouring/deleting and copying worksheets; setting design and layout of worksheets.

What are the Course Outcomes?

You will learn how to:

  • structure and enter numerical and other data accurately
  • combine and link data across worksheets
  • store and retrieve spreadsheet files
  • use advanced functions and formulas to meet calculation requirements