SALE

Solution Manual for Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition

Original price was: $35.00.Current price is: $26.50.

Solution Manual for Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition Digital Instant Download

Category:

This is completed downloadable of Solution Manual for Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition

 

Product Details:

  • ISBN-10 ‏ : ‎ 9780134479446
  • ISBN-13 ‏ : ‎ 978-0134479446
  • Author:  Mary Anne Poatsy (Author), Keith Mulbery (Author), Jason Davidson (Author), Robert Grauer (Author)

The goal of the Exploring series is to move students beyond the point-and-click, to understanding the why and how behind each skill. And because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, anytime. Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.

 

Also available with MyITLab

MyITLab® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, which engages students and improves results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, helping students learn more quickly and effectively. Digital badges lets students showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers. MyITLab builds the critical skills needed for college and career success.

 

Table of Content:

  1. Microsoft® Excel 2016 Comprehensive
  2. Dedications
  3. About the Authors
  4. Brief Contents
  5. Contents
  6. Preface
  7. The Exploring Series and You
  8. Key Features
  9. Resources
  10. Microsoft® Excel 2016 Comprehensive
  11. Common Features Chapter 1 Office 2016 Common Features Taking the First Step
  12. Learning Outcome
  13. Objectives & Skills
  14. Getting Started with Office Applications
  15. Starting an Office Application
  16. Change Your Microsoft Account
  17. Working with Files
  18. Create a New File
  19. Open a File
  20. Save a File
  21. Using Common Interface Components
  22. Use the Ribbon
  23. Use a Shortcut Menu
  24. Use Keyboard Shortcuts
  25. Customize the Ribbon
  26. Use the Quick Access Toolbar
  27. Customize the Quick Access Toolbar
  28. Getting Help
  29. Use the Tell me what you want to do Box
  30. Use Enhanced ScreenTips
  31. Installing Add-ins
  32. Hands-On Exercises 1 Getting Started with Office Applications
  33. Format Document Content
  34. Using Templates and Applying Themes
  35. Open a Template
  36. Apply a Theme
  37. Modifying Text
  38. Select Text
  39. Edit Text
  40. Use the Mini Toolbar
  41. Copy Formats with Format Painter
  42. Relocating Text
  43. Cut, Copy, and Paste Text
  44. Use the Office Clipboard
  45. Checking Spelling and Grammar
  46. Working with Pictures and Graphics
  47. Insert Pictures and Graphics
  48. Resize and Format Pictures and Graphics
  49. Hands-On Exercises 2 Format Document Content
  50. Modify Document Layout and Properties
  51. Using Backstage View
  52. Customize Application Options
  53. View and Edit Document Properties
  54. Changing the Document View
  55. Changing the Page Layout
  56. Change Margins
  57. Change Page Orientation
  58. Use the Page Setup Dialog Box
  59. Inserting a Header and Footer
  60. Previewing and Printing a File
  61. Hands-On Exercises 3 Modify Document Layout and Properties
  62. Chapter Objectives Review
  63. Key Terms Matching
  64. Multiple Choice
  65. Practice Exercises
  66. 1 Designing Webpages
  67. 2 Upscale Bakery
  68. Mid-Level Exercises
  69. 1 Reference Letter
  70. 2 Medical Monitoring
  71. 3 Today’s Musical Artists
  72. Beyond the Classroom
  73. Fitness Planner
  74. Household Records
  75. Capstone Exercise
  76. Open and Save Files
  77. Select Text, Move Text, and Format Text
  78. Apply a Theme and Change the View
  79. Insert and Modify a Picture
  80. Use the Tell me what you want to do Box
  81. Customize the Quick Access Toolbar
  82. Use Print Preview, Change Print Layout, and Print
  83. Check Spelling and Change View
  84. Excel Chapter 1 Introduction to Excel Creating and Formatting a Worksheet
  85. Learning Outcome
  86. Objectives & Skills
  87. Introduction to Spreadsheets
  88. Exploring the Excel Window
  89. Identify Excel Window Elements
  90. Identify Columns, Rows, and Cells
  91. Navigate in and Among Worksheets
  92. Entering and Editing Cell Data
  93. Enter Text
  94. Use Auto Fill to Complete a Sequence
  95. Enter Values
  96. Enter Dates and Times
  97. Edit and Clear Cell Contents
  98. Hands-On Exercises 1 Introduction to Spreadsheets
  99. Mathematical Operations and Formulas
  100. Creating Formulas
  101. Use Cell References in Formulas
  102. Apply the Order of Operations
  103. Use Semi-Selection to Create a Formula
  104. Copy Formulas
  105. Displaying Cell Formulas
  106. Hands-On Exercises 2 Mathematical Operations and Formulas
  107. Worksheet Structure and Clipboard Tasks
  108. Managing Columns and Rows
  109. Insert Cells, Columns, and Rows
  110. Delete Cells, Columns, and Rows
  111. Hide and Unhide Columns and Rows
  112. Adjust Column Width
  113. Adjust Row Height
  114. Selecting, Moving, Copying, and Pasting Data
  115. Select a Range
  116. Move a Range
  117. Copy and Paste a Range
  118. Use Paste Options and Paste Special
  119. Copy Excel Data to Other Programs
  120. Hands-On Exercises 3 Worksheet Structure and Clipboard Tasks
  121. Worksheet Formatting
  122. Applying Cell Styles, Alignment, and Font Options
  123. Merge and Center Labels
  124. Change Horizontal and Vertical Cell Alignment
  125. Wrap Text
  126. Increase and Decrease Indent
  127. Apply Borders and Fill Color
  128. Applying Number Formats
  129. Apply a Number Format
  130. Increase and Decrease Decimal Places
  131. Hands-On Exercises 4 Worksheet Formatting
  132. Worksheets, Page Setup, and Printing
  133. Managing Worksheets
  134. Insert and Delete a Worksheet
  135. Copy or Move a Worksheet
  136. Rename a Worksheet
  137. Selecting Page Setup Options
  138. Specify Page Options
  139. Set Margin Options
  140. Create Headers and Footers
  141. Select Sheet Options
  142. Previewing and Printing a Worksheet
  143. Hands-On Exercises 5 Worksheets, Page Setup, and Printing
  144. Chapter Objectives Review
  145. Key Terms Matching
  146. Multiple Choice
  147. Practice Exercises
  148. 1 Mathematics Review
  149. 2 Calendar Formatting
  150. 3 Downtown Theatre
  151. Mid-Level Exercises
  152. 1 Guest House Rental Rates
  153. 2 Real Estate Sales Report
  154. 3 Problem Solving with Classmates
  155. Beyond the Classroom
  156. Tip Distribution
  157. Net Proceeds from House Sale
  158. Capstone Exercise
  159. Format the Title and Complete the Input Areas
  160. Insert Formulas
  161. Add Rows, Indent Labels, and Move Data
  162. Format the Detailed Expenses Section
  163. Manage the Workbook
  164. Excel Chapter 2 Formulas and Functions Performing Quantitative Analysis
  165. Learning Outcome
  166. Objectives & Skills
  167. Formula Basics
  168. Using Relative, Absolute, and Mixed Cell References in Formulas
  169. Use a Relative Cell Reference
  170. Use an Absolute Cell Reference
  171. Use a Mixed Cell Reference
  172. Hands-On Exercises 1 Formula Basics
  173. Function Basics
  174. Inserting a Function
  175. Inserting Basic Math and Statistics Functions
  176. Use the SUM Function
  177. Use the AVERAGE and MEDIAN Functions
  178. Use the MIN and MAX Functions
  179. Use the COUNT Functions
  180. Perform Calculations with Quick Analysis Tools
  181. Using Date Functions
  182. Insert the TODAY Function
  183. Insert the NOW Function
  184. Hands-On Exercises 2 Function Basics
  185. Logical, Lookup, and Financial Functions
  186. Determining Results with the IF Function
  187. Design the Logical Test
  188. Design the Value_If_True and Value_If_False Arguments
  189. Using Lookup Functions
  190. Use the VLOOKUP function
  191. Create the Lookup Table
  192. Use the HLOOKUP Function
  193. Calculating Payments with the PMT Function
  194. Hands-On Exercises 3 Logical, Lookup, and Financial Functions
  195. Chapter Objectives Review
  196. Key Terms Matching
  197. Multiple Choice
  198. Practice Exercises
  199. 1 Hamilton Heights Auto Sales
  200. 2 Lockridge Marketing Analytics
  201. Mid-Level Exercises
  202. 1 Metropolitan Zoo Gift Shop Weekly Payroll
  203. 2 Auto Loan Calculator
  204. 3 Facebook and Blackboard
  205. Beyond the Classroom
  206. Auto Finance
  207. Park City Condo Rental
  208. Capstone Exercise
  209. Insert Current Date
  210. Calculate Cost
  211. Determine the Total Due
  212. Calculate the Monthly Payment
  213. Finalize the Workbook
  214. Excel Chapter 3 Charts Depicting Data Visually
  215. Learning Outcome
  216. Objectives & Skills
  217. Chart Basics
  218. Selecting the Data Source
  219. Choosing a Chart Type
  220. Create a Column Chart
  221. Create a Bar Chart
  222. Change the Chart Type
  223. Create a Line Chart
  224. Create a Pie Chart
  225. Create a Combo Chart
  226. Create Other Chart Types
  227. Moving, Sizing, and Printing a Chart
  228. Move a Chart
  229. Size a Chart
  230. Print a Chart
  231. Hands-On Exercises 1 Chart Basics
  232. Chart Elements
  233. Adding, Editing, and Formatting Chart Elements
  234. Edit, Format, and Position the Chart Title
  235. Add, Format, and Position Axis Titles
  236. Format the Axes
  237. Add, Position, and Format Data Labels
  238. Position and Format the Legend
  239. Add and Format Gridlines
  240. Format the Chart Area, Plot Area, and Data Series
  241. Format a Data Point
  242. Use the Chart Tools Format Tab
  243. Hands-On Exercises 2 Chart Elements
  244. Chart Design and Sparklines
  245. Applying a Chart Style and Colors
  246. Modifying the Data Source
  247. Apply Chart Filters
  248. Switch Row and Column Data
  249. Creating and Customizing Sparklines
  250. Insert a Sparkline
  251. Customize a Sparkline
  252. Hands-On Exercises 3 Chart Design and Sparklines
  253. Chapter Objectives Review
  254. Key Terms Matching
  255. Multiple Choice
  256. Practice Exercises
  257. 1 Hulett Family Utility Expenses
  258. 2 Trends in Market Value of Houses on Pine Circle
  259. Mid-Level Exercises
  260. 1 Airport Passenger Counts
  261. 2 Grade Analysis
  262. 3 Box Office Movies
  263. Beyond the Classroom
  264. Historical Stock Prices
  265. Harper County Houses Sold
  266. Capstone Exercise
  267. Insert and Format Sparklines
  268. Create a Pie Chart
  269. Add and Format Chart Elements
  270. Create and Size a Column Chart
  271. Format the Column Chart
  272. Finalizing the Workbook
  273. Excel Chapter 4 Datasets and Tables Managing Large Volumes of Data
  274. Learning Outcome
  275. Objectives & Skills
  276. Large Datasets
  277. Freezing Rows and Columns
  278. Printing Large Datasets
  279. Display and Change Page Breaks
  280. Set and Clear a Print Area
  281. Print Titles
  282. Control Print Page Order
  283. Hands-On Exercises 1 Large Datasets
  284. Excel Tables
  285. Understanding the Benefits of Data Tables
  286. Designing and Creating Tables
  287. Create a Table
  288. Rename a Table
  289. Add and Delete Fields
  290. Add, Edit, and Delete Records
  291. Remove Duplicate Rows
  292. Applying a Table Style
  293. Hands-On Exercises 2 Excel Tables
  294. Table Manipulation
  295. Creating Structured References in Formulas
  296. Sorting Data
  297. Sort One Field
  298. Sort Multiple Fields
  299. Create a Custom Sort
  300. Filtering Data
  301. Apply Text Filters
  302. Apply Number Filters
  303. Apply Date Filters
  304. Apply a Custom Filter
  305. Clear Filters
  306. Hands-On Exercises 3 Table Manipulation
  307. Table Aggregation and Conditional Formatting
  308. Adding a Total Row
  309. Applying Conditional Formatting
  310. Apply Conditional Formatting with the Quick Analysis Tool
  311. Apply Highlight Cells Rules
  312. Specify Top/Bottom Rules
  313. Display Data Bars, Color Scales, and Icon Sets
  314. Creating a New Rule
  315. Use Formulas in Conditional Formatting
  316. Manage Rules
  317. Hands-On Exercises 4 Table Aggregation and Conditional Formatting
  318. Chapter Objectives Review
  319. Key Terms Matching
  320. Multiple Choice
  321. Practice Exercises
  322. 1 Collectables and Replacement Values
  323. 2 Sunny Popcorn, Inc.
  324. Mid-Level Exercises
  325. 1 Crafton’s Pet Supplies
  326. 2 Artwork
  327. 3 Party Music
  328. Beyond the Classroom
  329. Flight Arrival Status
  330. Dairy Farm
  331. Capstone Exercise
  332. Prepare the Large Worksheet as a Table
  333. Sort and Print the Table
  334. Add Calculated Fields and a Total Row
  335. Apply Conditional Formatting
  336. Copy and Filter the Data
  337. Finalize the Workbook
  338. Excel Chapter 5 Subtotals, PivotTables, and PivotCharts Summarizing and Analyzing Data
  339. Learning Outcome
  340. Objectives & Skills
  341. Subtotals and Outlines
  342. Subtotaling Data
  343. Add a Second Level of Subtotals
  344. Collapse and Expand the Subtotals
  345. Grouping and Ungrouping Data
  346. Hands-On Exercises 1 Subtotals and Outlines
  347. PivotTable Basics
  348. Creating a PivotTable
  349. Create a Recommended PivotTable
  350. Create a Blank PivotTable
  351. Modifying a PivotTable
  352. Add Rows to a PivotTable
  353. Add Values in a PivotTable
  354. Add Columns to a PivotTable
  355. Collapse and Expand Items in a PivotTable
  356. Remove Fields from a PivotTable
  357. Rearrange Fields in a PivotTable
  358. Change the Values Field Settings
  359. Refresh a PivotTable
  360. Hands-On Exercises 2 PivotTable Basics
  361. PivotTable Options
  362. Filtering and Slicing a PivotTable
  363. Add Filters
  364. Insert a Slicer to Filter a PivotTable
  365. Customize a Slicer
  366. Insert a Timeline to Filter a PivotTable
  367. Creating a Calculated Field
  368. Show Values as a Specific Calculation Result
  369. Changing the PivotTable Design
  370. Change the PivotTable Style
  371. Change the PivotTable Layout
  372. Hands-On Exercises 3 PivotTable Options
  373. Data Modeling and PivotCharts
  374. Creating a Data Model
  375. Create a Relationship Between Tables
  376. Create a PivotTable from Related Tables
  377. Creating a PivotChart
  378. Modify the PivotChart
  379. Hands-On Exercises 4 Data Modeling and PivotCharts
  380. Chapter Objectives Review
  381. Key Terms Matching
  382. Multiple Choice
  383. Practice Exercises
  384. 1January Restaurant Revenue
  385. 2 Suburbia Regional Hospital
  386. Mid-Level Exercises
  387. 1 Mountain View Realty
  388. 2 Fiesta® Collection
  389. 3 Facebook® Social Phenomenon
  390. Beyond the Classroom
  391. Departing Flights
  392. Innovative Game Studio
  393. Capstone Exercise
  394. Sort, Subtotal, and Outline Data
  395. Create a PivotTable
  396. Change Value Field Settings and Create a Calculated Field
  397. Filter the PivotTable and Apply a Style
  398. Insert a Slicer and Timeline
  399. Create a PivotChart
  400. Finalizing Your Workbook
  401. Excel Chapter 6 What-If Analysis Using Decision-Making Tools
  402. Learning Outcome
  403. Objectives & Skills
  404. Range Names
  405. Creating and Maintaining Range Names
  406. Create a Range Name
  407. Edit or Delete a Range Name
  408. Use Range Names in Formulas
  409. Insert a List of Range Names
  410. Hands-On Exercises 1 Range Names
  411. One- and Two-Variable Data Tables
  412. Creating a One-Variable Data Table
  413. Set Up One-Variable Substitution Values
  414. Add Formulas to a One-Variable Data Table
  415. Calculate Results
  416. Format a One-Variable Data Table
  417. Creating a Two-Variable Data Table
  418. Set Up the Substitution Values for Two Variables
  419. Add a Formula to the Data Table
  420. Calculate Results for a Two-Variable Data Table
  421. Hands-On Exercises 2 One- and Two-Variable Data Tables
  422. Goal Seek and Scenario Manager
  423. Determining Optimal Input Values Using Goal Seek
  424. Using Scenario Manager
  425. Create Scenarios
  426. Add and Edit Scenarios
  427. View Scenarios
  428. Generate a Scenario Summary Report
  429. Hands-On Exercises 3 Goal Seek and Scenario Manager
  430. Solver
  431. Loading the Solver Add-In
  432. Optimizing Results with Solver
  433. Identify the Objective Cell and Changing Cells
  434. Define Constraints
  435. Create a Solver Report
  436. Configure Solver
  437. Save and Restore a Solver Model
  438. Hands-On Exercises 4 Solver
  439. Chapter Objectives Review
  440. Key Terms Matching
  441. Multiple Choice
  442. Practice Exercises
  443. 1 Monthly Commission
  444. 2 Sue’s Bakery
  445. Mid-Level Exercises
  446. 1 Housing Construction Cost Variables
  447. 2 Viking Heating and Air
  448. 3 College Budget
  449. Beyond the Classroom
  450. Too Cold to Snow
  451. IT Management
  452. Capstone Exercise
  453. Range Names
  454. Goal Seek
  455. One-Variable Data Table
  456. Two-Variable Data Table
  457. Scenario Manager
  458. Use Solver
  459. Excel Chapter 7 Specialized Functions Using Date, Logical, Lookup, Database, and Financial Functions
  460. Learning Outcome:
  461. Objectives & Skills
  462. Date, Logical, and Lookup Functions
  463. Using Date Functions
  464. Calculate Days and Years Between Dates
  465. Extract Day, Month, and Year
  466. Creating a Nested Logical Function
  467. Nested IF Within an IF Function
  468. Nest AND, OR, and NOT Functions
  469. Using Advanced Lookup Functions
  470. Use the Index Function
  471. Use the MATCH Function
  472. Create a Nested Function
  473. Hands-On Exercises 1 Date, Logical, and Lookup Functions
  474. Database Filtering and Functions
  475. Applying Advanced Filtering
  476. Define a Criteria Range
  477. Apply the Advanced Filter
  478. Manipulating Data with Database Functions
  479. Use DSUM and DAVERAGE Functions
  480. Identify Values with DMAX and DMIN
  481. Identify the Total Number with DCOUNT
  482. Hands-On Exercises 2 Database Filtering and Functions
  483. Financial Functions
  484. Using Financial Functions
  485. Calculate Present and Future Values
  486. Use NPER and RATE Functions
  487. Creating a Loan Amortization Table
  488. Perform Internal Calculations
  489. Calculate Interest and Principal Payments with IPMT and PPMT Functions
  490. Calculate Cumulative Interest with the CUMIPMT Function
  491. Calculate Cumulative Principal Payments with the CUMPRINC Function
  492. Hands-On Exercises 3 Financial Functions
  493. Chapter Objectives Review
  494. Key Terms Matching
  495. Multiple Choice
  496. Practice Exercises
  497. 1 Furniture Sales
  498. 2 Detailed Loan Amortization
  499. 3 Financial Investments
  500. Mid-Level Exercises
  501. 1 West Coast University Admissions Office
  502. 2 Artwork Database
  503. 3 Personal Financial Management
  504. Beyond the Classroom
  505. Studio Recording Equipment
  506. Cruises
  507. Capstone Exercise
  508. Perform Calculations
  509. Create a Search Area
  510. Manage a Database List
  511. Loan Amortization
  512. Finance Function
  513. Workbook Completion
  514. Excel Chapter 8 Statistical Functions Analyzing Statistics
  515. Learning Outcome
  516. Objectives & Skills
  517. Math and Statistical Functions
  518. Using Conditional Math and Statistical Functions
  519. Use the SUMIF, AVERAGEIF, and COUNTIF Functions
  520. Use the SUMIFS, AVERAGEIFS, and COUNTIFS Functions
  521. Enter Math and Statistical Functions
  522. Calculating Relative Standing with Statistical Functions
  523. Use the RANK and PERCENTRANK Functions
  524. Use the QUARTILE and PERCENTILE Functions
  525. Hands-On Exercises 1 Math and Statistical Functions
  526. Descriptive Statistical Functions
  527. Measuring Central Tendency
  528. Use the Standard Deviation and Variance Functions
  529. Use the CORREL Function
  530. Use the FREQUENCY Function
  531. Hands-On Exercises 2 Descriptive Statistical Functions
  532. Inferential Statistics
  533. Loading the Analysis ToolPak
  534. Performing Analysis Using the Analysis ToolPak
  535. Perform Analysis of Variance (ANOVA)
  536. Calculate COVARIANCE
  537. Create a Histogram
  538. Creating a Forecast Sheet
  539. Hands-On Exercises 3 Inferential Statistics
  540. Chapter Objectives Review
  541. Key Terms Matching
  542. Multiple Choice
  543. Practice Exercises
  544. 1 Sociology Textbooks
  545. 2 Indy Car
  546. Mid-Level Exercises
  547. 1 Investment Banking
  548. 2 Reading Comprehension Scores
  549. 3 Portfolio Analysis
  550. Beyond the Classroom Stock Market Research
  551. Taste Test
  552. Capstone Exercise
  553. Use Conditional Math and Statistical Functions
  554. Calculate Relative Standing with Statistical Functions
  555. Measure of Central Tendency
  556. Using the Analysis ToolPak and Forecast Sheet
  557. Create a Histogram
  558. Excel Chapter 9 Multiple-Sheet Workbook Management Ensuring Quality Control
  559. Learning Outcome
  560. Objectives & Skills
  561. Case Study Circle City Sporting Goods
  562. Multiple Worksheets
  563. Working with Grouped Worksheets
  564. Group and Ungroup Worksheets
  565. Enter Data and Format Grouped Worksheets
  566. Fill Across Worksheets
  567. Inserting Hyperlinks
  568. Managing Windows
  569. Control Visibility of Worksheets
  570. Open and Arrange Windows
  571. Split a Window
  572. Apply Other Window Settings
  573. Hands-On Exercises 1 Multiple Worksheets
  574. 3-D Formulas and Linked Workbooks
  575. Inserting Formulas and Functions with 3-D References
  576. Insert a Formula with a 3-D Reference
  577. Insert a Function with 3-D References
  578. Linking Workbooks
  579. Create an External Reference
  580. Manage and Update Linked Workbooks
  581. Hands-On Exercises 2 3-D Formulas and Linked Workbooks
  582. Formula Audits and Data Validation
  583. Auditing Formulas
  584. Trace Precedents and Dependents
  585. Check for and Repair Errors
  586. Evaluate a Formula
  587. Use the IFERROR Function to Detect Errors
  588. Setting Up a Watch Window
  589. Validating Data
  590. Specify Data Validation Criteria
  591. Create an Input Message
  592. Create an Error Alert
  593. Hands-On Exercises 3 Formula Audits and Data Validation
  594. Chapter Objectives Review
  595. Key Terms Matching
  596. Multiple Choice
  597. Practice Exercises
  598. 1 Organic Foods Corporation
  599. 2 Retirement Planning
  600. Mid-Level Exercises
  601. 1 Sales Data
  602. 2 Temperature Comparisons
  603. 3 Book Club
  604. Student 1
  605. Student 2
  606. Beyond the Classroom Pizza Sales
  607. Gradebook Errors
  608. Capstone Exercise
  609. Data Validation
  610. Group Worksheets, Fill Data, and Enter Formulas
  611. Create 3-D References
  612. Create Hyperlinks
  613. Audit a Workbook
  614. Link Workbooks
  615. Finalize the Workbooks
  616. Excel Chapter 10 Imports, XML, and Power Add-Ins Managing Data
  617. Learning Outcome
  618. Objectives & Skills
  619. External Data
  620. Importing Data from External Sources
  621. Import a Text File
  622. Import an Access Database Table or Query
  623. Import Data from Other Sources
  624. Managing Connections
  625. Set Connection Properties
  626. Hands-On Exercises 1 External Data
  627. Text Manipulation
  628. Converting Text to Columns
  629. Manipulating Text with Functions
  630. Combine Text with the CONCATENATE Function
  631. Change Text Case with Text Functions
  632. Use the Substitute Function
  633. Use Other Text Functions
  634. Using Flash Fill
  635. Hands-On Exercises 2 Text Manipulation
  636. XML
  637. Understanding XML Syntax
  638. Importing XML Data into Excel
  639. Refresh imported XML Data
  640. Hands-On Exercises 3 XML
  641. Power Add-Ins
  642. Using Power Pivot Functionality
  643. Load the Power Pivot Add-in
  644. Import data with Power Pivot
  645. Create Relationships with Power Pivot
  646. Create a PivotTable with Power Pivot
  647. Importing Data with Power Query
  648. Visualizing Data with Power View
  649. Hands-On Exercises 4 Power Add-Ins
  650. Chapter Objectives Review
  651. Key Terms Matching
  652. Multiple Choice
  653. Practice Exercises
  654. 1 Earline’s Bakery
  655. 2 New Employees
  656. 3 Years on the Job
  657. Mid-Level Exercises
  658. 1 DOW Jones Industrial Average
  659. 2 Animal Shelter
  660. 3 Favorite Movies
  661. Capstone Exercise
  662. Import data from an external Source
  663. Manipulate Text with Functions
  664. Import XML Data
  665. Create a PivotTable using Power Pivot
  666. Import data with Power Query
  667. Visualize data with Power View
  668. Finalize the Workbook
  669. Excel Chapter 11 Collaboration and Workbook Distribution Sharing Data with Others
  670. Learning Outcome
  671. Objectives & Skills
  672. Workbook Customization
  673. Customizing Excel Options
  674. Personalize Your Copy of Microsoft Office
  675. Customize the Ribbon
  676. Customize the Quick Access Toolbar
  677. Customize Other Options
  678. Changing Properties
  679. Display Properties in Backstage View
  680. Use the Properties Dialog Box
  681. Hands-On Exercises 1 Workbook Customization
  682. Collaboration
  683. Inserting Comments
  684. Show and Hide Comments
  685. Edit and Delete Comments
  686. Print Comments
  687. Sharing and Merging Workbooks
  688. Understand Conflicts and Network Issues
  689. Network Permissions
  690. Nonsharable Workbook
  691. Compare and Merge Workbooks
  692. Tracking Changes
  693. Highlight Changes
  694. Accept and Reject Changes
  695. Hands-On Exercises 2 Collaboration
  696. Workbook Information
  697. Checking for Issues
  698. Use Document Inspector
  699. Check Accessibility
  700. Check Compatibility
  701. Protecting a Workbook
  702. Encrypt a Workbook with a Password
  703. Add a Digital Signature
  704. Add a Signature Line
  705. Mark a Workbook as Final
  706. Hands-On Exercises 3 Workbook Information
  707. Workbook Distribution
  708. Saving a Workbook in Different Formats
  709. Save a Workbook for Previous Excel Versions
  710. Save a Workbook as a PDF File
  711. Sending a Workbook to Others
  712. Send a Workbook by Email
  713. Share Workbooks Through OneDrive
  714. Hands-On Exercises 4 Workbook Distribution
  715. Chapter Objectives Review
  716. Key Terms Matching
  717. Multiple Choice
  718. Practice Exercises
  719. 1 Harper County Houses Sold
  720. 2 Valentine’s Day Dance
  721. Mid-Level Exercises
  722. 1 House Sale Proceeds
  723. 2 Lecture Series Expenses
  724. 3 Ribbon Customization
  725. Beyond the Classroom
  726. Consulting Revenue
  727. Passenger Car Ratings
  728. Capstone Exercise
  729. Customize Excel
  730. Compare and Merge Workbooks
  731. Accept and Reject Changes
  732. Comments and Properties
  733. Check for Issues
  734. Distribute the Workbook
  735. Excel Chapter 12 Templates, Styles, and Macros Standardizing Workbooks
  736. Learning Outcome
  737. Objectives & Skills
  738. Templates, Themes, and Styles
  739. Selecting a Template
  740. Applying Themes and Backgrounds
  741. Customize a Theme
  742. Apply a Background
  743. Applying Cell Styles
  744. Create Custom Cell Styles
  745. Modify and Remove Cell Styles
  746. Hands-On Exercises 1 Templates, Themes, and Styles
  747. Custom Templates and Workbook Protection
  748. Creating and Using a Template
  749. Protecting a Cell, a Worksheet, and a Workbook
  750. Lock and Unlock Cells
  751. Protect a Worksheet
  752. Protect a Workbook
  753. Hands-On Exercises 2 Custom Templates and Workbook Protection
  754. Macros
  755. Creating a Macro
  756. Use the Macro Recorder
  757. Record a Macro
  758. Use Relative References
  759. Run a Macro
  760. Creating Macro Buttons
  761. Setting Macro Security
  762. Hands-On Exercises 3 Macros
  763. Visual Basic for Applications
  764. Creating a Sub Procedure
  765. Use VBA with Protected Worksheets
  766. Edit a Macro in the Visual Basic Editor
  767. Creating a Custom Function
  768. Hands-On Exercises 4 Visual Basic for Applications
  769. Chapter Objectives Review
  770. Key Terms Matching
  771. Multiple Choice
  772. Practice Exercises
  773. 1 Blood Pressure Tracker
  774. 2 Sales Management
  775. Mid-Level Exercises
  776. 1 Little League Statistics
  777. 2 Shield Lawn Care
  778. 3 Fundraiser
  779. Beyond the Classroom
  780. Trust Center
  781. Real Estate Listings
  782. Capstone Exercise
  783. Create a Template
  784. Create the Sort Macro
  785. Create a Custom Function
  786. Finalize the Template
  787. Excel Introductory Capstone Exercise (Chs. 1–4)
  788. Format the Worksheet
  789. Insert Formulas and Basic Functions
  790. Move Data and Insert Functions
  791. Format Data
  792. Select Page Setup Options
  793. Insert a Table, Sort and Filter Data, and Apply Conditional Formatting
  794. Create a Column Chart
  795. Create a Pie Chart
  796. Finish the Project
  797. Excel Comprehensive Capstone Exercise (Chs. 5–12)
  798. Format the Workbook
  799. Perform Lookup Functions and Conditional Math
  800. Use Conditional Logic and Conditional Formatting
  801. Perform Advanced Filtering and Database Functions
  802. Use What-If Analysis
  803. Complete an Amortization Schedule
  804. Enter Specialized Functions and Data Validation
  805. Create a PivotTable, PivotChart, and Slicer
  806. Import an Access Database
  807. Finalize the Workbook
  808. Microsoft Office 2016 Specialist Excel Core
  809. Glossary
  810. Index
  811. A
  812. B
  813. C
  814. D
  815. E
  816. F
  817. G
  818. H
  819. I
  820. K
  821. L
  822. M
  823. N
  824. O
  825. P
  826. Q
  827. R
  828. S
  829. T
  830. U
  831. V
  832. W
  833. X
  834. Y
  835. Z

Related products