GO! with Microsoft Excel 2013 Introductory

Name: GO! with Microsoft Excel 2013 Introductory
Price: 7.47 USD
Availability: InStock
ISBN: 9780133417326

ISBN-10: 0133417328

ISBN-13: 9780133417326

Edition: 2014

Authors: Shelley Gaskin, Alicia Vargas

List price: $119.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $7.47

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: $119.99
Copyright year: 2014
Publisher: Pearson Education
Publication date: 5/15/2013
Binding: Comb Bound
Pages: 448
Size: 9.25" wide x 11.00" long x 1.00" tall
Weight: 1.936
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


More Knowledge Read-Only



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



Perform Commands from the Ribbon and Quick Access Toolbar


More Knowledge Customizing the Ribbon



Apply Formatting in Office Programs


More Knowledge Zooming to Page Width



Compress Files and Use the Microsoft Office 2013 Help System



Install Apps for Office and Create a Microsoft Account


Summary, GO! Learn It Online


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


More Knowledge Inserting a Watermark



Printing a Section of the Worksheet



Changing Page Orientation and Displaying, Printing, and Hiding Formulas



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



Inventory Valuation


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


More Knowledge Hiding Rows and Columns


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


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


More Knowledge NOW Function Recalculates Each Time a Workbook Opens



Use Date & Time Functions and Freeze Panes



Using the NOW Function to Display a System Date



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


More Knowledge Band Rows and Columns in a Table



Filtering an Excel Table and Displaying a Total Row



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



Sort, Filter, and Use Functions in a Table



Weekly Sales Summary


More Knowledge Copying a Worksheet


More Knowledge Clearing an Entire Worksheet


More Knowledge Hide Worksheets


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


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



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



Tourism Spending Projection with Line Chart


More Knowledge Use of Parentheses in a Formula


More Knowledge Percentage Calculations


More Knowledge Percent Increase or Decrease


More Knowledge Resizing a Chart


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


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think



Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets



Amortization Schedule and -Merchandise Costs



Use Financial Functions



Inserting the PMT Financial Function



Use Goal Seek



Using Goal Seek to Produce a Desired Result



Using Goal Seek to Find an Increased Period



Create a Data Table



Designing a Two-Variable Data Table



Using a Data Table to Calculate Options



Use Defined Names in a Formula



Defining a Name



Inserting New Data into a Named Range



Creating a Defined Name by Using Row and Column Titles



Using Defined Names in a Formula



Lookup Form and Revenue Report


More Knowledge Creating Validation Messages


More Knowledge


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


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think



Managing Large Workbooks and Using Advanced Sorting and Filtering



Large Worksheet for a Class Schedule



Navigate and Manage Large Worksheets



Using the Go To Special Command



Hiding Columns



Using the Go To Command



Arranging Multiple Workbooks and Splitting Worksheets



Enhance Worksheets with Themes and Styles



Changing and Customizing a Workbook Theme



Creating and Applying a Custom Table Style



Format a Worksheet to Share with Others



Previewing and Modifying Page Breaks



Repeating Column or Row Titles



Inserting a Hyperlink in a Worksheet



Modifying a Hyperlink



Save Excel Data in Other File Formats



Viewing and Saving a Workbook as a Web Page



Saving Excel Data in CSV File Format



Saving Excel Data as a PDF or XPS File


More Knowledge Converting a Tab Delimited Text File to a Word Table



Sorted, Filtered, and Outlined Database


More Knowledge A Custom List Remains Available for All Workbooks in Excel


More Knowledge Using Wildcards


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


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think



Creating Charts, Diagrams, and Templates



Attendance Charts and Diagrams



Create and Format Sparklines and a Column Chart



Creating and Formatting Sparklines



Creating a Column Chart


More Knowledge Sizing Handles and Selection Handles



Changing the Display of Chart Data


More Knowledge Changing the Data in a Chart



Editing and Formatting the Chart Title



Adding, Formatting, and Aligning Axis Titles



Editing Source Data



Formatting the Chart Floor and Chart Walls



Create and Format a Line Chart



Creating a Line Chart



Changing a Chart Title



Changing the Values on the Value Axis



Formatting the Plot Area and the Data Series



Inserting a Trendline



Create and Modify a SmartArt Graphic



Creating a Process SmartArt Graphic



Modifying the Diagram Style



Create and Modify an Organization Chart



Creating and Modifying a SmartArt Organization Chart



Adding Effects to a SmartArt Graphic



Preparing Worksheets Containing Charts and Diagrams for Printing



Order Form Template


More Knowledge Setting the Default Font for New Worksheets


More Knowledge Modifying a Template


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


Glossary


Skills Review


Mastering Excel


Rubric


GO! Think