This course is designed for people preparing for the Microsoft Certified Application Specialist examination in Excel, and who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.
In this course, students will apply visual elements and advanced formulas to a worksheet to display data in various formats. You will further explore the Excel 2010 interface and learn to enter, edit and format data and use Microsoft Excel formulas and functions to calculate and analyse numeric data to a higher level.
In this course students will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.