MS Excel Advanced

skyrocket

MS Excel Advanced

From AED1,850.00

Description

This course is aimed at experienced Excel users who need to perform more complex functions with excel documents.

Your Gain:

  • Work with Functions
  • Create Pivot Tables
  • Sharing and Tracking Workbooks
  • Protecting workbook

Requirements:

You must have sound Excel skills and understand key concepts of spreadsheets

Course Duration:

08 hours

Course Content

Creating Formulae and Functions
  • Concept
  • Creating Formulae
  • Referencing
  • Common Basic Functions
  • Complex functions
Summarizing Data with Pivot Tables
  • Inserting calculated fields
  • Manipulating Fields
  • Grouping Data containing Dates and Numbers
  • Formatting Pivot Table
  • Pivot Table Options
Protecting and Sharing
  • Sharing a file
  • Tracking changes
  • Accepting or rejecting changes
  • Applying Data validation rules
  • Inserting comments
  • Protecting cells, sheets, files
  • Password protecting a file
  • Password protecting a cell range
Templates
  • Viewing Sample Templates
  • Creating Custom Templates
  • Opening And Editing Templates
  • Setting Template Properties

Reviews

There are no reviews yet.

Be the first to review “MS Excel Advanced”

Book Now
Contact Us