Online Microsoft Excel 2007 eLearning Training

Analyzing Data in Excel 2007 Excel 2007 provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve  more...

Protecting and Sharing Excel 2007 Workbooks In many organizations, teams and individuals require frequent and possibly simultaneous access to common spreadsheets and workbooks. To meet these demands without affecting efficiency, a number of review, security, and collaboration features are available in Excel 2007. Workbooks, worksheets, and specific data within worksheets, can be protected, enabling only those with access to view or make  more...

Exchanging Data with Excel 2007 In Excel 2007, there are a number of options for importing data and sharing data with other applications. Excel 2007 includes built-in functionality for importing text files and creating database queries to retrieve data from a variety of databases. Other applications, such as Access, Word, and Outlook, can also import Excel data. Using XML in conjunction with Excel enables you to further manage  more...