Exploring Microsoft Office 2010, Volume 1

Dr. Robert T. Grauer Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business.  He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy.   Dr. Grauer has written more than 50 books on programming and information systems.  His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels.   Dr. Grauer also has been a consultant to several major corporations including IBM and American Express.  He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.    Mary Anne Poatsy, MBA, CFP Mary Anne is an adjunct faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. Mary Anne holds a B.A. in Psychology and Elementary Education from Mount Holyoke College and an MBA in Finance from Northwestern University’s Kellogg Graduate School of Management. Mary Anne has more than nine years of educational experience, ranging from elementary and secondary education to Montgomery County Community College, Muhlenberg College, and Bucks County Community College, as well as training in the professional environment. Prior to teaching, Mary Anne was a vice president at Shearson Lehman Hutton in the Muncipal Bond Investment Banking department.   She is a co-author on Technology in Action as well as Better Business.   Lynn Hogan Lynn Hogan has taught computer literacy and microcomputer applications classes at Calhoun Community College for 25 years.  For the past 18 years, she has served as chair of the Department of Computer Information Systems.  She received Calhoun’s outstanding instructor award in 2006, and currently teaches computer literacy for senior adults and web design courses.  Having developed the first online computer course at Calhoun, she continues to work with the distance education program.  She received an M.B.A. from the University of North Alabama and a Ph.D. from the University of Alabama.   She resides in Alabama with her husband and two daughters.  Much of her free time is spent traveling to cutting horse shows and dressage shows, watching her daughters compete.  In addition to working with horses, she enjoys cooking, reading, and family travel   Michelle Hulett Michelle Hulett received a B.S. degree in CIS from the University of Arkansas and a M.B.A. from Missouri State University.  She has worked for various organizations as a programmer, network administrator, computer literacy coordinator, and educator.  She currently teaches computer literacy and Web design classes at Missouri State University.   When not teaching or writing, she enjoys flower gardening, traveling (Alaska and Hawaii are favorites), hiking, canoeing, and camping with her husband, John, and dog, Dakota.   Cynthia Krebs Cynthia Krebs is a professor in the Digital Media Department at Utah Valley State College, where she has taught since 1988.  In addition to teaching classes in basic computer proficiency using Microsoft Office, she teaches classes in business presentations, business graphics, and an introduction to multimedia.  She has received the Teacher-of-the-Year Award in the School of Business twice during her tenure at UVSC.   She has written chapters for many texts, co-authored a text on advanced word processing, and has presented locally and nationally.  A graduate of Utah State University, Cynthia lives in Springville, Utah.   She has four children and one granddaughter.  When she isn’t teaching or writing, she enjoys spending time with her children and spoiling her granddaughter.   Kendall E. Martin, Ph.D. Kendall has been teaching since 1988 at a number of institutions, including Villanova University, DeSales University, Arcadia University, Ursinus College, County College of Morris, and Montgomery County Community College, at both the undergraduate and master’s degree level. Kendall’s education includes a B.S. in Electrical Engineering from the University of Rochester and an M.S. and Ph.D. in Engineering from the University of Pennsylvania. She has industrial experience in research and development environments (AT&T Bell Laboratories) as well as experience from several start-up technology firms. At Ursinus College, Kendall developed a successful faculty training program for distance education instructors, and she makes conference presentations during the year. She is a co-author on Technology in Action as well as Better Business.   Keith Mast Keith A. Mast develops a wide range of Access applications that solve challenging business problems and improve efficiency. His solutions help businesses and organizations in manufacturing, pharmaceutical, financial services, and agriculture, among other industries. Clients include Visible Filing Concepts, Inc.; Moyer’s Chicks, Inc.; Marcho Farms, Inc.; TCM America, Inc.; LANsultants, Inc.; Spector, Roseman, Kodroff, & Willis, PC; Heinz, Inc.; DuPont; and Sony Entertainment. He is an adjunct faculty member at Montgomery County Community College, Blue Bell, Pennsylvania, continuing his long-standing love of teaching and exemplified by his prior experience as a high school teacher, business school instructor, and Access seminar leader.   Keith promotes the ethical standards of the consulting profession both in how Mast Consulting, LLC deals with its clients and as an active volunteer leader of the Independent Computer Consultants Association of the Delaware Valley.   Keith resides in Norristown, PA, a suburb of Philadelphia. In his free time, he enjoys biking, running, kayaking, ballroom dancing, and being in nature. For more information, visit him on Facebook, LinkedIn, or at www.keithmast.com.   Dr. Keith Mulbery Dr. Keith Mulbery is an Associate Professor in the Information Systems and Technology Department at Utah Valley State College, where he teaches computer applications, programming, and MIS classes.  He has written more than 15 software textbooks and business communication test banks.  In January 2001, he received the Utah Valley State College Board of Trustees Award of Excellence for authoring MOUS Essentials Word 2000.  In addition to his series editor and authoring experience, he also served as a developmental editor on two word processing textbooks.   He received his B.S. and M.Ed. (majoring in Business Education) from Southwestern Oklahoma State University and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State University in 2006.  His dissertation topic was computer-assisted instructions using TAIT to supplement traditional instruction in basic computer proficiency courses.

WINDOWS 7
Chapter 1 Getting Started with Windows 7

OFFICE
Chapter 1 Office Fundamentals and File Management

Word
Chapter 1 Introduction to Word
Chapter 2 Document Presentation
Chapter 3 Collaboration and Research
Chapter 4 Document Productivity

Excel
Chapter 1 Introduction to Excel
Chapter 2 Formulas and Functions
Chapter 3 Charts
Chapter 4 Datasets and Tables

Access
Chapter 1 Introduction to Access
Chapter 2 Relational Databases and Queries
Chapter 3 Customize, Analyze, and Summarize Query Data
Chapter 4 Creating and Using Professional Forms and Reports

PowerPoint
Chapter 1 Introduction to PowerPoint
Chapter 2 Presentation Development
Chapter 3 Presentation Design
Chapter 4 PowerPoint Rich Media Tools