GO! with Microsoft Excel 2013 Brief

by Gaskin, Shelley; Vargas, Alicia

• ISBN13: 9780133414424
• ISBN10: 0133414426
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2019-11-21
• Publisher: Pearson

Summary

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 and instructors achieve their goals.
• Engage Students with a Project-Based Approach: GO!’s project-based approach teaches students to solve real problems as they practice and learn the features.
• Motivate Students with Clear Instruction: Based on professor and student feedback, this text has been designed to offer clear instruction for full student comprehension.
• Teach the Course You Want in Less Time: The GO! series’ one-of-a kind instructional system provides you with everything you need to prepare for class, teach the material, and assess your students.

Table of Contents

Office

Chapter 1 Introduction to Microsoft Office 2013 Features

Project 1A Note Form

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

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

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

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

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

Activity 1.03 Entering and Editing Text in an Office 2013 Program

Activity 1.04 Checking Spelling

Objective 4 Perform Commands from a Dialog Box

Activity 1.05 Performing Commands from a Dialog Box

Activity 1.06 Using Undo

Objective 5 Create a Folder and Name and Save a File

Activity 1.07 Creating a Folder and Naming and Saving a File

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

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

Activity 1.09 Printing a File and Closing a Desktop App

 

Project 1B Memo

Objective 7 Open an Existing File and Save It with a New Name

Activity 1.10 Opening an Existing File and Saving It with a New Name

More Knowledge Read-only

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

Activity 1.11 Signing In to Office and Viewing Application Options

Objective 9 Perform Commands from the Ribbon and Quick Access Toolbar

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

More Knowledge Customizing the Ribbon

Activity 1.13 Minimizing and Using the Keyboard to Control the Ribbon

Objective 10 Apply Formatting in Office Programs

Activity 1.14 Changing Page Orientation and Zoom Level

More Knowledge Zooming to Page Width

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

Activity 1.16 Using Format Painter

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

Objective 11 Compress Files and Use the Microsoft Office 2013 Help System

Activity 1.18 Compressing Files

Activity 1.19 Using the Microsoft Office 2013 Help System in Excel

Objective 12 Install Apps for Office and Create a Microsoft Account

Activity 1.20 Installing Apps for Office

Activity 1.21 Creating a Microsoft Account

Summary, GO! Learn It Online

Guide to Chapter Assessments

Glossary

 

Excel Introduction to Microsoft Excel 2013

Chapter 1 Creating a Worksheet and Charting Data

Project 1A Sales Report with Embedded Column Chart and Sparklines

Objective 1 Create, Save, and Navigate an Excel Workbook

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

More Knowledge Creating a New Workbook by Using a Template

Objective 2 Enter Data in a Worksheet

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

Activity 1.03 Using Auto Fill and Keyboard Shortcuts

Activity 1.04 Aligning Text and Adjusting the Size of Columns

Activity 1.05 Entering Numbers

Objective 3 Construct and Copy Formulas and Use the SUM Function

Activity 1.06 Constructing a Formula and Using the Sum Function

Activity 1.07 Copying a Formula by Using the Fill Handle

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

Activity 1.08 Using Merge & Center and Applying Cell Styles

Activity 1.09 Formatting Financial Numbers

Activity 1.10 Changing the Workbook Theme

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

Objective 5 Chart Data to Create a Column Chart and Insert Sparklines

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

Activity 1.12 Using the Chart Tools to Apply Chart Styles

Activity 1.13 Creating and Formatting Sparklines

Objective 6 Print a Worksheet, Display Formulas, and Close Excel

Activity 1.14 Creating a Footer and Centering a Worksheet

Activity 1.15 Adding Document Properties and Printing a Workbook

Activity 1.16 Printing a Section of the Worksheet

Activity 1.17 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

 

Project 1B Inventory Valuation

Objective 7 Check Spelling in a Worksheet

Activity 1.18 Checking Spelling in a Worksheet

Objective 8 Enter Data by Range

Activity 1.19 Entering Data by Range

Objective 9 Construct Formulas for Mathematical Operations

Activity 1.20 Using Arithmetic Operator

Activity 1.21 Using the Quick Analysis Tool

Activity 1.22 Copying Formulas Containing Absolute Cell References

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

Objective 10 Edit Values in a Worksheet

Activity 1.23 Editing Values in a Worksheet

Activity 1.24 Formatting Cells with the Percent Style

Objective 11 Format a Worksheet

Activity 1.25 Inserting and Deleting Rows and Columns

More Knowledge Hiding Rows and Columns

Activity 1.26 Adjusting Column Widths and Wrapping Text

Activity 1.27 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

 

