Microsoft® Excel® 2013: Creating and Formatting Charts

Microsoft® Excel® 2013:

Creating and Formatting Charts

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

Course Description

Excel provides a variety of tools you can use to create, format and enhance charts—contextual Ribbon tab buttons, menus and galleries, shortcut menus, keyboard shortcuts, task panes, and more. Microsoft® Excel® 2013: Creating and Formatting Charts is a three-lesson basic to intermediate level course that allows you to explore using these tools to create and format common chart types. 


Lesson 1 introduces charting basics using step-by-step hands-on activities; Lessons 2 and 3 build on these basics by exploring additional charting tools and reinforcing previous learnings.


Learning Objectives

After completing this course you will be able to:


• create, preview and print commonly used charts,
• format charts using the Chart Elements and Chart Styles buttons,
• apply chart quick layouts and quick styles,
• modify a chart’s underlying data using multiple methods,
• reposition and resize an embedded chart,
• move an embedded chart to its own chart sheet, and
• select and format individual chart elements.

Author Biographies

H. Albert Napier, Ph.D.


H. Albert Napier is a Professor of Management in the Jones Graduate School of Business at Rice University, where he has taught graduate level courses related to entrepreneurship, information technology, and e-business. Dr. Napier also makes numerous management development program presentations on various topics of business and information technology topics. Additionally, he was a principal of Napier & Judd, Inc., a company engaged in computer training and consulting for 20 years.


Dr. Napier has trained thousands of CPAs and others to use various software packages in classroom and online environments. Dr. Napier is on the board of directors of three e-business companies. He is the author of more than 20 articles related to management information systems and application of computer-based decision processes in business and is the co-author of more than 60 textbooks. Dr. Napier holds a Ph.D. in Business Administration, an M.B.A., and a B.A. in Mathematics and Economics, 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, an Internet textbook, and a Web design textbook, and is a contributing author on more than 15 software package 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.


© 2013 Napier-Rivers LLC



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.