Microsoft Excel 2013 Full Coverage of Excel 2013’s Top Features and Functions 1st Edition by Michael Miller ISBN 1615645411 9781615645411

Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions 1st Edition by Michael Miller – Ebook PDF Instant Download/Delivery: 1615645411, 9781615645411

Full download Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions 1st Edition after payment

 

 

Product details:

ISBN 10: 1615645411

ISBN 13: 9781615645411

Author:  Michael Miller 

Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions 1st Edition: Microsoft® Excel® can be an overwhelming and intimidating software product to use, but armed with the right book, anyone can master the basics. Packed full of color screen shots and illustrations, Idiot’s Guides: Microsoft® Excel® 2013 will teach any novice how to perform all of the essential functions, including how to create a spreadsheet from scratch; build and edit basic formulas and functions; manage, sort, and edit data cleanly and efficiently; create and insert graphics; work with tables; generate readable reports; and much more.

 

Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions 1st Edition Table of contents:

• Case Study: Spotted Begonia Art Gallery

• Logging In with Your Microsoft Account

• Accessing the Desktop

• Hands-On Exercise: Windows 8 Startup

• Using File Explorer

• Working with Folders and Files

• Hands-On Exercise: Files and Folders

• Identifying Common Interface Components

• Getting Office Help

• Hands-On Exercise: Microsoft Office Software

• Opening, Printing, and Closing Files

• Hands-On Exercise: The Backstage View

• Selecting and Editing Text

• Using the Clipboard and Editing Commands

• Hands-On Exercise: Home Tab Tasks

• Inserting Objects and Reviewing Files

• Hands-On Exercise: Insert and Review Tab Tasks

• Chapter Review and Exercises

• Case Study: OK Office Systems

Excel Basics

• Exploring the Excel Window

• Entering and Editing Cell Data

• Hands-On Exercise: Introduction to Spreadsheets

• Creating Formulas and Using Auto Fill

• Hands-On Exercise: Mathematics and Formulas

• Managing Worksheets, Columns, and Rows

• Hands-On Exercise: Workbook Management

• Formatting and Printing Worksheets

• Hands-On Exercise: Formatting and Page Setup

• Chapter Review and Exercises

• Case Study: Townsend Mortgage Company

Advanced Excel Functions

• Using Cell References and Correcting Circular References

• Hands-On Exercise: Formula Basics

• Using Logical, Lookup, and Financial Functions

• Hands-On Exercise: Functions

• Creating and Using Range Names

• Hands-On Exercise: Range Names

• Chapter Review and Exercises

• Case Study: Computer Job Outlook

Data Visualization and Charts

• Creating and Formatting Charts

• Hands-On Exercise: Chart Basics

• Customizing Charts and Sparklines

• Hands-On Exercise: Chart Design

• Chapter Review and Exercises

• Case Study: Reid Furniture Store

Working with Large Datasets

• Managing and Formatting Large Datasets

• Hands-On Exercise: Large Datasets

• Sorting and Filtering Data

• Hands-On Exercise: Table Manipulation

• Applying Conditional Formatting

• Hands-On Exercise: Conditional Formatting

• Chapter Review and Exercises

• Case Study: Ivory Halls Publishing Company

PivotTables and Data Analysis

• Creating and Modifying PivotTables

• Hands-On Exercise: PivotTable Basics

• Filtering, Slicing, and Formatting PivotTables

• Hands-On Exercise: PivotTable Options

• Creating PivotCharts

• Hands-On Exercise: PivotCharts

• Chapter Review and Exercises

• Case Study: Personal Finance: Buying Your First Home

Advanced Data Analysis Tools

• Using Data Tables, Goal Seek, and Scenario Manager

• Hands-On Exercise: Data Analysis Tools

• Optimizing with Solver

• Hands-On Exercise: Solver

• Chapter Review and Exercises

• Case Study: TransPayne Filtration

Advanced Excel Formulas and Functions

• Creating Nested Functions and Using MATCH & INDEX

• Hands-On Exercise: Advanced Functions

• Using Advanced Filtering and Database Functions

• Hands-On Exercise: Filtering and Database Functions

• Financial Calculations and Loan Amortization

• Hands-On Exercise: Financial Functions

• Chapter Review and Exercises

 

People also search for Microsoft Excel 2013: Full Coverage of Excel 2013’s Top Features and Functions 1st Edition:

download microsoft excel 2013
    
modul microsoft excel 2013 lengkap pdf
    
succeeding in business with microsoft excel 2013
    
microsoft excel 2013 free download
    
update microsoft excel 2013
    
ส่วนประกอบ ของ โปรแกรม microsoft excel 2013

Tags:

Michael Miller,Microsoft,Excel 2013,Full Coverage,Excel,2013’s,Top,Features,Functions