SINGAPORE
Law
Welcome Guest | Login
SEARCH
Advanced
Excel 2010 Bible (PAP/CDR): Walkenbach, John: BOOKS KINOKUNIYA
Book Details
Excel 2010 Bible (PAP/CDR)
Excel 2010 Bible (PAP/CDR)
Publisher : John Wiley & Sons Inc
Published Date : 2010/05
Binding : Paperback
ISBN : 9780470474877

BookWeb Price : S$ 62.01
Kinokuniya Privilege Card member price : S$ 55.81

Availability Status : In stock at the Fulfillment Centre.
Usually dispatches within 5 working days.
Language : English
Stock Information
Store Shelf Location Click here Stock
Singapore Main Store G15-06, H02-06, H09-01 Map
Liang Court Store -
Bugis Junction Store C01-01 -
Important
  • While every attempt has been made to ensure stock availability, occasionally we do run out of stock at our stores.
  • Retail store and online prices may vary.
  • To confirm availability and pricing, please call the store directly.
Retail Store Contact Details and Operating Hours

Book Description
Source: ENG
Academic Descriptors: A93905800 A48401631
Place of Publication: United States
Continuations: Monograph Series,any number
Textual Format: Computer Applications
Academic Level: Extracurricular
Review:
Baker & Taylor Newly Released Computer Titles - January 2002 - Ongoing
Baker & Taylor Best-seller And Forthcoming Computer Titles - January 2000 - Ongoing

