Excel Data Analysis for Dummies
by Stephen L., CPA, MBA, MS Nelson
from For Dummies
So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job.
Using Excel for this kind of stuff is what Excel Data Analysis For Dummies is all about. This is a book that assumes that you want to use Excel to learn new stuff, discover new secrets, and gain new insights into the information you’re already working with in Excel.
Ready to take Excel to the next level? This plain-English guide covers all of these concepts, and more, to ensure that you’re using Excel to its fullest capacity:
- Harnessing information in lists
- Querying external databases and Web pages tables
- Cleaning data with text functions
- Building and working with PivotTables
- Customizing PivotCharts
- Using the statistics functions
- Understanding Optimization Modeling
If all this talk of statistics and advanced tools makes you light-headed, don’t worry. Excel Data Analysis For Dummies distills the most important fundamentals into everyday language. You’ll find just enough information to help you get your work done – without leaving you gasping for air in a sea of technobabble. It’d be a real shame if you didn’t at least know what bells and whistles Excel has to offer and the basic steps that you need to use them.
Excel 2000 for Windows for Dummies
by Greg, PhD Harvey
from For Dummies
You may not be a dummy, but that doesn't mean you were born knowing how to use spreadsheets. Excel 2000 for Windows for Dummies will bring you up to speed on Microsoft's premillennial package, even if you've never used anything like it before.
A great reference for the beginner and the pressed-for-time, this book is organized as a series of chapters that build from the basics of pointing and clicking and figuring out the different parts of the spreadsheet to more advanced topics like Web-based data entry and macros. Visual learners will find much to love as well--there are screen shots galore and plenty of icons to point you to the most salient items quickly.
Written in characteristic Dummies-style--laid-back and humorous--the text is as nonthreatening as can be; even the most diehard computer-phobes will find themselves chuckling as they (gulp) learn how to enter data. The techno-geeks down the hall might snicker at the bright yellow book on your desk, but you can snicker right back because you know you have better weekends. --Rob Lightner
Just because electronic spreadsheets like Excel 2000 have become almost as commonplace on today’s personal computers as word processors and games doesn’t mean that they’re either well understood or well used. Excel is a great organizer for all types of data, be they numeric, textual, or otherwise.
Excel 2000 For Windows For Dummies covers all the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In addition to showing you around the worksheet, this fun and friendly book exposes you to the basics of charting, creating databases, and converting spreadsheets into Web pages. Expect to pick up invaluable tips and tricks on
- Creating a spreadsheet from the get-go
- Dressing up the look of your cells
- Printing your spreadsheet masterpiece
- Facing a database
- Making sense of multiple worksheets
- Editing your worksheet Web pages
Keeping things simple, this book cuts to the chase by telling you in plain terms just what it is that you need to do to accomplish a task using Excel. With spreadsheets as the focus, Excel 2000 For Windows For Dummies shows you how to
- Launch Excel from a toolbar or browser
- Mess around with the menu bar
- Fabricate fabulous formulas
- Tamper with how text wraps
- Add hyperlinks to a worksheet
- Work with WordArt
- Customize and design your own toolbars
- Explore top features of Excel 2000
One look at the Excel 2000 screen (with all the boxes, buttons, and tabs), and you realize that there's a whole lot of stuff going on. With this book as your expert companion, you can tame your anxiety over the tech stuff and cell-abrate success with all the computing, text-editing, and formatting potential in this powerhouse program.
Office 2007: The Missing Manual
by Chris Grover
from Pogue Press
Quickly learn the most useful features of Microsoft Office 2007 with our easy to read four-in-one guide. This fast-paced book gives you the basics of Word, Excel, PowerPoint and Access so you can start using the new versions of these major Office applications right away. Unlike every previous version, Office 2007 offers a completely redesigned user interface for each program. Microsoft has replaced the familiar menus with a new tabbed toolbar (or "ribbon"), and added other features such as "live preview" that lets you see exactly what each option will look like in the document before you choose it. This is good news for longtime users who never knew about some amazing Office features because they were hidden among cluttered and outdated menus. Adapting to the new format is going to be a shock -- especially if you're a longtime user. That's where Office 2007: The Missing Manual comes in. Rather than present a lot of arcane detail, this quick & friendly primer teaches you how to work with the most-used Office features, with four separate sections covering the four programs. The book offers a walkthrough of Microsoft's redesigned Office user interface before taking you through the basics of creating text documents, spreadsheets, presentations, and databases with:
- Clear explanations
- Step-by-step instructions
- Lots of illustrations
- Plenty of friendly advice
Programming Excel with VBA and .NET (Programming)
by Jeff Webb
from O'Reilly Media, Inc.
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.
The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO).
This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages.
With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.
Microsoft Office Excel 2003 QuickSteps (Quicksteps)
by John Cronan
from McGraw-Hill Osborne Media
Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don’t break the flow of the quick steps themselves.
Excel 2000 Formulas
by John Walkenbach
from Wiley
This one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-to-typical) Excel challenges. From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets -- and make the most of Excel.
Excel 2002 for Dummies
by Greg, PhD Harvey
from For Dummies
Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that.
One look at the Excel 2002 screen (with all its boxes, buttons, and tabs), and you realize how much stuff is going on there. Excel 2002 For Dummies will help you make some sense out of the rash of icons, buttons, and boxes that you're going to be facing day after day. And when you ready to go beyond spreadsheet basics, this guide will also introduce you to
- Conjuring up charts
- Inserting graphics
- Designing a database
- Converting spreadsheets into Web pages
Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you'll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel. This down-to-earth guide covers all these topics and more:
- Creating a spreadsheet from scratch
- Document recovery
- Formatting fundamentals
- Making corrections (and how to undo them)
- Retrieving data from your spreadsheets
- Protecting your documents
- Demystifying formulas
Now, even if your job doesn't involve creating worksheets with a lot of fancy financial calculations or lah-dee-dah charts, you probably have plenty of things for which you could and should be using Excel. For instance, you may have to keep lists of information or maybe even put together tables of information for your job. Excel is a great list keeper and one heck of a table maker. You can use Excel anytime you need to keep track of products that you sell, clients who you service, employees who you oversee, or you name it.
Excel 2002 Power Programming with VBA
by John Walkenbach
from Wiley
Get the most out of Excel, Microsoft's powerful spreadsheet application. With John Walkenbach, the leading Excel expert better known as "Mr. Spreadsheet", discover better ways to analyze data and find solutions using Microsoft Excel 2002.
This book is an excellent resource for getting up to speed using streamlined spreadsheet creation tools, enhanced analysis tools and powerful Web integration. Transform Excel into an application suited to the whole organization so workgroups can work more effectively. Discover how developers can integrate information seamlessly, whether proposal text, financial figures or research data. Whether you are an expert or a novice, Excel 2002 Power Programming with VBA will help you work more efficiently, turning your data into answers you can count on.
Bonus: The book contains a coupon for the Professional Power Utility Pak.
Teach Yourself® Microsoft® Excel 2000
by Dennis P. Taylor
from Wiley
Looking for quick, solid answers to all your Excel 2000 questions? Find them in Teach Yourself(r) Microsoft(r) Excel 2000. This book skips the technical jargon and gets right to the heart of the matter, saving you time and frustration. Topics covered include: creating, formatting and managing worksheets, performing calculations with formulas and functions, using multisheet workbooks, integrating your data and charts into Web pages, creating stunning 3-D charts, and more.
Teach Yourself Microsoft Excel 2000 Visually
by Ruth Maran
from Visual
Packed with more than 300 full-color pages, Teach Yourself Microsoft Excel 2000 VISUALLY offers a clear and colorful way to read less and learn more on your way to becoming an Excel 2000 master. You'll receive jargon-free instructions on everything from working with formulas and functions on your worksheets, to adding graphics and charts to your worksheets, to using your Excel files on the Internet with clear examples that fill every chapter.
+++
