Excel 2010 / Edition 1

Excel 2010 / Edition 1

by Microsoft Official Academic Course
     
 

View All Available Formats & Editions

ISBN-10: 0470907673

ISBN-13: 9780470907672

Pub. Date: 09/06/2011

Publisher: Wiley

The Microsoft Official Academic Courseware (MOAC) Office 2010 Series is the only Official Academic Course Material. The new and enhanced MOAC/ Microsoft Office Excel features Enhanced Wiley Desktop Editions as well as many other enhanced features designed to re-enforce workforce skills. The addition of animated tutorials in the Enhanced Wiley Desktop Editions and

Overview

The Microsoft Official Academic Courseware (MOAC) Office 2010 Series is the only Official Academic Course Material. The new and enhanced MOAC/ Microsoft Office Excel features Enhanced Wiley Desktop Editions as well as many other enhanced features designed to re-enforce workforce skills. The addition of animated tutorials in the Enhanced Wiley Desktop Editions and WileyPLUS courses, textbooks include additional materials on different skill levels to help users keep pace. WileyPLUS and an automatic Office assignment grader provides immediate feedback on every assignment, to help users practice and hone skills at their own pace.

MOAC/ Microsoft Office Excel is built from the ground-up around the MOS® certification objectives- making it a great way to learn all the workforce-oriented tasks required for certification. The Test Bank now offers greater flexibility and provides more than 75 questions and 3 projects per lesson, as well as automated grading via OfficeGrader. Furthermore, the latest edition's use of color in screen captures allows users to follow on screen much easier, as screen captures will look the exact same as the application. Additional projects throughout the book helps  users comprehend how a task is applied on the job. OfficeGrader functionality added to WileyPLUS provides immediate feedback on all homework, assignments, and projects and additional animated tutorials on key Office tasks provides additional help on difficult topics.

Product Details

ISBN-13:
9780470907672
Publisher:
Wiley
Publication date:
09/06/2011
Edition description:
New Edition
Pages:
432
Product dimensions:
8.60(w) x 10.80(h) x 0.70(d)

Table of Contents

LESSON 1: OVERVIEW 1

LESSON 2: USING BACKSTAGE 22

LESSON 3: WORKING WITH MICROSOFT EXCEL 2010 51

LESSON 4: FORMATTING CELLS AND RANGES 76

LESSON 5: FORMATTING WORKSHEETS 113

CIRCLING BACK 1 146

LESSON 6: MANAGING WORKSHEETS 149

LESSON 7: WORKING WITH DATA 174

LESSON 8: USING BASIC FORMULAS AND FUNCTIONS 207

CIRCLING BACK 2 245

LESSON 9: USING ADVANCED FORMULAS AND SECURING WORKBOOKS 248

LESSON 10: CREATING CHARTS AND PIVOTTABLES 304

LESSON 11: ADDING PICTURES AND SHAPES TO A WORKSHEET 342

CIRCLING BACK 3 377

APPENDIX A 380

APPENDIX B 385

GLOSSARY 386

CREDITS 389

INDEX 390

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >