Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20
010-4091943
Bill Jelen Meer over Bill Jelen

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Specificaties
Paperback, blz. | Engels
Pearson Education | 2022
ISBN13: 9780137559534
Rubricering
Pearson Education e druk, 2022 9780137559534
Onderdeel van serie Inside Out
60,94
In winkelwagen
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

Renowned Excel expert Bill Jelen offers a complete tour of Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards.Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

Specificaties

ISBN13:9780137559534
Taal:Engels
Bindwijze:Paperback
Uitgever:Pearson Education
Serie:Inside Out

Inhoudsopgave

<div> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part I&nbsp;&nbsp; The Excel interface <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What's new in Microsoft 365 Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using the Excel interface <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Customizing Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Keyboard shortcuts <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p> &nbsp; </o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part II&nbsp; Calculating with Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Understanding formulas <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Controlling formulas <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Understanding functions <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using everyday functions: math, date and time, and text functions <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using powerful functions: logical, lookup, and database functions <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using names, LET, LAMBDA, and Data Types in Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Connecting worksheets and workbooks <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dynamic array formulas and names in Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"><br></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part III Data analysis with Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Transforming data with Power Query <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Summarizing data using subtotals or filter <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using pivot tables to analyze data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using slicers and filtering a pivot table <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 17&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mashing up data with Power Pivot <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using What-If, Scenario Manager, Goal Seek, and Solver <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 19&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Automating repetitive functions using VBA macros <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; More tips and tricks for Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p> &nbsp; </o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part IV Excel visuals <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Formatting worksheets <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using data visualizations and conditional formatting <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Graphing data using Excel charts <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using 3D Maps <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using sparklines <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Formatting spreadsheets for presentation <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Printing <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Chapter 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Collaborating in Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p> &nbsp; </o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part V&nbsp; Appendixes <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Appendix A&nbsp;&nbsp;&nbsp;&nbsp; Excel functions <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Appendix B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Excel functions with DAX or Power Query equivalents <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Appendix C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Adding functionality to Excel with add-ins <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Index <o:p></o:p></p> </div>

Rubrieken

Uw cookie-instellingen
Deze website maakt gebruik van verschillende soorten cookies. Sommige cookies worden geplaatst door diensten van derden die op onze pagina's worden weergegeven. Om deze externe content te kunnen tonen is nodig dat u toestemming geeft voor het zetten van persoonlijke en marketingcookies. U kunt uw toestemming op elk moment wijzigen of intrekken. In onze cookieverklaring vindt u meer informatie.

    Personen

      Trefwoorden

        Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

        Recensiebeleid
        AI-book

        Wat is een AI-book?

        Een AI-book is niet een boek dat geschreven is door AI maar een boek dat verrijkt is met AI. Het maakt de inhoud van een boek interactief via WhatsApp, zodat je ermee kunt chatten. Zie het als een razend slimme assistent die het boek perfect begrijpt en er alles uit onthouden heeft. Jij kunt deze assistent alles vragen. Vraag bijvoorbeeld hoe je iets kunt toepassen op jouw persoonlijke situatie, om een korte samenvatting, of wat de belangrijkste inzichten zijn. AI-books zijn alleen te gebruiken via WhatsApp, je hoeft er geen aparte app voor te installeren.
        Meer informatie over AI-books

        ?

        Geef uw beoordeling

        Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

        Verwijder uw beoordeling