Sale!

New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol DesJardins ISBN 1285169336 9781285169330

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

New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition June Jamrich Parsons Digital Instant Download

Author(s): June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol DesJardins
ISBN(s): 9781285169330, 1285169336
Edition: 1
File Details: PDF, 102.65 MB
Year: 2013
Language: english
SKU: EB-4965230 Category: Tags: , , , ,

New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition by June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol DesJardins – Ebook PDF Instant Download/Delivery: 1285169336, 9781285169330
Full download New Perspectives on Microsoft Excel 2013 Comprehensive 1st Edition after payment

Product details:

ISBN 10: 1285169336 
ISBN 13: 9781285169330
Author: June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol DesJardins

With proven pedagogy that emphasizes critical-thinking, problem-solving, and in-depth coverage, New Perspectives helps students develop the Microsoft Office 2013 skills they need to be successful in college and beyond. Updated with all new case-based tutorials, New Perspectives Microsoft Excel 2013 continues to engage students in applying skills to real-world situations, making concepts relevant. A new Troubleshoot case problem enhances critical thinking, and a new tutorial on Managing Your Files helps students navigate Windows 8. As always, New Perspectives improves learning outcomes and transference of skills by helping students understand why what they’re learning is important.

New Perspectives on Microsoft Excel 2013 Comprehensive 1st Table of contents:

Chapter 1: Introduction to Microsoft Excel 2013

  • What’s New in Excel 2013?

  • Navigating the Excel 2013 Interface: Ribbon, Quick Access Toolbar, and Backstage View

  • Creating and Saving Workbooks

  • Understanding Workbooks and Worksheets

  • Basic Excel Terminology and Concepts

Chapter 2: Entering and Formatting Data

  • Entering Text, Numbers, and Dates

  • Understanding Cell References and Ranges

  • Formatting Data: Fonts, Colors, and Alignment

  • Number Formatting: Currency, Percentages, Dates, and Custom Formats

  • Using Format Painter and Conditional Formatting

Chapter 3: Working with Worksheets and Workbooks

  • Managing Multiple Worksheets in a Workbook

  • Moving, Renaming, and Deleting Worksheets

  • Grouping and Ungrouping Worksheets

  • Protecting and Sharing Workbooks

  • Using the AutoSave and AutoRecover Features

Chapter 4: Formulas and Functions

  • Introduction to Formulas in Excel

  • Using Basic Functions: SUM, AVERAGE, MIN, MAX

  • Understanding Cell References: Relative, Absolute, and Mixed

  • Building More Complex Formulas

  • Using Logical Functions: IF, AND, OR

  • Date and Time Functions: NOW, TODAY, YEAR, MONTH

Chapter 5: Organizing and Analyzing Data

  • Sorting and Filtering Data

  • Using the Sort Options for Custom Lists

  • Advanced Filtering Techniques

  • Using the Subtotal and Outline Features

  • Working with Tables: Creating, Formatting, and Sorting Tables

Chapter 6: Visualizing Data with Charts

  • Introduction to Charts in Excel 2013

  • Creating Different Types of Charts: Column, Line, Pie, Bar, and More

  • Customizing Chart Styles and Layouts

  • Adding and Formatting Chart Elements: Titles, Legends, and Axes

  • Creating and Managing PivotCharts

Chapter 7: Using PivotTables for Data Analysis

  • What is a PivotTable? Overview and Uses

  • Creating and Customizing PivotTables

  • Grouping Data in PivotTables

  • Summarizing and Analyzing Data with PivotTables

  • Creating PivotCharts from PivotTables

Chapter 8: Advanced Formulas and Functions

  • Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH

  • Text Functions: CONCATENATE, LEFT, RIGHT, MID

  • Financial Functions: PMT, FV, NPV

  • Statistical Functions: COUNTIF, AVERAGEIF, SUMIF

  • Array Formulas and Dynamic Array Functions

Chapter 9: Data Validation and Error Checking

  • Introduction to Data Validation

  • Creating Drop-Down Lists and Input Messages

  • Setting Validation Criteria for Numbers, Dates, and Text

  • Error Checking and Tracing Formulas

  • Auditing and Resolving Formula Errors

Chapter 10: Advanced Data Tools

  • What-If Analysis: Scenario Manager, Goal Seek, Data Tables

  • Solver: Solving Complex Problems in Excel

  • Using Consolidate to Combine Data from Multiple Ranges

  • Working with Text-to-Columns and Flash Fill

  • Data Consolidation and Grouping Techniques

Chapter 11: Working with Macros and Automation

  • Introduction to Macros: What They Are and How They Work

  • Recording and Running Simple Macros

  • Using the Macro Recorder for Repetitive Tasks

  • Assigning Macros to Buttons and Shortcuts

  • Introduction to VBA (Visual Basic for Applications)

Chapter 12: Collaborating and Sharing Workbooks

  • Sharing Workbooks and Tracking Changes

  • Protecting Workbooks and Worksheets

  • Using Comments and Notes for Collaboration

  • Working with Excel Online and OneDrive Integration

  • Exporting Data to Other Formats: PDF, CSV, and More

Chapter 13: Printing and Publishing Workbooks

  • Preparing Your Workbook for Printing

  • Setting Print Areas and Page Layout

  • Using Headers, Footers, and Page Numbers

  • Printing Multiple Sheets and Large Workbooks

  • Publishing Workbooks to the Web or Cloud Services

Chapter 14: Excel Tips and Tricks

  • Time-Saving Keyboard Shortcuts and Techniques

  • Advanced Formatting Tricks: Custom Styles and Themes

  • Using Excel Templates for Quick Reports and Projects

  • Working Efficiently with Multiple Workbooks and Windows

  • Hidden Features and Lesser-Known Excel Tools

Chapter 15: Excel in the Real World: Case Studies and Applications

  • Using Excel for Budgeting and Financial Analysis

  • Project Management with Excel: Gantt Charts and Timelines

  • Analyzing Survey Data in Excel

  • Excel in Marketing: Sales Analysis and Data Visualization

  • Excel for Scientific and Statistical Analysis

 

People also search for New Perspectives on Microsoft Excel 2013 Comprehensive 1st:

    
new perspectives microsoft office 365 excel 2019
    
new perspectives microsoft office 365 & excel 2019 comprehensive pdf
    
new perspectives microsoft office 365 & excel 2019 comprehensive ebook
    
new perspectives microsoft office 365 & excel 2016 comprehensive pdf
    
new perspectives microsoft office 365 & excel 2019 comprehensive solutions

Tags: June Jamrich Parsons, Dan Oja, Roy Ageloff, Patrick Carey, Carol DesJardins, Perspectives, Microsoft Excel