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.
101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika
| 101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (243 pages) : illustrations |
| Disciplina | 005.369 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Electronic spreadsheets
Electronic spreadsheets - Computer programs Macro instructions (Electronic computers) Chemistry Physical Sciences & Mathematics Chemistry - General |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-118-90289-0 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Table of Contents; Introduction; Chapter 1: Introducing Excel Formulas; Creating and Editing Excel Formulas; Using Formula Operators; Relative versus Absolute Cell References; Using External Cell References; Formula Calculation Modes; Leveraging Excel Functions; Understanding Formula Errors; Using Named Ranges in Formulas; Chapter 2: Common Mathematical Operations; Formula 1: Calculating Percent of Goal; Formula 2: Calculating Percent Variance; Formula 3: Calculating Percent Variance with Negative Values; Formula 4: Calculating a Percent Distribution
Formula 5: Calculating a Running TotalFormula 6: Applying a Percent Increase or Decrease to Values; Formula 7: Dealing with Divide-by-Zero Errors; Formula 8: Basic Rounding of Numbers; Formula 9: Rounding to the Nearest Penny; Formula 10: Rounding to Significant Digits; Formula 11: Counting Values in a Range; Formula 12: Creating a Conversion Table; Chapter 3: Manipulating Text with Formulas; Formula 13: Joining Text Strings; Formula 14: Setting Text to Sentence Case; Formula 15: Removing Spaces from a Text String; Formula 16: Extract Parts of a Text String Formula 17: Finding a Particular Character in a Text StringFormula 18: Substituting Text Strings; Formula 19: Counting Specific Characters in a Cell; Formula 20: Adding a Line Break within a Formula; Formula 21: Cleaning Strange Characters from Text Fields; Formula 22: Padding Numbers with Zeros; Formula 23: Formatting the Numbers in a Text String; Chapter 4: Working with Dates and Times; Formula 24: Getting the Current Date and Time; Formula 25: Calculating Age; Formula 26: Calculating the Number of Days between Two Dates; Formula 27: Calculating the Number of Workdays between Two Dates Formula 28: Generate a List of Business Days Excluding HolidaysFormula 29: Extracting Parts of a Date; Formula 30: Calculating the Number of Years and Months between Dates; Formula 31: Converting Dates to Julian Date Formats; Formula 32: Calculating the Percent of Year Completed and Remaining; Formula 33: Returning the Last Date of a Given Month; Formula 34: Calculating the Calendar Quarter for a Date; Formula 35: Calculating the Fiscal Quarter for a Date; Formula 36: Returning a Fiscal Month from a Date; Formula 37: Calculate the Date of the Nth Weekday of the Month Formula 38: Calculate the Date of the Last Weekday of the MonthFormula 39: Extracting Parts of a Time; Formula 40: Calculating Elapsed Time; Formula 41: Rounding Time Values; Formula 42: Converting Decimal Hours, Minutes, or Seconds to a Time; Formula 43: Adding Hours, Minutes, or Seconds to a Time; Chapter 5: Performing Conditional Analysis; Formula 44: Check to See Whether a Simple Condition Is Met; Formula 45: Checking for Multiple Conditions; Formula 46: Check Whether Condition1 AND Condition2 Are Met; Formula 47: Check Whether Condition1 OR Condition2 Is Met Formula 48: Sum All Values That Meet a Certain Condition |
| Record Nr. | UNINA-9910464533203321 |
Alexander Michael
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika
| 101 ready-to-use Excel formulas / / by Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Hoboken, New Jersey : , : Wiley, , 2014 |
| Descrizione fisica | 1 online resource (243 pages) : illustrations |
| Disciplina | 005.369 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Electronic spreadsheets
Electronic spreadsheets - Computer programs Macro instructions (Electronic computers) Chemistry Physical Sciences & Mathematics Chemistry - General |
| ISBN | 1-118-90289-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Table of Contents; Introduction; Chapter 1: Introducing Excel Formulas; Creating and Editing Excel Formulas; Using Formula Operators; Relative versus Absolute Cell References; Using External Cell References; Formula Calculation Modes; Leveraging Excel Functions; Understanding Formula Errors; Using Named Ranges in Formulas; Chapter 2: Common Mathematical Operations; Formula 1: Calculating Percent of Goal; Formula 2: Calculating Percent Variance; Formula 3: Calculating Percent Variance with Negative Values; Formula 4: Calculating a Percent Distribution
Formula 5: Calculating a Running TotalFormula 6: Applying a Percent Increase or Decrease to Values; Formula 7: Dealing with Divide-by-Zero Errors; Formula 8: Basic Rounding of Numbers; Formula 9: Rounding to the Nearest Penny; Formula 10: Rounding to Significant Digits; Formula 11: Counting Values in a Range; Formula 12: Creating a Conversion Table; Chapter 3: Manipulating Text with Formulas; Formula 13: Joining Text Strings; Formula 14: Setting Text to Sentence Case; Formula 15: Removing Spaces from a Text String; Formula 16: Extract Parts of a Text String Formula 17: Finding a Particular Character in a Text StringFormula 18: Substituting Text Strings; Formula 19: Counting Specific Characters in a Cell; Formula 20: Adding a Line Break within a Formula; Formula 21: Cleaning Strange Characters from Text Fields; Formula 22: Padding Numbers with Zeros; Formula 23: Formatting the Numbers in a Text String; Chapter 4: Working with Dates and Times; Formula 24: Getting the Current Date and Time; Formula 25: Calculating Age; Formula 26: Calculating the Number of Days between Two Dates; Formula 27: Calculating the Number of Workdays between Two Dates Formula 28: Generate a List of Business Days Excluding HolidaysFormula 29: Extracting Parts of a Date; Formula 30: Calculating the Number of Years and Months between Dates; Formula 31: Converting Dates to Julian Date Formats; Formula 32: Calculating the Percent of Year Completed and Remaining; Formula 33: Returning the Last Date of a Given Month; Formula 34: Calculating the Calendar Quarter for a Date; Formula 35: Calculating the Fiscal Quarter for a Date; Formula 36: Returning a Fiscal Month from a Date; Formula 37: Calculate the Date of the Nth Weekday of the Month Formula 38: Calculate the Date of the Last Weekday of the MonthFormula 39: Extracting Parts of a Time; Formula 40: Calculating Elapsed Time; Formula 41: Rounding Time Values; Formula 42: Converting Decimal Hours, Minutes, or Seconds to a Time; Formula 43: Adding Hours, Minutes, or Seconds to a Time; Chapter 5: Performing Conditional Analysis; Formula 44: Check to See Whether a Simple Condition Is Met; Formula 45: Checking for Multiple Conditions; Formula 46: Check Whether Condition1 AND Condition2 Are Met; Formula 47: Check Whether Condition1 OR Condition2 Is Met Formula 48: Sum All Values That Meet a Certain Condition |
| Record Nr. | UNINA-9910786631003321 |
|
Alexander Michael
|
||
| Hoboken, New Jersey : , : Wiley, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika
| Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, 2013 |
| Descrizione fisica | 1 online resource (1299 p.) |
| Disciplina | 005.7565 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Database management
Databases |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-118-49034-7
1-299-46489-0 1-118-49154-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. I. Access building blocks -- pt. II. Understanding Access tables -- pt. III. Working with Access queries -- pt. IV. Analyzing data in Access -- pt. V. Working with Access forms and reports -- pt. VI. Access programming fundamentals -- pt. VII. Advanced Access programming techniques -- VIII. Access and Windows SharePoint services -- pt. XI. Appendixes. |
| Record Nr. | UNINA-9910452386003321 |
|
Alexander Michael
|
||
| Indianapolis, Ind., : John Wiley & Sons, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika
| Access 2013 bible [[electronic resource] ] : [the comprehensive tutorial resource] / / Michael Alexander and Dick Kusleika |
| Autore | Alexander Michael |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Indianapolis, Ind., : John Wiley & Sons, 2013 |
| Descrizione fisica | 1 online resource (1299 p.) |
| Disciplina | 005.7565 |
| Altri autori (Persone) | KusleikaDick |
| Soggetto topico |
Database management
Databases |
| ISBN |
1-118-49034-7
1-299-46489-0 1-118-49154-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. I. Access building blocks -- pt. II. Understanding Access tables -- pt. III. Working with Access queries -- pt. IV. Analyzing data in Access -- pt. V. Working with Access forms and reports -- pt. VI. Access programming fundamentals -- pt. VII. Advanced Access programming techniques -- VIII. Access and Windows SharePoint services -- pt. XI. Appendixes. |
| Record Nr. | UNINA-9910779568603321 |
|
Alexander Michael
|
||
| Indianapolis, Ind., : John Wiley & Sons, 2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2019 Bible / / Michael Alexander, Dick Kusleika
| Access 2019 Bible / / Michael Alexander, Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
| Descrizione fisica | 1 online resource (1,136 pages) |
| Disciplina | 005.7565 |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-119-54943-4
1-119-51473-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910466834203321 |
|
Alexander Michael
|
||
| Indianapolis, IN : , : Wiley, , [2019] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Access 2019 Bible / / Michael Alexander, Dick Kusleika
| Access 2019 Bible / / Michael Alexander, Dick Kusleika |
| Autore | Alexander Michael |
| Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
| Descrizione fisica | 1 online resource (1,136 pages) |
| Disciplina | 005.7565 |
| Soggetto genere / forma | Handbooks and manuals. |
| ISBN |
1-119-54943-4
1-119-51473-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Access building blocks. An introduction to database development ; Getting started with Access -- Understanding Access tables. Creating Access tables ; Understanding table relationships ; Working with Access tables ; Importing and exporting data ; Linking to external data -- Working with Access queries. Selecting data with queries ; Using operators and expressions in Access ; Going beyond select queries -- Analyzing data in Microsoft Access. Transforming data in Access ; Working with calculations and dates ; Performing conditional analyses ; The fundamentals of using SQL ; Subqueries and domain aggregate functions ; Running descriptive statistics in Access -- Working with Access forms and reports. Creating basic Access forms ; Working with data on Access forms ; Working with form controls ; Presenting data with Access reports ; Advanced Access report techniques -- Microsoft Access programming fundamentals. Using Access macros ; Using Access data macros ; Getting started with Access VBA ; Mastering VBA data types and procedures ; Understanding the Access event model ; Debugging your Access applications -- Advanced Access programming techniques. Accessing data with VBA ; Advanced data Access with VBA ; Customizing the ribbon ; Preparing your Access application for distribution ; Integrating Access with SharePoint. |
| Record Nr. | UNINA-9910528403703321 |
|
Alexander Michael
|
||
| Indianapolis, IN : , : Wiley, , [2019] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2016 Power Programming with VBA / / Michael Alexander, Dick Kusleika
| Excel 2016 Power Programming with VBA / / Michael Alexander, Dick Kusleika |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
| Descrizione fisica | 1 online resource (767 p.) |
| Disciplina | 005.369 |
| Collana | Mr. Spreadsheet's Bookshelf |
| Soggetto topico |
Business - Computer programs
Visual Basic for Applications (Computer program language) Visual programming (Computer science) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-5231-1481-9
1-119-41550-0 1-119-06756-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910270940703321 |
|
Alexander Michael
|
||
| Indianapolis, Indiana : , : Wiley, , 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2016 Power Programming with VBA / / Michael Alexander, Dick Kusleika
| Excel 2016 Power Programming with VBA / / Michael Alexander, Dick Kusleika |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
| Descrizione fisica | 1 online resource (767 p.) |
| Disciplina | 005.369 |
| Collana |
Mr. Spreadsheet's Bookshelf
THEi Wiley ebooks |
| Soggetto topico |
Business - Computer programs
Visual Basic for Applications (Computer program language) Visual programming (Computer science) |
| ISBN |
1-5231-1481-9
1-119-41550-0 1-119-06756-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910830621303321 |
|
Alexander Michael
|
||
| Indianapolis, Indiana : , : Wiley, , 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2019 Bible / / Michael Alexander, Dick Kusleika ; previously by John Walkenbach
| Excel 2019 Bible / / Michael Alexander, Dick Kusleika ; previously by John Walkenbach |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN : , : Wiley, , [2019] |
| Descrizione fisica | 1 online resource (1,123 pages) |
| Disciplina | 005.369 |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-119-54937-X
1-119-51477-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910466835403321 |
|
Alexander Michael
|
||
| Indianapolis, IN : , : Wiley, , [2019] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach
| Excel 2019 bible / / Michael Alexander, Dick Kusleika, previously by John Walkenbach |
| Autore | Alexander Michael |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, Ind. : , : Wiley, , c2019 |
| Descrizione fisica | 1 online resource (1,123 pages) |
| Disciplina | 005.369 |
| Collana | THEi Wiley ebooks |
| Soggetto topico |
Business - Computer programs
Electronic spreadsheets |
| ISBN |
1-119-51476-2
1-119-54937-X 1-119-51477-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover -- Title Page -- Copyright -- About the Authors -- About the Technical Editors -- Credits -- Acknowledgments -- Contents -- Introduction -- Is This Book for You? -- Software Versions -- Conventions Used in This Book -- Excel commands -- Typographical conventions -- Mouse conventions -- How This Book Is Organized -- How to Use This Book -- What's on the Website -- Part I: Getting Started with Excel -- Chapter 1: Introducing Excel -- Understanding What Excel Is Used For -- Looking at What's New in Excel 2019 -- Understanding Workbooks and Worksheets -- Moving around a Worksheet -- Navigating with your keyboard -- Navigating with your mouse -- Using the Ribbon -- Ribbon tabs -- Contextual tabs -- Types of commands on the Ribbon -- Accessing the Ribbon by using your keyboard -- Using Shortcut Menus -- Customizing Your Quick Access Toolbar -- Working with Dialog Boxes -- Navigating dialog boxes -- Using tabbed dialog boxes -- Using Task Panes -- Creating Your First Excel Workbook -- Getting started on your worksheet -- Filling in the month names -- Entering the sales data -- Formatting the numbers -- Making your worksheet look a bit fancier -- Summing the values -- Creating a chart -- Printing your worksheet -- Saving your workbook -- Chapter 2: Entering and Editing Worksheet Data -- Exploring Data Types -- Numeric values -- Text entries -- Formulas -- Entering Text and Values into Your Worksheets -- Entering numbers -- Entering text -- Using Enter mode -- Entering Dates and Times into Your Worksheets -- Entering date values -- Entering time values -- Modifying Cell Contents -- Deleting the contents of a cell -- Replacing the contents of a cell -- Editing the contents of a cell -- Learning some handy data-entry techniques -- Automatically moving the selection after entering data -- Selecting a range of input cells before entering data.
Using Ctrl+Enter to place information into multiple cells simultaneously -- Changing modes -- Entering decimal points automatically -- Using AutoFill to enter a series of values -- Using AutoComplete to automate data entry -- Forcing text to appear on a new line within a cell -- Using AutoCorrect for shorthand data entry -- Entering numbers with fractions -- Using a form for data entry -- Entering the current date or time into a cell -- Applying Number Formatting -- Using automatic number formatting -- Formatting numbers by using the Ribbon -- Using shortcut keys to format numbers -- Formatting numbers by using the Format Cells dialog box -- Adding your own custom number formats -- Chapter 3: Performing Basic Worksheet Operations -- Learning the Fundamentals of Excel Worksheets -- Working with Excel windows -- Moving and resizing windows -- Switching among windows -- Closing windows -- Activating a worksheet -- Adding a new worksheet to your workbook -- Deleting a worksheet you no longer need -- Changing the name of a worksheet -- Changing a sheet tab color -- Rearranging your worksheets -- Hiding and unhiding a worksheet -- Controlling the Worksheet View -- Zooming in or out for a better view -- Viewing a worksheet in multiple windows -- Comparing sheets side by side -- Splitting the worksheet window into panes -- Keeping the titles in view by freezing panes -- Monitoring cells with a Watch Window -- Working with Rows and Columns -- Inserting rows and columns -- Deleting rows and columns -- Changing column widths and row heights -- Changing column widths -- Changing row heights -- Hiding rows and columns -- Chapter 4: Working with Excel Ranges and Tables -- Understanding Cells and Ranges -- Selecting ranges -- Selecting complete rows and columns -- Selecting noncontiguous ranges -- Selecting multisheet ranges -- Selecting special types of cells. Selecting cells by searching -- Copying or Moving Ranges -- Copying by using Ribbon commands -- Copying by using shortcut menu commands -- Copying by using shortcut keys -- Copying or moving by using drag-and-drop -- Copying to adjacent cells -- Copying a range to other sheets -- Using the Office Clipboard to paste -- Pasting in special ways -- Using the Paste Special dialog box -- Performing mathematical operations without formulas -- Skipping blanks when pasting -- Transposing a range -- Using Names to Work with Ranges -- Creating range names in your workbooks -- Using the Name box -- Using the New Name dialog box -- Using the Create Names from Selection dialog box -- Managing names -- Adding Comments to Cells -- Formatting comments -- Changing a comment's shape -- Reading comments -- Hiding and showing comments -- Editing comments -- Deleting comments -- Working with Tables -- Understanding a table's structure -- The header row -- The data body -- The total row -- The resizing handle -- Creating a table -- Adding data to a table -- Sorting and filtering table data -- Sorting a table -- Filtering a table -- Filtering a table with slicers -- Changing the table's appearance -- Chapter 5: Formatting Worksheets -- Getting to Know the Formatting Tools -- Using the formatting tools on the Home tab -- Using the Mini toolbar -- Using the Format Cells dialog box -- Formatting Your Worksheet -- Using fonts to format your worksheet -- Changing text alignment -- Choosing horizontal alignment options -- Choosing vertical alignment options -- Wrapping or shrinking text to fit the cell -- Merging worksheet cells to create additional text space -- Displaying text at an angle -- Using colors and shading -- Adding borders and lines -- Using Conditional Formatting -- Specifying conditional formatting -- Using graphical conditional formats -- Using data bars. Using color scales -- Using icon sets -- Creating formula-based rules -- Understanding relative and absolute references -- Conditional formatting formula examples -- Identifying weekend days -- Highlighting a row based on a value -- Displaying alternate-row shading -- Creating checkerboard shading -- Shading groups of rows -- Working with conditional formats -- Managing rules -- Copying cells that contain conditional formatting -- Deleting conditional formatting -- Locating cells that contain conditional formatting -- Using Named Styles for Easier Formatting -- Applying styles -- Modifying an existing style -- Creating new styles -- Merging styles from other workbooks -- Controlling styles with templates -- Understanding Document Themes -- Applying a theme -- Customizing a theme -- Chapter 6: Understanding Excel Files and Templates -- Creating a New Workbook -- Opening an Existing Workbook -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- Using AutoRecover -- Recovering versions of the current workbook -- Recovering unsaved work -- Configuring AutoRecover -- Password-Protecting a Workbook -- Organizing Your Files -- Other Workbook Info Options -- Protect Workbook options -- Check for Issues options -- Manage Workbook options -- Browser View options -- Compatibility Mode section -- Closing Workbooks -- Safeguarding Your Work -- Working with Templates -- Exploring Excel templates -- Viewing templates -- Creating a workbook from a template -- Modifying a template -- Using default templates -- Using the workbook template to change workbook defaults -- Creating a worksheet template -- Editing your template -- Resetting the default workbook -- Using custom workbook templates -- Creating custom templates -- Saving your custom templates -- Using custom templates -- Chapter 7: Printing Your Work -- Doing Basic Printing. Changing Your Page View -- Normal view -- Page Layout view -- Page Break Preview -- Adjusting Common Page Setup Settings -- Choosing your printer -- Specifying what you want to print -- Changing page orientation -- Specifying paper size -- Printing multiple copies of a report -- Adjusting the page margins -- Understanding page breaks -- Inserting a page break -- Removing manual page breaks -- Printing row and column titles -- Scaling printed output -- Printing cell gridlines -- Printing row and column headers -- Using a background image -- Adding a Header or a Footer to Your Reports -- Selecting a predefined header or footer -- Understanding header and footer element codes -- Exploring other header and footer options -- Exploring Other Print-Related Topics -- Copying Page Setup settings across sheets -- Preventing certain cells from being printed -- Preventing objects from being printed -- Creating custom views of your worksheet -- Creating PDF files -- Chapter 8: Customizing the Excel User Interface -- Customizing the Quick Access Toolbar -- About the Quick Access toolbar -- Adding new commands to the Quick Access toolbar -- Other Quick Access toolbar actions -- Customizing the Ribbon -- Why you may want to customize the Ribbon -- What can be customized -- How to customize the Ribbon -- Creating a new tab -- Creating a new group -- Adding commands to a new group -- Resetting the Ribbon -- Part II: Working with Formulas and Functions -- Chapter 9: Introducing Formulas and Functions -- Understanding Formula Basics -- Using operators in formulas -- Understanding operator precedence in formulas -- Using functions in your formulas -- Examples of formulas that use functions -- Function arguments -- More about functions -- Entering Formulas into Your Worksheets -- Entering formulas manually -- Entering formulas by pointing. Pasting range names into formulas. |
| Altri titoli varianti | Microsoft Excel 2019 bible |
| Record Nr. | UNINA-9910526529603321 |
|
Alexander Michael
|
||
| Indianapolis, Ind. : , : Wiley, , c2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
