Overview

This Step-By-Step Workbook will guide you through learning every aspect of using Excel program. This comprehensive workbook/guide combines Excel Level 1, 2 and 3 into a single book. It can be used by a beginner to understand core concepts, and an advanced student to learn the in's and out's of Excel. Included are over 400 Practice Exercises that demonstrate how to use Excel concepts. They can also be used as a reference guide to quickly look up specific topics. What's is in the workbook? Click on the left side of the screen: Look Inside! Enter one of the following keywords: Variables, Range, Input Boxes, VB Editor, etc. Take A Class: http: //www.elearnlogic.com/download/schedule.pdf This valuable workbook/guide is broken into 5 major categories below: Introductory Concepts - The chapters in this group will cover three major Excel categories including Formulas, Formatting, and Printing. It also covers Sum, Average, Minimum, Maximum, Cell Manipulation, Sheet tabs, Backstage View, Font, Alignment, Number, Borders, and Fill Cell features, Print Area, Scale a sheet, Manipulating Columns and Rows. Intermediate Formulas - The primary skills covered in this group of chapters are Formulas and Functions including Name Ranges, Statistical, d104, Date/Time, Financial, Informational, Math/Trig, Logical IF Statements, Lookup, as well as Database functions. Major Components - The three major components of Excel (in this group) include Tables, Charts, and PivotTables. PivotTables will cover Filtering, Formatting, PivotCharts, Label Adjustments, and Calculation Capability. Advanced Features - In this group of chapters, students will learn the advanced in's and out's of Excel including protection, share a workbook, track changes, data validation, dropdown lists, macros, error checking, what-if analysis, and consolidate worksheets. Advanced Power Add-Ins - This is covered in a workbook/guide: http: //www.createspace.com/7528032 Excel VBA - This is covered in a separate workbook/guide: http: //www.createspace.com/7826938 Design Strategy This workbook is designed in conjunction with an Online-Instructor-Led course (for more information see: www.elearnlogic.com). Unlike other computer guides, students will not need to review lengthy procedures in order to understand a topic. All that is necessary are the brief statements and command paths located within the guide that demonstrate how a concept is used. There are many Step-By-Step Practice Exercises and more comprehensive Student Projects offered to help students better understand concepts. Furthermore, they will find that this workbook/guide can often be used as a reference to help them understand concepts quickly and thoroughly. An index is also provided on the last page to reference important topics as necessary. However, if more detail is needed for study, the Internet can be used, as well, to search a concept. Also, if student's skills are weak due to lack of implementation, they can refresh their knowledge quickly by visually scanning concepts of choice, and then testing them out using the application.

Full Product Details

9781976539428

Table of Contents

Reviews

Author Information

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.

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available