Excel Level 1
Upon successful completion of this course, students will be able to:
- work with cells and cell data by using a variety of moving and copying techniques.
- perform calculations on data by using formulas, including functions.
- change the appearance of worksheet data by using a variety of formatting techniques.
- work with multiple worksheets by formatting, repositioning, copying and moving, and adding and deleting worksheets within a workbook.
- create and modify charts.
- set the page display and printing options.
|
|
||||||||
- J asked: I want to get excel certification. How much and where are you located in New York City
- R asked: Hello, Is this seminar scheduled for anytime soon? If so, when, where, how much does it cost, and what does that include? Thank you!
- M asked: I would like to take Excel Level class. I need to know location and dates and times this class is offered.
- J asked: Would like to start as soon as possible.
- J asked: Looking for classroom basic excel training in the lower New York area.
- I asked: Need to know the address of this course? is saturday training available?
- Windows 98/ME
- Windows Server
Next Course(s):
- Excel Expert Level
- Peachtree Accounting A-Z
This course is included in these Certification Programs:
- Microsoft Office Specialist
- Certified Medical Administrative Assistant
- Certified Office Assistant
Our Program is All-Inclusive:
- 8 hours of classroom instruction
- Unlimited supervised computer lab/practice time for 6 months
- A complete instruction manual
- Certificate upon completion
- Career Enhancement Services
- Full Placement Counseling
- Free Resume Review
- Job Placement Assistance
- Free Test Preparation
- Computer-Based Training Files
- Assessment Testing
- Internship Opportunities
- Guarantee: Retake the course for free until test passed and/or employed.
- Check the schedule
Topics:
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
