Table of Contents

Getting Started with Microsoft Office 2010.
Tutorial 1: Getting Started with Excel.
Tutorial 2: Designing a Workbook.
Tutorial 3: Working with Formulas and Functions.
Tutorial 4: Working with Charts and Graphics.
Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts.
Tutorial 6: Managing Multiple Worksheets and Workbooks.
Tutorial 7: Using Advanced Functions, Conditional Formatting, and Filtering.
Tutorial 8: Developing an Excel Application.
Appendix A: Working with Text Functions and Creating Custom Formats.
Appendix B: Integrating Excel with Other Windows Programs.

About the Author

June Parsons purchased her 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 she opened a successful small computer retail store with Dan Oja that also offered software instruction to children and adults. Dr. Parsons taught at the university level for more than 20 years. She holds a doctorate in Educational Technology and was certified by the ICCP in 1995. Dr. Parsons began writing and creating educational software for Course Technology in 1992. She contributed to the Windows for Business and Illustrated Series and developed the New Perspectives, e-Course, and Practical series. She works via the Internet with a team of highly skilled media specialists and desktop publishers located in various states and provinces. 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. Mr. 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. Today, Mr. Carey has authored or co-authored more than 20 leading academic and trade texts for the software industry. 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.