Excel for job and studies 3

Building on the skills taught in the Excel 1 and 2 courses, you will learn how to use additional functions and tools in the following areas: Using names, customised number formats, working with the date and time function and with special date and time functions, daisy chain contents, process contexts from external (textual) sources, data tools, conditional formatting and the goal seek function.

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

  • Using names
  • Working with the date and time function
  • Special date and time functions
  • Conditional formatting
  • Break-even analysis and goal seek
  • Data tools