The quick way to get started with Microsoft Office ! This is …. The quick way to learn Microsoft Outlook ! Get more done quickly …. The quick way to learn Microsoft PowerPoint !
Skip to main content. Start your free trial. Microsoft Excel Step by Step by. Book description Now in full color! Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need Show and hide more.
Table of contents Product information. Introduction Who this book is for The Step by Step approach Download the practice files Ebook edition Get support and give feedback Errata and support We want to hear from you Stay in touch Part 1: Create and format workbooks 1. Work with data and Excel tables Enter and revise data Manage data by using Flash Fill Move data within a workbook Find and replace data Correct and expand upon data Define Excel tables Skills review Practice tasks Enter and revise data Manage data by using Flash Fill Move data within a workbook Find and replace data Correct and expand upon data Define Excel tables 3.
Perform calculations on data Name groups of data Create formulas to calculate values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations Skills review Practice tasks Name groups of data Create formulas to calculate values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations 4.
Change workbook appearance Format cells Define styles Apply workbook themes and Excel table styles Make numbers easier to read Change the appearance of data based on its value Add images to worksheets Skills review Practice tasks Format cells Define styles Apply workbook themes and Excel table styles Make numbers easier to read Change the appearance of data based on its value Add images to worksheets Part 2: Analyze and present data 5.
Manage worksheet data Limit data that appears on your screen Manipulate worksheet data Summarize data in worksheets that have hidden and filtered rows Find unique values within a data set Define valid sets of values for ranges of cells Skills review Practice tasks Limit data that appears on your screen Manipulate worksheet data Define valid sets of values for ranges of cells 6. Table of contents Product information.
Create and manage files Create files Open and move around in files Display different views of files Display and edit file properties Save and close files Skills review Practice tasks Create files Open and move around in files Display different views of files Display and edit file properties Save and close files Part 2: Microsoft Word 3. Modify the structure and appearance of text Apply paragraph formatting Configure alignment Configure vertical spacing Configure indents Structure content manually Apply character formatting Create and modify lists Apply built-in styles to text Apply styles Manage outline levels Change the document theme Skills review Practice tasks Apply paragraph formatting Structure content manually Apply character formatting Create and modify lists Apply built-in styles to text Change the document theme 4.
Collaborate on documents Mark up documents Insert comments Track changes Display and review document markup Display markup Review and respond to comments Review and process tracked changes Compare and merge documents Compare and combine separate copies of a document Compare separate versions of a document Control content changes Restrict actions Restrict access by using a password Coauthor documents Skills review Practice tasks Mark up documents Display and review document markup Compare and merge documents Control content changes Coauthor documents 5.
Merge data with documents and labels Understand the mail merge process Start the mail merge process Get started with letters Get started with labels Get started with email messages Choose and refine the data source Select an existing data source Create a new data source Refine the data source records Insert merge fields Preview and complete the merge Create individual envelopes and labels Generate individual envelopes Generate individual mailing labels Skills review Practice tasks Understand the mail merge process Start the mail merge process Choose and refine the data source Insert merge fields Preview and complete the merge Create individual envelopes and labels Part 3: Microsoft Excel 6.
Perform calculations on data Name groups of data Define Excel tables Create formulas to calculate values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations Skills review Practice tasks Name groups of data Create formulas to calculate values Define Excel tables Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations 7.
Manage worksheet data Limit data that appears on your screen Manipulate worksheet data Summarize data in worksheets that have hidden and filtered rows Find unique values within a data set Define valid sets of values for ranges of cells Skills review Practice tasks Limit data that appears on your screen Manipulate worksheet data Define valid sets of values for ranges of cells 8.
Reorder and summarize data Sort worksheet data Sort data by using custom lists Organize data into levels Look up information in a worksheet Skills review Practice tasks Sort worksheet data Sort data by using custom lists Organize data into levels Look up information in a worksheet 9.
Analyze alternative data sets Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Find optimal solutions by using Solver Analyze data by using descriptive statistics Skills review Practice tasks Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Find optimal solutions by using Solver Analyze data by using descriptive statistics Part 4: Microsoft PowerPoint Create and manage slides Add and remove slides Insert new slides Copy and import slides and content Hide and delete slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds Skills review Practice tasks Add and remove slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds Insert and manage simple graphics Insert, move, and resize pictures Edit and format pictures Draw and modify shapes Draw and add text to shapes Move and modify shapes Format shapes Capture and insert screen clippings Create a photo album Skills review Practice tasks Insert, move, and resize pictures Edit and format pictures Draw and modify shapes Capture and insert screen clippings Create a photo album Add sound and movement to slides Animate text and pictures on slides Customize animation effects Add audio content to slides Add video content to slides Compress media to decrease file size Skills review Practice tasks Animate text and pictures on slides Customize animation effects Add audio content to slides Add video content to slides Compress media to decrease file size Part 5: Microsoft Outlook Send and receive email messages Create and send messages Create messages Troubleshoot message addressing Save and send messages Attach files and Outlook items to messages Display messages and message attachments Display message content Display attachment content Display message participant information Respond to messages Skills review Practice tasks Create and send messages Attach files and Outlook items to messages Display messages and message attachments Display message participant information Respond to messages Organize your Inbox Display and manage conversations Arrange messages by specific attributes Categorize items Organize messages in folders Skills review Practice tasks Display and manage conversations Arrange messages by specific attributes Categorize items Organize messages in folders Manage scheduling Schedule appointments and events Convert calendar items Configure calendar item options Schedule and change meetings Respond to meeting requests Display different views of a calendar Skills review Practice tasks Schedule appointments and events Convert calendar items Configure calendar item options Schedule and change meetings Respond to meeting requests Display different views of a calendar Index About the authors Acknowledgments Survey Show and hide more.
Get it now.
0コメント