MS EXCEL

About This Course

This course is designed to give users a good introduction to the basic concepts till advanced levels of MS Excel. It explores the structure of the Excel workbook and demonstrates basic techniques required for working with spreadsheets.

Career Advancement Areas

MS Excel training can make the difference between work performance that is acceptable and work performance which is levels beyond expectations. For professionals individual it will help them make their work easily in analysing data calculate formulas, sort and filter data, build charts and graphs, and provide on-demand reports.

What You Will Learn

  • Create a basic worksheet by entering text, values, and formulas.
  • Change the appearance of worksheet data by using a variety of formatting techniques.
  • Create formulas by using some of Excel's built-in functions.
  • Filter and sort Excel data.
  • Plan, create and modify charts.
  • Prepare a document for printing by using a variety of printing options.
  • Use workbooks as templates for other workbooks.
  • Manipulate worksheet data.
  • Use intermediate data management tools such as filters and advanced filters.
  • Summarize data that meets specific conditions.
  • Link to data in other worksheets and workbooks.
  • Locate and use some of the more complex Excel functions.
  • Create and modify charts.
  • Creating a Pivot Table
  • Analysing Data using Pivots
  • Filtering and Slicers
  • Creating a Pivot Chart Report
  • Working with multiple Values Areas

Instructions

Prerequisites
General Knowledge of Computers, Comfortable with Windows
Duration
11 academic Hours
Who Should Register?
  • Anyone who is interested in learning advanced Excel.

Overview

Inara Training Institute
Course Type:
Training Course
Study Mode:
Modular Classroom
Location:
Dubai, Al Barsha
Fees:
800 AED
Certification:
Certificate of Completion
Date:
31/03/17


Your information is 100% Secure and will be delivered directly to the school.