Microsoft Office 365 Excel 2016 : comprehensive / Steven M. Freund, Joy L. Starks, Eric J. Schmieder
Book | Cengage Learning | 2017
Not Available at Gateway-Racine Campus General Collection (DUE 12-18-20)

Additional actions:

More Details

Description
1 volume (various pagings) : color illustrations ; 28 cm.
Series
Note
"For Microsoft Office updates go to sam.cengage.com"--Cover.
Includes index.
Contents
Ch.1 Productivity Apps for School and Work
Introduction to OneNote 2016 -- Introduction to Sway -- Introduction to Office Mix -- Introduction to Microsoft Edge
Pt.1: Office 2016 and Windows 10
Ch.2 Office 2016 and Windows 10: Essential Concepts and Skills
Objectives -- Introduction to the Windows 10 Operating System -- Introduction to Microsoft Office 2016 -- Running and Using an App -- Document Properties -- Printing, Saving, and Organizing Files -- Screen Resolution -- Additional Common Features of Office Apps -- Renaming, Moving, and Deleting Files -- Microsoft Office and Windows Help -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
Pt.2: Excel 2016
MODULE ONE
Ch.3 Creating a Worksheet and a Chart
Objectives -- Introduction -- Project - Personal Budget Worksheet and Chart -- Selecting a Cell -- Entering Text -- Entering Numbers -- Calculating a Sum -- Using the Fill Handle to Copy a Cell to Adjacent Cells -- Formatting the Worksheet -- Adding a Pie Chart to the Worksheet -- Changing the Sheet Tab Names -- Printing a Worksheet -- Autocalculate -- Correcting Errors -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE TWO
Ch.4 Formulas, Functions, and Formatting
Objectives -- Introduction -- Project - Worksheet with Formulas and Functions -- Entering the Titles and Numbers into the Worksheet -- Flash Fill -- Entering Formulas -- Option Buttons -- Using the AVERAGE, MAX, and MIN Functions -- Verifying Formulas Using Range Finder -- Formatting the Worksheet -- Checking Spelling -- Printing the Worksheet -- Displaying and Printing the Formulas Version of the Worksheet -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE THREE
Ch.5 Working with Large Worksheets, Charting, and What-If Analysis
Objectives -- Introduction -- Project - Financial Projection Worksheet with What-If Analysis and Chart -- Rotating Text and Using the Fill Handle to Create a Series -- Copying a Range of Cells to a Nonadjacent Destination Area -- Inserting and Deleting Cells in a Worksheet -- Absolute Versus Relative Addressing -- Making Decisions - The IF Function -- Adding and Formatting Sparkline Charts -- Formatting the Worksheet -- Adding a Clustered Column Chart to the Workbook -- Organizing the Workbook -- Changing the View of the Worksheet -- What-If Analysis -- Insights -- Accessibility Features -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE FOUR
Ch.6 Financial Functions, Data Tables, and Amortization Schedules
Objectives -- Introduciton -- Project - Mortage Payment Calculator with Data Table and Amortization Schedule -- Creating Cell Names -- Using a Data Table to Analyze Worksheet Data -- Creating an Amortization Schedule -- Printing Sections of the Worksheet -- Protecting and Hiding Worksheets and Workbooks -- Formula Checking -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE FIVE
Ch.7 Working with Multiple Worksheets and Workbooks
Objectives -- Introduction -- Project - Consolidated Expenses Worksheet -- Creating the Consolidated Worksheet -- Fill Series -- Date, Time, and Round Functions -- Format Codes -- Creating Cell Style -- Working with Multiple Worksheets -- Referencing Cells Across Worksheets -- Formatting Pie Charts -- Creating Separate Files from Worksheets -- Consolidating Data by Linking Separate Workbooks -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE SIX
Ch.8 Creating, Sorting, and Querying a Table
Objectives -- Introduction -- Project - Coffee Craft Daily Services -- Creating a Table -- Using a Lookup Table -- Adding Calculated Fields to the Table -- Conditional Formatting -- Working with Tables in Excel -- Sorting a table -- Querying a Table Using AutoFilter -- Using Criteria and Extract Ranges -- Using Database Functions -- Using the Sumif, Countif, Match, and Index Functions -- Summarizing Data -- Treemap Charts -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE SEVEN
Ch.9 Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots
Objectives -- Introduction -- Project - Home Security Systems -- Creating Templates -- Importing Data -- Using the Quick Analysis Gallery -- Using the Find and Replace Commands -- Inserting a Bar Chart -- Working with Smartart Graphics -- Using Screenshots on a Worksheet -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE EIGHT
Ch.10 Working with Trendlines, PivotTables, PivotCharts, and Slicers
Objectives -- Introduction -- Project - LinkMe Internet Service Provider -- Adding a Trendline to a Chart -- Creating and Formatting PivotTable Reports -- Summary Functions -- Creating and Formatting PivotChart Reports -- Working with Slicers -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE NINE
Ch.11 Formula Auditing , Data Validation, and Complex Problem Solving
Objectives -- Introduction -- Project - Life Coach Services Scheduling Analysis -- Formula Auditing -- Data Validation -- Customizing Excel Add-Ons -- Solving Complex Problems -- Using Solver to Solve Complex Problems -- Using Scenarios and Scenario Manager to Analyze Data -- Summarzing Scenarios -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE TEN
Ch.12 Data Analysis with Power Tools and Creating Macros
Objectives -- Introduction -- Project - Business Decisions Demographics -- Get & Transform -- Power Pivot -- Power View -- 3D Maps -- Power BI -- Creating a Home Page with Hyperlinks -- Macros -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
MODULE ELEVEN
Ch.13 User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel
Objectives -- Introduction -- Project - Global Pharmaceutical Company Sales Analysis -- Designing the User Interface -- Sharing and Collaboration -- Gathering Feedback Using Comments -- Tracking Changes on a Workbook -- Finalizing a Workbook -- Summary -- Apply Your Knowledge -- Extend Your Knowledge -- Expand Your World -- In the Labs
Summary
125.00 OFFA (31-106-1) OFFT (10-106-6)
Subject
Added Author
Starks, Joy
Schmieder, Eric J.
Added Title
Excel 2016 : comprehensive
Browse Results
Other Sources:
View in classic catalog View MARC display
Recently Added:
Loading Suggestions...
Back to top