Google Docs 4 Everyone

Since its introduction in 2006, Google Docs has changed the way people think about office productivity tools — first word-processing documents and spreadsheets and then slideshow-style presentations (which made their Google Docs debut in 2007). Unlike traditional productivity applications, which you buy, install on your computer, and later upgrade yourself (for an additional fee), Google Docs’ applications are Web-based. That means your documents, spreadsheets, and presentations are stored on the Web, and you can access them from anywhere you have an Internet connection and a Web browser. Imagine the possibilities: No more having to remember to transfer a file from your desktop computer to your laptop before you hit the road. No more wondering whether the version you’re working on is the current version. No more having to back up all your documents — because Google’s got you covered.

And if you sometimes need to work when you’re offline, Google’s got you covered there, too. When you install Google Gears (Chapter 3 tells you how), you can work on your documents and view your spreadsheets even when you’re not connected to the Internet. Using Gears to work offline is optional; you don’t have to install it to use Google Docs.

But one of the greatest advantages of Google Docs is the ability to share your documents with others—and collaborate on them in real time. If you’ve ever collaborated by emailing a flurry of files or waiting for someone else to check a document back into a central repository (so you can have your turn), you’ll love collaborating in Google Docs. When you share a document with some collaborators, those people can sign in and work on the document whenever they want, from wherever they are. Multiple collaborators can work on a document at the same time. All edits happen to the current version of the document, so you never have to worry about working on an out-of-date file. (If someone makes edits you need to undo, you can roll back to a previous version using Google Docs’ revision history feature.)

Best of all, Google Docs is free. Yes, you heard that right—it won’t cost you a penny to use. There’s nothing to install on your computer, and Google takes care of fixing bugs and updating the applications.

It’s no wonder that organizations—including GE, L’Oreal, the District of Columbia, and Google itself—are evaluating or switching to Google for their productivity tools. And it’s no wonder that millions of individuals are choosing Google Docs to create, edit, and store their documents. Given that you are reading this introduction, you’ve probably done the same (or are thinking about it). Whether for business or personal use, this book will help you get the most out of Google Docs.

Download Google Docs 4 Everyone (9.7 MB, 265 pages)

Excel VBA Programming For Dummies

VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company that tries to get you to buy a new version of Windows every few years. Excel, along with the other members of Microsoft Office, includes the VBA language (at no extra charge). In a nutshell, VBA is the tool that people like you and me use to develop programs that control Excel.

Imagine an intelligent robot that knows all about Excel. This robot can read instructions, and it can also operate Excel very fast and accurately. When you want the robot to do something in Excel, you write up a set of robot instructions by using special codes. Then you tell the robot to follow your instructions, while you sit back and drink a glass of lemonade. That’s kind of what VBA is all about — a code language for robots. Note, however, that Excel does not come with a robot or lemonade.

Download Excel VBA Programming For Dummies (10.9 MB, 411 pages)

Excel 2016 For Dummies

Excel 2016, like Excel 2013, 2010, and 2007 before it, relies upon a single strip at the top of the worksheet called the Ribbon that puts the bulk of the Excel commands you use at your fingertips at all times.

Add to the Ribbon a File tab and a Quick Access toolbar — along with a few remaining task panes (Clipboard, Clip Art, and Research) — and you end up with the handiest way to crunch your numbers, produce and print polished financial reports, as well as organize and chart your data. In other words, to do all the wonderful things for which you rely on Excel.

Best of all, the Excel 2016 user interface includes all sorts of graphical elements that make working on spreadsheets a lot faster and a great deal easier. Foremost is Live Preview that shows you how your actual worksheet data would appear in a particular font, table formatting, and so on before you actually select it. This Live Preview extends to the new Quick Analysis and Recommended PivotTables and Recommended Charts commands to enable you to preview your data in various formats before you apply them.

Additionally, Excel 2016 supports a Page Layout View that displays rulers and margins along with headers and footers for every worksheet with a Zoom slider at the bottom of the screen that enables you to zoom in and out on the spreadsheet data instantly. Finally, Excel 2016 is full of pop‐up galleries that make spreadsheet formatting and charting a real breeze, especially in tandem with Live Preview.

Download Excel 2016 For Dummies (13.1 MB, 435 pages)

Access VBA Programming for Dummies

Welcome to Access VBA Programming For Dummies. As you (hopefully) already know, Microsoft Access is a huge database management program, offering lots of ways to manage data (information). Common uses of Access include managing mailing lists, memberships, scientific and statistical data, an entire small business, and just about anything else that involves storing and managing large amounts of information.

