Excel 2013 Mastering the Basics
| Author | : | |
| Rating | : | 4.67 (783 Votes) |
| Asin | : | 1492143332 |
| Format Type | : | paperback |
| Number of Pages | : | 542 Pages |
| Publish Date | : | 2014-07-13 |
| Language | : | English |
DESCRIPTION:
not much anthony ervin Save your money and buy the advanced version. This one is far to basic, but it is blotted worth a bunch of useless info that is hard to wade through.
Excel 2013 Mastering the Basics uses a practical approach to learning this powerful software tool: analysis of key features, combined with step-by-step tutorials which will reinforce your understanding of what Microsoft Excel is all about. Aimed at beginner to intermediate Excel users, who may already be familiar with earlier Excel versions, this book will provide the practical insights, tips and shortcuts you need to start becoming an Excel power user. Creating and customizing pivot tables, pivot charts and dashboards, featuring slicers and timelines which provide interactive data filtering and exploration. Working with tabular data: sorting data numerically, chronologically, by colour and by custom order, filtering data and creating multi-level subtotals. Creating and customizing charts and graphics: practical exercises on creating the different types of Excel charts, creating sparklines, importing and creating graphics and embedding formulas into graphic elements. Understanding the Excel Interface: the Welcome Screen; the Ribbon, Tabs and Ribbon controls; the Quick Access Toolbar and working in Backstage view. How to build efficient Excel formulas using functions; nested functions; relative, mixed and absolute references; named ranges and 3-D formulas. Topics include: Using Excel’s powerful new features such as Recommended PivotTables, Recommended Charts, Quick Analysis Lens, Timelines, and Flash Fill. Customizing the way worksheets a