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

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

Joan Lambert

Curtis Frye

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

A digital version of the text you can personalize and read online or offline.

eTextbook

This product is a bound, printed text book.

Print

Paperback

Microsoft Excel Step by Step (Office 2021 and Microsoft 365), 1st edition