Excel 2010 Made Simple 1st Edition by Abbott Katz – Ebook PDF Instant Download/Delivery. 1430235454, 9781430235453
Full download Excel 2010 Made Simple 1st Edition after payment
Product details:
ISBN 10: 1430235454
ISBN 13: 9781430235453
Author: Abbott Katz
Get the most out of Excel 2010 with Excel 2010 Made Simple—learn the key features, understand what’s new, and utilize dozens of time-saving tips and tricks to get your job done. Over 500 screen visuals and clear-cut instructions guide you through the features of Excel 2010, from formulas and charts to navigating around a worksheet and understanding Visual Basic for Applications (VBA) and macros.
Excel 2010 Made Simple takes a practical and highly effective approach to using Excel 2010, showing you the best way to complete your most common spreadsheet tasks. You’ll learn how to input, format, sort, and filter your data to find out what you want to know. You’ll see how to place your data in tables and named ranges for easy access, all of which will get you working efficiently and productively.
Excel 2010 Made Simple also covers the new features introduced in Excel 2010. For instance, it shows you how to use Sparklines for data comparison and the Backstage view for printing and sharing your spreadsheets, so you can carry out your tasks with minimum fuss. The hands-on focus on tasks means you’ll see how to actually use Excel 2010 to suit your needs.
Excel 2010 Made Simple 1st Table of contents:
Chapter 1: Getting Started with Excel 2010
- Navigating the Excel Interface
- Understanding the Ribbon and Quick Access Toolbar
- Customizing the Excel Workspace
- Creating and Saving Workbooks
- Using Excel’s Help System
Chapter 2: Working with Data
- Entering Data into Excel
- Editing and Deleting Data
- Working with Multiple Worksheets
- Using Autofill and Flash Fill for Quick Data Entry
Chapter 3: Basic Excel Functions and Formulas
- What Is a Formula?
- Using Simple Mathematical Functions (SUM, AVERAGE)
- Introduction to Cell References (Relative, Absolute)
- Using Functions for Text, Date, and Time
Chapter 4: Formatting Worksheets and Data
- Formatting Text and Numbers
- Applying Number Formats (Currency, Percent, etc.)
- Formatting Cells, Rows, and Columns
- Using Themes and Styles to Format Data
Chapter 5: Organizing Data in Excel
- Sorting Data (Ascending/Descending)
- Filtering Data to Show Specific Information
- Using Find and Replace for Easy Editing
- Grouping and Outlining Data
Chapter 6: Working with Charts
- Creating Basic Charts in Excel
- Customizing Chart Styles and Layouts
- Adding Titles, Legends, and Data Labels to Charts
- Working with Different Chart Types (Bar, Line, Pie, etc.)
Chapter 7: Using PivotTables and PivotCharts
- Introduction to PivotTables
- Creating a PivotTable from Data
- Analyzing Data with PivotCharts
- Filtering and Sorting PivotTable Data
Chapter 8: Conditional Formatting
- What Is Conditional Formatting?
- Applying Conditional Formatting to Data
- Using Color Scales, Icon Sets, and Data Bars
- Customizing Conditional Formatting Rules
Chapter 9: Data Validation and Protection
- Setting Data Validation Rules (Text Length, Dates)
- Creating Drop-Down Lists for Easy Data Entry
- Protecting Cells and Workbooks from Unwanted Changes
- Sharing and Collaborating on Excel Files
Chapter 10: Printing and Sharing Excel Files
- Preparing Workbooks for Printing
- Customizing Print Layouts
- Printing Selected Ranges or Entire Worksheets
- Saving Excel Files in PDF and Other Formats
- Emailing Workbooks from Excel
Chapter 11: Time-Saving Tips and Tricks
- Keyboard Shortcuts for Excel 2010
- Using Autofill and Flash Fill Efficiently
- Customizing Excel’s Ribbon and Quick Access Toolbar
- Automating Tasks with Macros (Basic Introduction)
People also search for Excel 2010 Made Simple 1st:
You may also like…
eBook PDF
Strategic Project Management Made Simple 1st edition by Terry Schmidt 1119718155 9781119718154
eBook PDF
Excel 2010 All in One For Dummies 1st Edition by Greg Harvey ISBN 0470489596 9780470489598