As the title implies, this is a book about using Visual Basic for Applications (VBA) to enhance the power of Access databases. It’s not a book about creating Access tables, queries, forms, reports, and such. To stay focused on VBA, I need to assume that you already know all that. Furthermore, there’s really no point in even using VBA until you’ve already created a database with at least some tables and forms in it. In fact, writing VBA code is usually the last step in creating a custom Access database.

Unlike other programming books that you might have seen, this one doesn’t assume that you’re already a programmer. I don’t even assume that you’re already an accomplished programmer who is just picking up a new programming language. Rather, I assume that you’ve never written any programming code in your life — and maybe aren’t even all that sure what programming code means or how it relates to Microsoft Access.

By the time you finish this book, you’ll know exactly what VBA is all about and you’ll know how it fits into Access. You’ll discover the meanings of all those obscure terms that programmers throw around — code, variable, array, loop, object — as though they were common knowledge. You’ll be able to write and use your own custom code, just like programmers do.

You might have noticed there is no version number in this book’s title: That is, it’s not Access 2002 VBA or Access 2003 VBA. Here’s why: Although many changes and improvements to Access have occurred in all the versions that Microsoft has released, the VBA programming language has hardly changed a bit over the years. The code that you see here should work as-is in Access 2000, 2002, 2003, and any subsequent versions released. The vast majority of the code in this book will also work just fine even in last century’s versions, such as Access 97.

Download Access VBA Programming for Dummies (8.01 MB, 410 pages)

Access Forms & Reports for Dummies

Access Forms & Reports For Dummies is a hands-on guide that uses real-world examples to show you just what you need to know about Access and why you need to know it. You won’t find a bunch of buzzwords and jargon. Rather, you do find the solid information you really need and can’t find elsewhere about creating queries, forms, and reports. Yes, I do give you good, solid information about queries in addition to forms and reports because queries are an essential element that will help you create better forms and reports.

Access Forms & Reports For Dummies is also a reference that you can use as you like. If you have a specific problem you need to solve right now, you can jump directly to the related topic and skip around as much as you want. But if you really want to make Access work for you, I suggest that you read through the entire book because you will discover many things you don’t already know.

Finally, Access Forms & Reports For Dummies is for users of pretty much any version of Access from Access 97 onwards. The basics of queries, forms, and reports haven’t changed much, so you’ll find this book extremely helpful no matter which version of Access you use.

Download Access Forms & Reports for Dummies (11.6 MB, 408 pages)

Access 2016 Bible

Welcome to Access 2016 Bible, your personal guide to the most powerful desktop database management system available today.

Microsoft Access can help you manage your data in ways that no other application can. Even the king of applications, Microsoft Excel, can’t do what Access can. Now, it may seem silly to compare Access (a database management application) with Excel (a spreadsheet application), but there is no doubt that Excel is being used every day to manage and analyze large amounts of data in all kinds of organizations. Indeed, you may be opening this book because you need to get past the limitations of Excel.

Access is an excellent (many would say logical) next step for the analyst who faces an ever-increasing data pool. Access takes very few performance hits with larger datasets. It has no predetermined row limitations. And it can effectively manage the relationships between disparate data tables. In addition, Access comes with tools that help you build your own distributable applications.

Today, when we have more data than ever and more demands for complex data analysis, power analysts need to add some tools to their repertoire in order to get away from being simply “spreadsheet mechanics.” That’s why this book is such an important step in the evolution of your skillset. Throughout this book, not only will you get an introduction to Access, but you’ll also learn various ways in which you can use Access to improve your daily data management and analysis.

Donwload Access 2016 Bible (66.7 MB, 1155 pages)

Big Data Preview Issue

The combination of cloud computing, internet, and mobile devices is moving ever greater portions of our lives and businesses inside the data center. As a result, we are generating, and must analyze, vast and varied flows of information. The techniques developed to do this form the body of technology we refer to as “big data.” This ability to find insight beyond normal human grasp has caught the imagination of the public. Readers of the computing, business, and general press alike will find the term hard to escape this year.

The precise definition of “big data” is hazy, although I, like many others, have attempted to provide one:
Big data is data that exceeds the processing capacity of conventional database systems. The data is too big, moves too fast, or doesn’t fit the strictures of your database architectures. To gain value from this data, you must choose an alternative way to process it.

Download Big Data Preview Issue (4.77 MB, 28 pages)