A comprehensive reference to the newest version of the world's most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010. An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else. Excel guru and bestselling author John Walkenbach ("Mr.Spreadsheet") guides you through every aspect of Excel Delivers essential coverage of all the newest features of Excel 2010 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak Excel 2010 Bible serves as an excellent resource on all things Excel! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Contents
Acknowledgments xxxvii Introduction xxxviii Part IStarted with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data29 Chapter 3: Essential Worksheet Operations 49 Chapter 4: Working with Cells and Ranges 69 Chapter 5: Introducing Tables 99 Chapter 6: Worksheet Formatting 115 Chapter 7: Understanding Excel Files 141 Chapter 8: Using and Creating Templates 161 Chapter 9: Printing Your Work 171 Part II: Working with Formulas and Functions 193 Chapter 10: Introducing Formulas and Functions 195 Chapter 11: Creating Formulas That Manipulate Text 229 Chapter 12: Working with Dates and Times 249 Chapter 13: Creating Formulas That Count and Sum 281 Chapter 14: Creating Formulas That Look Up Values 309 Chapter 15: Creating Formulas for Financial Applications 329 Chapter 16: Introducing Array Formulas 355 Chapter 17: Performing Magic with Array Formulas 379 Part III: Creating Charts and Graphics 401 Chapter 18: Getting Started Making Charts 403 Chapter 19: Learning Advanced Charting 437 Chapter 20: Visualizing Data Using Conditional Formatting 481 Chapter 21: Creating Sparkline Graphics 503 Chapter 22: Enhancing Your Work with Pictures and Drawings 517 Part IV: Using Advanced Excel Features 539 Chapter 23: Customizing the Excel User Interface 541 Chapter 24: Using Custom Number Formats 551 Chapter 25: Using Data Validation 569 Chapter 26: Creating and Using Worksheet Outlines 581 Chapter 27: Linking and Consolidating Worksheets 589 Chapter 28: Excel and the Internet 605 Chapter 29: Sharing Data with Other Office Applications 615 Chapter 30: Using Excel in a Workgroup 627 Chapter 31: Protecting Your Work 637 Chapter 32: Making Your Worksheets Error-Free 649 Part V: Analyzing Data with Excel 675 Chapter Chapter 34: Introducing Pivot Tables 695 Chapter 33: Getting Data from External Database Files 677 Chapter 35: Analyzing Data with Pivot Tables 715 Chapter 36: Performing Spreadsheet What-If Analysis 745 Chapter 37: Analyzing Data Using Goal Seeking and Solver 761 Chapter 38: Analyzing Data with the Analysis ToolPak 781 Part VI: Programming Excel with VBA 793 Chapter 39: Introducing Visual Basic for Applications 795 Chapter 40: Creating Custom Worksheet Functions 823 Chapter 41: Creating UserForms 837 Chapter 42: Using UserForm Controls in a Worksheet 859 Chapter 43: Working with Excel Events 873 Chapter 44: VBA Examples 887 Chapter 45: Creating Custom Excel Add-Ins 903 Part VII: Appendixes 915 Appendix A: Worksheet Function Reference 917 Appendix B: What's on the CD-ROM 933INTRODUCTION TO THE GLOBE: Objectives; Science Table; To Get Ready-Exploring Corn; Tell the Story of People and Corn; Touch Corn Seeds; Plant Corn Seeds; Many Varieties of Corn; The Story's Ending; A Photograph of the Earth; Hold a Model of Our Earth, a Globe; Corn Tastes Good; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Corn and an Introduction to the Globe; WINTER BIRDS: Objectives; Science Table; To Get Ready-Exploring Winter Birds; Bird Food; Bird Shapes and Colours; Bird Shape Rubbings; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Winter Birds; PLANTING PEAS: Objectives; Science Table; To Get Ready-Exploring Planting; Preparing the Peas for Planting; Planting Inside; Measure the Growth; Planting Outside; Fair Test Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Planting Peas; A TREE IS NICE: Objective; Science Table; To Get Ready-Exploring Trees; Where Do Trees Come From?; Hold a Baby Tree; How Big?; Make a Leaf Rubbing; A Tree Poem; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home To Families About Trees; BUTTERLIES CHANGE AS THEY GROW: Objectives; Science Table; To Get Ready-Exploring Butterflies; Look at Butterflies and Caterpillars While Using Identification Books; Pretend Butterfly Tongues; Ongoing Observation of the Butterflies; Checking the Butterfly Habitat for Eggs; Have the Caterpillars Hatched?; Chart the Growth and Change of the Caterpillars; Caterpillars Changing into Pupas; Emerging Butterflies; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About the Life Cycle of Butterflies; PLANTING A BUTTERFLY GARDEN: Objectives; Science Table; To Get Ready-Exploring a Butterfly Garden; What Do Butterflies Eat?; Plants for Butterflies; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Planting a Butterfly Garden; WHAT IS IT?: Objective; Science Table; To Get Ready-Exploring the Unknown; Seeing and Touching the Choices; Science Investigation; Telling What You Guess; Repeat the Experience; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About What Is It?A"; EATING SUNLIGHT: Objective; Science Table; To Get Ready-Exploring Sunlight; Make a Sun Print Indoors; Explore Sunlight; Make a Sun Print Outdoors; Talk About the Grass Again; Churn Butter; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Eating Sunlight; OUR SENSE OF TOUCH: Objective; Science Table; To Get Ready-Exploring Our Sense of Touch With a Feely BoxA"; Feeling Sensations; A Sensitive Game; Sensitive Plants Feel Our Touch; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Our Sense of Touch; OUR SENSE OF SMELL: Objective; Science Table; To Get Ready-Exploring Our Sense of Smell; Practise Sniffing; Animal Noses; Smell Guessing Games; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Using Our Sense of Smell; MAKING SOLUTIONS: Objective; Science Table; To Get Ready-Exploring Solutions; Identifying Plain Water; Identify the Solids; Mix the Liquid and the Solids; Comparing the Results; Taste the Water to Find the Sugar; Science Investigation; Follow-up Activities; Bringing Science Home! A Note Home to Families About Making Solutions; MEASURING HANDS: Objective; Science Table; To Get Ready-Exploring Measuring; Make a Set of Measuring Hand; Measure With a Hand; Measure With Many Hands; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Measuring Hands; MAGNETS AND TESTING HYPOTHESES: Objectives; Science Table; To Get Ready-Introducing Magnet Play; Feeling Magnetic Force; Magnets Attract Some Objects; Testing Objects and Making a Hypothesis; More Hypothesizing; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Magnets and Making Predictions; WHAT IS MELTING?: Objective; Science Table; To Get Ready-Exploring Melting; Use Body Heat to Melt Chocolate; Ice Melts; Melt Wax; Melted Rock; Melt Chocolate Again!; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Melting; SOIL, WHAT IS IT?: Objectives; Science Table; To Get Ready-Exploring Soil; Use the Senses to Learn about Soil; Separate Soil Into Its Parts, Add Water -; - And Shake; Try to Make Soil; Is it Soil Yet?; Check the Separated Soil Sample for Settling; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home To Families About Soil-What Is It?; ROCKS MADE OF TINY PIECES (SEDIMENTARY ROCKS): Objective; Science Table; To Get Ready-Exploring Sedimentary Rocks; Comparing Rocks; Feel the Ingredients of Rocks; Feel the Difference Between Two Kinds of Rocks; Mixing Up a Pretend Rock; Mixing Plaster of Paris; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Rocks Made of Tiny Pieces (Sedimentary Rocks); ROCKS THAT WERE MELTED (IGNEOUS ROCKS) AND VOLCANOES: Objectives; Science Table; To Get Ready-Exploring Igneous Rocks; Touch Volcanic Rocks; Experiencing Baking Soda and Vinegar Separately; Going to the Pretend Volcano; Erupting the Volcano; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Rocks That Were Melted (Igneous Rocks) and Volcanoes; FOSSIL DISCOVERY: Objectives; Science Table; To Get Ready-Exploring Fossils; Matching Objects to Their Imprints in Playdough; Playdough Recipe; Plaster Casts of Footprints; Make Imprints in Playdough; Preserving the Imprints With Plaster; Handling Real Fossils; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Fossil Discovery; TAKING NOTE OF VOLUME: Objectives; Science Table; To Get Ready-Exploring Volume; Seeing Air as Bubbles; Air Fills the Container and Keeps the Water Out; Shape and Volume; Measuring and Comparing the Volumes; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home To Families About Taking Note of Volume; EVAPORATION AND CONDENSATION: Objective; Science Table; To Get Ready-Exploring Evaporation and Condensation; What Happens to Spilled Water?; Water on a Blackboard; Meanwhile, Look at Condensation; Condensing Water; Feel Water Evaporating from Our Skin; Condensing the Water in Our Breath; Sing About Condensation; Book to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Evaporation and Condensation; MAKING A CHEMICAL REACTION TO CREATE SLIME: Objectives; Science Table; To Get Ready-Exploring Mixtures Independently; Examining the Ingredients-Are They Liquids or Solids?; Measuring to Make a Solution; Mixing the Two Liquid Ingredients; Adding the Solution; Feeling the Slime; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Making a Chemical Reaction to Create Slime; BUBBLES: Objective; Science Table; To Get Ready-Exploring Bubbles; Feel Air; Blow Air Into Water to Make Bubbles; What Is the Shape of a Bubble?; Can You Make a Square Bubble?; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Bubbles; RECYCLING PAPER TO USE AGAIN: Objective; Science Table; To Get Ready; Feel Many Kinds of Paper; What Does It Mean to Re-use Something?; What Does It Mean to Recycle Something?; Prepare for Recycling Paper; Recycled Paper, Step 1; Recycled Paper, Step 2; Making Papier-Mache From Newspapers; Make Papier-Mache Worlds; The Resources of the Earth Are Precious; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Recycling Paper; ROCKET SHIPS BLASTING OFF: Objective; Science Table; To Get Ready-Exploring Rocket Ships; How Do Rockets Work?; The Power of Gas; Fuel for the Pretend Rocket; Blast Off!; Science Investigation; Books to Read; Website to Visit; Follow-up Activities; Bringing Science Home! A Note Home to Families About Rocket Ships Blasting Off; SOUND IS VIBRATION: Objective; Science Table; To Get Ready-Exploring Sound; Feel Your Throat Vibrating; Feel a Triangle Vibrate; See and Feel a String Vibrate; Make Music With Vibration; Make a Musical Instrument to Take Home; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Sound Is Vibration; MIRRORS REFLECT: Objectives; Science Table; To Get Ready-Exploring Mirrors; What Do We See in a Mirror?; Predicting Where Light Will Travel; Torches Use Electricity; Exploring How a Mirror Affects the Direction of Light; Where Does the Light Go?; Light Reflects Off Surfaces and on to Others; Use a Mirror to See Around Corners; Use a Periscope; Make a Periscope; Use a Flexible Mirror; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Mirrors; WORKING WITH PUMPS, SIPHONS AND CAPILLARY ACTION: Objectives; Science Table; To Get Ready-Exploring Pumps, Siphons, and Capillary Action; Move the Water; How Do Pumps Work?; Siphons Work With Suction and Gravity; Capillary Action in Paper; Capillary Action in Plants; Science Investigation; Follow-up Activity; Bringing Science Home! A Note Home to Families About Working With Pumps, Siphons and Capillary Action; WHAT CAN THE WIND DO?: Objectives; Science Table; To Get Ready-Exploring What the Wind Can Do; Blow It; Pretend to Be the Wind; Move Like a Wind-blown Object; Wind Socks; Wind Ribbons; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About What Wind Can Do; OBJECTS IN MOTION: Objectives; Science Table; To Get Ready-Exploring Objects in Motion; Tell a Ball to Move; Move the Ball; Put the Attention on Gravity; Relate Gravity to Car Seat Safety; Put on a Seat Belt; Make a Newton's Cradle; Test the Hypothesis; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Objects in Motion; MIXING AND SEPARATING COLOURS: Objectives; Science Table; To Get Ready-Exploring Mixing and Separating Colours; Mix Colours Using Plastic Squares; Spin a Top to Mix Colours; The Colour Black Can Be Separated; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Mixing and Separating Colours; WHEELS ARE TOOLS: Objective; Science Table; To Get Ready-Exploring Wheels; Moving a Variety of Shapes; Rollers and Sliders; Prints of a Roller and a Slider; Move a Heavy Load; What Other Way Can We Move It?; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Wheels Are Tools; INTRODUCING ELECTRICITY: Objectives; Science Table; To Get Ready-Using Electricity; Exploring Torches; Making a Simple Circuit; Using the Components; Switching It On and Off; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Electricity; Writing Additional Lessons; Complete Book List; Index.