Subcategories

Excel 2013 Bible (Repost)

Posted By: roxul
Excel 2013 Bible (Repost)

John Walkenbach, "Excel 2013 Bible"
English | ISBN: 1118490363 | 2013 | EPUB, PDF | 1056 pages | 19 + 216 MB

Excel at Excel with this ultimate guide

Whether you want to create charts, import and clean data, automate tasks with VBA macros, or work in the cloud—however you want to use Excel, John Walkenbach can show you how. Fully updated for the latest features in Excel 2013, this perennial bestseller is packed with information, techniques, helpful notes, and tips to take your spreadsheet skills to the next level. Beginner, power user, or somewhere in between, this is the ultimate Excel resource you'll turn to again and again.
Get up to speed on everything new in Excel 2013
Review Excel basics—worksheets, formulas, functions, and charts
Learn to handle data in many ways, including importing, cleaning, and analyzing
Master useful Excel tools, such as Sparklines, Flash Fill, and Analysis ToolPak
Discover the power of Excel's ultimate analysis tool—pivot tables
Create VBA macros, add controls, and work with Excel events
Slice and dice your data to identify trends and patterns
Work your way through sample workbooks and take advantage of downloadable templates on the companion website

Use formulas and functions to create useful forms

Learn which chart is most suitable for your data

Pivot table slicers make it easy to filter data