GO! with Microsoft Excel 2013 Brief

Name: GO! with Microsoft Excel 2013 Brief
Availability: InStock
ISBN: 9780133414424

ISBN-10: 0133414426

ISBN-13: 9780133414424

Edition: 2014

Authors: Shelley Gaskin, Alicia Vargas

List price: $79.99

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $8.05

Marketplace

3 new & used from $3.67

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

For use in the Office Applications course. This book is also suitable for students and individuals seeking an introduction to Microsoft Excel 2013. The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly defined projects. Teaching and Learning Experience This program will provide a better teaching and learning experience–for you and your students. Here’s how: Personalize Learning: MyITLab delivers proven results in helping students succeed, provides engaging experiences that personalize learning, and comes from a trusted partner with educational expertise and a deep commitment to helping students…

Book details

List price: $79.99
Copyright year: 2014
Publisher: Pearson Education
Publication date: 11/21/2019
Binding: Comb Bound
Pages: 272
Size: 9.00" wide x 10.75" long x 0.75" tall
Weight: 1.518
Language: English

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.



Office



Introduction to Microsoft Office 2013 Features



Note Form



Use File Explorer to Download, Extract, and Locate Files and Folders



Using File Explorer to Download, Extract, and Locate Files and Folders



Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App



Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App



Enter, Edit, and Check the Spelling of Text in an Office 2013 Program



Entering and Editing Text in an Office 2013 Program



Checking Spelling



Perform Commands from a Dialog Box



Performing Commands from a Dialog Box



Using Undo



Create a Folder and Name and Save a File



Creating a Folder and Naming and Saving a File



Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App



Inserting a Footer, Inserting Document Info, and Adding Document Properties



Printing a File and Closing a Desktop App



Memo



Open an Existing File and Save It with a New Name



Opening an Existing File and Saving It with a New Name


More Knowledge Read-only



Sign In to Office and Explore Options for a Microsoft Office Desktop App



Signing In to Office and Viewing Application Options



Perform Commands from the Ribbon and Quick Access Toolbar



Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar


More Knowledge Customizing the Ribbon



Minimizing and Using the Keyboard to Control the Ribbon



Apply Formatting in Office Programs



Changing Page Orientation and Zoom Level


More Knowledge Zooming to Page Width



Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles



Using Format Painter



Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste



Compress Files and Use the Microsoft Office 2013 Help System



Compressing Files



Using the Microsoft Office 2013 Help System in Excel



Install Apps for Office and Create a Microsoft Account



Installing Apps for Office



Creating a Microsoft Account


Summary, GO! Learn It Online


Guide to Chapter Assessments


Glossary


Excel Introduction to Microsoft Excel 2013



Creating a Worksheet and Charting Data



Sales Report with Embedded Column Chart and Sparklines



Create, Save, and Navigate an Excel Workbook



Starting Excel, Navigating Excel, and Naming and Saving a Workbook


More Knowledge Creating a New Workbook by Using a Template



Enter Data in a Worksheet



Entering Text, Using AutoComplete, and Using the Name Box to Select a Cell



Using Auto Fill and Keyboard Shortcuts



Aligning Text and Adjusting the Size of Columns



Entering Numbers



Construct and Copy Formulas and Use the SUM Function



Constructing a Formula and Using the Sum Function



Copying a Formula by Using the Fill Handle



Format Cells with Merge & Center, Cell Styles, and Themes



Using Merge & Center and Applying Cell Styles



Formatting Financial Numbers



Changing the Workbook Theme


More Knowledge Formatting a Cell's Font, Style, Size, or Color with Individual Commands



Chart Data to Create a Column Chart and Insert Sparklines



Charting Data and Using Recommended Charts to Select and Insert a Column Chart



Using the Chart Tools to Apply Chart Styles



Creating and Formatting Sparklines



Print a Worksheet, Display Formulas, and Close Excel



Creating a Footer and Centering a Worksheet



Adding Document Properties and Printing a Workbook



Printing a Section of the Worksheet



Changing Page Orientation and Displaying, Printing, and Hiding Formulas


More Knowledge Inserting a Watermark


GO! with Office Web Apps


Objective Create a Sales Report with an Embedded Column Chart Using the Excel Web App


Activity Creating a Sales Report with Embedded Column Chart Using the Excel Web App



Inventory Valuation



Check Spelling in a Worksheet



Checking Spelling in a Worksheet



Enter Data by Range



Entering Data by Range



Construct Formulas for Mathematical Operations



Using Arithmetic Operator



Using the Quick Analysis Tool



Copying Formulas Containing Absolute Cell References


More Knowledge Calculate a Percentage if You Know the Total and the Amount



Edit Values in a Worksheet



Editing Values in a Worksheet



Formatting Cells with the Percent Style



Format a Worksheet



Inserting and Deleting Rows and Columns


More Knowledge Hiding Rows and Columns



Adjusting Column Widths and Wrapping Text



Changing Theme Colors


GO! with Office Web Apps


Objective Calculate the Value of an Inventory in the Excel Web App


Activity Creating an Inventory Valuation Report in the Excel Web App


GO! with Microsoft Office 365


Activity Using the Exchange Online Outlook Meeting Tool to Collaborate


Summary, GO! Learn It Online, GO! For Job Success


