Excel 2010: The Missing Manual Author: Matthew MacDonald | Language: English | ISBN:
B0043EWTY4 | Format: PDF
Excel 2010: The Missing Manual Description
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.
- Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
- Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
- Organize your data. Search, sort, and filter huge amounts of information
- Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
- Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
- File Size: 16629 KB
- Print Length: 898 pages
- Simultaneous Device Usage: Unlimited
- Publisher: O'Reilly Media; 1 edition (June 18, 2010)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B0043EWTY4
- Text-to-Speech: Enabled
X-Ray:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #125,868 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #60
in Books > Computers & Technology > Software > Business > Workflow - #68
in Kindle Store > Kindle eBooks > Computers & Technology > Software > Business
- #60
in Books > Computers & Technology > Software > Business > Workflow - #68
in Kindle Store > Kindle eBooks > Computers & Technology > Software > Business
Excel 2010: the missing manual is part of a growing series of reference manuals for popular software products. Mr MacDonald has also written Access 2010 among other books. A CD with training exercises is not available but a website is available to download the necessary essentials.
Before starting the tutelage, the author describes all the new stuff Microsoft built into this latest version. Throughout the book, there are also many illustrations to help the reader follow the narrative. There are also samples of dialogs that you'll meet in using the program, giving tips on how best to use the dialogs. Interesting sidebars also adds to your learning experience.
The manual targets the absolute novice who hasn't used a spreadsheet before and people who have been using Excel for a while but at a basic level and will transport them to an intermediate level of expertise if so desired. The author starts at the beginning, showing how to open a spreadsheet and then taking a tour of the many features the program has. He slowly and deliberately progresses to adding and moving data, formatting, managing multiple sheets as well as printing your work. Moving on, building formulas and using the many built-in formulas including using the family of "if" statements, math, financial, time, text etc is given high priority. Moving into more interesting fields, List Management, Grouping Data, building templates and creating charts and adding pictures is presented. The program also has clip art and a decent drawing editor that the author shows you how to use.
Moving deeper into Databases, creating Scenarios, Pivot tables, web queries and connecting to a SQL server is next, followed by using Excel with other programs.
The last two chapters cover using VBA in automating tasks.
Excel 2010: The Missing Manual Preview
Link
Please Wait...