Skip to Main Content
Microsoft Excel Functions & Formulas
book

Microsoft Excel Functions & Formulas

by Bernd Held
September 2006
Beginner to intermediate content levelBeginner to intermediate
397 pages
13h 15m
English
Jones & Bartlett Learning
Content preview from Microsoft Excel Functions & Formulas
Index
& operator,
combining columns, 70
combining text and dates, 15
combining text and numbers, 14
combining text and time, 16
100-minute hours, calculating with, 121
360-day year, calculating with, 108-109
A
ADDRESS function, 212-213
determining last used cell, 276-277
finding cell reference for largest
number, 212-213
finding cell reference for smallest
number, 214
summing sales to today’s date, 215
addresses, displaying in and selecting
from drop-down box, 309-310
Advent, calculating weeks of, 118
age,
calculating, 116, 117, 361
calculating in days, 3
determining and shading, 270
determining oldest/youngest, 207
Analysis ToolPak add-in, loading, 107
Analysis T
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Excel - Advanced Formulas And Functions

Microsoft Excel - Advanced Formulas And Functions

Guy Vaccaro

Publisher Resources

ISBN: 9781598220117