Sale!

Teach Yourself VISUALLY Excel 2010 1st Edition by Paul Mcfedries ISBN 0470577649 9780470577646

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

Teach Yourself VISUALLY Excel 2010 1st Edition Paul Mcfedries Digital Instant Download

Author(s): Paul McFedries
ISBN(s): 9780470577646, 0470577649
Edition: 1
File Details: PDF, 88.77 MB
Year: 2010
Language: english
SKU: EB-1856604 Category: Tag:

Teach Yourself VISUALLY Excel 2010 1st Edition by Paul Mcfedries – Ebook PDF Instant Download/Delivery:  0470577649 ,9780470577646
Full download Teach Yourself VISUALLY Excel 2010 1st Edition after payment

Product details:
ISBN 10: 0470577649 
ISBN 13: 9780470577646
Author: Paul Mcfedries

If you’re always hearing about the cool things that Excel can do, here’s your chance to see how to do them! With pages of full-color, step-by-step instructions and crystal-clear screen shots, this guide shows you how to get the most out of Excel 2010. The book covers all the basics as well as Excel 2010’s new features and functions, including a new interface and better collaboration tools. Crunch and chart your data over a network, over the Web, or at home-helpful tips on every page will get you there even faster!

  • Provides a clear look at Excel 2010, the newest version of the world’s leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
  • Demonstrates how to create spreadsheets and charts, filter and sort data, work with PivotTable, and present your data-on a network, on the Web, or on your laptop
  • Explores all features and functions in full-color pages packed with screen shots and other visual graphics that clearly show you how to accomplish tasks
  • Includes practical examples, tips, and advice on how to use all the tools more effectively

Get the very most out of Excel 2010 with this easy-to-follow guide!

Teach Yourself VISUALLY Excel 2010 1st Edition Table of contents:

Chapter 1: Getting Started with Excel

  • Opening and Creating Workbooks
  • Excel’s Interface: Ribbon, Tabs, and Commands
  • Navigating the Excel Environment
  • Entering and Editing Data
  • Saving, Closing, and Opening Files

Chapter 2: Formatting Worksheets

  • Formatting Text and Numbers
  • Cell Styles and Themes
  • Conditional Formatting
  • Working with Columns, Rows, and Cells
  • Changing Cell Alignment, Borders, and Fill Colors

Chapter 3: Formulas and Functions

  • Writing Simple Formulas
  • Common Excel Functions (SUM, AVERAGE, COUNT, etc.)
  • Using the Formula Bar and Name Box
  • Working with Relative, Absolute, and Mixed References
  • Creating Logical and Text Functions

Chapter 4: Organizing Data with Tables and Lists

  • Creating and Formatting Tables
  • Sorting and Filtering Data
  • Using Table Tools and Styles
  • Converting Data into Structured Tables
  • Creating and Using Named Ranges

Chapter 5: Visualizing Data with Charts

  • Creating and Modifying Charts
  • Working with Different Chart Types (Bar, Line, Pie, etc.)
  • Customizing Chart Elements
  • Adding and Formatting Chart Titles, Axes, and Legends
  • Using Sparklines for Quick Data Insights

Chapter 6: Advanced Data Management

  • Using PivotTables and PivotCharts
  • Grouping and Summarizing Data
  • Advanced Filtering and Sorting
  • Using Excel’s Data Validation Features
  • Importing and Exporting Data

Chapter 7: Working with Multiple Worksheets and Workbooks

  • Linking Data Across Worksheets
  • Consolidating Data from Multiple Sources
  • Using 3D References
  • Protecting and Sharing Workbooks
  • Collaborative Features in Excel

Chapter 8: Using Excel for Analysis

  • Working with Data Models
  • Using What-If Analysis Tools (Goal Seek, Scenario Manager)
  • Analyzing Data with Solver and Analysis ToolPak
  • Creating and Using Array Formulas

Chapter 9: Automating Tasks with Macros

  • Introduction to Macros
  • Recording a Simple Macro
  • Assigning Macros to Buttons and Keys
  • Editing and Customizing Macros in VBA
  • Automating Repetitive Tasks

Chapter 10: Printing and Sharing Workbooks

  • Preparing Worksheets for Printing
  • Customizing Page Layout and Margins
  • Printing Multiple Worksheets at Once
  • Exporting Workbooks to PDF and Other Formats
  • Sharing Workbooks via OneDrive and Other Cloud Services

People also search for Teach Yourself VISUALLY Excel 2010 1st Edition:

teach yourself visually excel 365

teach yourself visually microsoft 365

teach yourself visually windows 11 pdf

how to teach yourself excel for free

Tags:

Paul Mcfedries,Teach Yourself VISUALLY,Excel 2010