The Secrets of Excel by John Rappange
English | 2014-08-24 | ASIN: B00N0UR6KY | 655 Pages | PDF| 10.27 MB
homepage:www.thesecretsofexcel.com
The Essential Excel Manual:Step-by-Step Guide to Mastering the Most Widely Used Spreadsheet Software in the Market

Excel, the most widely used spreadsheet application on the market, can help you manage and organize your professional, personal and business life with plenty of functions and formulas at your fingertips.

Improve your CV, organize your contacts, manage your personal finances, build databases or use the impressive array of data collection options to grow your business.

What you will learn with this eBook

• Shortcuts

  Work faster. Learn the best practices to efficiently using Excel. Increase your production by reducing the time it takes to perform repetitive functions by using keyboard shortcuts.

• Formulas and Functions

  Learn the functions that will do the number crunching for you. Calculations can be as simple as basic addition and subtraction to complex calculations as VLOOKUP, payroll deductions and general ledger allocation. Learn to create PivotTable reports that can help you more easily summarize, organize and analyze your data.

• Data Merging

  Integrate files and documents from multiple data sources which will allow you to organize large contact lists, employee information, sales leads and more.

• Visual Basic For Applications (VBA)

  Learn the popular programming language that will serve you in multiple Microsoft applications. As an easier language to learn than other programming languages, you can create your own applications to create a personalized, more efficient Excel user experience.

• Charts and Graphs

  Charts and graphs make it easier to visualize data, understand the numbers and identify trends. Learn how to create graphs for presentations and business reports for more powerful emphasis.

• Ribbon Navigation

  Mastering the ribbon makes working faster. Learn to use the interface fluently and how to find the quick command keys to perform functions that much faster.