|
Level 1: Basic Formatting, Absolute References, Formulas, Functions, Charts
Table of Contents
Contents About This Book Excel 2002 Keyboard Summary Sheet Quick Reference Index Visual Conventions MOUSE Program
LESSON 1: CREATING AND EDITING A SIMPLE WORKSHEET
What Is Microsoft Excel? Starting Excel Worksheets and Workbooks The Highlight The Task Pane Entering Data Undo and Redo Repeat Number Entries Save Concepts Editing Entries Selecting Cells Aligning Cell Entries AutoSum AutoCalculate Print Preview Printing Closing Workbooks Opening Workbooks Exiting from Excel
LESSON 2: EXPANDING ON THE BASICS
Managing Toolbars The Fill Handle Formulas Number Formats Merging and Splitting Cells Indenting Entries Formatting Entries The Format Painter Clearing Cell Contents and Formats
LESSON 3: POWERFUL FEATURES AND AUTOMATED TOOLS
The Ofoce Assistant Online Help AutoCorrect AutoComplete Functions Cut, Copy, and Paste Drag and Drop Right Dragging Cell Borders Fill Colors and Patterns AutoFormat Zooming Hiding Rows and Columns Unhiding Rows and Columns
LESSON 4: DATES, TEXT FEATURES, AND RESTRUCTURING WORKSHEETS
Working with Dates Date and Time Functions Line Breaks Vertical Alignment Rotating Text Column Widths and Row Heights Inserting and Deleting Rows and Columns Error Checking Tools Find and Replace Contents
LESSON 5: FINANCIAL MODELING AND ABSOLUTE CELL REFERENCES
Absolute References Revising Formulas Displaying Formulas Printing Selections Print Areas
LESSON 6: CREATING AN IMPACT WITH CHARTS
Managing Worksheets Chart Concepts Column Charts and Bar Charts Previewing and Printing Charts Moving and Sizing Embedded Charts Line Charts Pie Charts Modifying Charts
LESSON 7: WORKING WITH LARGE WORKSHEETS
Sorting Freezing Header Rows and Columns Splitting Window Panes Printing large Worksheets Inserting Page Breaks Page Break Preview Index Contents ISBN 9788173665462
|
|
Pages : 252
|