Excel for the small business owner /
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, tri...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Uniontown, Ohio :
Holy Macro! Books,
©2006.
|
| Subjects: | |
| Online Access: | CONNECT |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | mig00005483513 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 081008s2006 ohua o 001 0 eng d | ||
| 005 | 20240611175714.4 | ||
| 020 | |a 9781932802610 |q (electronic bk.) | ||
| 020 | |a 1932802614 |q (electronic bk.) | ||
| 035 | |a 1WRLDSHRocn261232011 | ||
| 035 | |a (OCoLC)261232011 | ||
| 037 | |a 6E33252E-3E05-412B-966B-C2768363B1AB |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 040 | |a TEFOD |b eng |e pn |c TEFOD |d TEFOD |d N$T |d OCLCQ |d VALIL |d OCLCF |d NLGGC |d YDXCP |d OCLCQ |d TEFOD |d OCLCQ |d AGLDB |d VNS |d OCLCQ |d VTS |d AU@ |d M8D |d OCLCQ |d OCLCO |d K6U |d OCLCO |d OCLCQ |d OCLCO |d OCLCL |d SFB | ||
| 049 | |a TXMM | ||
| 050 | 4 | |a HF5548.4.M523 |b S83 2006eb | |
| 082 | 0 | 4 | |a 005.54 |2 22 |
| 100 | 1 | |a Subramanian, P. K. Hari Hara. | |
| 245 | 1 | 0 | |a Excel for the small business owner / |c P.K. Hari Hara Subramanian. |
| 260 | |a Uniontown, Ohio : |b Holy Macro! Books, |c ©2006. | ||
| 300 | |a 1 online resource (vi, f, 351 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 500 | |a "Designed for entrepreneurs"--Cover | ||
| 500 | |a Includes index. | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a 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. | ||
| 505 | 0 | |a Front Cover -- Table of Contents -- Dedications -- Acknowledgements -- About the Author -- Starting off on the Right Foot -- Basic Terminology -- Creating, Saving, Opening, and Closing Workbooks and Worksheets -- Navigating in Excel -- Within a Worksheet and Between Workbooks -- Selecting Cells, Rows and Columns, Non-adjacent Cells -- Editing, Updating, and Deleting Data -- Ways Available -- Sheet Background, Name, Hiding, and Unhiding -- Entering Formulas in Excel -- Creating Charts -- the Basics -- Excel-lent Tips -- Activating the Menus -- Accessing the Toolbars with the Keyboard -- Basic and Common Shortcut Keys -- Shortcuts Using the Shift Key -- Shortcuts Using the Alt Key -- Shortcuts Using the Function Keys -- Twenty Terrific Excel Tips -- Links for More Tips -- Formulas, Functions, and More... -- What Is a Formula and How Does It Work? -- Introducing Array Formulas -- Common Error Messages in Formulas -- How are Functions Different from Formulas? -- What are the Categories and Components of Functions? -- Financial Functions -- Date and Time Functions -- Math, Trig, and Statistical Functions -- Lookup and Reference Functions -- Database Functions -- Text Functions -- Logical Functions -- Information Functions -- Nesting Functions -- Troubleshooting and Evaluating Formulas and Functions -- Conclusion -- Data Management in Excel -- Database Management -- the Basics -- Data Management Functions Available in Excel -- Sorting a Database -- Filtering Data -- AutoFilter and Advanced Filter -- Subtotals, Grouping and Outlining -- Data Validation Feature -- Converting Text to Columns / Importing Text Data -- Sound Interesting? -- Advanced Data Management in Excel -- Database Functions -- the Concept -- Detailed Listing of Database Functions -- Using Database Functions -- Working with Data Tables -- Creating and Managing Lists -- Consolidation of Data. | |
| 505 | 8 | |a Importing External Data -- Handling XML data -- More Terrific Links -- PivotTables, PivotCharts, and Reporting -- Introducing PivotTables -- When Should You Use a PivotTable? -- Creating a PivotTable -- Filtering and Modifying Fields within a PivotTable -- Sorting Data and Listing Specific PivotTable Items -- PivotTable Report Formatting Options -- PivotTable Field Settings -- Things You Should Know When Using PivotTables -- Creating a PivotChart -- Links for More Information -- Auditing Tools -- Introducing Auditing Tools -- Formula Auditing Toolbar -- Error Checking Feature -- Tracing Precedents -- Tracing Dependents -- Removing Tracing Arrows -- Trace Error Option -- New Comment / Edit Comment Option -- Circling Invalid Data -- Clearing Validation Circles -- Showing Watch Window -- Evaluate Formula Option -- Tracking Changes Made to a Workbook -- Viewing and Printing Formulas in Any Sheet -- Viewing and Printing Comments and Errors -- Related Links -- Formatting and Printing Reports -- Print Preview Options and Zooming -- Controlling Print Selection, Page, Cells, and Copies -- Setting, Removing Page Breaks -- Page Break Preview -- Print Area -- Setting, Clearing -- Page Control -- Orientation, Size, Scaling, Quality -- Alignment Control -- Margins, Centering Report -- Headers and Footers, First Page Numbers -- Controlling Sheet Properties During Printing -- Printing Charts -- Four More Topics -- For Further Study -- Adding Interactivity and Publishing Reports on the Web -- Saving as a Web Page -- Publishing an Entire Workbook on a Web Page -- Publishing One Worksheet / Range / Other Items -- Publishing a Chart on a Web page -- Publishing a PivotTable Report on a Web Page -- Further Information -- An Introduction to VBA -- What Is a Macro and What Is It Used for? -- Recording a Macro -- the Toolkit -- Writing a Macro -- the VBE Window -- Running a Macro. | |
| 505 | 8 | |a Other Advanced Topics and Links -- Case Studies -- Peter F. Drucker's Advice to CEOs -- Reviewing Projects and Their Profitability -- Checking Delivery Schedules Using Gantt Charts -- Comparing Excel Worksheets/Workbooks -- Financial Analysis Models -- Creation and Automation -- Having Your Own Menu Bar -- Control Reports Using PivotTables -- Using Conditional Statements for Reporting -- Controlling Entry of Dates -- the Dating Problem! -- Some Interesting Examples -- Goal Seek and Scenario Builder -- Using Goal Seek -- Using Scenario Builder -- Other New Techniques and Developments -- One Journey Ends -- Another Begins -- A Word of Conclusion -- Appendix A -- Finding and Launching Excel -- Where to Find Excel -- Appendix B -- Excel's Roots -- How Did It All Start -- Weaving the Excel Magic -- Index -- Back Cover. | |
| 500 | |a EBSCO eBook Business Collection |5 TMurS | ||
| 500 | |a EBSCO eBook Academic Comprehensive Collection North America |5 TMurS | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 650 | 0 | |a Small business |x Computer programs. | |
| 650 | 0 | |a Electronic spreadsheets. | |
| 730 | 0 | |a WORLDSHARE SUB RECORDS | |
| 758 | |i has work: |a Excel for the small business owner (Text) |1 https://id.oclc.org/worldcat/entity/E39PCG6g4QfcwYgvVtXKP4HjYP |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Subramanian, P.K. Hari Hara. |t Excel for the small business owner / P.K. Hari Hara Subramanian. |d Uniontown, Ohio : Holy Macro! Books, ©2006 |z 9781932802177 |
| 856 | 4 | 0 | |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=235112&authtype=ip,sso&custid=s4672406 |z CONNECT |3 eBooks on EBSCOhost |t 0 |
| 907 | |a 4762212 |b 05-23-21 |c 07-06-20 | ||
| 949 | |a ho0 | ||
| 994 | |a 92 |b TXM | ||
| 998 | |a wi |d z | ||
| 999 | f | f | |s 2ea64a07-89ee-4162-91fc-4c13c8a47a4f |i f4c88e71-4033-47fa-93e3-5dd946fed485 |t 0 |
| 952 | f | f | |a Middle Tennessee State University |b Main |c James E. Walker Library |d Electronic Resources |t 0 |e HF5548.4.M523 S83 2006eb |h Library of Congress classification |
