اکسل ۲۰۱۰ به سادگی

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. What you’ll learn How to do efficient and complex data entry How to format your data How to write basic—and not so basic—formulas How to use Excel's database capabilities, including PivotTables How to create colorful, meaningful charts How to create basic macros and how to use them How to use new Excel 2010 features, such as Sparklines and the Backstage view Who this book is for Excel 2010 Made Simple is for newcomers to Excel. Table of Contents Introducing Excel 2010 Getting Around the Worksheet and Data Entry Editing Data Number Crunching 101: Functions, Formulas, and Ranges For Appearance's Sake: Formatting Your Data Charting Your Data Sorting and Filtering Your Data: Excel's Database Features PivotTables: Data Aggregation Without the Aggravation Managing Your Workbook Printing Your Worksheets: Hard Copies Made Easy Automating Your Work with Macros

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.

What you’ll learn

• How to do efficient and complex data entry
• How to format your data
• How to write basic—and not so basic—formulas
• How to use Excel's database capabilities, including PivotTables
• How to create colorful, meaningful charts
• How to create basic macros and how to use them
• How to use new Excel 2010 features, such as Sparklines and the Backstage view

Who this book is for

Excel 2010 Made Simple is for newcomers to Excel.

Table of Contents

1. Introducing Excel 2010
2. Getting Around the Worksheet and Data Entry
3. Editing Data
4. Number Crunching 101: Functions, Formulas, and Ranges
5. For Appearance's Sake: Formatting Your Data
6. Charting Your Data
7. Sorting and Filtering Your Data: Excel's Database Features
8. PivotTables: Data Aggregation Without the Aggravation
9. ManagingYour Workbook
10. PrintingYour Worksheets: Hard Copies Made Easy
11. Automating Your Work with Macros

Annotation Get the most out of Excel 2010 withExcel 2010 Made Simplelearn the key features, understand whats 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 Simpletakes 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 Simplealso 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. What youll learnHow to do efficient and complex data entryHow to format your dataHow to write basicand not so basicformulasHow to use Excel's database capabilities, including PivotTablesHow to create colorful, meaningful chartsHow to create basic macros and how to use themHow to use new Excel 2010 features, such as Sparklines and the Backstage viewWho this book is forExcel 2010 Made Simpleis for newcomers to Excel. Table of ContentsIntroducing Excel 2010Getting Around the Worksheet and Data EntryEditing DataNumber Crunching 101: Functions, Formulas, and RangesFor Appearance's Sake: Formatting Your DataCharting Your DataSorting and Filtering Your Data: Excel's Database FeaturesPivotTables: Data Aggregation Without the AggravationManagingYour WorkbookPrintingYour Worksheets: Hard Copies Made EasyAutomating Your Work with Macros 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 the minimum of fuss. The hands-on focus on tasks means you'll see how to actually use Excel 2010 to suit your needs. What you'll learn How to do efficient and complex data entry How to format your data How to write basic--and not so basic--formulas How to use Excel's database capabilities, including PivotTables How to create colorful, meaningful charts How to create basic macros and how to use them How to use new Excel 2010 features, such as Sparklines and the Backstage view Who this book is for Excel 2010 Made Simple is for newcomers to Excel Learn all the key features, understand what's new, and utilize dozens of time-saving tips and tricks. This is a practical and highly effective approach to using Excel 2010, showing you the best way to complete the most common spreadsheet tasks