Working with Advanced Excel 2013

IT is an integral part of every organization, it is but natural that individuals working in such organizations would be employing IT tools in business processes and feel the need of being well versed with such tools that would result in better productivity.

Swift Advanced Excel is a course under the Office Productivity Curriculum which will enable the learner to appreciate and use the advanced 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.

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 on 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.

Contents

This course is designed for the candidates who have the basic working knowledge of Microsoft Excel and are proficient in working with contents of MS Office Excel Level 1 as outlined below.

  • Working with an Excel worksheet
  • Modifying a worksheet
  • Performing Calculations
  • Formatting a worksheet
  • Developing a workbook
  • Printing workbook contents
  • Presenting data using Charts

Pre-Requisites

  • Working knowledge of MS Excel Level 1 objectives which are defined above

Exit Profile

  • After completing this course, students will be able to apply advanced features of Microsoft Office Excel 2013 and benefit at their workplace by increasing productivity and efficiency