|
Provided by: RAMCO Software Training Microsoft Excel 2007 Level 2Training, Instruction and Documentation |
 |
Certificate Program
Provided by RAMCO Software Training
The course uses a combination of lecture and hands-on exercises to familiarize students with higher level skills in the Excel program. Students learn to differentiate between absolute and relative cell references, create and use complex formulas, manipulate large worksheets, name ranges, and link worksheets.
Students should be ready to work with large spreadsheets commonly used in budget preparation after taking this class.
Related Software Programs or Products: Microsoft Excel, Microsoft Office
Related Awards, Degrees or Certifications: Microsoft Office User Specialist
Related Jobs or Careers: Accounting, Finance, Administrative Assistant, Bookkeeper, Office Assistant
|
|
||||||||||||||||||||||
Microsoft Excel 2007 Level 2
Upon successful completion of the class, students should be able to:
Create absolute and mixed cell references in formulas
Use the ROUND, DATE, IF, VLOOKUP functions
Find and replace cell contents
Protect cells and worksheets
Format cells with conditional and custom formats
Work with multiple sheets in a workbook
Copy and move cells between worksheets and worksheets between workbooks
Create a name for a range of cells and use the name in various ways
Link information in multiple worksheets and workbooks
Hide rows and columns in a worksheet
Freeze titles on the screen
Set print titles and page breaks for printing
Create absolute and mixed cell references in formulas
Use the ROUND, DATE, IF, VLOOKUP functions
Find and replace cell contents
Protect cells and worksheets
Format cells with conditional and custom formats
Work with multiple sheets in a workbook
Copy and move cells between worksheets and worksheets between workbooks
Create a name for a range of cells and use the name in various ways
Link information in multiple worksheets and workbooks
Hide rows and columns in a worksheet
Freeze titles on the screen
Set print titles and page breaks for printing
About The Training Provider: RAMCO Software Training
RAMCO Software Training - RAMCO Software Training is a leader in innovative solutions for corporate computer software training on business software programs such as Microsoft Windows, Office, Project, Adobe Photoshop, InDesign, Acrobat, and Dreamweaver. Whether at your facility or in one of our conveniently located training centers in Seattle, Tacoma, or Tukwila, RAMCO Software Training delivers a comprehensive...
