Microsoft Office Excel 2010: Transition from Excel 2003 (First Look)
Microsoft Office Excel 2010 provides additional features in the latest release of the software for improving the management, presentation, and distribution of your spreadsheets. In this course, you will be introduced to the new features available in Microsoft Office Excel 2010.This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Office Excel, ideally Microsoft Office Excel 2003, and who are planning to upgrade to Microsoft Office Excel 2010.
Course Length: 4 hours and 7 minutes
|
Microsoft Office Excel 2010: Level 1
You would have used a calculator and paper to record data and perform calculations, and now want to migrate to using a computer application to store and process data in an electronic format. In this course, you will use Microsoft® Office Excel® 2010 to create spreadsheets that you can use to perform these tasks. This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.
Course Length: 5 hours and 15 minutes
|
Microsoft Office Excel 2010: Level 2
To increase your proficiency in Microsoft® Office Excel® 2010, you need to know how to perform advanced calculations, analyze and interpret data, and display spreadsheet data in an visually effective manner. In this course, you will use advanced formulas and various tools to streamline and analyze data in your spreadsheets. You will also enhance the look and appeal of your workbooks by means of adding charts and graphical objects.This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.
Course Length: 5 hours and 30 minutes
|
Microsoft Office Excel 2010: Level 3
You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some repeated tasks, troubleshooting errors, sharing workbooks with others in secure manner, applying advanced analysis techniques to more complex data sets, and sharing Excel data with other applications. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Course Length: 7 hours and 45 minutes
|
Excel® 2010: Analyzing Data Using PivotTables, Slicers, and PivotCharts
To increase your proficiency in Microsoft® Office Excel® 2010, you need to know how to selectively display the data using PivotTables and PivotCharts. In this course, you will create PivotTables and PivotCharts and use their associated tools to analyze data.This course is meant for those desiring to gain advanced skill sets related to using PivotTables, Slicers, and PivotCharts.
Course Length: 45 minutes
|
Excel® 2010: Presenting Data Using Charts
To increase your proficiency in Microsoft® Office Excel® 2010, you need to know the process of creating charts from the worksheet data and customizing them to suit your requirements. In this course, you will create a chart and modify it. This course is meant for those desiring to gain advanced skill sets related to creating charts from worksheet data.
Course Length: 45 minutes
|
Microsoft Office Excel 2008: Level 1 (Macintosh)
You want to migrate your spreadsheet data to an electronic format. In this course, you will use Microsoft Office Excel 2008 to manage, edit, and print data. This course is designed for people preparing for certification as a Microsoft Certified Application Specialist in Excel, who already have knowledge of Microsoft Office, Windows 2000 (or above), and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2008 worksheets.
Course Length: 6 hours and 14 minutes
|
Microsoft Office Excel 2008: Level 2 (Macintosh)
In this intermediate-level course, you will use Microsoft Office Excel 2008 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, which will allow the data to be analyzed in a variety of formats. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web.
Course Length: 5 hours
|
Microsoft Office Excel 2007: New Features
This course provides an overview of the redesigned user interface and interactive features of Microsoft Office Excel 2007. This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel, ideally Microsoft Excel 2003, and who have upgraded or are planning to upgrade to Microsoft Excel 2007.
Course Length: 4 hours
|
Microsoft Office Excel 2007: Level 1 (Second Edition)
As a business professional, you may have worked with the earlier versions of Excel such as Microsoft Excel 2003. This course is designed for experienced Excel users who want to use the upgraded version of Microsoft Excel 2007 or those who want to examine the redesigned user interface and utilize its interactive features. In this course, you will explore the new features and enhancements in Microsoft Excel 2007, insert and format tables, sort and filter data in spreadsheets, create charts and illustrations, and save data in specified formats. The information presented in this course will enable you to work effectively by organizing, analyzing, and presenting data. This will help you gain the confidence needed to perform tasks quickly and efficiently thereby improving your overall efficiency and productivity.
Course Length: 6 hours and 30 minutes
|
Microsoft Office Excel 2007: Level 2 (Second Edition)
In this intermediate-level course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas, which will allow the data to be analyzed in a variety of formats. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. In addition, this course helps prepare students who desire to take the Microsoft Office Specialist exam in Excel and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.
Course Length: 6 hours
|
Microsoft Office Excel 2007: Level 3 (Second Edition)
You have used Microsoft Office Excel 2007 to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel 2007, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Course Length: 8 hours and 15 minutes
|
Microsoft Office Excel 2007: VBA
In the previous Excel courses, you used Excel to simplify business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pencil and paper. You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development. In Excel 2007: Introduction to VBA you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks you learned in Excel 2007: Level 1, Excel 2007: Level 2, and Excel 2007: Level 3.
Course Length: 5 hours and 7 minutes
|