Higher Education

shoe image

Microsoft® Excel® 2013 : Comprehensive (Print on Demand)

Author(s): Steven M. Freund | Mali Jones | Joy L. Starks

ISBN: 9788131531686

1st Edition

Copyright: 2014

India Release: 2016

₹2290

Binding: Paperback

Pages: 916

Trim Size: 279 x 216

Refer Book

Order Inspection Copy

Introduce your students to the latest that Microsoft Office has to offer with the new generation of Shelly Cashman Series® books! For the past three decades, the Shelly Cashman Series has effectively introduced computer skills to millions of students. With Microsoft Excel 2013, we're continuing our history of innovation by enhancing our proven pedagogy to reflect the learning styles of today's students. In this text you'll find features that are specifically designed to engage students, improve retention, and prepare them for future success. Our trademark step-by-step, screen-by-screen approach now encourages students to expand their understanding of Microsoft Excel 2013 through experimentation, critical thought, and personalization. With these enhancements and more, the Shelly Cashman Series® continues to deliver the most effective educational materials for you and your students.

  • Step-by-Step Learning: Screen-by-screen guidance supports all learning styles and real-world application.
  • Project-Based Pedagogy: Each chapter centers on solving a practical problem, encouraging critical thinking.
  • Skill Reinforcement: End-of-chapter activities offer varied opportunities to apply and expand skills.
  • Purposeful Instruction: Students learn not just how, but why each step matters.
  • Visual Roadmaps: Mini-roadmaps show progress through chapter projects.
  • Expanded Critical Thinking: “Consider This” prompts and assignments develop problem-solving skills.
  • Personalization: Students add personal details to make each project unique.
  • Cloud Integration Lab: New lab explores Excel with cloud and web technologies.
  • Error Analysis Task: “Analyze, Correct, Improve” assignment builds diagnostic and improvement skills.
  • Streamlined Content: Redistributed topics ensure concise, complete skill coverage.

Office 2013 and Windows 8: Essential Concepts and Skills.

Office 365 Essentials.

1. Creating a Worksheet and a Chart.

2. Formulas, Functions, and Formatting.

3. Working with Large Worksheets, Charting, and What-If Analysis.

4. Working with Multiple Worksheets and Workbooks.

5. Financial Functions, Data Tables, and Amortization Schedules.

6. Creating, Sorting, and Querying a Table.

7. Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet.

8. Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.

9. Formula Auditing, Data Validation, and Complex Problem Solving.

10. Using Macros and Visual Basic for Applications (VBA) with Excel.

11. Collaboration Features for Workbooks.

Certification Appendix.

Index.

Quick Reference.

Important Notes for Windows 7 Users.

Steven M. Freund

Steven M. Freund attended the University of Central Florida and serves as a leader instructor of various Microsoft® Office, computer concepts, programming, and Internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute, as well as other customer events. Mr. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, Mozilla Firefox, Windows® Internet Explorer, Windows®, Office, and Dreamweaver books. He has also written numerous successful instructor supplements.

 

Mali Jones

Mali B. Jones has more than 20 years of editorial, instructional and support experience in the field of computer and information technology. She has been associated with the Shelly Cashman Series for nearly 10 years, providing editorial, authoring, and product management services.

 

Joy L. Starks

Joy L. Starks is a Professor of Computer and Information Technology at Indiana University Purdue University Indianapolis. She has written chapters in several of the Shelly Cashman Series Office books and authored the Photoshop, Java Programming, and Microsoft Publisher series of books. As well as speaking engagements, she also hosts the nationally-renowned Tech Camp for Teachers on the IUPUI campus each summer.