Publisher's Synopsis
This workbook is discontinued and replaced by Release 2. See: https: //www.amazon.com/dp/B09DMW9SLM
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.", learn a new variety of short cuts and time-saving tricks to enhance spreadsheet use. After studying this group of chapters, students will experience an increased understanding and productivity of Excel concepts.Obtain Your PDF Copy and Video Course
Included with this purchase is an Online Recorded Video course and PDF Download, which will guide you through the book. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt. 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 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. Also, setting up Headers and Footers will be covered.
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 of Excel 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
