Microsoft Excel – Advanced

£59.00

Book Now
Address
Glasdir, Plas Yn Dre, Station Road, Llanrwst, LL26 0DF    View map
Trainer

This one day Advanced Excel training course will provide you with an understanding of the more advanced features of Excel. The skills and knowledge gained in this course will enable you to use advanced data operations to summarise and consolidations data, advanced PivotTable techniques, work with macros, and much more!

What will I learn from this Microsoft Excel – Advanced course?

  • understand and modify Excel options
  • protect data in worksheets and workbooks
  • import data into Excel and export data from Excel
  • link data to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotals
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • create and edit PivotCharts
  • construct and manipulate PivotTables using some of the more advanced techniques
  • use advanced filters to analyse data
  • use a variety of data validation techniques
  • use a range of Information functions
  • use a range of text functions
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

Who is this course suitable for?

The Microsoft Excel Advanced course assumes that you have attended the Excel Introduction and Intermediate courses or have the equivalent knowledge of the software, you may find it helpful to look at the Introduction and Intermediate Course Outlines to ensure this is the correct course for you.

What other people have said about this course:

‘Very fun, useful and informative course, thanks Sue’

Microsoft Excel – Advanced

£59.00

This one day Advanced Excel training course will provide you with an understanding of the more advanced features of Excel. The skills and knowledge gained in this course will enable you to use advanced data operations to summarise and consolidations data, advanced PivotTable techniques, work with macros, and much more!

Categories: , , ,

Status

Contact Us

If you've got an enquiry, fill in the form below and we’ll get back to you asap.

Not readable? Change text. captcha txt
0

Start typing and press Enter to search