Excel 2007 Advanced - Half Day Class Personalize our class outlines. We'll create a class just for you.
Printable Version | See Other Class Topics | See All Class Outlines
Upon successful completion of this training class, students will be able to:
- Create macros to automate tasks
- Collaborate with others using workbooks
- Audit worksheets
- Analyze data
- Import data
Lesson 1: Streamlining Workflow
- Creating a Macro
- Editing a Macro
- Applying Conditional Formatting
Lesson 2: Collaborating with Others
- Protecting Worksheets
- Sharing a Workbook
Lesson 3: Auditing Worksheets
- Tracing Cell Precedents
- Tracing Cell Dependents
- Locating Errors in Formulas
Lesson 4: Analyzing Data
- Developing a PivotTable Report
- Developing a PivotChart Report
Lesson 5: Importing and Updating Data
- Importing Data from a File or Database
- Importing Data from a Web Page
- Updating Imported Data
If you would like to customize this training class, please contact us at (888) 572-1200.
Have a Question?
Give us a call at (888) 572-1200 or contact us for fast attention.
Get in touch!