Microsoft Excel Advanced – Part 1

Dorset based half-day Training Course

Basepoint-Meeting room

To select and use appropriate tools and techniques to present spreadsheet information effectively

Who is this course designed for?

This course is designed for existing users of Excel who have attended the Microsoft Excel Intermediate courses, or who already possess intermediate skills. In this course, you will learn how to set up worksheets and workbooks for other users, including how to protect your data. You will learn how to use formulas and functions across worksheets and workbooks and understand how files are linked together.

Price: £99 + VAT

Contact Us:

01202 788277

Next Date: TBA

Click here to book

About your Trainer: Claire

What is in the Course?

  • Excel Review: inserting data into single and multiple cells; clearing and editing cell contents; replicating data; using find and replace; adding data and text and images to a chart; saving, opening, closing and finding workbooks; opening and saving .csv file formats; saving templates; selective data import and export; importing and exporting with Microsoft Access; setting file properties
  • Collaborating with others: protecting worksheets and workbooks; inserting comments and hyperlinks; hiding and protecting cells; applying data validation, create, modify and merge multiple copies of a shared workbook; tracking and reviewing changes; creating a workspace file
  • Advanced Formatting: formatting text, numbers and dates; adding borders and colours; changing column widths and row heights; hiding rows, columns and worksheets; merging and aligning cells; freezing panes; applying conditional formatting; creating custom formats and styles
  • Linking and consolidating workbooks: designing formulas and functions including mathematical, statistical, financial, logical and lookup; summarising data from different worksheets and workbooks; linking data from other applications; creating 3D formulas; revealing formulae; auditing formulas and functions; formatting worksheet tabs; moving, inserting, deleting and copying worksheets; checking links

What are the Course Outcomes?

To select and use appropriate tools and techniques to present spreadsheet information effectively.

You will learn how to:

  • select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets
  • protect cells, worksheets and workbooks and use a range of collaboration tools
  • design 3D formulas and functions across different worksheets and workbooks and use a range of auditing tools