Presenting innovative Microsoft Excel techniques for top management professionals, this reference for company leaders who do not have the time to attend courses or read bulky books on the program provides basics, special shortcuts, and tips that cover the special features of Excel. Useful facts, trivia, and insider secrets about Excel are interspersed throughout the text, and readers have the choice of jumping directly to the section of real-life case studies to learn by the innovative Do & Learn (D&L) approach. This reference is fully updated to reflect Excel 12.

Excel for the CEO (Excel for Professionals series)

Hari, P. K; ebrary, Inc

Uniontown, Ohio: Holy Macro! Books

Tickling Keys, Incorporated

United States, United States of America

1st ed., Uniontown, Ohio, 2006

Illustrated, US, 2006

October 1, 2006

subject: Excel; Business Executives; Microcomputer Spreadsheet Software; Computers; Computers-Other Applications; Computer Books: Spreadsheets; Miscellaneous Software; Computers/Spreadsheets/IBM-Compatible; Business Software-General; Spreadsheets-General; Microsoft Excel (Computer file); Microsoft Excel (Computer software)

contributor: Internet Archive

format: Image/Djvu(.djvu)

rights: The access limited around the compus-network users

unit_name: Internet Archive

topic: Excel; Business Executives; Microcomputer Spreadsheet Software; Computers; Computers-Other Applications; Computer Books: Spreadsheets; Miscellaneous Software; Computers/Spreadsheets/IBM-Compatible; Business Software-General; Spreadsheets-General; Microsoft Excel (Computer file); Microsoft Excel (Computer software)

Type: 英文图书

