New Perspectives on Microsoft Excel 2013

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 Parsons and Dan Oja purchased their first computer, 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, they opened a successful small computer retail store that also offered software instruction to children and adults. June taught at the university level for more than 20 years, has a doctorate in Educational Technology, and was certified by the ICCP in 1995. June and Dan began writing and creating educational software for Course Technology in 1992. They contributed to the Windows for Business and Illustrated Series and developed the New Perspectives, e-Course, and Practical series. They work via the Internet with a team of highly skilled media specialists and desktop publishers located in various states and provinces. Patrick Carey received his M.S. in Biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Patrick has authored or co-authored over 20 academic and trade texts for the software industry.

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: Creating 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: Enhancing Excel with Visual Basic for Applications. Additional Cases. Appendix A: Using Text Functions and Creating Custom Formats. Appendix B: Using Advanced Filters, Database, and Summary IFS Functions. Appendix C: Creating a Shared Workbook. Appendix D: Working with Enhanced Formatting Tools.