|
Provided by: RAMCO Software Training Microsoft Excel 2007 Level 2Training, Instruction and Documentation |
 |
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.
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
|
|
||||||||||||||||||||
Certificate Program
Provided by RAMCO Software Training
- P asked: Hi, Just wanted to know when I could get into the next vaible class in Seattle ?
- J asked: please send me a schedule for the columbus, ohio area. thank you!
- T asked: Please e-mail me class dates, times, and cost. Thanks, com
- M asked: When and where would I be able to attend a RAMCO seminar in Tacoma, WA, level ? Thanks!
- J asked: When is the next available course in Tacoma WA?
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 - Whether you are a training coordinator needing to increase staff productivity or an IT professional charged with a new project using computer software you can't even spell, we have innovative solutions for you. As your technology training partner, we help you identify software training goals, set up online training, hands-on classes, or demo-style seminars to achieve those goals, coordinate...
