|
|
|||
|
|
|||
|
|
|
||
|
|
MS-Excel 2007 Level 2 COURSE INTRODUCTION: The Microsoft Excel 2007 – Level 2 course teaches students intermediate to advanced-level concepts and features of the Microsoft Excel 2007 application. |
||
|
In this course, students learn to customize Microsoft Excel and streamline workflow by building upon the basic skills learned in the Microsoft Excel 2007 – Level 1 course. They learn to use named references, validate and consolidate data, use links and hyperlinks, and reference external data. Students learn to use cell comments, custom and conditional formatting, styles, and templates. They also practice working with graphics, charts, diagrams, and databases (lists). Students accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the Microsoft Excel skills covered in the lesson. A practice exercise and review questions are included at the end of each lesson to measure progress and enforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review, to reinforce the topics learned throughout the course, and to help prepare students for the exam. OF INTEREST TO: Those who are interested in preparing and maintaining financial statements, and other kinds of reports in an up-to-date office spreadsheet environment. COURSE AIMS: To provide an understanding of Microsoft Excel that goes beyond the basics, in order to create and manage spreadsheets. PREREQUISITES:- MS-Excel 2007 Level 1 COURSE CONTENT: Lesson 1: Creating Customer Themes; Working with Quick Styles,; Using Conditional and Customer Formatting Lesson 2: Referencing Data; Using Hyperlinks; Ensuring Data Integrity Lesson 3: Creating Tables; Sorting and Filtering Data; Grouping and Outlining Lesson 4: Creating Charts; Modifying and Formatting Charts Lesson 5: Using Conditional Logic in Formulas; Using Formulas to Look Up Data; Using Formulas to Modify or Format Text; Using Formulas for Financial Calculations; Using Arrays Lesson 6: Using SmartArt; Inserting Graphic objects; Modifying and Formatting Graphic objects Lab Exercise |
|||
|
Courses Start every Monday We are open weekdays, one evening and Saturday mornings. Flexi-Time Self-Paced, Pick-'n-Mix Training. Our Exclusive System allows you to learn at your own pace within your own flexible, time commitments. There is no need to keep pace with other students Set your own schedule; You can create a schedule that lets you accommodate your job, your family and other time commitments. Financial arrangements available or use our Time Payment Plan. WINZ funding may be available - conditions apply. |
|||
