Joan Lambert,
Curtis Frye
Pearson Education
e druk, 2022
9780137564279
Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
Specificaties
Paperback, blz.
|
Engels
Pearson Education |
e druk, 2022
ISBN13: 9780137564279
Rubricering
Onderdeel van serie
Step by Step
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
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 Set up a workbook <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">2 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 Perform calculations on data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">4 Change workbook appearance <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p> </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 Manage worksheet data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">6 Reorder and summarize data <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">7 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 Analyze alternative data sets <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">9 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 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> </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 Print worksheets and charts <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">12 Automate tasks and input <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">13 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 Collaborate with colleagues <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;"> <o:p> </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 Perform business intelligence analysis <o:p></o:p></p> <p class="MsoNormal" style="margin: 0in; font-size: 12pt; font-family: Calibri, sans-serif;">16 Create forecasts and visualizations <o:p></o:p></p>