|
Provided by: AcademyX Excel (classroom training) in San Francisco at AcademyXExcel |
 |
Training
Provided by AcademyX
Excel Introduction is taught by AcademyX, (www.academyx.com, 415-392-8024), the San Francisco's only Internet-focused, instructor-led training company in the Bay Area.
This course, Excel 2002 Level 1, is the first course in a series. This course will give you the skills to create, edit, format, and print basic worksheets and charts in Excel.
Course Objective: You will create basic worksheets and charts.
Target Student: Persons desiring to prepare to be a certified Microsoft Office User Specialist (MOUS) in Excel, and who already have knowledge of Microsoft Windows 98 or above operating system, and desire to gain the skills necessary to create, edit, format, and print basic worksheets and charts in Excel.
|
|
||||||||||
Excel (classroom training) in San Francisco at AcademyX
Lesson 1: Getting Started
Topic 1A: Identify What You Can Do with Excel
Topic 1B: Enter Data in a Worksheet
Topic 1C: Edit Data
Topic 1D: Change the Appearance of Data
Topic 1E: Save a Workbook
Topic 1F: Obtain Help
Lesson 2: Editing Your Worksheet
Topic 2A: Moving Data to Other Cells
Topic 2B: Copy Data to Other Cells
Topic 2C: Fill Cells with a Series of Data
Topic 2D: Insert and Delete Rows and Columns
Topic 2E: Undo and Redo an Entry
Topic 2F: Find and Replace Numbers
Topic 2G: Enter Data in a Range
Topic 2H: Verify Data in a Range
Lesson 3: Performing Calculations
Topic 3A: Sum a Range of Data
Topic 3B: Use a Built-in Function
Topic 3C: Copy a Formula
Topic 3D: Create an Absolute Reference
Lesson 4: Formatting
Topic 4A: Specify Number Formats
Topic 4B: Create a Custom Number Format
Topic 4C: Change Font Size and Type
Topic 4D: Apply Styles
Topic 4E: Add Borders and Color to Cells
Topic 4F: Find and Replace Formats
Topic 4G: Change Column Width and Row Height
Topic 4H: Align Cell Contents
Topic 4I: Merge and Center Cells
Topic 4J: Apply an AutoFormat
Lesson 5: Working with Multiple Worksheets
Topic 5A: Format Worksheet Tabs
Topic 5B: Reposition Worksheets in a Workbook
Topic 5C: Copy Worksheets
Topic 5D: Change the Number of Worksheets
Lesson 6: Creating and Modifying Charts
Topic 6A: Create a Chart
Topic 6B: Modify Chart Items
Topic 6C: Format a Chart
Topic 6D: Change the Chart Type
Lesson 7: Setting Page Display and Printing Options
Topic 7A: Freeze Rows and Columns
Topic 7B: Set Print Title
Topic 7C: Set Page Margins
Topic 7D: Create a Header and Footer
Topic 7E: Change Page Orientation
Topic 7F: Insert and Remove Page Breaks
Topic 7G: Print a Range
Topic 1A: Identify What You Can Do with Excel
Topic 1B: Enter Data in a Worksheet
Topic 1C: Edit Data
Topic 1D: Change the Appearance of Data
Topic 1E: Save a Workbook
Topic 1F: Obtain Help
Lesson 2: Editing Your Worksheet
Topic 2A: Moving Data to Other Cells
Topic 2B: Copy Data to Other Cells
Topic 2C: Fill Cells with a Series of Data
Topic 2D: Insert and Delete Rows and Columns
Topic 2E: Undo and Redo an Entry
Topic 2F: Find and Replace Numbers
Topic 2G: Enter Data in a Range
Topic 2H: Verify Data in a Range
Lesson 3: Performing Calculations
Topic 3A: Sum a Range of Data
Topic 3B: Use a Built-in Function
Topic 3C: Copy a Formula
Topic 3D: Create an Absolute Reference
Lesson 4: Formatting
Topic 4A: Specify Number Formats
Topic 4B: Create a Custom Number Format
Topic 4C: Change Font Size and Type
Topic 4D: Apply Styles
Topic 4E: Add Borders and Color to Cells
Topic 4F: Find and Replace Formats
Topic 4G: Change Column Width and Row Height
Topic 4H: Align Cell Contents
Topic 4I: Merge and Center Cells
Topic 4J: Apply an AutoFormat
Lesson 5: Working with Multiple Worksheets
Topic 5A: Format Worksheet Tabs
Topic 5B: Reposition Worksheets in a Workbook
Topic 5C: Copy Worksheets
Topic 5D: Change the Number of Worksheets
Lesson 6: Creating and Modifying Charts
Topic 6A: Create a Chart
Topic 6B: Modify Chart Items
Topic 6C: Format a Chart
Topic 6D: Change the Chart Type
Lesson 7: Setting Page Display and Printing Options
Topic 7A: Freeze Rows and Columns
Topic 7B: Set Print Title
Topic 7C: Set Page Margins
Topic 7D: Create a Header and Footer
Topic 7E: Change Page Orientation
Topic 7F: Insert and Remove Page Breaks
Topic 7G: Print a Range
About The Training Provider: AcademyX
AcademyX - Since 1998, AcademyX's (www.academyx.com) mission has been to provide the highest quality Internet training in the world. AcademyX is an Adobe Certified Training Center, as well as an authorized training company for ActiveState (Perl) and Altova (XMLSpy). We are located in downtown San Francisco near BART. Please call us if you have any questions: 415-392-8024. We offer hands-on, instructor-led...