Chapter 2 Using Functions, Creating Tables, and Managing Large Workbooks

Project 2A Inventory Status Report

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

Activity 2.01 Using Flash Fill

Activity 2.02 Moving a Column

Activity 2.03 Using the SUM and AVERAGE Functions

Activity 2.04 Using the MEDIAN Function

Activity 2.05 Using the MIN and MAX Functions

Objective 2 Move Data, Resolve Error Messages, and Rotate Text

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

Activity 2.07 Rotating Text

Objective 3 Use COUNTIF and IF Functions and Apply Conditional Formatting

Activity 2.08 Using the COUNT and Countif Functions

Activity 2.09 Using the IF Function

Activity 2.10 Applying Conditional Formatting by Using Highlight Cells Rules and Data Bars

Activity 2.11 Using Find and Replace

Objective 4 Use Date & Time Functions and Freeze Panes

Activity 2.12 Using the Now Function to Display a System Date

More Knowledge NOW Function Recalculates Each Time a Workbook Opens

Activity 2.13 Freezing and Unfreezing Panes

More Knowledge Freeze Columns or Freeze Both Rows and Columns

Objective 5 Create, Sort, and Filter an Excel Table

Activity 2.14 Creating an Excel Table and Applying a Table Style

Activity 2.15 Sorting an Excel Table

Activity 2.16 Filtering an Excel Table and Displaying a Total Row

More Knowledge Band Rows and Columns in a Table

Activity 2.17 Clearing Filters and Converting a Table to a Range of Data

Objective 6 View, Format, and Print a Large Worksheet

Activity 2.18 Modifying and Shrinking the Worksheet View

Activity 2.19 Splitting a Worksheet Window into Panes

Activity 2.20 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

 

Project 2B Weekly Sales Summary

Objective 7 Navigate a Workbook and Rename Worksheets

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

More Knowledge Copying a Worksheet

Objective 8 Enter Dates, Clear Contents, and Clear Formats

Activity 2.22 Entering and Formatting Dates

Activity 2.23 Clearing Cell Contents and Formats

More Knowledge Clearing an Entire Worksheet

Objective 9 Copy and Paste by Using the Paste Options Gallery

Activity 2.24 Copying and Pasting by Using the Paste Options Gallery

Objective 10 Edit and Format Multiple Worksheets at the Same Time

Activity 2.25 Grouping Worksheets for Editing

More Knowledge Hide Worksheet

Activity 2.26 Formatting and Constructing Formulas on Grouped Worksheets

Activity 2.27 Determining Multiple Totals at the Same Time

Activity 2.28 Formatting Grouped Worksheets

Objective 11 Create a Summary Sheet with Column Sparklines

Activity 2.29 Ungrouping Worksheets

Activity 2.30 Inserting a Worksheet

Activity 2.31 Constructing Formulas That Refer to Cells in Another Worksheet

Activity 2.32 Changing Values in a Detail Worksheet to Update a Summary Worksheet

Activity 2.33 Inserting Column Sparklines

Objective 12 Format and Print Multiple Worksheets in a Workbook

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

Activity 2.35 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

 

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

Project 3A Enterprise Fund Pie Chart

Objective 1 Chart Data with a Pie Chart

Activity 3.01 Calculating Values for a Pie Chart

Activity 3.02 Creating a Pie Chart in a Chart Sheet

Objective 2 Format a Pie Chart

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

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

Activity 3.05 Formatting a Data Series with 3-D Effects

Activity 3.06 Formatting a Data Series with a Shadow Effect

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

Activity 3.08 Exploding and Coloring a Pie Slice

Activity 3.09 Formatting the Chart Area

Objective 3 Edit a Workbook and Update a Chart

Activity 3.10 Editing a Workbook and Updating a Chart

Objective 4 Use Goal Seek to Perform What-If Analysis

Activity 3.11 Using Goal Seek to Perform What-If Analysis

Activity 3.12 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

 

Project 3B Tourism Spending Projection with Line Chart

Objective 5 Design a Worksheet for What-If Analysis

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

More Knowledge Use of Parentheses in a Formula

Activity 3.14 Using Format Painter

More Knowledge Percentage Calculations

Activity 3.15 Calculating a Value After an Increase

More Knowledge Percent Increase or Decrease

Objective 6 Answer What-If Questions by Changing Values in a Worksheet

Activity 3.16 Answering What-If Questions and Using Paste Special

Objective 7 Chart Data with a Line Chart

Activity 3.17 Inserting Multiple Rows and Creating a Line Chart

Activity 3.18 Formatting Axes in a Line Chart

Activity 3.19 Formatting the Chart Area in a Line Chart

Activity 3.20 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