WORKING WITH ADVANCE EXCEL

IT is an integral part of every organization, it is but natural that individual working in such organization would be employing IT tools in business process and fill the need of being well versed with such tools that would result in better productivity. Swift Advance Excel is a course under the office productivity curriculum which will enable the learner to appreciate and used the advance features available with Microsoft Excel. Participants will be able to apply visual elements and advanced formulas to an excel worksheet and display data in various formats.

Working with Advanced Excel 2013

This course enables the learner to use Microsoft Office Excel 2013 to analyze and calculate complex data using tools like pivot tables and organizing and presenting data using charts and graphics. It will enable students to automate some common tasks, apply advanced analysis techniques to more complex data sets, and collaborate and share worksheets and Excel data with other applications.
This course also emphasizes creating templates, sorting and filtering data, importing and exporting data, analyzing data, and working with Excel on the Web. Furthermore, it discusses more specialized and advanced capabilities of Excel by applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.
Students will be able to extend their knowledge on Microsoft Office Excel and use it to be more productive and efficient at their workplace

Course Contents

Calculating data with advanced formulas

Organizing Worksheet and Table data

Presenting Data using Charts

 Analyzing Data using pivot tables and pivot charts

 Inserting graphic Objects
Customizing and Enhancing workbooks and the Excel environment

 Streamlining workflow

 Collaborating with others

Auditing worksheets

Analyzing data

Working with multiple workbooks
Importing and Exporting data

Using Excel with the web

Structuring workbooks with XML
Automating business operations

Manipulating the Excel environment

Pre-requisites

This course is designed for the candidates who have the basic working knowledge of Microsoft Excel.

Exit Profile

After completing this course, student will be able to apply advanced features of Microsoft office Excel 2013 and get benefit at their work place by increasing productivity and efficiency.

profile details

It features the ability to perform advance calculations, use graphing tools, create pivot tables and create macros. Excel has the same basic features as all spreadsheet applications, which use a collection of cells arranged into rows and columns to organize and manipulate data.

Eligibility Criteria

Working knowledge of basic of M/S office
Able to read and comprehend English.

Certification

After completion of the course and passing the internal exams, students will be rewarded with certificates which will add up to your resumes.

Copyright © 2019 NiitPanvel