Students seeking Excel training can usually find standalone courses at colleges, universities, and adult education centers as non-credit and for-credit classes. The Excel program is also often covered in undergraduate certificate and degree courses that teach productivity software. Some certificate programs in Excel do exist and usually cover introductory through advanced topics. Depending on the institution offering the course, instructors may use different versions of Excel from different years.
Some common concepts covered in Excel courses include:
- Chart and table creation
- Data analysis
- Date integration
List of Courses
In a beginning Excel course, students develop basic knowledge of the Microsoft Office suite and are introduced to Excel specifically. Skills are developed in creating Excel spreadsheets and setting up simple calculations and formulas. Students learn how to make changes to an existing worksheet as well how to format new worksheets. A beginning Excel course also covers print set-up and techniques in working with large spreadsheets.
In an intermediate Excel course students expand on their basic skills in order to implement additional tools such as graphs, charts, and advanced formulas. An intermediate course develops skills in graph development and modification, the addition of graphic elements, and the customization of entire workbooks (multiple worksheets that work together). Students in this course may also use Pivot Tables or Pivot Charts, which are interactive graphic elements within the Excel program.
In this advanced course students learn how to automate information based on the skills they have developed in the two previous courses. This course also provides information on how to combine multiple worksheets to handle larger, more complex sets of data. Additional coursework is spent on data analysis, importing or exporting data, and coordinating Excel documents with internet sources. This course may even give students skills to develop worksheets in XML (Extensible Markup Language).
There are a variety of options for Excel training programs. These programs may be found at community colleges, private training centers, or as part of a continuing education course. There are also some employers, such as temp agencies, that offer Excel training to employees. Microsoft, the company that produces the Excel software, also offers an exam to become a Microsoft Certified Application Specialist in Excel.
Excel training courses are typically offered in a one-day format. Training can last anywhere from a one-hour basic introduction to a full eight-hour day of training. Excel training programs may be broken down into different levels from beginner to advanced, as well as according to different topics of study. As mentioned in the course list, students may learn anything from how to create tables and formulas to how to input data and share files.
Excel training programs are also offered in conjunction with the various systems and versions available. For example, a student may take an Excel for beginners class based on Excel 2000, and another student may take a similar course based on the Excel 2009 version. Each version of Excel has minor differences in how the programs operate and compute data.