Excel for the small business owner [[electronic resource] /] / P.K. Hari Hara Subramanian |
Autore | Hari P. K |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Uniontown, Ohio, : Holy Macro! Books, 2006 |
Descrizione fisica | vi, a-f, 351 p |
Disciplina | 005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN | 1-932802-61-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910782682103321 |
Hari P. K
![]() |
||
Uniontown, Ohio, : Holy Macro! Books, 2006 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel for the small business owner [[electronic resource] /] / P.K. Hari Hara Subramanian |
Autore | Hari P. K |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Uniontown, Ohio, : Holy Macro! Books, 2006 |
Descrizione fisica | vi, a-f, 351 p |
Disciplina | 005.54 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN | 1-932802-61-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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. |
Record Nr. | UNINA-9910823974503321 |
Hari P. K
![]() |
||
Uniontown, Ohio, : Holy Macro! Books, 2006 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel formulas and functions for dummies [[electronic resource] /] / Ken Bluttman |
Autore | Bluttman Ken |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 |
Descrizione fisica | 1 online resource (410 p.) |
Disciplina | 005.54 |
Collana | --For dummies Excel formulas and functions for dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-46085-5
1-299-24191-3 1-118-46089-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Putting the fun in functions -- pt. 2. Doing the math -- pt. 3. Solving with statistics -- pt. 4. Working with data -- pt. 5. The part of tens. |
Record Nr. | UNINA-9910465388903321 |
Bluttman Ken
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel formulas and functions for dummies [[electronic resource] /] / Ken Bluttman |
Autore | Bluttman Ken |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 |
Descrizione fisica | 1 online resource (410 p.) |
Disciplina | 005.54 |
Collana | --For dummies Excel formulas and functions for dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN |
1-118-46085-5
1-299-24191-3 1-118-46089-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Putting the fun in functions -- pt. 2. Doing the math -- pt. 3. Solving with statistics -- pt. 4. Working with data -- pt. 5. The part of tens. |
Record Nr. | UNINA-9910792080503321 |
Bluttman Ken
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel formulas and functions for dummies / / Ken Bluttman |
Autore | Bluttman Ken |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 |
Descrizione fisica | 1 online resource (410 p.) |
Disciplina | 005.54 |
Collana | --For dummies Excel formulas and functions for dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN |
1-118-46085-5
1-299-24191-3 1-118-46089-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Putting the fun in functions -- pt. 2. Doing the math -- pt. 3. Solving with statistics -- pt. 4. Working with data -- pt. 5. The part of tens. |
Record Nr. | UNINA-9910813685303321 |
Bluttman Ken
![]() |
||
Indianapolis, Ind., : John Wiley & Sons, Inc., 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel per saperne di più senza fatica / Greg Harvey |
Autore | Harvey, Greg |
Pubbl/distr/stampa | Milano, : McGraw-Hill Libri Italia, c1995 |
Descrizione fisica | vi, 353 p. : ill. ; 24 cm |
Disciplina | 005.369 |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
ISBN | 8838603189 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | ita |
Record Nr. | UNISALENTO-991000185999707536 |
Harvey, Greg
![]() |
||
Milano, : McGraw-Hill Libri Italia, c1995 | ||
![]() | ||
Lo trovi qui: Univ. del Salento | ||
|
Excel programming weekend crash course / / Peter G. Aitken |
Autore | Aitken Peter G |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub., c2003 |
Descrizione fisica | 1 online resource (457 p.) |
Disciplina | 005.54 |
Collana | Weekend Crash Course |
Soggetto topico |
Business - Computer programs
Electronic spreadsheets Computer software - Programming |
ISBN |
1-280-35369-4
9786610353699 0-7645-5575-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Excel Programming Weekend Crash Course; About the Author; Preface; Who Should Read This Book; Weekend Crash Course Layout and Features; Acknowledgments; Contents at a Glance; Contents; P A R T I: Friday Evening; Session 1: Microsoft Excel Programming - Why and How; Advantages of Programming; Programming Fundamentals; The VBA Language; The Excel Object Model; Objects and Classes; Macros and Programming; Designing Your Custom Application; Your First Excel Program; Programs and Procedures; Running the Program; Session 2: The VBA Code Editor; Code and Project Organization; Editing Tools
The Property WindowThe VBA Editor Menus; The Immediate Window; Using Macros in Programming; Session 3: The Excel Object Model; Understanding Properties and Methods; The Importance of Object References; Working with Collections; The Object Hierarchy; The Workbook Object; The Worksheet Object; The Usefulness of Nothing; Session 4: Syntax and Data in VBA; VBA Syntax Fundamentals; Employing Constants; Declaring and Using Variables; VBA Naming Rules; Variable Declaration and Option Explicit; Using Arrays; Determining Array Size; Understanding Variable Scope; P A R T I: Friday Evening Part Review P A R T II: Saturday MorningSession 5: Operators; The Assignment Operator; Numerical Operators; String Operators; Logical Operators; Comparison Operators; Operator Precedence; Session 6: Control Constructs; The If... Then Statement; With... End With; The Select Case Statement; The IIf Function; The Do... Loop Statement; The For... Next Statement; Stopping an Infinite Loop; The For Each... Next Statement; The Goto Statement; Session 7: Procedures and Modules; Sub Procedures; The Insert; Procedure Command; Function Procedures; Variables in Procedures; Procedure Scope; Storing Procedures Session 8: Working with Dates and TimesThe Date Data Type; Date/Time Values; Dates and System Settings; Date Calculations; The System Date and Time; Date and Time Details; Formatting Date/Time Values; Session 9: Working with Text; Text Input and Output; Searching for Text; Comparing Strings; String Conversions; Working with ASCII Values; Displaying Unicode Characters; Extracting or Modifying Parts of Strings; Session 10: Using Ranges and Selections; The Range Object; Empty Cells; Reading Data from Ranges; Naming Ranges; The Selection Property; Display a Range to the User P A R T II: Saturday Morning Part ReviewP A R T III: Saturday Afternoon; Session 11: Working with Columns, Rows, and Cells; Referencing Cells with the Cells Property; The SpecialCells Method; Screen Updating; Manipulating Columns and Rows; Referencing Entire Rows and Columns; Adding and Deleting Rows and Columns; Session 12: Programming with Custom Formulas; Cell References in Formulas; Use Caution When Using Links Between Workbooks; Operators; Avoiding Circular References; Controlling Formula Calculation; Session 13: Programming with Excel's Built-In Functions; Excel's Built-in Functions Using Excel Functions in Formulas |
Record Nr. | UNINA-9910555227103321 |
Aitken Peter G
![]() |
||
Indianapolis, IN, : Wiley Pub., c2003 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel spreadsheet tutorial with Workshop Physics Tools / John E. Gastineau...[et al.] (ed.) |
Pubbl/distr/stampa | Raleigh, NC : Physics Academic Software, c1999 |
Descrizione fisica | x, 91 p. : ill. ; 24 cm. + 1 computer laser optical disc |
Altri autori (Persone) | Gastineau, John E. |
Soggetto topico |
Electronic spreadsheets
Engineering - Data processing Science - Data processing |
ISBN | 1928550088 |
Classificazione |
502'85'53
621.3.8 LC Q183.9 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNISALENTO-991003472139707536 |
Raleigh, NC : Physics Academic Software, c1999 | ||
![]() | ||
Lo trovi qui: Univ. del Salento | ||
|
Excel VBA programming for dummies [[electronic resource] /] / by John Walkenbach |
Autore | Walkenbach John |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2013 |
Descrizione fisica | 1 online resource (411 p.) |
Disciplina | 005.5/4 |
Collana | --For dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
Soggetto genere / forma | Electronic books. |
ISBN |
1-118-49038-X
1-118-49174-2 1-299-19024-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Getting started with Excel VBA programming -- pt. 2. How VBA works with Excel -- pt. 3. Programming concepts -- pt. 4. Communicating with your users -- pt. 5. Putting it all together -- pt. 6. The part of tens. |
Altri titoli varianti | Microsoft Excel VBA programming for dummies |
Record Nr. | UNINA-9910452751803321 |
Walkenbach John
![]() |
||
Hoboken, N.J., : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Excel VBA programming for dummies [[electronic resource] /] / by John Walkenbach |
Autore | Walkenbach John |
Edizione | [3rd ed.] |
Pubbl/distr/stampa | Hoboken, N.J., : Wiley, 2013 |
Descrizione fisica | 1 online resource (411 p.) |
Disciplina | 005.5/4 |
Collana | --For dummies |
Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
ISBN |
1-118-49038-X
1-118-49174-2 1-299-19024-3 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | pt. 1. Getting started with Excel VBA programming -- pt. 2. How VBA works with Excel -- pt. 3. Programming concepts -- pt. 4. Communicating with your users -- pt. 5. Putting it all together -- pt. 6. The part of tens. |
Altri titoli varianti | Microsoft Excel VBA programming for dummies |
Record Nr. | UNINA-9910779596803321 |
Walkenbach John
![]() |
||
Hoboken, N.J., : Wiley, 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|