Muutke küpsiste eelistusi

E-raamat: Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables 3rd Edition [Wiley Online]

(Professional Programmer)
  • Formaat: 368 pages
  • Sari: Visual Blueprint
  • Ilmumisaeg: 02-Jul-2010
  • Kirjastus: Visual
  • ISBN-10: 1118983939
  • ISBN-13: 9781118983935
Teised raamatud teemal:
  • Wiley Online
  • Hind: 31,71 €*
  • * hind, mis tagab piiramatu üheaegsete kasutajate arvuga ligipääsu piiramatuks ajaks
Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables 3rd EditionSuurem pilt
  • Formaat: 368 pages
  • Sari: Visual Blueprint
  • Ilmumisaeg: 02-Jul-2010
  • Kirjastus: Visual
  • ISBN-10: 1118983939
  • ISBN-13: 9781118983935
Teised raamatud teemal:
Wiley Online e-raamatudRohkem infot Wiley Online kohta
Raamatu kodulehekülg: https://onlinelibrary.wiley.com/doi/book/10.1002/9781118983935
Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.

Advanced techniques for Excel power users

Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.

  • Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
  • Expands your Excel knowledge and helps you use Excel data more efficiently
  • Demonstrates how to retrieve data from databases;; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
  • Explores all features and functions in friendly, two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
  • Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions

Learn Excel at the highest levels with this practical guide.

