Working With Larger Workbooks
Using Microsoft Excel
3 Hours
Versions 2003 or 2007
This course covers topics such as linking multiple worksheets and workbooks; working with larger workbooks; and sharing workbooks. It is geared for users who have experience with Microsoft Excel and need to learn these more intermediate/advanced features.
Freezing, Hiding, and Sorting Data Keeping Headings on the Screen as You Work Hiding Columns Sorting Rows of Information Creating Custom Sorts Creating and Working with Multiple-Sheet Files Creating Multiple-Worksheet Workbooks Copying Worksheets Deleting and Inserting Worksheets Writing 3-D References Formatting Multiple Worksheets Simultaneously Grouping Multiple Worksheets Formatting Cells on Multiple Worksheets Ungrouping Worksheets
|
Writing Formulas that Link Multiple Excel Files Opening Multiple Workbooks Copying Worksheets to New Workbooks Creating Links Between Workbooks Viewing Linked Information Watching Formulas Editing Linked Source Files Inserting Rows and Columns in the Source Files Saving Multiple Files as a Workspace Opening Workspaces Working with Shared Workbooks Creating Shared Workbooks Highlighting Changes Accepting and Rejecting Changes |
Find us
Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.
Or, are you intersted in scheduling a private group class at your office or at Softek? Learn more about our private group training.
©2008 Softek Services, Inc. All Rights Reserved. - 1156 15th Street, NW Suite 100, Washington, DC 20005 - (202) 747-5000