or
Book: Special Edition - Using Microsoft Office Excel 2007
Jelen, B. (2007). "Special Edition - Using Microsoft Office Excel 2007". Indianapolis: Que Publishing
ISBN 078973611X 9780789736116
Review
Mum (Val) loved statistics... I think that gene (you know, the "I love stats" gene) skipped a generation in my case... I have used Excel up to around MS Office 2000 for small business and project budgeting; and for a digital photograph repository for using mail-merge to create catalogues (that was using Excel v4; then I swapped to tables in MS Word 2000 from memory). I did use the spreadsheet function in MS Works for Windows 3.1 (remember MS Works?) but it was fairly limited.
Then came Excel 2007, and it was a game-changer. There were a huge amount of features added as PC memory sizes grew exponentially and cpus could handle multiple tasks. I got this copy (cheaply!) mainly to study up on the statistics chapter; it has taken over ten years for me to finally pick up the book and read it cover to cover. I can understand why it took so long. It is an excellent reference, except... there are a lot of flaws in the editing of the examples. Simple things like changing a "$" sign to an "E" (p.801) could really mess with a reference. You have been warned. Use at your discretion.
.
Other reading of related texts
Coffin, C., & Wadman, T. (1985). The HP-12C Pocket Guide: Just In Case. Portland, Ore: Grapevine Publications.
A long time ago, around the time I was reading Byte Magazine, I saw a couple of copies of The HP-12C Pocket Guide: Just In Case. It had been recommended in Byte as in the mid-1980s Personal Computers were still running with less than 1Meg of RAM and spreadsheets were still a novelty. I was earning a meagre wage as a radio producer and I wanted to learn how to manage my income better, and using PCs and calculators seemed the way of the future.
In the days before the internet and access to online tutorials, little pocket books like this were very handy: even if you didn't own the hardware it related to. It was a pared-down version of a larger tutorial book: An easy course in using the HP-12C and other HP financial calculators.
Considering this little book was held in such high esteem by its reviewer, it seems strange that Worldcat doesn't seem to identify its ISBN or any copies in any library. I was able to trace the authors and the larger book through Worldcat. I have included the ISBN off the back of the smaller book; and some others attributed to it but still not functional.
ISBN 0-931011-12-4 [9780931011122, 0931011051, 9780931011054]
On Worldcat I did find the lager book:
Coffin, C., & Wadman, T. (1984). An easy course in using the HP-12C and other HP financial calculators. Portland, Ore: Grapevine Publications.
Reference List / In-Text Citation Styles in APA 6th
Please Note: I do not strictly follow APA style in these citations as I would like various technology and media to be able to access these pages.
Jelen, B. (2007). "Special Edition - Using Microsoft Office Excel 2007". Indianapolis: Que Publishing.
or
Jelen, B. (2007). "Special Edition - Using Microsoft Office Excel 2007". Indianapolis: Que Publishing.
20220129
www.worldcat.org
Unless otherwise noted all books listed were in my personal library at the time of the first blog posting about the book.
Some titles were borrowed or referenced from RMIT University libraries (City, Carlton, Brunswick Campuses) during the period 2006-2016; or from Hobsons Bay City Council library. or Bayside (Brighton) Council library, or Prahran Mechanics Institute (& ARHS) library.
About this website and privacy
European Union (EU) laws require me, as author of this blog, to give EU visitors information about cookies used on this blog. In many cases, these laws may also require me, as author, or Google, as blog host, to obtain consent.
As a courtesy, I note that Google have added the following notice on this blog to help meet these regulations:
"This site uses cookies from Google to deliver its services and analyze traffic. Your IP address and user-agent are shared with Google along with performance and security metrics to ensure quality of service, generate usage statistics, and to detect and address abuse."
My LinkedIn and
Fender PR244 93 Super Amp websites.
202101
.
Ampersand Code: & website.
202112
https://m0414533224.blogspot.com/2020/12/book-blues-harp-marine-band-schackner.html
https://www.html.am/html-codes/links/ ...
Jump down to My Named Anchor
..........
..........
..........
PR244
My Named Anchor
See my webpage devoted to my Fender '93 Super Amp
Fender 93 Super Amp PR244 websites.
.
PAGE THEN CHAPTER...
. . .
Introduction
I Mastering the New User Interface
1 Introducing the Ribbon User Interface . . . . . . . . . . . . . . . 21
2 The Quick Access Toolbar . . . . . . . . . . . . . . . . . . . . . 41
3 The Mini Toolbar and Other U.I. Improvements . . . . . . . . . . . 53
4 Keyboard Shortcuts . . . . . . . . . . . . . . . . . . . . . . . . 65
5 Galleries, Live Preview, and Themes . . . . . . . . . . . . . . . . 87
6 The Excel Options Dialog . . . . . . . . . . . . . . . . . . . . . . 103
II A Tour of What's New
7 The Big Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121
8 Fabulous Table Intelligence . . . . . . . . . . . . . . . . . . . . 131
9 Visualizing Data in Excel . . . . . . . . . . . . . . . . . . . . . 153
10 Using Pivot Tables to Analyze Data . . . . . . . . . . . . . . . . 191
11 Formatting Pivot Tables . . . . . . . . . . . . . . . . . . . . . . 215
12 Pivot Table Data Crunching for Excel 2007 . . . . . . . . . . . . . 237
13 Removing Duplicates and Filtering . . . . . . . . . . . . . . . . . 271
14 Sorting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 287
15 Using Excel Charts . . . . . . . . . . . .. . . . . . . . . . . . . 299
16 Using SmartArt, Shapes, WordArt, and Text Boxes . . . . . . . . . . 327
17 Using Pictures and Clip Art . . . . . . . . . . . . . . . . . . . . 351
III Working in a Legacy Environment
18 File Format Differences . . . . . . . . . . . . . . . . . . . . . . 365
19 Working with Prior Versions of Excel . . . . . . . . . . . . . . . 371
IV Calculating with Excel
20 Understanding Formulas . . . . . . . . . . . . . . . . . . . . . . 385
21 Controlling Formulas . . . . . . . . . . . . . . . . . . . . . . . 409
22 Understanding Functions . . . . . . . . . . . . . . . . . . . . . . 431
23 Using Everyday Functions: Math, Date and Time,and Text Functions . 451
24 Using Powerful Functions: Logical, Lookup, andDatabase Functions . 525
25 Using Financial Functions . . . . . . . . . . . . . . . . . . . . . 587
26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . 631
27 Using Trig, Matrix, and Engineering Functions . . . . . . . . . . . 735
28 Connecting Worksheets, Workbooks, and External Data . . . . . . . . 797
29 Using Super Formulas in Excel . . . . . . . . . . . . . . . . . . . 823
30 Using Names in Excel . . . . . . . . . . . . . . . . . . . . . . . 841
31 Using What If, Scenario Manager, Goal Seek,and Solver . . . . . . . 863
V Formatting and Sharing Information
32 Formatting Worksheets . . . . . . . . . . . . . . . . . . . . . . 891
33 Printing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 925
34 Sharing Workbooks with Others . . . . . . . . . . . . . . . . . . . 941
35 More Tips and Tricks for Excel 2007 . . . . . . . . . . . . . . . . 949
VI More Power
36 Automating Repetitive Functions Using VBA Macros . . . . . . . . . 969
37 Interacting with Other Office Applications . . . . . . . . . . . . 1005
38 A Tour of the Best Add-Ins for Excel . . . . . . . . . . . . . . . 1019
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1025
..
..
26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . 631
: DESCRIPTIVE STATISTICS : Descriptive statistics that describe a dataset -- these include measures of central tendency and dispersion
: REGRESSION AND FORECASTING : Regression tools -- These allow you to predict future value based on past values.
: INFERENTIAL STATISTICS : Inferential statistics -- This type of statistic allows you to predict the likelihood of an event happening, based on a sample of a population. [Jelen, p.632]
pp.632-642 ALPHABETICAL LIST OF STATISTICAL FUNCTIONS
AVEDEV
AVERAGE
AVERAGEA
BETADIST
BETAINV
BINOMDIST
CHIDIST
CHIINV
CHITEST
CONFIDENCE
CORREL
COVAR
CRITBINOM
DEVSQ
EXPODIST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FREQUENCY
FTEST
GAMMADIST
GAMMAINV
GAMMALN
GEOMEAN
GROWTH
HARMEAN
HIPGEOMDIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGINV
LOGNORMDIST
MAX
MAXA
MEDIAN
MIN
MINA
MODE
NEGBINOMDIST
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
POISSON
PROB
QUARTILE
RANK
RSQ
SKEW
SLOPE
SMALL
STANDARDIZE
STDEV
STDEVA
STDEVP
STDEVPA
STEYX
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TDIST
TINV
TREND
TRIMMEAN
TTEST
VAR
VARA
VARP
VARPA
WEIBULL
ZTEST
..
..
EXAMPLES OF FUNCTIONS FOR DESCRIPTIVE STATISTICS. . . . . . . . . . . . . 642
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
EXAMPLES OF FUNCTIONS FOR REGRESSION AND FORECASTING . . . . . . . . . . 658
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
EXAMPLES OF FUNCTIONS FOR INFERENTIAL STATISTICS. . . . . . . . . . . . . 682
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
USING THE ANALYSIS TOOLPACK TO PERFORM STATISTICAL ANALYSIS . . . . . 711
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
. . . . . . . . . . . . .
26 Using Statistical Functions . . . . . . . . . . . . . . . . . . . . 631
. . . . . . . . . . . . .
Other Titles: Using Microsoft Office Excel 2007
Microsoft Office Excel 2007
