About the Book
This product has become a valuable industry standard and everyone will need to use Excel at some point in their career. Whether it is used to create a budget, list information, or improve math accuracy, it is a very useful resource. Most people use Excel on some level or are self-taught users. This Workbook is a valuable resource for beginners to understand core concepts as well as an advanced student to learn the "in's and out's." Everyone who uses this Workbook will learn a new variety of short cuts and time-saving tricks to enhance spreadsheet use. After studying this group of chapters, students will experience a higher level of increased understanding and productivity of Excel concepts.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. This Step-By-Step Workbook will cover three major Excel categories including Formulas, Formatting, and Printing. The following topics will be covered:
- Interface - This will provide an overview of the system including cell manipulation, entering data into cells, Quick Access Toolbar, and Zooming capabilities.
- General Formulas - This will include Sum, Average, Minimum, Maximum, Count functions, as well as other manually entered formulas. Also, it will cover formula manipulation techniques such as Fill Handle, Fill Down, Paste Special, Absolute Reference, and Copying a Formula.
- Row and Columns - This will include Insert, Delete, Hiding, and Auto-Adjust Columns/Rows. We will also cover ways to format and Auto-adjust multiple columns/rows at the same time.
- Worksheet Tabs - These are located on the bottom of the interface and will allow you to Insert, Delete, Rename, Move, Copy, and change the color of the Tabs. We will also cover how to manipulate information in cells and apply them to multiple sheets at the same time.
- Large Spreadsheet Management - This will cover View Workbooks Side-By-Side, Split, Freeze, Arrange All, and Arrange 2 Sheets Side-By-Side.
- Formatting - These chapters cover Font, Alignment, Number, Borders, Format Painter, and Fill Cell Features.
- Printing - This chapter will cover Repeat Title, Print Area, and Print Selection as well as how to Scale a sheet to fit a typical sized page.
What's in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: Formulas, Formatting, Print, Worksheets, Zooming, Sum, Average, etc.
How the Workbook is Designed
This Workbook contains over 200+ step-by-step practice exercises to help you get up to speed quickly and understand each concept. The commands and features are very similar to previous versions and differences are documented where appropriate. The following link is a Video Clip explaining how the courseware has been designed and how to use it most effectively.
www.elearnlogic.com/media/coursewareexplanation.mp4
About the Author:
Jeff Hutchinson is a computer instructor teaching a variety of classes around the country. He has a BS degree from BYU in Computer-Aided Engineering and has worked in the Information Technology field supporting and maintaining computers for many years. He also previously owned a computer training and consulting firm in San Francisco, California. After selling his business in 2001, he has continued to work as an independent computer instructor/consultant around the country.
Jeff Hutchinson lives in Utah and also provides training for Utah Valley University Community Education system, offering valuable computer skills for the general knowledge of students, career development, and career advancement. Understanding the technology and the needs of students has been the basis for developing this material.
Jeff Hutchinson can be contacted at
jeffhutch@elearnlogic.com or
(801) 376-6687.