How to Use This Book v
1 Getting Started
2(14)
Introducing Data Analysis with Excel
2(1)
Tour the Excel Window
3(1)
Explore the Ribbon
4(1)
Using the Mini Toolbar and Context Menu
5(1)
Select Options on the Status Bar
6(1)
Take a Look at Backstage View
7(1)
Upload a File to Excel's Web-based Application
8(2)
Create a File Using Excel's Web-based Application
10(2)
Enter Data
12(2)
Select Cells
14(2)
2 Formatting a Worksheet
16(24)
Using the Ribbon to Format Numbers
16(2)
Using the Format Cells Dialog Box
18(2)
Understanding Dates and Times
20(2)
Format Percentages
22(1)
Format Fractions
23(1)
Format in Scientific Notation
24(1)
Format as Text
25(1)
Add a Border
26(2)
Change the Font or Font Size
28(2)
Add a Background Color
30(1)
Change the Font Color
31(1)
Bold, Underline, or Italicize
32(1)
Align Data
33(1)
Rotate Data
34(1)
Wrap Text
35(1)
Merge and Center
36(1)
Apply a Style
37(1)
Using Format Painter
38(1)
Clear Formats
39(1)
3 Structuring Your Workbook
40(18)
Cut, Copy, and Paste Cells
40(2)
Using Live Preview with Paste
42(2)
Paste from the Office Clipboard
44(2)
Insert or Delete
46(2)
Find and Replace Information
48(2)
Change the Name of a Worksheet
50(1)
Change Column Widths or Row Heights
51(1)
Hide Columns or Rows
52(1)
Hide a Worksheet
53(1)
Move or Copy a Worksheet
54(2)
Freeze Worksheet Titles
56(1)
Hide Gridlines, Headings, or the Formula Bar
57(1)
4 Creating Formulas
58(22)
Understanding Formulas
58(2)
Calculate with an Operator
60(1)
Calculate Using a Function and Cell Addresses
61(1)
Create an Array Formula
62(2)
Using the Sum, Average, Count, Min, and Max Functions
64(1)
Create a Formula that Refers to Another Worksheet
65(1)
Understanding Relative and Absolute Cell Addresses
66(2)
Edit Formulas
68(2)
Name Cells and Ranges
70(2)
Define and Display Constants
72(2)
Create Formulas That Include Names
74(2)
Check Formulas for Errors
76(2)
Trace Precedents and Dependents
78(2)
5 Using Functions
80(16)
Understanding the Function Wizard
80(2)
Round a Number
82(2)
Create a Conditional Formula
84(2)
Calculate a Conditional Sum
86(1)
Calculate a Conditional Count
87(1)
Find the Square Root
88(1)
Retrieve Column or Row Numbers
89(1)
Using VLookup
90(2)
Determine the Location of a Value
92(1)
Using Index
93(1)
Perform Date and Time Calculations
94(2)
6 Using Financial Functions
96(20)
Calculate Future Value
96(2)
Calculate Present Value
98(2)
Calculate Loan Payments
100(2)
Calculate Principal or Interest
102(2)
Calculate the Interest Rate
104(2)
Calculate the Internal Rate of Return
106(2)
Calculate Straight-Line Depreciation
108(2)
Calculate Declining Balance Depreciation
110(2)
Calculate Double-Declining Balance Depreciation
112(2)
Calculate Sum-of-the-Years-Digits Depreciation
114(2)
7 Using Statistical Functions and Tools
116(24)
Calculate an Average
116(1)
Calculate a Conditional Average
117(1)
Calculate the Median or the Mode
118(2)
Calculate Rank
120(2)
Determine the Nth Largest Value
122(2)
Calculate Frequency
124(2)
Calculate Variance and Standard Deviation
126(2)
Find the Correlation
128(2)
Install Excel Add-Ins
130(2)
Calculate a Moving Average
132(2)
Compare Variances
134(2)
Using the Data Analysis Toolpak to Determine Rank and Percentile
136(2)
Calculate Descriptive Statistics
138(2)
8 Organizing Worksheet Data
140(28)
Enter Data with a Form
140(2)
Perform Simple Sorts and Filters
142(2)
Perform Multilevel Sorts
144(2)
Perform a Custom Sort
146(1)
Sort by Cell Color, Font Color, or Cell Icon
147(1)
Perform Complex Filters
148(2)
Enter Criteria to Find Records
150(2)
Using Advanced Filtering Techniques
152(2)
Filter Duplicate Records
154(2)
Count Filtered Records
156(2)
Subtotal Records
158(2)
Using Auto Outline
160(2)
Define Data as a Table
162(2)
Modify a Table Style
164(2)
Using Database Functions with a Table
166(2)
9 Working With Pivottables
168(18)
Create a PivotTable
168(4)
Modify a PivotTable Layout
172(2)
Summarize PivotTable Values
174(2)
Create a PivotTable Calculated Field
176(2)
Group the Rows or Columns in a PivotTable
178(1)
Apply a Style to a PivotTable
179(1)
Filter a PivotTable
180(1)
Sort a PivotTable
181(1)
Retrieve Values from a PivotTable
182(2)
Using Slicer
184(2)
10 Charting Data
186(26)
Create a Chart
186(2)
Add Chart Details
188(4)
Create a Combination Chart
192(2)
Change the Chart Type
194(2)
Add or Remove Chart Data
196(2)
Add Sparklines
198(2)
Create a Trendline
200(2)
Add Error Bars
202(2)
Create a Histogram
204(2)
Chart Filtered Data
206(2)
Create a PivotChart
208(2)
Filter a PivotChart
210(2)
11 Working With External Data
212(18)
Paste Link into Word
212(2)
Embed a Worksheet
214(2)
Hyperlink a Worksheet
216(2)
Query a Web Site
218(2)
Import a Text File
220(4)
Import an Access Database
224(2)
Query an Access Database
226(4)
12 Using Data Analysis Tools And Techniques
230(26)
Perform What-If Analysis
230(2)
Optimize a Result with Goal Seek
232(2)
Using Solver
234(2)
Solve a Formula with a Data Table
236(2)
Extend a Series with Auto Fill
238(2)
Join Text
240(1)
Add a Calculator
241(1)
Consolidate Worksheets
242(2)
Highlight Cells that Meet Your Criteria
244(2)
Find the Highest or Lowest Ranked Values
246(1)
Add Data Bars to Your Worksheet
247(1)
Add Icon Sets to Your Worksheet
248(1)
Remove Conditional Formatting
249(1)
Change Conditional Formatting Rules
250(2)
Paste with Paste Special
252(4)
13 Sharing Your Workbook With Others
256(20)
Validate with a Validation List
256(2)
Validate with Data Entry Rules
258(2)
Add Comments to Your Worksheet
260(2)
Track Changes
262(2)
Protect Your Worksheet
264(2)
Save Your Workbook as a Template
266(2)
Choose a Format When Saving a Workbook
268(2)
Print Your Workbook
270(4)
Print Multiple Areas of Your Worksheet
274(2)
14 Automating With Macros
276(16)
Introducing Macros
276(2)
Set Macro Security
278(1)
Create a Digital Signature
279(1)
Record a Macro
280(2)
Assign a Digital Signature to a Macro
282(2)
Run a Macro
284(2)
Create and Launch a Keyboard Shortcut
286(2)
Assign a Macro to the Quick Access Toolbar
288(2)
Delete a Macro
290(2)
15 Illustrating Your Worksheets
292(16)
Place a Screenshot in Your Worksheet
292(2)
Insert Clip Art into Your Worksheet
294(1)
Crop a Clip Art Illustration or a Photograph
295(1)
Insert a Picture into Your Worksheet
296(1)
Recolor a Picture
297(1)
Adjust the Sharpness, Brightness, and Contrast
298(2)
Compress a Picture
300(2)
Add a Border
302(1)
Add a Picture Effect
303(1)
Apply a Picture Style
304(1)
Add an Artistic Effect
305(1)
Remove a Background
306(2)
16 Illustrating Your Ideas
308(16)
Insert a Text Box
308(1)
Format a Text Box
309(1)
Insert a Shape
310(1)
Add Text to a Shape
311(1)
Change the Size of an Object
312(1)
Rotate an Object
313(1)
Change the Stacking Order
314(1)
Group Objects
315(1)
Align Objects
316(1)
Insert a Symbol
317(1)
Using SmartArt Graphics
318(2)
Modify a SmartArt Graphic
320(2)
Apply a SmartArt Style
322(1)
Apply a SmartArt Layout
323(1)
17 Customizing Excel
324(12)
Add a Form Control to a Worksheet
324(2)
Assign Values to a Form Control
326(2)
Add a Macro to a Form Control
328(2)
Customize the Quick Access Toolbar
330(2)
Customize the Ribbon
332(4)
APPENDIX A USING EXCEL KEYBOARD SHORTCUTS
336(6)
Using Excel Keyboard Shortcuts
336(6)
Index 342
Denise Etheridge (Burlington, NJ) is a certified public accountant as well as the president and founder of BayCon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, teaches college-level computer and accounting courses, and has authored or coauthored two computer related books: Flash ActionScript: Your visual blueprint for creating Flash-enhanced Web sites. In addition, she authored Excel 2007 Visual Quick Tips and Excel 2007 Top 100 Simplified Tips and Tricks. Denise has trained and assisted clients with the implementation of accounting-related software since 1985. Stanford University and the United States House of Representatives are among her former clients. Prior to founding BayCon Group, she spent two years working for Oracle Corporation as an Oracle Financials software consultant.
Püsilink: https://www.kriso.ee/db/9781118983935_pe.html
Märksõnad: