101 excel 2013 tips, tricks & timesavers
Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka ""Mr. Spreadsheet,...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
Wiley
c2013.
|
| Edición: | 1st edition |
| Colección: | Mr. Spreadsheet's bookshelf.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628448506719 |
Tabla de Contenidos:
- 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
