Excel for Work Environment (Intermediate) Closed
Excel for Work Environment (Intermediate)
Learn using the advanced Excel functions; creating charts, graphs and tables; and more.
About this course

the most needed features of Excel giving you a great insight on the world's most popular spreadsheet program.

The course will cover the Excel interface, creating advanced functions, sorting and filtering data, working with tables, links and external references, and Excel security.

Target Audience

This course is designed for Intermediate users who needs to improve their Excel skills in areas such as using advanced functions; creating charts, graphs and tables; and more.

Anybody needing Excel in his work or business will find this course of a high value.

What you'll learn

By the end of this seminar you will be able to:

  • Create Advanced functions
  • Create lookup and search functions
  • Create and edit tables
  • Automate data creation
  • Conditional formatting
  • Link and reference 
  • Apply data validation
  • Create Sparklines
  • Secure your worksheet

Outline:

The outline of this course is as follows:

  • Creating Advanced functions
  • Creating lookup and search functions
  • Creating and editing tables
  • Automation of data creation
  • Conditional formatting
  • Linking and referencing external data
  • Applying data validation
  • Creating advanced charts and Sparklines
  • Securing your worksheet
Register
Enroll into: Excel for Work Environment (Intermediate)

Excel for Work Environment (Intermediate)
Join our contact list