MICROSOFT EXCEL: PRACTICAL WORKBOOK
CHAPTER 1: ENTERING THE SPREADSHEET DATA LAUNCHING EXCEL OPENING A NEW WORKBOOK MOVING AROUND THE WORKBOOK MOVING WITHIN THE DISPLAYED AREA MOVING TO A NEW AREA OF THE WORKSHEET MOVING TO A DIFFERENT SHEET IN THE WORKBOOK SELECTING CELL RANGES MAKING CELL ENTRIES ENTERING DATA IN A SINGLE CELL ENTERING DATA IN A CELL RANGE FILLING IN A DATA SERIES WITH THE FILL HANDLE COPYING A FORMULA WITH THE FILL HANDLE SAVING THE SPREADSHEET IN A WORKBOOK FILE CHAPTER 2: FORMATTING THE SPREADSHEET RESIZING COLUMNS AND ROWS MAKING COLUMN WIDTHS SUIT THE DATA MANIPULATING THE HEIGHT OF CERTAIN ROWS CELL FORMATTING TECHNIQUES FORMATTING CELLS WITH THE FORMATTING TOOLBAR FORMATTING CELLS WITH THE FORMAT CELLS DIALOG BOX USING FORMAT PAINTER AND AUTOFORMAT USING CONDITIONAL FORMATTING HIDING COLUMNS AND ROWS CHAPTER 3: PRINTING SPREADSHEET REPORTS PREVIEWING THE PRINTED REPORT ADJUSTING PAGE BREAKS ADDING CUSTOM HEADERS AND FOOTERS ADDING PRINT TITLES TO A REPORT MODIFYING THE PRINT SETTING FOR A REPORT PRINTING ALL OR PART OF THE WORKBOOK PRINTING A RANGE OF CELLS PRINTING THE ENTIRE WORKBOOK PRINTING CHARTS IN THE SPREADSHEET PRINTING THE SPREADSHEET FORMULAS CHAPTER 4: MODIFYING THE SPREADSHEET FINDING AND OPENING THE WORKBOOK FOR EDITING ADDING SUMMARY INFORMATION TO A WORKBOOK SEARCHING FOR WORKBOOK FILES EXPLORING THE OPEN OPTIONS FINDING AND IDENTIFYING THE REGION THAT NEEDS EDITING SELECTING THE RANGES TO EDIT EDITING DATA ENTRIES CATCHING ERRORS WITH TEXT TO SPEECH DELETING AND INSERTING DATA AND CELLS MOVING AND COPYING DATA AND CELLS USING NOTES IN THE SPREADSHEET USING FIND AND REPLACE AND SPELL-CHECKING GROUP EDITING PART II: USING FORMULAS AND FUNCTIONS CHAPTER 5: BUILDING FORMULAS BUILDING FORMULAS BUILDING FORMULAS BY HAND BUILDING FORMULAS WITH BUILT-IN FUNCTIONS EDITING FORMULAS ALTERING THE NATURAL ORDER OF OPERATIONS USING EXTERNAL REFERENCE LINKS CONTROLLING WHEN FORMULAS ARE RECALCULATED CHAPTER 6: COPYING AND CORRECTING FORMULAS COPYING FORMULAS WITH RELATIVE REFERENCES COPYING FORMULAS WITH ABSOLUTE REFERENCES COPYING FORMULAS WITH MIXED REFERENCES USING RANGE NAMES IN FORMULAS BUILDING ARRAY FORMULAS TRACING AND ELIMINATING FORMULA ERRORS DEALING WITH CIRCULAR REFERENCES CHAPTER 7: CREATING DATE AND TIME FORMULAS CONSTRUCTING DATE AND TIME FORMULAS WORKING WITH THE DATE FUNCTIONS WORKING WITH THE TIME FUNCTIONS CHAPTER 8: FINANCIAL FORMULAS AND FUNCTIONS WORKING WITH FINANCIAL FUNCTIONS USING THE BASIC INVESTMENT FUNCTIONS FIGURING THE DEPRECIATION OF AN ASSET CHAPTER 9: USING MATH FUNCTIONS ROUNDING OFF VALUES FINDING PRODUCTS, POWERS, AND SQUARE ROOTS DOING FANCIER SUMS SUMMING PRODUCTS, SQUARES, AND THEIR DIFFERENCES CONDITIONAL TOTALS CHAPTER 10: USING STATISTICAL FUNCTIONS COMPUTING AVERAGES FINDING THE HIGHEST AND LOWEST VALUES COUNTING CELLS USING THE STATISTICAL FUNCTIONS IN THE ANALYSIS TOOLPAK ADD-IN CHAPTER 11: USING THE LOOKUP FUNCTIONS RETURNING SINGLE VALUES FROM A LOOKUP TABLE PERFORMING A HORIZONTAL LOOKUP PERFORMING A VERTICAL LOOKUP USING THE LOOKUP WIZARD CHAPTER 12: USING THE LOGICAL FUNCTIONS WORKING WITH THE LOGICAL FUNCTIONS CONSTRUCTING DECISION-MAKING FORMULAS SELECTING BETWEEN ALTERNATE VALUES SELECTING BETWEEN ALTERNATE CALCULATIONS NESTING IF FUNCTIONS CONSTRUCTING ERROR-TRAPPING FORMULAS CHAPTER 13: TEXT FORMULAS AND FUNCTIONS CONSTRUCTING TEXT FORMULAS USING TEXT FUNCTIONS PART III: WORKING WITH GRAPHICS CHAPTER 14: CHARTING SPREADSHEET DATA UNDERSTANDING EXCEL CHARTS CREATING CHARTS FORMATTING CHARTS EDITING CHARTS CHAPTER 15: ADDING GRAPHICS TO THE SPREADSHEET UNDERSTANDING GRAPHIC OBJECTS USING THE DRAWING TOOLBAR INSERTING CLIP ART IMPORTING GRAPHICS FILES DRAWING AND ADDING GRAPHIC SHAPES ADDING TEXT BOXES CONSTRUCTING WORDART PART IV: MANAGING AND SECURING DATA CHAPTER 16: BUILDING AND MAINTAINING DATA LISTS CREATING A DATA LIST SORTING LISTS USING SORTING KEYS SORTING ON MORE THAN THREE KEYS SORTING THE FIELDS (COLUMNS) IN A DATA LIST SUBTOTALING A LIST FILTERING A LIST QUERYING EXTERNAL DATABASE TABLES CHAPTER 17: PROTECTING THE SPREADSHEET PASSWORD-PROTECTING THE WORKBOOK PROTECTING THE WORKSHEET DOING DATA ENTRY IN A PROTECTED WORKSHEET PROTECTING THE ENTIRE WORKBOOK PART V: DOING DATA ANALYSIS CHAPTER 18: PERFORMING WHAT-IF ANALYSIS USING DATA TABLES CREATING SINGLE-VARIABLE DATA TABLES CREATING TWO-VARIABLE DATA TABLES EXPLORING VARIOUS SCENARIOS PERFORMING GOAL SEEKING CREATING COMPLEX MODELS WITH SOLVER CHAPTER 19: GENERATING PIVOT TABLES UNDERSTANDING PIVOT TABLES CREATING PIVOT TABLES MODIFYING THE PIVOT TABLE MODIFYING THE TABLE FORMATTING PIVOTING THE TABLE’S FIELDS CHANGING THE TABLE SUMMARY FUNCTION AND ADDING CALCULATED FIELDS CREATING PIVOT CHARTS PART VI: EXCEL AND THE WEB CHAPTER 20: PUBLISHING SPREADSHEETS AS WEB PAGES SAVING WORKSHEETS AS WEB PAGES CREATING STATIC WEB PAGES CREATING INTERACTIVE WEB PAGES WEB PAGES WITH INTERACTIVE DATA TABLES WEB PAGES WITH INTERACTIVE DATA LISTS WEB PAGES WITH INTERACTIVE PIVOT TABLES WEB PAGES WITH INTERACTIVE CHARTS EXPORTING AN INTERACTIVE WEB PAGE TO EXCEL DOING A WEB QUERY CHAPTER 21: ADDING HYPERLINKS TO SPREADSHEETS CREATING HYPERLINKS ADDING LINKS TO OTHER SHEETS IN A WORKBOOK ADDING LINKS TO OTHER DOCUMENTS ADDING LINKS TO WEB PAGES EDITING HYPERLINKS ASSIGNING LINKS TO TOOLBARS AND MENUS PART VII: MACROS AND VISUAL BASIC FOR APPLICATIONS CHAPTER 22: USING MACROS CREATING MACROS USING THE MACRO RECORDER RECORDING MACROS WITH RELATIVE CELL REFERENCES ASSIGNING MACROS TO TOOLBARS AND MENUS CHAPTER 23: USING THE VISUAL BASIC EDITOR USING THE VISUAL BASIC EDITOR EDITING A RECORDED MACRO ADDING A DIALOG BOX THAT PROCESSES USER INPUT CREATING USER-DEFINED FUNCTIONS USING A CUSTOM FUNCTION IN YOUR SPREADSHEET SAVING CUSTOM FUNCTIONS IN ADD-IN FILES PART VIII: THE PART OF TENS CHAPTER 24: TOP TEN TIPS FOR USING EXCEL LIKE A PRO GENERATE NEW WORKBOOKS FROM TEMPLATES ORGANIZE SPREADSHEET DATA ON DIFFERENT WORKSHEETS CREATE DATA SERIES WITH AUTOFILL USE RANGE NAMES FREEZE COLUMN AND ROW HEADINGS PREVENT DATA ENTRY ERRORS WITH DATA VALIDATION TRAP ERROR VALUES IN THEIR ORIGINAL FORMULAS SAVE MEMORY BY USING ARRAY FORMULAS CONTROLLING THE DISPLAY OF DATA IN TABLES THROUGH OUTLINES USE COMPARE SIDE BY SIDE TO WORK WITH TWO WORKBOOKS CHAPTER 25: TEN (MORE OR LESS) SHORTCUT KEYS FOR ENTERING DATA CHAPTER 26: TEN (MORE OR LESS) SHORTCUT KEYS FOR FORMATTING THE WORKSHEET CHAPTER 27: TEN (MORE OR LESS) SHORTCUT KEYS FOR EDITING DATA CHAPTER 28: TEN (MORE OR LESS) MISCELLANEOUS SHORTCUT KEYS