Microsoft® Excel 2013

Price: $299.00

The Microsoft Office suite of applications is one of the most widely used pieces of software in the world. Whether used for professional, academic or home purposes, every entity utilizes some part of the Microsoft Office suite, whether for Apple or PC. The MS Excel course will introduce students to the ease and functionality of Excel spreadsheets to store, manipulate, analyze and visualize data in a variety of ways. Students will learn the benefits of working with MS Excel, how to create and format Excel worksheets and how to navigate through MS Excel, customize the toolbar to suit their needs, create basic worksheets by entering text, create basic formulas using MS Excel functions, and apply certain formatting functions for creating professional-looking spreadsheets. Adding more advanced skills to the program, students will learn how to work within multiple workbooks at once, organize data in a variety of strategic ways, and utilize the different chart and graph features in order to present data in the most effective and meaningful way. Finally, this course will ensure students understand how the Excel program interacts with the other Microsoft Office applications.

The MS Excel course will address the following primary course objectives:

  • Develop Excel worksheets that include formulas and functions
  • Develop professional-looking worksheets using Excel
  • Develop charts and graphs
  • Manage financial data using Excel
  • Create static and dynamic Web pages using Excel
  • Work with multiple worksheets and workbooks
  • Manipulate data with database functions, lookup function and templates
  • Enhance Excel worksheets with Visual Basic and Macros for applications
  • Demonstrate “What-If-Analysis” using Excel
  • Import data into Excel worksheets from other Microsoft applications