Guide to Chapter Assessments


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think



Using Functions, Creating Tables, and Managing Large Workbooks



Inventory Status Report



Use Flash Fill and the Sum, Average, Median, Min, and Max Functions



Using Flash Fill



Moving a Column



Using the SUM and AVERAGE Functions



Using the MEDIAN Function



Using the MIN and MAX Functions



Move Data, Resolve Error Messages, and Rotate Text



Moving Data and Resolving a # # # # # Error Message



Rotating Text



Use COUNTIF and IF Functions and Apply Conditional Formatting



Using the COUNT and Countif Functions



Using the IF Function



Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars



Using Find and Replace



Use Date & Time Functions and Freeze Panes



Using the Now Function to Display a System Date


More Knowledge NOW Function Recalculates Each Time a Workbook Opens



Freezing and Unfreezing Panes


More Knowledge Freeze Columns or Freeze Both Rows and Columns



Create, Sort, and Filter an Excel Table



Creating an Excel Table and Applying a Table Style



Sorting an Excel Table



Filtering an Excel Table and Displaying a Total Row


More Knowledge Band Rows and Columns in a Table



Clearing Filters and Converting a Table to a Range of Data



View, Format, and Print a Large Worksheet



Modifying and Shrinking the Worksheet View



Splitting a Worksheet Window into Panes



Printing Titles and Scaling to Fit


More Knowledge Scaling for Data That Is Slightly Larger Than the Printed Page


GO! with Office Web Apps


Objective Sort, Filter, and Use Functions in a Table in Excel Web App


Activity Sort, Filter, and Use Functions in a Table



Weekly Sales Summary



Navigate a Workbook and Rename Worksheets



Navigating Among Worksheets, Renaming Worksheets, and Changing the Tab Color of Worksheets


More Knowledge Copying a Worksheet



Enter Dates, Clear Contents, and Clear Formats



Entering and Formatting Dates



Clearing Cell Contents and Formats


More Knowledge Clearing an Entire Worksheet



Copy and Paste by Using the Paste Options Gallery



Copying and Pasting by Using the Paste Options Gallery



Edit and Format Multiple Worksheets at the Same Time



Grouping Worksheets for Editing


More Knowledge Hide Worksheet



Formatting and Constructing Formulas on Grouped Worksheets



Determining Multiple Totals at the Same Time



Formatting Grouped Worksheets



Create a Summary Sheet with Column Sparklines



Ungrouping Worksheets



Inserting a Worksheet



Constructing Formulas That Refer to Cells in Another Worksheet



Changing Values in a Detail Worksheet to Update a Summary Worksheet



Inserting Column Sparklines



Format and Print Multiple Worksheets in a Workbook



Moving a Worksheet, Repeating Footers, and Formatting Multiple Worksheets in a Workbook



Printing All or Individual Worksheets in a Workbook


GO! with Office Web Apps


Objective Summarize the Data on Multiple Worksheets in Excel Web App


Activity Creating an Inventory Valuation Report in the Excel Web App


GO! with Microsoft Office 365


Summary, GO! Learn It Online, GO! For Job Success


Guide to Chapter Assessments


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think



Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools



Enterprise Fund Pie Chart



Chart Data with a Pie Chart



Calculating Values for a Pie Chart



Creating a Pie Chart in a Chart Sheet



Format a Pie Chart



Formatting a Chart Title by Applying a WordArt Style and Changing Font Size



Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels



Formatting a Data Series with 3-D Effects



Formatting a Data Series with a Shadow Effect



Rotating a Pie Chart by Changing the Angle of the First Slice



Exploding and Coloring a Pie Slice



Formatting the Chart Area



Edit a Workbook and Update a Chart



Editing a Workbook and Updating a Chart



Use Goal Seek to Perform What-If Analysis



Using Goal Seek to Perform What-If Analysis



Preparing and Printing a Workbook with a Chart Sheet


GO! with Office Web Apps


Objective Create a Jpeg Photo of a Chart and Upload to a OneNote Web App Notebook


Activity Creating a Jpeg Photo of a Chart and Uploading It to a OneNote Web App Notebook



Tourism Spending Projection with Line Chart



Design a Worksheet for What-If Analysis



Using Parentheses in a Formula to Calculate a Percentage Rate of Increase


More Knowledge Use of Parentheses in a Formula



Using Format Painter


More Knowledge Percentage Calculations



Calculating a Value After an Increase


More Knowledge Percent Increase or Decrease



Answer What-If Questions by Changing Values in a Worksheet



Answering What-If Questions and Using Paste Special



Chart Data with a Line Chart



Inserting Multiple Rows and Creating a Line Chart



Formatting Axes in a Line Chart



Formatting the Chart Area in a Line Chart



Formatting the Plot Area Gridlines and Axis Fonts in a Line Chart


More Knowledge Resizing a Chart


GO! with Office Web Apps


Objective Convert an Excel Worksheet to a Google Docs Spreadsheet with a Chart


Activity Converting an Excel Worksheet to a Google Docs Spreadsheet with a Chart


GO! with Microsoft Office 365


Activity Using a Team Site to Collaborate


Summary, GO! Learn It Online, GO! For Job Success


Guide to Chapter Assessments


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think