Atjaunināt sīkdatņu piekrišanu

E-grāmata: Excel 2010 Made Simple

3.50/5 (4 ratings by Goodreads)
,
  • Formāts: PDF+DRM
  • Izdošanas datums: 14-Aug-2011
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430235460
Citas grāmatas par šo tēmu:
  • Formāts - PDF+DRM
  • Cena: 27,35 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
  • Šī e-grāmata paredzēta tikai personīgai lietošanai. E-grāmatas nav iespējams atgriezt un nauda par iegādātajām e-grāmatām netiek atmaksāta.
Excel 2010 Made SimplePalielināt
  • Formāts: PDF+DRM
  • Izdošanas datums: 14-Aug-2011
  • Izdevniecība: APress
  • Valoda: eng
  • ISBN-13: 9781430235460
Citas grāmatas par šo tēmu:

DRM restrictions

  • Kopēšana (kopēt/ievietot):

    nav atļauts

  • Drukāšana:

    nav atļauts

  • Lietošana:

    Digitālo tiesību pārvaldība (Digital Rights Management (DRM))
    Izdevējs ir piegādājis šo grāmatu šifrētā veidā, kas nozīmē, ka jums ir jāinstalē bezmaksas programmatūra, lai to atbloķētu un lasītu. Lai lasītu šo e-grāmatu, jums ir jāizveido Adobe ID. Vairāk informācijas šeit. E-grāmatu var lasīt un lejupielādēt līdz 6 ierīcēm (vienam lietotājam ar vienu un to pašu Adobe ID).

    Nepieciešamā programmatūra
    Lai lasītu šo e-grāmatu mobilajā ierīcē (tālrunī vai planšetdatorā), jums būs jāinstalē šī bezmaksas lietotne: PocketBook Reader (iOS / Android)

    Lai lejupielādētu un lasītu šo e-grāmatu datorā vai Mac datorā, jums ir nepieciešamid Adobe Digital Editions (šī ir bezmaksas lietotne, kas īpaši izstrādāta e-grāmatām. Tā nav tas pats, kas Adobe Reader, kas, iespējams, jau ir jūsu datorā.)

    Jūs nevarat lasīt šo e-grāmatu, izmantojot Amazon Kindle.

