Microsoft excel 2016 step by step pdf download

Connect with us to learn more. He has also created and recorded more than three dozen courses for lynda. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats. We're sorry! We don't recognize your username or password. Please try again. The work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning.

You have successfully signed out and will be required to sign back in should you need to download more resources. Microsoft Excel Step by Step.

Description This is learning made easy. Students will get productive fast with Excel and jump in wherever they need answers--brisk lessons and colorful screen shots show them exactly what to do, step by step. 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 Click the Download button below to start the download.

If prompted, click Save. Easy lessons for essential tasks Big full-color visuals Skill-building practice files. If you find an error, you can report it to us through our Submit errata page.

Sign in. Your cart. This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

Downloads Follow the instructions to download additional support files. Features Easy lessons for essential tasks Big full-color visuals Skill-building practice files.