New Perspectives on Microsoft�Excel� 2013, Comprehensive Enhanced Edition

June Jamrich Parsons is an educator, digital book pioneer, co-author of Texty and McGuffey award-winning textbooks and a TAA fellow. She co-developed the first commercially successful multimedia, interactive digital textbook that established the standard for platforms now being developed by numerous educational publishers. In addition to authoring textbooks for Course Technology and Cengage, Dr. Parsons' career includes extensive classroom teaching and product design for eCourseware. She also served as a creative strategist for MediaTechnics Corp. and director of content for Veative Virtual Reality Labs. A member of the Association for Computing Machinery, she holds a Ph.D. in instructional technology and Certified Computing Professional certification. An esteemed professional and respected author, Dan Oja, along with June Parsons, purchased an Apple II+ in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, he and Dr. Parsons opened a successful small computer retail store that offered software instruction to children and adults. With Dr. Parsons, Mr. Oja began writing and creating educational software for Course Technology in 1992. Together, they contributed to the leading success of the Windows for Business and Illustrated Series. They also developed the New Perspectives, e-Course, and Practical series. Today, Mr. Oja's and Dr. Parson's team of highly skilled media specialists and desktop publishers located in various states and provinces work together via the Internet to deliver exceptional texts. Roy Ageloff has taught courses in computer programming, database design and development, accounting information systems, and office productivity software at the University of Rhode Island and has written textbooks in programming languages, database software, and spreadsheet applications. He is a business consultant and teacher at Paradise Valley Community College, Arizona. June Jamrich Parsons is an educator, digital book pioneer, co-author of Texty and McGuffey award-winning textbooks and a TAA fellow. She co-developed the first commercially successful multimedia, interactive digital textbook that established the standard for platforms now being developed by numerous educational publishers. In addition to authoring textbooks for Course Technology and Cengage, Dr. Parsons' career includes extensive classroom teaching and product design for eCourseware. She also served as a creative strategist for MediaTechnics Corp. and director of content for Veative Virtual Reality Labs. A member of the Association for Computing Machinery, she holds a Ph.D. in instructional technology and Certified Computing Professional certification. A leading textbook author, lecturer and instructor, Patrick Carey has authored or co-authored more than 40 popular academic and trade texts for the academic market. He has taught and written about a wide range of topics, including website design, JavaScript programming, Microsoft Office and Excel, statistics, data analysis and mathematics. Mr. Carey received his Master of Science in biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. Today, he splits his time between Wisconsin and Colorado, and when he is not writing, he can be found hiking and cycling.

Student Success Guide.
Managing Your Files.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Formatting Workbook Text and Data.
Tutorial 3: Calculating Data with Formulas and Functions.
Tutorial 4: Analyzing and Charting Financial Data.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Developing an Excel Application.
Tutorial 8: Working with Advanced Functions.
Tutorial 9: Exploring Financial Tools and Functions.
Tutorial 10: Performing What-If Analyses.
Tutorial 11: Connecting to External Data.
Tutorial 12: Collaborating on a Shared Workbook.
Additional Cases.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Advanced Filters, Database Functions, and Summary IFS Functions.
Appendix C: Enhancing Excel with Visual Basic for Applications.
Appendix D: Working with Enhanced Formatting Tools.
Appendix E: SAM Projects.
Appendix F: Capstone Projects.
Appendix G: Microsoft Office Specialist Certification.