Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Learn Excel from Mr Excel [[electronic resource] ] : 277 Excel mysteries solved / / Bill Jelen
| Learn Excel from Mr Excel [[electronic resource] ] : 277 Excel mysteries solved / / Bill Jelen |
| Autore | Jelen Bill |
| Pubbl/distr/stampa | Uniontown, OH, : Holy Macro! Books, c2005 |
| Descrizione fisica | 1 online resource (877 p.) |
| Disciplina | 005.54 |
| Soggetto topico | Electronic spreadsheets |
| ISBN | 1-932802-19-3 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
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 |
| Record Nr. | UNINA-9910826306203321 |
Jelen Bill
|
||
| Uniontown, OH, : Holy Macro! Books, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel
| Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel |
| Autore | Marmel Elaine J |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub. |
| Descrizione fisica | 1 online resource (801 p.) |
| Disciplina | 005.54 |
| Collana | Visual read less, learn more |
| Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-281-28584-6
9786611285845 0-470-38525-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Master Visually Excel 2007; Credits; About the Author; Author's Acknowledgments; WHAT'S INSIDE; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Part I: EXCEL BASICS; What You Can Do in Excel; Start and Close Excel; Understanding the Excel Screen; Learn Excel Terminology; Understanding the Ribbon; Work with the Mini Toolbar and Context Menu; Enter Information; Undo and Redo; Move Around in a Worksheet; Chapter 1: Getting Started with Excel; Move Around in a Workbook; Manage the Status Bar; Chapter 2: Managing Workbooks; Save a Workbook; Open a Workbook
Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook Start a New Workbook; Switch between Workbooks; Work with Workspaces; Add Properties to a Workbook; Close a Workbook; Chapter 3: Formatting Cells; Change Fonts or Font Size; Apply Boldface, Italics, or Underlining; Change Font Color; Apply Font Effects; Assign a Number Format; Assign a Currency Format; Assign an Accounting Format; Assign a Short Date Format; Assign a Long Date Format; Assign a Time Format; Assign a General Format; Assign a Percentage Format; Assign a Fraction Format; Assign a Scientific Format; Assign a Text Format Assign a Special Format Assign a Custom Format; Fill Cells with Color; Indent Text within Cells; Align Cell Content Vertically; Align Cell Content Horizontally; Wrap Text within Cells; Shrink Text within Cells; Rotate Text in Cells; Add Borders to Cells; Apply a Style; Create a Style; Copy Formatting; Clear Formatting; Part II: DESIGNING WORKSHEETS; Chapter 4: Editing Worksheets; Base a Worksheet on a Template; Apply a Theme; Mix and Match Themes; Select Cells; Move or Copy Information; Find and Replace Information; Chapter 5: Proofreading a Worksheet; Check Spelling; Edit the Dictionary Translate Text Using the Thesaurus; Research Online; Chapter 6: Adjusting Worksheets; Insert and Delete Rows; Insert and Delete Columns; Swap Rows and Columns; Adjust Row Height; Adjust Column Width; Copy Width from One Column to Another; Hide and Unhide Rows or Columns; Merge Cells in Columns or Rows; Chapter 7: Managing Workbook Structure; Set Worksheet Tab Colors; Edit Multiple Worksheets Simultaneously; Add or Delete a Worksheet; Move or Copy a Worksheet; Rename a Worksheet; Hide and Unhide a Worksheet; Hide and Unhide a Workbook; Arrange Open Worksheets or Workbooks Switch to Another Workbook Merge Styles; Outline a Worksheet; Work with Custom Views of Outline Settings; Manually Create an Outline; Remove an Outline; Chapter 8: Working with Views; Switch Views; Zoom In and Zoom Out; Create and Use a Custom View; Hide or Display Gridlines; Hide or Display Row Numbers and Column Letters; Hide or Display the Formula Bar; Open a New Window; Freeze Column and Row Titles; Split a Window; Chapter 9: Printing Worksheet Information; Set Margins; Add Headers and Footers to a Worksheet; Select an Area to Print; Insert, Adjust, or Remove Page Breaks Set Page Orientation |
| Altri titoli varianti |
Excel 2007
Master visually Microsoft Office Excel 2007 |
| Record Nr. | UNINA-9910451268803321 |
|
Marmel Elaine J
|
||
| Indianapolis, IN, : Wiley Pub. | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel
| Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel |
| Autore | Marmel Elaine J |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub. |
| Descrizione fisica | 1 online resource (801 p.) |
| Disciplina | 005.54 |
| Collana | Visual read less, learn more |
| Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
| ISBN |
1-281-28584-6
9786611285845 0-470-38525-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Master Visually Excel 2007; Credits; About the Author; Author's Acknowledgments; WHAT'S INSIDE; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Part I: EXCEL BASICS; What You Can Do in Excel; Start and Close Excel; Understanding the Excel Screen; Learn Excel Terminology; Understanding the Ribbon; Work with the Mini Toolbar and Context Menu; Enter Information; Undo and Redo; Move Around in a Worksheet; Chapter 1: Getting Started with Excel; Move Around in a Workbook; Manage the Status Bar; Chapter 2: Managing Workbooks; Save a Workbook; Open a Workbook
Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook Start a New Workbook; Switch between Workbooks; Work with Workspaces; Add Properties to a Workbook; Close a Workbook; Chapter 3: Formatting Cells; Change Fonts or Font Size; Apply Boldface, Italics, or Underlining; Change Font Color; Apply Font Effects; Assign a Number Format; Assign a Currency Format; Assign an Accounting Format; Assign a Short Date Format; Assign a Long Date Format; Assign a Time Format; Assign a General Format; Assign a Percentage Format; Assign a Fraction Format; Assign a Scientific Format; Assign a Text Format Assign a Special Format Assign a Custom Format; Fill Cells with Color; Indent Text within Cells; Align Cell Content Vertically; Align Cell Content Horizontally; Wrap Text within Cells; Shrink Text within Cells; Rotate Text in Cells; Add Borders to Cells; Apply a Style; Create a Style; Copy Formatting; Clear Formatting; Part II: DESIGNING WORKSHEETS; Chapter 4: Editing Worksheets; Base a Worksheet on a Template; Apply a Theme; Mix and Match Themes; Select Cells; Move or Copy Information; Find and Replace Information; Chapter 5: Proofreading a Worksheet; Check Spelling; Edit the Dictionary Translate Text Using the Thesaurus; Research Online; Chapter 6: Adjusting Worksheets; Insert and Delete Rows; Insert and Delete Columns; Swap Rows and Columns; Adjust Row Height; Adjust Column Width; Copy Width from One Column to Another; Hide and Unhide Rows or Columns; Merge Cells in Columns or Rows; Chapter 7: Managing Workbook Structure; Set Worksheet Tab Colors; Edit Multiple Worksheets Simultaneously; Add or Delete a Worksheet; Move or Copy a Worksheet; Rename a Worksheet; Hide and Unhide a Worksheet; Hide and Unhide a Workbook; Arrange Open Worksheets or Workbooks Switch to Another Workbook Merge Styles; Outline a Worksheet; Work with Custom Views of Outline Settings; Manually Create an Outline; Remove an Outline; Chapter 8: Working with Views; Switch Views; Zoom In and Zoom Out; Create and Use a Custom View; Hide or Display Gridlines; Hide or Display Row Numbers and Column Letters; Hide or Display the Formula Bar; Open a New Window; Freeze Column and Row Titles; Split a Window; Chapter 9: Printing Worksheet Information; Set Margins; Add Headers and Footers to a Worksheet; Select an Area to Print; Insert, Adjust, or Remove Page Breaks Set Page Orientation |
| Altri titoli varianti |
Excel 2007
Master visually Microsoft Office Excel 2007 |
| Record Nr. | UNINA-9910784817903321 |
|
Marmel Elaine J
|
||
| Indianapolis, IN, : Wiley Pub. | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel
| Master visually Excel 2007 [[electronic resource] /] / by Elaine Marmel |
| Autore | Marmel Elaine J |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley Pub. |
| Descrizione fisica | 1 online resource (801 p.) |
| Disciplina | 005.54 |
| Collana | Visual read less, learn more |
| Soggetto topico |
Electronic spreadsheets
Business - Computer programs |
| ISBN |
1-281-28584-6
9786611285845 0-470-38525-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Master Visually Excel 2007; Credits; About the Author; Author's Acknowledgments; WHAT'S INSIDE; TABLE OF CONTENTS; HOW TO USE THIS BOOK; Part I: EXCEL BASICS; What You Can Do in Excel; Start and Close Excel; Understanding the Excel Screen; Learn Excel Terminology; Understanding the Ribbon; Work with the Mini Toolbar and Context Menu; Enter Information; Undo and Redo; Move Around in a Worksheet; Chapter 1: Getting Started with Excel; Move Around in a Workbook; Manage the Status Bar; Chapter 2: Managing Workbooks; Save a Workbook; Open a Workbook
Convert an Excel 97-2003 Workbook to an Excel 2007 Workbook Start a New Workbook; Switch between Workbooks; Work with Workspaces; Add Properties to a Workbook; Close a Workbook; Chapter 3: Formatting Cells; Change Fonts or Font Size; Apply Boldface, Italics, or Underlining; Change Font Color; Apply Font Effects; Assign a Number Format; Assign a Currency Format; Assign an Accounting Format; Assign a Short Date Format; Assign a Long Date Format; Assign a Time Format; Assign a General Format; Assign a Percentage Format; Assign a Fraction Format; Assign a Scientific Format; Assign a Text Format Assign a Special Format Assign a Custom Format; Fill Cells with Color; Indent Text within Cells; Align Cell Content Vertically; Align Cell Content Horizontally; Wrap Text within Cells; Shrink Text within Cells; Rotate Text in Cells; Add Borders to Cells; Apply a Style; Create a Style; Copy Formatting; Clear Formatting; Part II: DESIGNING WORKSHEETS; Chapter 4: Editing Worksheets; Base a Worksheet on a Template; Apply a Theme; Mix and Match Themes; Select Cells; Move or Copy Information; Find and Replace Information; Chapter 5: Proofreading a Worksheet; Check Spelling; Edit the Dictionary Translate Text Using the Thesaurus; Research Online; Chapter 6: Adjusting Worksheets; Insert and Delete Rows; Insert and Delete Columns; Swap Rows and Columns; Adjust Row Height; Adjust Column Width; Copy Width from One Column to Another; Hide and Unhide Rows or Columns; Merge Cells in Columns or Rows; Chapter 7: Managing Workbook Structure; Set Worksheet Tab Colors; Edit Multiple Worksheets Simultaneously; Add or Delete a Worksheet; Move or Copy a Worksheet; Rename a Worksheet; Hide and Unhide a Worksheet; Hide and Unhide a Workbook; Arrange Open Worksheets or Workbooks Switch to Another Workbook Merge Styles; Outline a Worksheet; Work with Custom Views of Outline Settings; Manually Create an Outline; Remove an Outline; Chapter 8: Working with Views; Switch Views; Zoom In and Zoom Out; Create and Use a Custom View; Hide or Display Gridlines; Hide or Display Row Numbers and Column Letters; Hide or Display the Formula Bar; Open a New Window; Freeze Column and Row Titles; Split a Window; Chapter 9: Printing Worksheet Information; Set Margins; Add Headers and Footers to a Worksheet; Select an Area to Print; Insert, Adjust, or Remove Page Breaks Set Page Orientation |
| Altri titoli varianti |
Excel 2007
Master visually Microsoft Office Excel 2007 |
| Record Nr. | UNINA-9910828905303321 |
|
Marmel Elaine J
|
||
| Indianapolis, IN, : Wiley Pub. | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen
| Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen |
| Autore | Hansen Steve |
| Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
| Descrizione fisica | 1 online resource (606 p.) |
| Disciplina |
005.369
005.54 |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
| Record Nr. | UNINA-9910456026503321 |
|
Hansen Steve
|
||
| San Francisco, : SYBEX, 2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen
| Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen |
| Autore | Hansen Steve |
| Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
| Descrizione fisica | 1 online resource (606 p.) |
| Disciplina |
005.369
005.54 |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
| Record Nr. | UNINA-9910780447603321 |
|
Hansen Steve
|
||
| San Francisco, : SYBEX, 2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen
| Mastering Excel 2003 [[electronic resource] ] : programming with VBA / / Steven M. Hansen |
| Autore | Hansen Steve |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | San Francisco, : SYBEX, 2004 |
| Descrizione fisica | 1 online resource (606 p.) |
| Disciplina |
005.369
005.54 |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| ISBN |
1-280-52218-6
9786610522187 0-7821-5105-1 1-4175-0798-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents; Introduction; Part 1 Introduction to Excel Development; Chapter 1 Excel as a Development Platform; Who Develops in Excel?; What Is an Excel Application?; Why Use Excel?; Stop When You See Red; Summary; Chapter 2 Getting to Know Your Environment; One Exceptional Editor; Managing Your Modules; Optimizing Your Editor; Helpful Editor Features; Understated Features of the Code Window; Object Inspection Using the Object Browser; Obtaining Help Has Never Been So Easy; Securing Your Project; Quick Code Navigation; Summary; Chapter 3 Getting Started with VBA; Thinking Like a Computer
VBA Building BlocksVariables Are the Elements You Interact With; Operators; Directing Your Program with Statements; Basic Array Usage; Objects-A Human-Friendly Way to Think of Bits and Bytes; Summary; Chapter 4 Debugging Tactics that Work; A Bug Epidemic; Debugging Weapons in the VBE; A Simple Debugging Methodology; Implementing Simple Error Handling; Summary; Part 2 Mastering the Excel Object Model; Chapter 5 Exploring the Application Object; A Bird's-Eye View of the Application Object; Display-Oriented Features You Have to Know; Display-Oriented Features That Are Nice to know Convenient Excel Object PropertiesCommon File Operations Simplified; Inspecting Your Operating Environment; Two Useful Bonus Members; Summary; Chapter 6 Working with the Workbook Object; Walk before You Run: Opening and Closing Workbooks; Is That Workbook Open?; Untangle Links Programmatically (Part I); Plain Vanilla Workbook Properties; Respond to User Actions with Events; Summary; Chapter 7 Winning with Worksheets; Setting the Stage; Validating Your Worksheets before Using Them; Now You See It, Now You Don't; Lock Up Your Valuables; Managing Workbook Worksheets Expounding on Worksheet EventsSummary; Chapter 8 The Most Important Object; Referring to Ranges; Finding My Way; Input Easy; Output Easier; Summary; Chapter 9 Practical Range Operations; Data Mobility with Cut, Copy, and Paste; Find What You Are Seeking; Don't Like It? Change It with Replace; Would You Like Special Sauce with That?; CurrentRegion: A Useful Shortcut; Sorting Lists Simplified; Summary; Chapter 10 Exploring Other Excel Objects; Make a Good First Impression; Chart Manipulation; Summary; Part 3 Advanced Excel Programming Techniques; Chapter 11 Developing Class Modules Class Modules Are for Creating ObjectsA Linguistic Foundation; What's the Big Deal? Why Use Objects?; Creating a Simple Object; Using Your Object; A Better, Smarter Object; An Object Showdown; Collecting Your Objects; Implementing More Accurate Properties; Summary; Chapter 12 Adding User Personalization to Your Application; The Need for Persistence; Class Semi-Specification; Planning the Plumbing; Security Considerations; The Setting Class; Collect Those Setting Objects with Settings; Pseudo? Says Who?; Put Those Settings to Work; Summary; Chapter 13 Excel Development Best Practices Deactivate Activate |
| Record Nr. | UNINA-9910823013903321 |
|
Hansen Steve
|
||
| San Francisco, : SYBEX, 2004 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mastering Excel through projects : a learn-by-doing approach from payroll to crypto to data analysis / / Hong Zhou
| Mastering Excel through projects : a learn-by-doing approach from payroll to crypto to data analysis / / Hong Zhou |
| Autore | Zhou Hong |
| Pubbl/distr/stampa | New York, New York : , : Apress Media LLC, , [2022] |
| Descrizione fisica | 1 online resource (251 pages) |
| Disciplina | 005.54 |
| ISBN |
1-5231-5101-3
1-4842-7842-9 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Chapter 1: Master Excel Through Projects -- Why Learn Through Projects -- Cell Reference and Formula -- Formula -- Cell Reference in Formulas -- Experiment -- Excel Options and Show Formulas -- Autofill or Copy -- Experiment 1 -- Experiment 2 -- Experiment 3 -- Functions to Learn -- SUM, AVERAGE, MAX, MIN, and COUNT -- CHAR and CODE -- MID -- RANDBETWEEN -- LOOKUP -- Experiment 1 -- Experiment 2 -- Experiment 3 -- IF -- IFERROR -- Autofill Formulas -- Relative Cell Reference -- Absolute Cell Reference -- Work on the Project -- Chapter Tip -- Review Points -- Chapter 2: Food Nutrition Ranking -- Functions to Learn -- IF -- ISBLANK -- AND, OR -- VLOOKUP -- Work on the Project -- Name Manager and Data Validation -- Instructions to Complete the Project -- Chapter Tip -- Review Points -- Chapter 3: Payroll Calculation -- Functions to Learn -- ROUND -- SUBSTITUTE -- INDEX -- MATCH -- Experiment 1 -- Experiment 2 -- Experiment 3 -- INDIRECT -- Work on Project 1 -- Federal Tax Withholding Explanation and Worksheet Setup -- Instructions to Complete Project 1 -- Work on Project 2 -- Table Setup and Naming -- Instructions to Complete Project 2 -- Chapter Tip -- Review Points -- Chapter 4: Public and Private Key Cryptography -- Functions to Learn -- CONCATENATE and the & -- Operator -- LEN and INT -- MOD and Its Use in Encryption -- QUOTIENT and GCD -- COUNTIF -- Knowledge to Learn -- Work on the Project -- Chapter Tip -- Review Points -- Chapter 5: Two-Way Table and Chi-Square Test -- Functions to Learn -- ISERROR -- ADDRESS -- Work on the Project -- Chapter Tip -- Review Points -- Chapter 6: Kaplan-Meier Analysis -- Functions to Learn -- MEDIAN -- COUNTIFS -- Work on the Project -- Chapter Tip -- Review Points.
Chapter 7: PivotTable Data Analysis -- Group and Subtotal -- What-If Analysis -- PivotTable and PivotChart -- Work on the Project -- Chapter Tip -- Review Points -- Chapter 8: K-Means Clustering and Iterative Calculation -- Functions to Learn -- SQRT -- SUMXMY2 -- AVERAGEIFS -- SHEET -- Work on Project 1 -- Iterative Calculation -- Experiment 1 -- Experiment 2 -- Work on Project 2 -- Chapter Tip -- Review Points -- Chapter Summary and Book Summary -- Index. |
| Record Nr. | UNINA-9910522976603321 |
|
Zhou Hong
|
||
| New York, New York : , : Apress Media LLC, , [2022] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Mi chiamo Excel: risolvo i problemi : Excel e Power Bi pratici per professionisti e aziende / Alessandro Mattavelli, Davide Bruno
| Mi chiamo Excel: risolvo i problemi : Excel e Power Bi pratici per professionisti e aziende / Alessandro Mattavelli, Davide Bruno |
| Autore | Mattavelli, Alessandro <1971- > |
| Pubbl/distr/stampa | Milano, : Franco Angeli, 2021 |
| Descrizione fisica | 341 p. : ill. ; 23 cm |
| Disciplina | 005.54 |
| Altri autori (Persone) | Bruno, Davide |
| Collana | Management tools |
| Soggetto non controllato |
Microsoft Excel |
| ISBN | 978-88-351-1811-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Record Nr. | UNINA-9910646279303321 |
|
Mattavelli, Alessandro <1971- >
|
||
| Milano, : Franco Angeli, 2021 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe
| Microsoft business intelligence tools for excel analysts / / by Michael Alexander, Jared Decker, Bernard Wehbe |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : John Wiley & Sons, , 2014 |
| Descrizione fisica | 1 online resource (385 p.) |
| Disciplina | 005.54 |
| Collana | Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts |
| Soggetto topico | Business intelligence |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-118-82156-4
1-118-82155-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Title Page; Copyright Page; About the Authors; Contents at a Glance; Table of Contents; Introduction; Part I: Leveraging Excel for Business Intelligence; Chapter 1: Important Database Concepts; Traditional Limits of Excel and How Databases Help; Database Terminology; How Databases Are Designed; Chapter 2: PivotTable Fundamentals; Introducing the PivotTable; Customizing Your PivotTable; Understanding Slicers; Creating a Timeline Slicer; Understanding the Internal Data Model; Chapter 3: Introduction to Power Pivot; Understanding the Power Pivot Internal Data Model
Linking Excel Tables to Power PivotCreating Relationships Among Your Power Pivot Tables; Creating a PivotTable from Power Pivot Data; Enhancing Power Pivot Data with Calculated Columns; Utilizing DAX to Create Calculated Columns; Understanding Calculated Fields; Chapter 4: Loading External Data into Power Pivot; Loading Data from Relational Databases; Loading Data from Flat Files; Loading Data from Other Data Sources; Refreshing and Managing External Data Connections; Chapter 5: Creating Dashboards with Power View; Activating the Power View Add-In; Creating a Power View Dashboard Chapter 6: Adding Location Intelligence with Power MapInstalling and Activating the Power Map Add-In; Loading Data into Power Map; Managing and Modifying Map Visualizations; Adding Custom Components; Customizing and Managing Power Map Tours; Chapter 7: Using the Power Query Add-In; Installing and Activating the Power Query Add-In; Power Query Basics; Understanding Column and Table Actions; Power Query Connection Types; Creating and Using Power Query Functions; Part II: Leveraging SQL for Business Intelligence; Chapter 8: Essential SQL Server Concepts; SQL Server Components Connecting to a Database ServiceSQL Server Security; Working with Databases; Working with Tables and Views; Data Importing and Exporting; Chapter 9: Introduction to SQL; SQL Basics; Advanced SQL Concepts; Chapter 10: Creating and Managing SQL Scripts; Design Concepts; Working with SQL Scripts; Indexing and Performance Considerations; SQL Solutions to Common Analytics Problems; Chapter 11: Calling Views and Stored Procedures from Excel; Importing Data from SQL Server; Passing Your Own SQL Statements to External Databases; Creating a Data Model with Multiple SQL Data Objects Calling Stored Procedures Directly from Power PivotChapter 12: Understanding Reporting Services; Reporting Services Overview; Developing a Reporting Services Report; Deploying Reports; Managing Subscriptions; Chapter 13: Browsing Analysis Services OLAP Cubes with Excel; What Is an OLAP Database and What Can It Do?; Understanding OLAP Cubes; Connecting to an OLAP Data Source; Understanding the Limitations of OLAP PivotTables; Creating Offline Cubes; Using Cube Functions; Adding Calculations to Your OLAP PivotTables; Chapter 14: Using the Data Mining Add-In for Microsoft Office Installing and Activating the Data Mining Add-In |
| Record Nr. | UNINA-9910453848103321 |
|
Alexander Michael
|
||
| Hoboken, New Jersey : , : John Wiley & Sons, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
