Free Tutorial Central Home |Complex Formulas in Microsoft Excel 2003|

Working With Complex Formulas in Microsoft® Excel 2003 With Lots of Tips and Tricks

H. Albert Napier, Ph.D., Ollie N. Rivers, and JB Napier

This lesson is available in PDF format and can be downloaded free.

Description

formulas

Microsoft®Excel 2003: Working with Complex Formulas is an intermediate-level lesson that guides you through adding the same formula to multiple worksheets at one time, creating complex formulas that link worksheets and workbooks, using the Insert Function feature to identify, select, and add unfamiliar functions to formulas, using range names and column or row labels as function arguments, and applying formatting to formulas' results based on specific criteria.


Click the "Download" button to download this free lesson in PDF format.

See also:
  1. Getting Started With Excel 2003
  2. Excel 2003 Useful Functions
  3. Excel 2007

Objectives

  1. Enter formulas on grouped worksheets
  2. Create formulas with 3-D references
  3. Use the Insert Function feature
  4. Use range names and labels as function arguments
  5. Apply conditional formatting to formula results

Key Terms

Insert Function

nesting IF functions

SHIFT + click

ungroup worksheets

3-D references

conditional formatting

CTRL + click

grouping worksheets

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 BA degree in Mathematics and Economics, an MBA 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 MBA and a BS in Accounting and Management from Houston Baptist University.



JB Napier
JB Napier has over 7 years of experience in the technology and consulting industries. He has led early stage software companies in product launches, business development, and partner integration activities. Prior to working in operational roles in the software industry, Mr. Napier provided financial, operation, and strategic consulting services to Fortune 1000 companies for a global consulting firm. Mr. Napier holds a B.S. in Economics from Trinity University and an M.B.A. from the McCombs School of Business at the University of Texas at Austin.



Copyright © 2006
H. Albert Napier, Ollie N. Rivers, and JB Napier
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.