Designed to cover the beginning and intermediate features of Microsoft Excel for Windows 95. Easy to learn in 30-40 hours. Activities in the text cover a variety of topics that are geared to users interest.
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 Worksheets. 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 File Management. 12 Display Options. 13 Working with Multiple Worksheets and Workbooks. 14 Linking Functions and Analysis Tools.
UNIT 3- CREATING AND ENHANCING CHARTS: 15 Chart Basics. 16 Creating Embedded Charts. 17 Editing Charts. 18 Enhanced Chart Features.
UNIT 4- PRODUCTIVITY FEATURES: 19 Protection Options. 20 Templates. 21 Creating Invoices and Purchase Orders with Templates. 22 Creating Outlines and Subtotals.
UNIT 5- WORKING WITH DATA LISTS AND MACROS: 23 Data Lists Basics. 24 Editing and Sorting Data Lists. 25 Searching Data Lists. 26 Basic Macros. UNIT 6- EXCEL'S POWER FEATURES: 27 Graphic Objects. 28 Embedding Objects. 29 Integration with Microsoft Word. 30 Integration with Microsoft PowerPoint.