Microsoft Excel 2010 Plain & Simple

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

It is probably safe to assume that if you are looking at this book it is because you plan on using Excel for some projects, or are using it, but would like to become more of a power user; perhaps you have used Excel 2003 or 2007, or a Mac version, and would like to prepare for using 2010. It does not matter if you are new to Excel or reviewing, this book will likely not fail you. One thing that makes this book stand out is it's easy to follow instructions, it's ability to communicate with lots of full color pictures, and how it "tells the story" (for lack of better words) in both, words and pictures. What you must keep in mind is that this book is meant for those trying to master Excel, and perhaps how it can communicate with other parts of the Office Suite, but by no means is this book meant for developers (book is code free, yay!!) or those in a SharePoint environment (although understanding Excel as a stand alone tool will help in one adapting to Excel Services and other SharePoint related services). A final thing to keep in mind is that this is a book by Microsoft; which means that the end goal of the book is for the user to understand the tool, Excel, and unlike other books (such as those by Apress), will not show you tricks or provide you with ideas that non-Microsoft evangelists or developers have come across. In Excel 2010, one of the major changes you will notice are modifications to the Microsoft Fluent Interface (or Ribbon Interface), which was introduced in Office 2007, and has now been "improved". Microsoft has also listened to users and has improved on format, functions, and how data is presented. Excel is one of those products that Microsoft will more than likely never completely redesign, but will rather continue to build on; therefore, whatever you learn with this book, will help you in the long run. I'm not new to Excel, but purchased this book to prepare for a class I have participated to teach, and not only have I learned how to effectively teach Excel to beginners, but have also managed to learn a few tricks myself. Excel is one of the best products developed by Microsoft, and used across all industries, so regardless or previous knowledge, as long as you know how to use a mouse, keyboard and own a version of Office 2010, this book will greatly help.

Author(s): Curtis Frye D.
Edition: 1
Publisher: Microsoft Press
Year: 2010

Language: English
Commentary: +OCR
Pages: 76

Microsoft Excel 2010: An Overview......Page 4
Analyze your data quickly and effectively.......Page 5
Save time and simplify your work.......Page 6
Collaborate on workbooks in new ways.......Page 7
Access your workbooks virtually anytime, anywhere.......Page 8
Ribbon Improved!......Page 9
Microsoft Office Backstage View New!......Page 10
Sparklines New!......Page 12
PivotChart Interactivity Improved!......Page 13
Slicer New!......Page 14
Conditional Formatting Improved!......Page 15
PowerPivot for Excel 2010 New!......Page 16
Function Accuracy Improved!......Page 18
Filter Capabilities Improved!......Page 19
Solver Add-in Improved!......Page 20
64-bit Version New!......Page 21
Recover Unsaved Versions New!......Page 22
Equations New!......Page 23
Office Themes Improved!......Page 24
Paste with Live Preview New!......Page 25
Picture Editing Tools Improved!......Page 26
Protected View New!......Page 28
Trusted Documents New!......Page 29
Accessibility Checker New!......Page 30
Streamlined Communications New!......Page 31
Language Tools Improved!......Page 33
Microsoft Excel Web App New!......Page 35
Microsoft Excel Mobile 2010 Improved!......Page 38
Accessing Show Value As calculations......Page 40
% of Parent Row Total / % of Parent Column Total......Page 41
% Running Total In......Page 42
Rank Smallest to Largest / Rank Largest to Smallest......Page 43
Explore Recover Unsaved Workbooks and Autosave Versions......Page 44
Customize the Ribbon......Page 45
Customize workbooks and save time using Office Open XML......Page 47
Conclusion......Page 49
Bring Your Ideas to Life......Page 50
Work Together More Efficiently......Page 54
Anywhere Access to Your Work......Page 56
Analyze your data quickly and effectively.......Page 57
Obtain powerful analysis from your desktop.......Page 59
Save time and simplify your work.......Page 60
Collaborate on workbooks in new ways.......Page 61
Access your workbooks virtually anytime, anywhere.......Page 64
About Microsoft Excel 2010......Page 66
Excel 2010 System Requirements & Compatibility......Page 68
Using Excel 2010......Page 70
Buying Excel 2010......Page 72
Excel 2010 Feature-Specific Questions......Page 73
Links provided in this product guide......Page 75