Bookmarks:
1. (p1) Acknowledgements
2. (p2) About the Author
3. (p3) Starting off on the Right Foot
3.1. (p4) Basic Terminology
3.2. (p19) Status Bar
3.3. (p20) Creating, Saving, Opening, and Closing Workbooks and Worksheets
3.3.1. (p5) Title Bar
3.3.2. (p6) Menu Bar
3.3.3. (p7) Active Cell
3.3.4. (p8) Toolbar Collections
3.3.5. (p9) Toolbar Collections
3.3.6. (p10) Help Bar
3.3.7. (p11) Minimize/Maximnize and Close Buttons
3.3.8. (p12) Task Pane/Task Selector
3.3.9. (p13) Task Pane/Task Selector
3.3.10. (p14) Rows and Columns
3.3.11. (p15) Formula Bar
3.3.12. (p16) Name Box
3.3.13. (p17) Scroll Bars
3.3.14. (p18) Tab Scrollers
3.3.15. (p21) Creating Workbooks
3.3.16. (p22) Saving Workbooks
3.3.17. (p23) Opening Workbooks
3.3.18. (p24) Closing Workbooks
3.4. (p25) Navigating in Excel-Within a Worksheet and Between Workbooks
3.5. (p26) Selecting Cells, Rows and Columns, Non-adjacent Cells
3.6. (p27) Editing, Updating, and Deleting Data-Ways Available
3.6.1. (p28) Copying Data
3.6.2. (p29) Moving Data
3.6.3. (p30) Updating and Deleting Data
3.6.4. (p31) Formatting Cells and Data
3.7. (p32) Sheet Background, Name, Hiding, and Unhiding
3.7.1. (p33) Entering Functions in Excel
3.8. (p34) Entering Formulas in Excel
3.9. (p35) Creating Charts-the Basics
4. (p36) Excel-lent Tips
4.1. (p37) Activating the Menus
4.2. (p38) Accessing the Toolbars with the Keyboard
4.3. (p39) Basic and Common Shortcut Keys
4.3.1. (p40) Shortcuts with the Ctrl Key Combination
4.3.2. (p41) Ctrl Key with Special Keys
4.3.3. (p42) Ctrl Key with Function Keys
4.4. (p43) Shortcuts Using the Shift Key
4.4.1. (p44) Shift Key with Numeric Pad Keys
4.4.2. (p45) Shift Key with Function Keys and Other Keys
4.5. (p46) Shortcuts Using the Alt Key
4.5.1. (p47) Alt Key with Numeric Keys
4.5.2. (p48) Alt Key with Alphabet keys
4.5.3. (p49) Alt Key with Function Keys
4.5.4. (p50) Special Shortcut Keys
4.6. (p51) Shortcuts Using the Function Keys
4.7. (p52) Twenty Terrific Excel Tips
4.8. (p53) Links for More Tips
5. (p57) Formulas, Functions, and More
5.1. (p58) What Is a Formula and How Does It Work?
5.1.1. (p59) The Operator Precedence Rules
5.1.2. (p60) Relative vs. Absolute Referencing
5.2. (p61) Introducing Array Formulas
5.3. (p62) Common Error Messages in Formulas
5.4. (p63) How are Functions Different from Formulas?
5.5. (p64) What are the Categories and Components of Functions?
5.6. (p65) Financial Functions
5.6.1. (p66) Depreciation-related Functions
5.6.2. (p67) Annuity/Investment-related Functions
5.6.3. (p68) Functions for Interest Computation
5.6.4. (p69) Examples
5.7. (p70) Date and Time Functions
5.7.1. (p71) Examples of Time-related Functions
5.7.2. (p72) Examples of Date-related Functions
5.8. (p73) Math. Trig. and Statistical Functions
5.8.1. (p74) Math and Trig functions
5.8.2. (p75) Statistical Functions
5.9. (p76) Lookup and Reference Functions
5.10. (p77) Database Functions
5.11. (p78) Text Functions
5.12. (p80) Logical Functions
5.13. (p82) Information Functions
5.14. (p84) Nesting Functions
5.15. (p86) Troubleshooting and Evaluating Formulas and Functions
5.16. (p87) Conclusion
6. (p88) Data Management in Excel
6.1. (p89) Database Management-the Basics
6.2. (p90) Data Management Functions Available in Excel
6.2.1. (p91) Creating a Database
6.3. (p92) Sorting a Database
6.3.1. (p93) Steps in Data Sorting
6.4. (p94) Filtering Data-AutoFilter and Advanced Filter
6.4.1. (p95) AutoFilter
6.4.2. (p96) Advanced Filter
6.5. (p97) Subtotals, Grouping and Outlining
6.5.1. (p98) Grouping and Outlining
6.6. (p99) Data Validation Feature
6.7. (p100) Converting Text to Columns/Importing Text Data
6.8. (p101) Sound Interesting?
7. (p102) Advanced Data Management in Excel
7.1. (p103) Database Functions-the Concept
7.2. (p104) Detailed Listing of Database Functions
7.3. (p105) Using Database Functions
7.3.1. (p106) DSUM Function
7.3.2. (p107) DCOUNT Function
7.3.3. (p108) Other Functions
7.4. (p109) Working with Data Tables
7.4.1. (p110) Data Table Based on Two Variables
7.5. (p111) Creating and Managing Lists
7.5.1. (p112) Advantages of Using a List
7.5.2. (p113) Step-by-Step Process of Creating a List
7.6. (p114) Consolidation of Data
7.6.1. (p115) Consolidation Using 3D Formulas
7.7. (p116) Importing External Data
7.8. (p117) Handling XML data
7.9. (p118) More Terrific Links
7.10. (p119) PivotTables, PivotCharts, and Reporting
7.11. (p120) Introducing PivotTables
7.12. (p121) When Should You Use a PivotTable?
7.13. (p122) Creating a PivotTable
7.14. (p123) Filtering and Modifying Fields within a PivotTable
7.15. (p124) Sorting Data and Listing Specific PivotTable Items
7.16. (p128) PivotTable Report Formatting Options
7.17. (p129) PivotTable Field Settings
7.18. (p130) Things You Should Know When Using PivotTables
7.19. (p135) Creating a PivotChart
7.20. (p136) Links for More Information
8. (p137) Auditing Tools
8.1. (p138) Introducing Auditing Tools
8.2. (p139) Formula Auditing Toolbar
8.3. (p140) Error Checking Feature
8.3.1. (p141) The Rules and What They Check for
8.3.2. (p142) Other Buttons in the Error Checking Dialog Box
8.4. (p143) Tracing Precedents
8.5. (p144) Tracing Dependents
8.6. (p145) Removing Tracing Arrows
8.7. (p146) Trace Error Option
8.8. (p147) New Comment/Edit Comment Option
8.9. (p148) Circling Invalid Data
8.10. (p149) Clearing Validation Circles
8.11. (p150) Showing Watch Window
8.12. (p151) Evaluate Formula Option
8.13. (p153) Tracking Changes Made to a Workbook
8.14. (p154) Viewing and Printing Formulas in Any Sheet
8.15. (p156) Viewing and Printing Comments and Errors
8.16. (p159) Related Links
9. (p160) Formatting and Printing Reports
9.1. (p161) Print Preview Options and Zooming
9.2. (p162) Controlling Print Selection, Page, Cells, and Copies
9.2.1. (p163) Selecting Pages to Print
9.2.2. (p164) Controlling Print Copies
9.2.3. (p165) Printing to a File
9.3. (p166) Setting, Removing Page Breaks; Page Break Preview
9.4. (p167) Print Area-Setting, Clearing
9.5. (p168) Page Control-Orientation, Size, Scaling, Quality
9.6. (p169) Alignment Control-Margins, Centering Report
9.7. (p170) Headers and Footers, First Page Numbers
9.8. (p171) Controlling Sheet Properties During Printing
9.9. (p172) Printing Charts
9.10. (p173) Four More Topics
9.11. (p178) For Further Study
10. (p179) Adding Interactivity and Publishing Reports on the Web
10.1. (p180) Saving as a Web Page
10.2. (p181) Publishing an Entire Workbook on a Web Page
10.3. (p182) Publishing One Worksheet/Range/Other Items
10.4. (p183) Publishing a Chart on a Web page
10.5. (p184) Publishing a PivotTable Report on a Web Page
10.6. (p185) Further Information
11. (p186) An Introduction to VBA
12. (p192) Case Studies
13. (p219) Goal Seek and Scenario Builder
14. (p228) One Journey Ends-Another Begins
15. (p230) Appendix A-Finding and Launching Excel
16. (p232) Appendix B-Excel's Roots
17. (p234) Index

theme: Excel; Business Executives; Microcomputer Spreadsheet Software; Computers; Computers-Other Applications; Computer Books: Spreadsheets; Miscellaneous Software; Computers/Spreadsheets/IBM-Compatible; Business Software-General; Spreadsheets-General; Microsoft Excel (Computer file); Microsoft Excel (Computer software)

This book covers real-life business cases that can be managed with Microsoft Excel. Learn how to actually use Excel's features to monitor your business. From the basics of Excel to powerful features like Pivot Tables, learn how to use Excel in running your business. This book uses the do & learn style of teaching, enabling you to learn the techniques in an easy yet definitive way, which will remain forever in the mind.

Includes bibliographical references and index
Electronic reproduction

"Excel for the CEO" is about computers/software.

2023-06-28