Microsoft® Excel® 2010: Working with Formulas and Functions With Lots of Tips and Tricks
H. Albert Napier, Ph.D. and Ollie N. Rivers
You can purchase this e-book (renamed "Creating and Auditing Formulas") for iOS (iPhone and iPad) here for $2.99
Description
Microsoft® Excel® 2010: Working with Formulas and Functions With Lots of Tips and Tricks is a three-lesson basic to intermediate level course. The course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2010 using step-by-step hands-on activities.
In Lesson 1, you will learn about the syntax of formulas and about Excel’s predefined formulas, called functions. Then you will create basic formulas by entering the formulas into cells manually, by using the Sum (AutoSum) feature, and by copying and pasting existing formulas into other cells. You will also learn how to use status bar options to quickly find the sum, average, minimum, maximum, and number of values for a range without creating a formula.
In Lesson 2, you will learn how to use the Formula AutoComplete feature, how to enter formulas on grouped worksheets, and how to create formulas with 3-dimensional references—references that span worksheets and workbooks. Next, you will use the Function Library to add the current date and time to a worksheet and to create a formula that performs two logical tests. Then you will learn to use defined names and column or row labels as function arguments. Finally, you will learn how to apply conditional formatting to formulas.
In Lesson 3, you will learn how to use tools that help you identify and correct errors in formulas and other kinds of worksheet errors including the Error Checking feature and the Trace Error icon, the Formula Auditing tools, the Watch Window toolbar, displaying a workbook in more than one window and splitting a worksheet into multiple viewing panes, and protecting a worksheet.
The Office Fluent user interface, first introduced with Office 2007, is very different from the Office 2003 (and earlier versions) user interface. Additionally, Office 2010 applications replace the Office 2007 Office Button and menu with the new Office 2010 File tab. Therefore, you must use Excel 2010 to complete this course.
Lessons
- Creating, Copying, and Pasting Basic Formulas
- Creating Complex Formulas
- Identifying and Correcting Errors
Author Biographies
H. Albert Napier, Ph.D.Dr. Napier is a successful professor, author and entrepreneur. Currently, he serves as Professor of Management in the Jones Graduate School of Management at Rice University, where he teaches graduate level courses on entrepreneurship, information technology and e-business.
He is a co-author of more than 60 books on Microsoft Office application software. His books have been used as the textbooks for courses in hundreds of universities, colleges, and corporations. Dr. Napier is also co-author of additional computer software training courses that are provided on the Internet.
Dr. Napier is also co-author of Creating a Winning E-Business, E-Business Technologies, Business Planning: 25 Keys to a Successful Business Plan, and Preparing an Entrepreneurial Business Plan. He is currently completing another book on the entrepreneurial process.
He is an owner of the successful e-business town Favorites that provides on-line grocery shopping for candies, condiments and everyday food items that are hard to find where you live. The company is located at www.hometownfavorites.com.
In addition to his duties at Rice, Dr. Napier was a principal for 20 years of Napier & Judd, Inc. The company provided consulting services in IT strategy, planning, and systems development to more than 200 organizations and trained more than 150,000 participants on personal computer software applications. Some of the industries served by Napier & Judd, Inc. included energy, health, education, finance, banking, distribution, and accounting.
He is the author of more than 25 articles related to information technology, human-computer interface, and applications of computer based decision processes in business.
Dr. Napier holds a B.A. degree in Mathematics and Economics, an M.B.A. degree, and a Ph.D. degree in Business Administration, all from the University of Texas at Austin.
Ollie N. Rivers
Ollie N. Rivers has more than 20 years' business experience in financial and administrative management and more than 10 years’ experience as a corporate trainer. She is a co-author of two e-business textbooks and a Web design textbook, and is a contributing author on more than 15 software package and Internet textbooks. Ms. Rivers has also developed and delivered numerous classroom and online continuing education seminars for CPAs. Ms. Rivers holds an M.B.A. and a B.S. in Accounting and Management from Houston Baptist University.
Copyright © 2009
H. Albert Napier and Ollie N. Rivers
Distributed by FreeTutorialCentral with permission
Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation.