Instructor Led Import Data From Training Classes
From Last Minute Training
Excel Datalist Management
Upon completion of the course, participants will be able to accomplish the following:
* Add, edit, search for, and delete records in a data list using a form, as well as look up data
* Sort records in a data list using a variety of methods
* Filter data in a list using a variety of methods, as well as work with filtered data
* Create and work with subtotalled lists, as well as use
more...
From 2e2
Microsoft Excel Advanced
...PivotTables to analyse and compare large amounts of data. Import data from and export data to external databases. Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas
more...
From Boston University Corporate Education Center
Excel 2003 Level II
In Microsoft Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
Course Objective: You will apply
more...
