Excel for job and studies 2

You will acquire basic knowledge of the following: Formatting diagrams, page layout, setting printer properties, protecting cells and workbooks.
We will pay particular attention to diagrams.
Further topics include: Sorting and filtering data, using the advanced filter, evaluating data sets using the database function and pivot tables.

We use Windows and MS Office 2013. The skills you acquire in this course will also be useful when working with other operating systems or Office applications, including e.g. Open Office, Libre Office, Mac Office.

Contents

  • Advanced diagram options and functions
  • Printing Excel files
  • Creating links between different worksheets and workbooks
  • Protecting tables
  • Lists and filters
  • Pivot tables