This title is being sold in the downloadable VitalBook™ format.
The Professional Approach Series is designed for students unfamiliar with the Microsoft Office Suite, or even students who are nervous about trying to learn computer skills. It is ideal for students who are new to the world of computers, yet in-depth enough to teach and challenge more savvy users. Each lesson contains up to 25 skill-applications and 5 end-of-unit skill-applications that take students from simple to complex situations. The Office 2007 texts complete instruction in all skill sets and activities for the appropriate MCAS Exams.
This title will only allow printing of 2 consecutive pages and copying of 2 consecutive pages at a time.
Table of Contents
- preface
- installation requirements
- windows tutorial
- case study
- Lesson 1: Getting Started with Excel
- Lesson 2: Creating a Workbook
- Lesson 3: Using Editing and Style tools
- Lesson 4: Exploring Home Tab Commands
- Unit 1: Applications
- Lesson 5: Exploring Formula Basics
- Lesson 6: Working with Functions
- Lesson 7: Using Logical and Financial Functions
- Lesson 8: Rounding and Nesting Functions
- Unit 2: Applications
- Lesson 9: Building Charts
- Lesson 10: Inserting Shapes
- Lesson 11: Using Images and SmartArt Graphics
- Unit 3: Applications
- Lesson 12: Using 3-D References
- Lesson 13: Working with tables
- Lesson 14: Using Named Ranges and Structured References
- Unit 4: Applications
- Lesson 15: Using Auditing tools
- Lesson 16: Using What-If Analysis
- Lesson 17: Consolidating and Linking Workbooks
- Unit 5: Applications
- Lesson 18: Using External Data Sources
- Lesson 19: Exploring List Ranges
- Lesson 20: Using Data Tables and PivotTables
- Unit 6: Applications
- Lesson 21: Working with Macros
- Lesson 22: Using Templates
- Lesson 23: Using Workgroup Features
- Unit 7: Applications
- APPENDIX
- Glossary
- Index