Get the most out of Excel 2010 with Excel 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 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.
Contents at a Glance iii
About the Author xi
About the Technical Reviewer xi
Acknowledgments xii
Quick Start Guide
1(338)
The Excel Worksheet: What You're Looking At
1(4)
Key Tips: Accessing Buttons with the Keyboard
5(1)
Contextual Tabs
6(1)
A Visit Backstage
7(1)
Customizing the Quick Access Toolbar
8(4)
Where to Learn More
12(6)
Excel Keyboard Equivalents
18(9)
Chapter 1 Introducing Excel 2010
27(4)
The Advantages of Learning More
27(1)
Spreadsheets Defined
28(2)
Excel Can Be Fun
30(1)
Summary
30(1)
Chapter 2 Getting Around the Worksheet and Data Entry
31(32)
The Journey Starts Here
31(1)
Looking Around
31(1)
Getting Around a Worksheet
31(3)
Selecting Multiple Cells
34(4)
Selecting Cells Down and Across the Worksheet
35(1)
Selecting Cells with the Keyboard
36(1)
Selecting All the Cells
36(1)
Still One More Selection Technique--The Name Box
37(1)
Entering Text and Data
38(1)
Aligning Your Data--Where It Appears in the Cell
39(2)
Widening and Narrowing Columns
41(3)
Altering a column manually
41(1)
Using the Auto-fit Feature
42(2)
Entering Numerical Data-How it's Different
44(1)
Entering Data into a Selected Range
45(3)
Using Auto Fill to Speed Up Data Entry
48(6)
Copying a Value with Auto Fill
48(1)
Auto Filling a Numeric Sequence
48(2)
Using Auto Fill with Text
50(1)
Using the Auto Fill Option Button
50(3)
Customizing Auto Fill Lists
53(1)
Data Validation: Bringing Quality Control to the Worksheet
54(6)
Making a List--Personalizing a Drop-Down Menu
57(2)
Explaining Data Validation Errors with Error Alerts
59(1)
Adding Data Entry Instructions with Input Messages
60(1)
Summary
61(2)
Chapter 3 Editing Data
63(10)
Changing Your Data
63(3)
Undoing an Edit
64(2)
Undoing What You've Just Undone with the Redo Button
66(1)
Deleting Cell Contents
66(1)
Copying and Moving: Duplicating and Relocating Your Data
66(3)
Copying Data
67(2)
Moving Data
69(1)
The Clipboard: The Storage Area for Copied and Cut Data
69(2)
Summary
71(2)
Chapter 4 Number Crunching 101: Functions, Formulas, and Ranges
73(30)
Automatic Calculations with Functions
73(11)
Adding a Column of Numbers
74(2)
Selecting the Range You Need
76(1)
Viewing and Editing Your Formula: Back to the Formula Bar
77(2)
Calculating an Average
79(1)
Displaying Values Based on a Certain Condition
80(2)
Revisiting Function Structure
82(1)
Locating Functions in the Function Library
82(2)
Customizing the Worksheet with Formulas
84(11)
Writing a Basic Formula
85(1)
Working Out the Order of Operations in a Formula
86(1)
Copying Formulas: More Than Just Duplication
87(8)
Clarifying Cell References by Naming a Range
95(7)
Naming a Range in the Name Box
95(4)
Naming Ranges from the Data in Your Worksheet
99(1)
Naming A Range Containing One Cell: Why Bother?
100(1)
The Name Manager: Where They're All Ar-ranged
101(1)
Summary
102(1)
Chapter 5 For Appearance's Sake: Formatting Your Data
103(52)
What Formatting Does (and Doesn't Do)
103(1)
Basic Formatting
104(10)
Changing the Font
104(2)
Changing the Font Size
106(1)
Using Bold, Italics, and Underline
107(1)
Determining a Cell's Formatting
108(1)
Adding a Border
109(2)
Adding Color to Your Cells
111(2)
Adding Extra Formatting
113(1)
Aligning (and Realigning) Your Data
114(7)
Changing Horizontal Alignment
114(1)
Changing Vertical Alignment
115(1)
Changing Data Orientation
116(3)
Indenting Data
119(1)
Wrapping Text
119(1)
Adding a Title with Merge and Center
120(1)
Inserting, Deleting, and Hiding Columns and Rows
121(8)
Inserting a Column or Row
122(1)
Inserting Multiple Columns or Rows
123(1)
What Inserting Does to Formulas
124(1)
Deleting Columns and Rows
124(1)
Hiding Rows and Columns
125(2)
Unhiding Columns and Rows
127(1)
Inserting and Deleting Cells
128(1)
Formatting Values: Making the Numbers Look Good
129(8)
Turning Values into Currency
129(3)
Working with Percentages
132(1)
Punctuating Values
132(1)
Formatting Decimal Points
133(1)
Working with Dates: Dates Are Numbers Too
134(3)
Customizing Number Formats
137(3)
The Special Formats Option
337
The Custom Option
138(2)
Copying Formats (Not Data) with the Format Painter
140(1)
Applying Ready-Made Formats with Styles
141(3)
Customizing Your Own Style
142(2)
Applying Styles Quickly: Another Way to Access Formatting Options
144(1)
Conditional Formatting
145(8)
Looking for Scores Equal to or Greater Than 90
149(1)
An Alternative Approach to the Same Result
149(1)
Some Additional Conditional Formatting Options
150(2)
Turning Off Conditional Formatting
152(1)
Using Data Bars: A Different Kind of Conditional Format
152(1)
Summary
153(2)
Chapter 6 Charting Your Data
155(40)
Defining Chart Elements
156(1)
Choosing a Chart Type
157(2)
Creating a Column Chart
159(1)
Creating a Chart in 2 Seconds
160(1)
Changing a Chart
160(8)
Moving and Resizing the Chart
160(2)
Changing the Chart by Changing Its Data
162(1)
Changing the Chart Type
163(4)
Where's the Pie Chart?
167(1)
Changing the Default Chart
167(1)
Switching Rows with Columns: A Different Kind of Change
168(1)
Formatting Charts
169(20)
Formatting with the Mini-Toolbar
170(1)
Formatting with the Context Menu
171(1)
Formatting with the Current Selection Button Group
171(1)
Exploring the Format Dialog Box
172(3)
Reformatting the Vertical Axis
175(2)
Color-Coordinating Your Data Using Chart Styles
177(1)
Formatting a Chart Object Using Shape Styles
178(1)
Formatting Text Elements with WordArt
179(1)
Adding Extra Chart Elements with Chart Layouts
180(1)
Adding Extra Chart Elements with the Layout Tab
181(8)
Introducing Sparklines: Mini-Charts Placed in Cells
189(4)
Modifying Sparklines
191(1)
Representing Binary Values with Sparklines
192(1)
Summary
193(2)
Chapter 7 Sorting and Filtering Your Data: Excel's Database Features
195(24)
Sorting Data: Instilling Order in Your Data
196(6)
Sorting by Two Fields: The Hows and Whys
199(2)
Sorting by Cell Format
201(1)
Finding What You Want with Filters
202(7)
Clearing a Filter
205(1)
Text and Number Filters: Filters Within the Filter
205(3)
Filtering Multiple Fields
208(1)
Tables: Adding User-Friendliness to Your Database
209(9)
Finding Duplicate Records in the Table (and Removing Them)
216(1)
Converting a Table to a Range
217(1)
Summary
218(1)
Chapter 8 PivotTables: Data Aggregation Without the Aggravation
219(42)
Looking at Some PivotTables
219(5)
Creating a PivotTable
224(10)
Choosing Which Data to Work On
227(1)
Getting the Fields Where You Want Them
228(1)
Pivoting the Data Sideways Using the Column Labels Area
229(1)
Filtering Items Using the Report Filter Area
229(2)
Creating a Report Worksheet for Each Item in a Filter
231(1)
Counting Records: A Way to Break Out Text Data
232(2)
Grouping Related Items Using Two Fields
234(8)
Using the Row and Column Value Areas to Group Items
237(1)
Changing the Calculation
237(2)
Grouping PivotTable Data: Organizing Your Time(s)
239(1)
Refreshing the PivotTable: Changing the Data
240(1)
Adding New Records to a PivotTable
241(1)
Viewing Which Records Are Filtered: Using the Slicer
242(5)
How the Slicer Works
243(3)
Restyling the Slicer
246(1)
Formatting the PivotTable
247(2)
Styling Your Report
249(4)
Changing PivotTable Headers
250(1)
Layout Options
251(2)
Creating Charts from PivotTables Using PivotCharts
253(6)
Filtering Data in the Chart with Field Buttons
256(2)
Creating a PivotTable and PivotChart Together
258(1)
Summary
259(2)
Chapter 9 Managing Your Workbook
261(28)
Adding Worksheets to Your Workbook
261(7)
Clicking Through the Worksheets
262(1)
Adding and Moving New Worksheets
263(2)
Deleting Sheets
265(1)
Copying a Sheet
266(1)
Renaming and Recoloring the Worksheet Tabs
266(1)
Hiding Sheets
267(1)
Grouping Sheets: Changing Multiple Sheets at the Same Time
268(5)
How to Group Sheets
269(1)
Ungrouping the Sheets
269(1)
Referring to Cells in Other Worksheets: Using Them in Formulas
270(1)
Using Ranges on Other Sheets in Formulas
271(2)
Using the View Context Tab to Show and Hide Basic Screen Elements
273(6)
Showing Formulas in Cells
274(1)
Hiding the Ribbon
275(1)
Keeping Important Data in View with the Freeze Panes Option
276(2)
Freezing Rows and Columns at the Same Time
278(1)
Protecting the Worksheet and the Workbook
279(9)
Protecting a Worksheet
280(1)
Using a Password: Some Extra Protection
281(1)
Unprotecting a Worksheet
282(1)
Protecting Some, but Not All, of a Worksheet
282(2)
Hiding Formulas
284(2)
Protecting a Workbook
286(2)
Unprotecting a Workbook
288(1)
Summary
288(1)
Chapter 10 Printing Your Worksheets: Hard Copies Made Easy
289(34)
Deciding What You Want to Print
289(5)
Printing the Entire Worksheet
289(1)
Printing a Selection
290(4)
Surveying Printing Options: The Print Backstage
294(6)
Setting the Print Area
300(2)
Customizing Your Printing
302(10)
Working with Page Breaks
302(3)
Previewing the Page Break: Getting a Bird's-Eye View of the Printout
305(3)
Printing Titles
308(4)
Adding Headers and Footers
312(7)
Adding Headers and Footers in the Page Layout View
312(2)
Adding Headers and Footers Using the Page Setup Dialog Box
314(2)
Adding Custom Headers and Footers
316(3)
Printing the Gridlines and Headings
319(2)
Summary
321(2)
Chapter 11 Automating Your Work with Macros
323(16)
The Two Kinds of Macros
323(1)
Composing a Macro
324(2)
About Saving a Workbook with a Macro
326(4)
Playing Back the Macro
327(1)
What We've Done
328(1)
Relative References in a Macro
328(2)
Saving a Macro to the Personal Macro Workbook
330(2)
Deleting a Macro
332(1)
Editing a Macro by Tweaking It in VBA
332(3)
VBA: Written Behind the Scenes
333(1)
Exposing the VBA Worksheet
333(2)
Activating a Macro with a Keyboard Shortcut
335(2)
A Note on Macro Security
337(1)
Summary
338(1)
Index 339
Abbott Katz, author of Beginning Microsoft Excel 2010, brings extensive Microsoft Office instructional experience to the task, having trained users of the suite s components in varied academic and corporate settings. He has a doctorate in sociology and wide-ranging writing experience as well. Abbott has composed, and continue to compose, numerous complex spreadsheets, twinning technical fluency with the imagination to realize Excel s potential in a diverse array of settings.
Biežāk uzdotie jautājumi par e-grāmatām Biežāk uzdotie jautājumi par e-grāmatām
Permanent link: https://www.kriso.lv/db/97814302354602e.html
Keywords: