| Nota di contenuto |
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.
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.
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.
|
Info
Excel for the small business owner [[electronic resource] /] / P.K. Hari Hara Subramanian
