- Shopping Bag ( 0 items )
Ships from: Toledo, OH
Usually ships in 1-2 business days
This book is a comprehensive instructional tool that provides the reader with all the instruction necessary to become an expert user of this popular spreadsheet software. Immediately after new concepts are introduced, users are given activities so that the concepts may be applied. Excel '97 Tutorial and Applications cover beginning through intermediate features of the software.
UNIT 1- EXCEL BASICS: 1 Getting Started with Excel 7.0 for Windows 95. 2 Using Excel's Menus, Dialog Boxes, and Help Feature. 3 Creating a Worksheet. 4 Editing a Worksheet. 5 Number, Date, and Custom Formats. 6 Formulas and Functions. 7 Printing. UNIT 2- ENHANCING EXCEL WORKSHEETS: 8 Text Formatting. 9 Cell Enhancement. 10 Modifying Columns and Rows. 11 Display Options. 12 Working with Multiple Worksheets and Workbooks. 13 Consolidating Data. UNIT 3- CREATING AND ENHANCING CHARTS: 14 Chart Basics. 15 Creating Embedded Charts. 16 Editing Charts. 17 Enhanced Chart Features. UNIT 4- PRODUCTIVITY FEATURES: 18 Protection Options. 19 Using Templates. 20 Creating Outlines and Subtotals. UNIT 5- WORKING WITH DATA LISTS AND MACROS: 21 Data Lists Basics. 22 Editing and Sorting Data Lists. 23 Searching Data Lists. 24 Basic Macros. UNIT 6- EXCEL'S POWER FEATURES: 25 Advanced Analysis Tools. 26 Hyperlinks. 27 Graphic Objects. 28 Embedding Objects. 29 Integration with Microsoft Word. 30 Importing Data and Sharing Files. APPENDIX. GLOSSARY. INDEX.