UNHARNESS THE TRUE POWER OF MICROSOFT'S "KILLER" SPREADSHEET APPLICATION DISCOVER THE REAL "POWER USER" SECRETS THAT MANY USERS SEEK, BUT FEW ACTUALLY EVER OBTAIN!
Whether you're just discovering Excel, or consider yourself a relatively competent user, this eBook is for you. From basic formulas, functions, and chart creation to data analysis, customer number formats, data validation, and Excel macros, this is an AUTHORITATIVE QUALITY resource for mastering Excel XP & 2003 - Microsoft's 'killer' spreadsheet application.
Inside, you'll find a coverage of the application which ensures you are able to painlessly gain a real "Power User" mastering of Excel.
- Perform "what if" analysis, use Goal Seek and Solver
- Learn your way around cells, rows, columns, worksheets, workbooks and ranges
- Find out how to automate tasks by building and utilising macros
- Explore conditional formatting, link and consolidate worksheets
- Discover how to create charts and diagrams, organise lists and simplify complex tasks using Excel
- Develop formulas that manipulate text, look up values and perform financial applications
- Become skilled at setting up dynamic links with other Microsoft Office applications
- Anlayse data using external database files and pivot tables
- And Much More!
eBook Contents 16 Chapters (157 Pages)
- Macros
- Auditing & Troubleshooting
- Printing
- Pivot Tables
- Making Your Workbook Easier To Use & Understand
- Making It Look Good
- Improving Data Entry & Readability
- Getting Started In Excel
- Functions
- Database Features
- Data Management Tools
- Charts
- Basic Principles
- Appendices
- Advanced Functions
- Advanced Excel Functionality
