Autore	Walkenbach John
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, N.J., : Wiley, c2013
Descrizione fisica	1 online resource (314 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's bookshelf
Soggetto topico	Electronic spreadsheets
Soggetto genere / forma	Electronic books.
ISBN	1-118-64232-5 1-118-65106-5
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	About the Author; Table of Contents; INTRODUCTION; What You Should Know; What You Should Have; Conventions in This Book; Formula listings; Key names; The Ribbon; Functions, procedures, and named ranges; Mouse conventions; What the icons mean; How This Book Is Organized; How to Use This Book; About the Power Utility Pak Offer; Part I: Workbooks and Files; Tips and Where to Find Them; Tip 1: Changing the Look of Excel; Cosmetic changes; Hiding the Ribbon; Using options on the View tab; Hiding other elements; Hiding the status bar; Tip 2: Customizing the Quick Access Toolbar About the Quick Access toolbarAdding new commands to the Quick Access toolbar; Performing other Quick Access toolbar actions; Tip 3: Customizing the Ribbon; How to customize the Ribbon; Tip 4: Understanding Protected View; What causes Protected View?; Printing and copying; Forcing a file to open in Normal view; Tip 5: Understanding AutoRecover; Recovering versions of the current workbook; Recovering unsaved work; Tip 6: Using a Workbook in a Browser; Tip 7: Saving to a Read-Only Format; Send a printed copy; Send an electronic copy in the form of a PDF file; Send an MHTML file Tip 8: Generating a List of FilenamesTip 9: Generating a List of Sheet Names; Tip 10: Using Document Themes; Applying a theme; Customizing a theme; Tip 11: Understanding Excel Compatibility Issues; The Excel 2013 file formats; The Office Compatibility Pack; Checking compatibility; Tip 12: Where to Change Printer Settings; Part II: Formatting; Tips and Where to Find Them; Tip 13: Working with Merged Cells; Other merge actions; Potential problems with merged cells; Locating all merged cells; Unmerging all merged cells; Alternatives to merged cells; Tip 14: Indenting Cell Contents Tip 15: Using Named StylesUsing the Style gallery; Modifying an existing style; Creating new styles; Merging styles from other workbooks; Tip 16: Creating Custom Number Formats; Parts of a number format string; Custom number format codes; Tip 17: Using Custom Number Formats to Scale Values; Tip 18: Creating a Bulleted List; Using a bullet character; Using SmartArt; Tip 19: Shading Alternate Rows Using Conditional Formatting; Displaying alternate row shading; Creating checkerboard shading; Shading groups of rows; Tip 20: Formatting Individual Characters in a Cell Tip 21: Using the Format PainterPainting basics; Format Painter variations; Tip 22: Inserting a Watermark; Tip 23: Showing Text and a Value in a Cell; Using concatenation; Using the TEXT function; Using a custom number format; Tip 24: Avoiding Font Substitution for Small Point Sizes; Tip 25: Updating Old Fonts; Part III: Formulas; Tips and Where to Find Them; Tip 26: Resizing the Formula Bar; Tip 27: Monitoring Formula Cells from Any Location; About the Watch Window; Customizing the Watch Window; Navigating with the Watch Window; Tip 28: Learning Some AutoSum Tricks Tip 29: Knowing When to Use Absolute and Mixed References
Record Nr.	UNINA-9910465609703321

Autore	Biech Elaine
Pubbl/distr/stampa	Hoboken, New Jersey : , : Wiley, , 2015
Descrizione fisica	1 online resource (454 p.)
Disciplina	371.3
Collana	Active Training Series
Soggetto topico	Active learning Training
ISBN	1-118-97196-5 1-118-97195-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	200 Tips to Make Training Active and Learning Successful -- Open Every Session Actively -- Delivering active learning.
Record Nr.	UNINA-9910140488303321

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

Pubbl/distr/stampa	Hoboken (N.J.), : Wiley, c2006
Descrizione fisica	XIII, P. 6391-7008 ; 27 cm
ISBN	0471743720
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Record Nr.	UNISANNIO-IST0049693