Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Name: Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
Author: Bill Jelen

E-book Engels 2022 9780137559565

Verwachte levertijd ongeveer 9 werkdagen

54,99

In winkelwagen

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:9780137559565

Taal:Engels

Bindwijze:e-book

Uitgever:Pearson Education

Serie:Inside Out

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Schrijf een recensie

Uw cijfer

?

Log in om te stemmen

Inhoudsopgave

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

Managementboek Top 100

Bekijk de volledige Managementboek Top 100

Uw winkelwagen

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Samenvatting

Specificaties

Lezersrecensies

Inhoudsopgave

Managementboek Top 100

Rubrieken

Populaire producten

Personen

Trefwoorden