MENY

Excel Advanced Course (in English)

This course is for those who already use Excel on a daily basis, but who wants to become more proficient and efficient. In this course we will go through more advanced features, analysis tools and methods when producing spreadsheets.

Excel banner

Prerequisites:
Excel basics course.

Audience
The course is aimed at people familiar with the Excel tools that require further study in the use of more advanced tools like lists and pivot techniques.

Goal
To create and effectively use large lists and tables, as well as creating and using pivot tables in Excel.

Teaching method
Classroom instruction with a maximum of 12 participants. One computer per participant.

Price
Kr. 6200, -
Includes lunch and course documentation.

Duration
2 days - from 9 am to 3 pm

Topics

  • Themes
  • Cell Styles
  • Number Format
  • Conditional Formatting
  • Naming of cells
  • Cell references
  • Consolidation of data
  • Tracking cells
  • Functions
  • Review of function types
  • Chart Types
  • Formatting the chart
  • Data Series
  • Clip Art and Images
  • Working with objects
  • Formatting Pictures
  • SmartArt
  • Lists and tables
  • Sort
  • Filtering
  • Grouping and Outlining
  • Pivot Tables
  • PivotChart
  • “If” functionality
  • Data Tables
  • Analysis
  • Data exchange
  • Linking and embedding
  • Importing data
  • Exporting data
  • What is a macro?
  • Templates

Please contact us by e-mail uis-ikt@uis.no or give us a call 51831073