Learn Excel from Mr. Excel: 277 Excel Mysteries Solved

✍ Scribed by Jelen, Bill

• Publisher: Holy Macro! Books
• Year: 2006
• Tongue: English
• Leaves: 877
• Category: Library

✦ Synopsis

Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions.;Book Cover; Half Title; Full Title; Copyright Page; Table Of Contents; About The Author; Acknowledgments; Dedication; Foreword; Part-I: The Excel Environment; Show Full Menus All The Time; Show Full Toolbars All The Time; Add A Close Button To The Standard Toolbar; Close All Open Workbooks; Double The Value Of The Recently Used File List; Remember Workbooks To Open Using A Workspace; Automatically Move The Cell Pointer In A Direction After Entering A Number; How To See Headings As You Scroll Around A Report; How To See Headings And Row Labels As You Scroll Around A Report.

✦ Table of Contents

Book Cover
Half Title
Full Title
Copyright Page
Table Of Contents
About The Author
Acknowledgments
Dedication
Foreword
Part-I: The Excel Environment
Show Full Menus All The Time
Show Full Toolbars All The Time
Add A Close Button To The Standard Toolbar
Close All Open Workbooks
Double The Value Of The Recently Used File List
Remember Workbooks To Open Using A Workspace
Automatically Move The Cell Pointer In A Direction After Entering A Number
How To See Headings As You Scroll Around A Report
How To See Headings And Row Labels As You Scroll Around A Report. How To Print Titles At The Top Of Each Pageprint A Letter At The Top Of Page 1 And Repeat Headings At The Top Of Each Subsequent Page
How To Print Page Numbers At The Bottom Of Each Page
How To Make A Wide Report Fit To One Page Wide By Many Pages Tall
Arrange Windows To See Two Or More Open Workbooks
Why Is There A ":2" After My Workbook Name In The Title Bar?
Have Excel Always Open Certain Workbook(S)
Set Up Excel Icons To Open A Specific File On Startup
Use A Macro To Further Customize Startup
Control Settings For Every New Workbook And Worksheet
Open A Copy Of A Workbook. Open A Saved File Whose Name You Cannot Recallsuppress The Update Links Message
Send Excel File As An Attachment
Save Excel Data As A Text File
Use A Laser Printer To Have Excel Calculate Faster
Use Excel As A Word Processor
Spellcheck A Region
Use Hyperlinks To Create An Opening Menu For Your Workbook
Get Quick Access To Paste Special
Use Shift Key To Reverse Popular Toolbar Icons
Create A Menu Or A Toolbar Of Your Favorite Icons
Restore Your Menus After Customizing
Quickly Copy A Formula To All Rows Of Data
Quickly Turn A Range On Its Side. Stop Excel From Autocorrecting Certain Wordsuse Autocorrect To Enable A Shortcut
Why Won't The Track Chages Feature Work In Excel?
Copy Cells From One Worksheet To Many Worksheets
Have Excel Talk To You
Enter Special Symbols
Find Text Entries
Copy A Formula That Contains Relative References
Copy A Formula While Keeping One Reference Fixed
Create A Multiplication Table
Calculate A Sales Commission
Simplify Entry Of Dollar Signs In Formulas
Learn R1c1 Referencing To Understand Formula Copying
Create Easier-To-Understand Formulas With Named Range
Use Named Constants To Store Numbers. Build A Formula Using Labels Instead Of Cell Addressesuse Natural Language Formulas To Refer To The Current Row
Assign A Formula To A Name
Total Without Using A Formula
Count, Average, Etc. Without Using A Formula
Add Two Columns Without Using Formulas
How To Calculate Sales Over Quota
How To Join Two Text Columns
How To Sort On One Segment Of An Account Id
How To Isolate The Center Portion Of An Account Id
How To Isolate Everything Before A Dash In A Column By Using Functions
How To Use Functions To Isolate Everything After A Dash In A Column. How To Use Functions To Isolate Everything After The Second Dash In A Column.

✦ Subjects

Business;Computer science;Electronic books