Master the leading spreadsheet and data analysis tool with this book-and-CD package! Excel is essential to business today, and it can be complex. This multimedia kit tackles Excel 2010 with both a book and a CD so you can learn by your preferred method — even if you prefer both! Learn step by step to create worksheets, work with formulas and functions, format data, use financial functions, create charts and PivotTables, and more.
-
Work with worksheets — set one up, understand how cells work, and insert or delete rows and columns
-
The function of formulas — write formulas that calculate, learn to use basic functions, and use named ranges
-
All about formatting — format cells and numbers, cell content, and entire worksheets
-
Master the math — work with math, statistical, and text functions including SQRT, AVG, and UPPER
-
Validate and share — find and fix errors, use data validation, enable sharing, and secure workbooks
Open and find:
-
A tour of the Excel interface
-
Tips on using AutoFill
-
How to set up and print a worksheet
-
Advice on merging and splitting data
-
What the PMT, NPER, and PV functions are for
-
All about scenarios and how to use them
-
How to add a legend and data table to a chart
-
Directions for formatting PivotTables
Includes CD-ROM and Online Course
See inside for details
Includes
-
Book, CD, or both — pick the way you learn best
-
Four hours of Excel 2010 instruction
-
Easy-to-follow format that lets you learn at your own pace
The For Dummies eLearning Kit lets you choose your ideal way to learn—from the book, the CD, or both!
A full-color, richly illustrated book teaches you Excel 2010
If you prefer to learn from a book, this one is perfect. Full of colorful illustrations and screen shots, hands-on tutorials, summaries, definitions, and progress assessments, this book makes learning Excel 2010 easy.
The book includes:
-
Eleven lessons covering the essentials of Excel 2010
-
Step-by-step instructions illustrated in full color
-
Chapter summaries, concept descriptions, and practice exercises
Learn interactively and see how it's done with the CD-ROM
If you like to see and hear instructions, the CD offers narrated screencasts, illustrations, animations, exercises, resources, and more. Learn Excel 2010 from interactive lessons and plenty of practice questions.
The CD-ROM includes:
-
Four hours of interactive training to teach you all the basics of Excel 2010
-
Integrated audio and video instruction
-
Easy navigation controls and progress-tracking features
