You are in:

Advanced Excel Course - Best way to use Excel in different contexts: planning, organising, analysing

Previous editions of the short Excel course were very popular and, to satisfy the requests for another course, the Cremona Campus offered the "Advanced Excel Course - Best way to use Excel in different contexts: planning, organising, analysing" again.

The Basic Course was held on Saturday 8 June and Saturday 15 June 2013 from 9.00 to 13.00.

The courses were open to all, especially to students, professional workers, secretaries, office workers and all the people who are interested in learning the basics of Excel or who are already familiar with it and want to learn more about what it can offer.

These courses are organised regularly as the previous editions of the short Excel course proved to be so successful. The average scores given by participants in the latest edition were:

  • course quality score: 4.38 out of 5
  • mark on the value provided by the teacher: 4.79 out of 5

The programme of the Advanced Course included the topics listed below.

  • How to organise data in a worksheet
  • How to use cell formatting
  • Automatic column resizing
  • Inserting and deleting rows and columns
  • How to fix rows and columns
  • How to insert functions in Excel - practical tasks
  • Various examples on how to perform mathematical operations on data
  • Using simple functions and conditions (if, search, etc.)
  • Conditional formatting of a table
  • Managing lists of customers, orders, services, invoices
  • Pivot tables
  • Creating automatic and customised graphs
  • Preparing modules with formulas for invoices and offers
  • Filtering lists to obtain the desired data
  • Protecting documents
  • Setting up a business plan
  • Analysing different scenarios

For more information please got to Advanced Course leaflet.