Microsoft Excel 365 Bible:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Newark
John Wiley & Sons, Incorporated
2022
|
| Ausgabe: | 2nd ed |
| Schriftenreihe: | Bible Series
|
| Schlagworte: | |
| Online-Zugang: | DE-2070s |
| Beschreibung: | Description based on publisher supplied metadata and other sources |
| Beschreibung: | 1 Online-Ressource (1074 Seiten) |
| ISBN: | 9781119835226 |
Internformat
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV049872720 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240919s2022 |||| o||u| ||||||eng d | ||
| 020 | |a 9781119835226 |9 978-1-119-83522-6 | ||
| 035 | |a (ZDB-30-PQE)EBC6887027 | ||
| 035 | |a (ZDB-30-PAD)EBC6887027 | ||
| 035 | |a (ZDB-89-EBL)EBL6887027 | ||
| 035 | |a (OCoLC)1299382620 | ||
| 035 | |a (DE-599)BVBBV049872720 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 005.54 | |
| 100 | 1 | |a Alexander, Michael |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Microsoft Excel 365 Bible |
| 250 | |a 2nd ed | ||
| 264 | 1 | |a Newark |b John Wiley & Sons, Incorporated |c 2022 | |
| 264 | 4 | |c ©2022 | |
| 300 | |a 1 Online-Ressource (1074 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 490 | 0 | |a Bible Series | |
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Cover -- Title Page -- Copyright Page -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Looking at What's New in Excel 365 -- 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 -- 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 -- Changing Your Mind -- 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 -- Error values -- 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 | |
| 505 | 8 | |a 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 -- Using Excel on a Tablet -- Exploring Excel's tablet interface -- Entering formulas on a tablet -- Introducing the Draw Ribbon -- 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 -- Selecting 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 | |
| 505 | 8 | |a Chapter 4 Working with Excel Ranges and Tables -- Understanding Cells and Ranges -- Selecting ranges -- Selecting complete rows and columns -- Selecting noncontiguous ranges -- Selecting multi-sheet 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 -- Showing comments -- Replying to comments -- Editing comments and replies -- Deleting comments and replies -- Resolving comment threads -- Adding Notes to Cells -- Showing notes -- Formatting notes -- Editing notes -- Deleting notes -- 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 | |
| 505 | 8 | |a 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-rowshading -- 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 -- About Protected View -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- File-Naming Rules -- 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 -- Version History -- Manage Workbook options -- Browser View options -- Compatibility Mode section -- Closing Workbooks -- Safeguarding Your Work -- Working with Templates -- Exploring Excel templates -- Viewing templates | |
| 505 | 8 | |a 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 -- Using Print Preview -- 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 | |
| 505 | 8 | |a Part II Working with Formulas and Functions | |
| 650 | 4 | |a Electronic spreadsheets | |
| 700 | 1 | |a Kusleika, Dick |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Alexander, Michael |t Microsoft Excel 365 Bible |d Newark : John Wiley & Sons, Incorporated,c2022 |z 9781119835103 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-035212178 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=6887027 |l DE-2070s |p ZDB-30-PQE |q HWR_PDA_PQE |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1810600617817669632 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Alexander, Michael |
| author_facet | Alexander, Michael |
| author_role | aut |
| author_sort | Alexander, Michael |
| author_variant | m a ma |
| building | Verbundindex |
| bvnumber | BV049872720 |
| collection | ZDB-30-PQE |
| contents | Cover -- Title Page -- Copyright Page -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Looking at What's New in Excel 365 -- 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 -- 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 -- Changing Your Mind -- 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 -- Error values -- 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 -- Using Excel on a Tablet -- Exploring Excel's tablet interface -- Entering formulas on a tablet -- Introducing the Draw Ribbon -- 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 -- Selecting 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 multi-sheet 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 -- Showing comments -- Replying to comments -- Editing comments and replies -- Deleting comments and replies -- Resolving comment threads -- Adding Notes to Cells -- Showing notes -- Formatting notes -- Editing notes -- Deleting notes -- 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-rowshading -- 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 -- About Protected View -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- File-Naming Rules -- 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 -- Version History -- 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 -- Using Print Preview -- 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 |
| ctrlnum | (ZDB-30-PQE)EBC6887027 (ZDB-30-PAD)EBC6887027 (ZDB-89-EBL)EBL6887027 (OCoLC)1299382620 (DE-599)BVBBV049872720 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 2nd ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nmm a2200000zc 4500</leader><controlfield tag="001">BV049872720</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240919s2022 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119835226</subfield><subfield code="9">978-1-119-83522-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC6887027</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC6887027</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL6887027</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1299382620</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049872720</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-2070s</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Alexander, Michael</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Excel 365 Bible</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Newark</subfield><subfield code="b">John Wiley & Sons, Incorporated</subfield><subfield code="c">2022</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2022</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (1074 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Bible Series</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Title Page -- Copyright Page -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Looking at What's New in Excel 365 -- 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 -- 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 -- Changing Your Mind -- 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 -- Error values -- 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 -- Using Excel on a Tablet -- Exploring Excel's tablet interface -- Entering formulas on a tablet -- Introducing the Draw Ribbon -- 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 -- Selecting 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Chapter 4 Working with Excel Ranges and Tables -- Understanding Cells and Ranges -- Selecting ranges -- Selecting complete rows and columns -- Selecting noncontiguous ranges -- Selecting multi-sheet 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 -- Showing comments -- Replying to comments -- Editing comments and replies -- Deleting comments and replies -- Resolving comment threads -- Adding Notes to Cells -- Showing notes -- Formatting notes -- Editing notes -- Deleting notes -- 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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-rowshading -- 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 -- About Protected View -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- File-Naming Rules -- 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 -- Version History -- Manage Workbook options -- Browser View options -- Compatibility Mode section -- Closing Workbooks -- Safeguarding Your Work -- Working with Templates -- Exploring Excel templates -- Viewing templates</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 -- Using Print Preview -- 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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Part II Working with Formulas and Functions</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kusleika, Dick</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Alexander, Michael</subfield><subfield code="t">Microsoft Excel 365 Bible</subfield><subfield code="d">Newark : John Wiley & Sons, Incorporated,c2022</subfield><subfield code="z">9781119835103</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-035212178</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/hwr/detail.action?docID=6887027</subfield><subfield code="l">DE-2070s</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">HWR_PDA_PQE</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049872720 |
| illustrated | Not Illustrated |
| indexdate | 2024-09-19T05:21:46Z |
| institution | BVB |
| isbn | 9781119835226 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035212178 |
| oclc_num | 1299382620 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | 1 Online-Ressource (1074 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE HWR_PDA_PQE |
| publishDate | 2022 |
| publishDateSearch | 2022 |
| publishDateSort | 2022 |
| publisher | John Wiley & Sons, Incorporated |
| record_format | marc |
| series2 | Bible Series |
| spelling | Alexander, Michael Verfasser aut Microsoft Excel 365 Bible 2nd ed Newark John Wiley & Sons, Incorporated 2022 ©2022 1 Online-Ressource (1074 Seiten) txt rdacontent c rdamedia cr rdacarrier Bible Series Description based on publisher supplied metadata and other sources Cover -- Title Page -- Copyright Page -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Looking at What's New in Excel 365 -- 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 -- 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 -- Changing Your Mind -- 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 -- Error values -- 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 -- Using Excel on a Tablet -- Exploring Excel's tablet interface -- Entering formulas on a tablet -- Introducing the Draw Ribbon -- 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 -- Selecting 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 multi-sheet 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 -- Showing comments -- Replying to comments -- Editing comments and replies -- Deleting comments and replies -- Resolving comment threads -- Adding Notes to Cells -- Showing notes -- Formatting notes -- Editing notes -- Deleting notes -- 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-rowshading -- 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 -- About Protected View -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- File-Naming Rules -- 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 -- Version History -- 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 -- Using Print Preview -- 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 Electronic spreadsheets Kusleika, Dick Sonstige oth Erscheint auch als Druck-Ausgabe Alexander, Michael Microsoft Excel 365 Bible Newark : John Wiley & Sons, Incorporated,c2022 9781119835103 |
| spellingShingle | Alexander, Michael Microsoft Excel 365 Bible Cover -- Title Page -- Copyright Page -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Looking at What's New in Excel 365 -- 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 -- 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 -- Changing Your Mind -- 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 -- Error values -- 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 -- Using Excel on a Tablet -- Exploring Excel's tablet interface -- Entering formulas on a tablet -- Introducing the Draw Ribbon -- 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 -- Selecting 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 multi-sheet 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 -- Showing comments -- Replying to comments -- Editing comments and replies -- Deleting comments and replies -- Resolving comment threads -- Adding Notes to Cells -- Showing notes -- Formatting notes -- Editing notes -- Deleting notes -- 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-rowshading -- 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 -- About Protected View -- Filtering filenames -- Choosing your file display preferences -- Saving a Workbook -- File-Naming Rules -- 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 -- Version History -- 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 -- Using Print Preview -- 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 Electronic spreadsheets |
| title | Microsoft Excel 365 Bible |
| title_auth | Microsoft Excel 365 Bible |
| title_exact_search | Microsoft Excel 365 Bible |
| title_full | Microsoft Excel 365 Bible |
| title_fullStr | Microsoft Excel 365 Bible |
| title_full_unstemmed | Microsoft Excel 365 Bible |
| title_short | Microsoft Excel 365 Bible |
| title_sort | microsoft excel 365 bible |
| topic | Electronic spreadsheets |
| topic_facet | Electronic spreadsheets |
| work_keys_str_mv | AT alexandermichael microsoftexcel365bible AT kusleikadick microsoftexcel365bible |