|
| |
|
EBooks » Office
 The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful--and can be downright intimidating. If you're new to Excel or among the many existing Excel users who are dazed and confused by all that the program can do (and by how little it has actually done for you), Excel for Starter: The Missing Manual is your ideal resource. For everyone who wants to quickly get up to speed on Excel to create, organize, and present household and/or office data and information, this smart new guide delivers just the essentials: it concentrates on the must-have information and the best, most practical Excel features that people like you can use to maximize your productivity and minimize your spreadsheet confusion and frustration. Excel for Starters: The Missing Manual demystifies spreadsheets and explains how to use them most effectively and efficiently. Clear explanations (with lots of examples), step-by-step instructions, helpful illustrations, and timesaving advice guide you through all the most common and useful features of Excel 2002 and 2003--including how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Sure, there are plenty more thorough, more massive Excel books on the bookstore shelves. But why wade your way through a swamp of details you'll never need--or want--to use? Let author Matthew MacDonald, an educator and software developer who also wrote the highly popular Excel: The Missing Manual, be your trusted guide as you learn which Excel features will serve you best and which are best ignored. # Paperback: 504 pages # Publisher: Que (June 11, 2004) # Language: English # ISBN: 0789731533 # Product Dimensions: 9.2 x 7.4 x 1.1 inches  The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating for even advanced computer users. Perhaps like you, a majority of users find it difficult to get the most they can out of this very valuable program. Formulas and Functions with Microsoft Excel 2003 strives to break down the complexities by focusing on the four primary technologies to master: ranges, formulas, data analysis tools and lists. Chapters such as “Getting the Most Out of Ranges,” “Building Your Own Functions Using VBA,” and “Solving Complex Problems with Solver” will teach you practical skills and solutions that you can put to work immediately. Frustration will become a thing of the past as you begin to master the complex world of Excel! In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much do*****entation on their cross-usage. Until now. Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately. But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to: - Utilize the built in features of Access and Excel to access data
- Use VBA within Access or Excel to access data
- Build connection strings using ADO and DAO
- Automate Excel reports including formatting, functions, and page setup
- Write complex functions and queries with VBA
- Write simple and advanced queries with the Access GUI
- Produce pivot tables and charts with your data
 This practical, hands-on tutorial expertly builds your skills with Microsoft Office Access 2003—one step at a time! With STEP BY STEP, you work at your own pace through easy-Hey, you know your way around a database—so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery!
•Build on what you already know about Access and quickly dive into what’s new
•Design your database the way the experts do—and sidestep common mistakes
•Import data from spreadsheets, text files, databases, and other sources
•Write simple to sophisticated queries to manipulate data
•Learn advanced techniques for building forms and reports
•Develop PivotTable and PivotChart dynamic views
•Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures
•Implement database security features
•Deliver dynamic data on the Web with data access pages and XML
•Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages  Become a power user with Word Hacks! Insider tips, tools, tricks, and hacks help you accomplish your pressing tasks, address your frequent annoyances, and solve even your most complex problems. The book examines Word's advanced (and often hidden) features and delivers clever, time-saving hacks on taming document bloat, customization, complex search and replace, tables and comments, XML, and even using Google without leaving Word! |
| |
|
