,

Microsoft Excel Step by Step (Office 2021 and Microsoft 365)

Paperback Engels 2022 9780137564279
Verwachte levertijd ongeveer 9 werkdagen

Samenvatting

With Microsoft Excel 365 Step by Step students will master the skills they need: Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines Visualize data with 3D maps, funnel charts, and other powerful tools Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query Build powerful data models and use them in business intelligence Look up just the tasks and lessons needed

Specificaties

ISBN13:9780137564279
Taal:Engels
Bindwijze:Paperback

Lezersrecensies

Wees de eerste die een lezersrecensie schrijft!

Inhoudsopgave

<p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Introduction <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">Part 1: Create and format workbooks <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set up a workbook <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Work with data and Excel tables <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Perform calculations on data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Change workbook appearance <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 2: Analyze and present data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manage worksheet data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Reorder and summarize data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Combine data from multiple sources <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Analyze alternative data sets <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Create charts and graphics. 207 <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Create PivotTables and PivotCharts <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 3: Collaborate and share in Excel <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Print worksheets and charts <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Automate tasks and input <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Work with other Microsoft 365 apps <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Collaborate with colleagues <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 4: Perform advanced analysis <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Perform business intelligence analysis <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Create forecasts and visualizations <o:p></o:p></p>

Managementboek Top 100

Rubrieken

Populaire producten

    Personen

      Trefwoorden

        Microsoft Excel Step by Step (Office 2021 and Microsoft 365)