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.
- email me
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
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
Collaborating with others
Working with multiple workbooks
Importing and Exporting data
Using Excel with the web
Structuring workbooks with XML
Automating business operations
Manipulating the Excel environment
This course is designed for the candidates who have the basic working knowledge of Microsoft Excel.
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.
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.
Working knowledge of basic of M/S office
Able to read and comprehend English.
After completion of the course and passing the internal exams, students will be rewarded with certificates which will add up to your resumes.