Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • 2005-2009  (25)
  • 1995-1999
  • Boston, Mass. :Safari Books Online  (25)
  • Birmingham, AL, USA : EBSCO Industries, Inc.
  • Microsoft Excel (Computer file)  (25)
Datasource
Material
Language
Years
Year
  • 1
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 9780735622913 , 0735622914
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Get the fast facts that make learning Microsoft Office Excel 2007 plain and simple! This no-nonsense guide uses easy numbered steps and concise, straightforward language to show the most expedient ways to learn a skill or solve a problem.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 2
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 9780596528348 , 0596528345
    Language: English
    Edition: 2nd ed.
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks -- clever tools, tips and techniques -- that will leapfrog your work beyond the ordinary. Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to: Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption. Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform. Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet. Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them. Create customized charts -- tweak and combine Excel's built-in charting capabilities. Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time. Make the most of macros -- including ways to manage them and use them to extend other features. Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook. You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 3
    Online Resource
    Online Resource
    Indianapolis, Ind. : Wiley | Boston, Mass. :Safari Books Online
    ISBN: 9780470044032 , 0470044039
    Language: English
    Pages: xlii, 866 p , ill. , 24 cm. +
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Electronic books ; local
    Abstract: This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won't find anywhere else John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld's leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 4
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 9780735623217 , 073562321X
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Learn how to conquer Microsoft Office Excel 2007-from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds, all in concise, fast-answer format. Includes a companion CD.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 5
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 9780735624078 , 0735624070
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Microsoft SharePoint (Electronic resource) ; Business ; Computer programs ; Web services ; Electronic books ; local
    Abstract: Get the straightforward information you need to use Excel Services to add Microsoft Office Excel functionality to your Microsoft Windows--based, Web-based, and smart-client applications. This practical guide covers the essentials for adding Office Excel spreadsheets and workbooks to your dashboards and portals running on Microsoft Office SharePoint- Server 2007. Armed with your experience in developing applications using the Microsoft .NET Framework, you'll discover how to enable users to share and reuse data--without regard to platform dependence. You will compare and contrast multiple options for building charts, pivot tables, spreadsheets, and more. The examples are carefully crafted to illustrate Windows, Web, and smart-client application development and are designed to help professional developers build proficiency in Excel Services to help satisfy today's business requirements. Includes code samples in Visual C# and Visual Basic.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 6
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 9780735624023 , 073562402X
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Create macros to automate repetitive tasks Automatically format charts, shapes, and text Manipulate tables and other objects-even build PivotTable reports Write your own functions and procedures Use loops and conditions to add decision logic to macros Build custom command buttons, dialog boxes, and user forms Your all-in-one learning experience includes: Files for building skills and practicing the book's lessons Fully searchable eBook Windows Vista Product Guide eReference-plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes bibliographical references and index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 7
    Online Resource
    Online Resource
    Berkeley, Calif. : Peachpit Press | Boston, Mass. :Safari Books Online
    ISBN: 9780321461520 , 0321461525
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Business ; Computer programs ; Electronic books ; local
    Abstract: Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web. For the first time in years there is a lot to learn to make the most of this powerful new update. To take advantage of all of the new features in this powerful program (and to do so quickly), users need this V i sual QuickStart Guide . In these pages, veteran author and trusted Excel teacher Maria Langer provides step-by-step instructions for the full gamut of Excel tasks: from worksheet basics like editing, using functions, formatting cells, and adding graphics objects, to more advanced topics like creating charts, working with databases, and Web publishing. As with all Visual QuickStart Gui de books, clear, concise instructions and lots of visual aids make learning easy and painless.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 8
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 9780735623965 , 0735623961
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Industrial management ; Statistical methods ; Computer programs ; Decision making ; Computer programs ; Business ; Computer programs ; Electronic books ; local
    Abstract: Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide-updated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You'll learn how to create best, worst, and most-likely scenarios for sales, estimate a product's demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. You'll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 9
    Online Resource
    Online Resource
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online
    ISBN: 073562304X , 9780735623040
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2007. With Step By Step, you set the pace-building and practicing the skills you need, just when you need them! Create formulas, calculate values, and analyze data Present information visually with graphics, charts, and diagrams Build PivotTable dynamic views-even easier with new data tables Reuse information from databases and other documents Share spreadsheets for review and manage changes Create macros to automate repetitive tasks and simplify your work Your all-in-one learning experience includes: Files for building skills and practicing the book's lessons Fully searchable eBook Bonus quick reference to the Ribbon, the new Microsoft Office interface Windows Vista Product Guide eReference-plus other resources on CD For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 10
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 9780596514525 , 0596514522
    Language: English
    Edition: 2nd ed.
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost. With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find: A visual guide to the new "Ribbon" interface that helps users find familiar tools A section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediately Quick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying data Convenient techniques for connecting data across worksheets and projects Help for moving from the basics of spreadsheet construction to more advanced features This edition also includes an extensive reference on commonly used formulas, which reveal at a glance the many possibilities Excel 2007 provides for easy calculation. Tasks in the book are presented as answers to "How do I..." questions -- such as "How do I change the formatting of part of a cell's contents?" -- followed by concise instructions for performing the task. You'll learn ways to customize Excel to fit your needs, and how to share workbooks and collaborate with others. And much more. Don't let Excel 2007 baffle you. Pick up this convenient pocket guide and learn to navigate this redesigned application with ease.
    Note: Includes bibliographical references and index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 11
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que Pub. | Boston, Mass. :Safari Books Online
    ISBN: 9780789736642 , 0789736640
    Language: English
    Edition: 3rd ed.
    Keywords: Microsoft Excel (Computer file) ; Corporations ; Finance ; Corporations ; Finance ; Computer programs ; Electronic books ; local
    Abstract: Whether you own a small business or work for a large corporation-whether you are looking for help making financial and business decisions-this book is for you. Business Analysis with Microsoft® Excel, Third Edition, provides in-depth information that will streamline your use of the tools within Excel. Professional advice and guidance from an experienced author provide the answers to your most pressing questions: • What's the relationship between my cost of goods sold and my inventory? • How do I get Excel to keep these values up-to-date on my income statement and my balance sheet? • I have to track service quality over time. How can I automate that using Excel charts? • How can I forecast future demand for my products, based on prior sales results? • What's the difference between financial leverage and operating leverage? How do I calculate them using my financial records? • I need to project my financials for next year. Does Excel have a tool for that? What do I need to know to use it effectively? • How do I do all these things using the new Ribbon in Excel 2007? • What are the best ways to automate a connection between Excel and an external database? Category Spreadsheets Covers Applicable for versions of Microsoft Excel 97 to 2007 User Level Intermediate-Advanced More great stuff... is just a click away! • Sample journals and ledgers; examples of trial balances, income statements, and balance sheets • Custom functions, such as FIFO and LIFO, for inventory management • VBA routines that automate the creation of forecasts, quality control charts, and sales and marketing analysis • Statistical process control charts: P charts, X-and-S charts, X-and-MR charts • Forecasting tools: Seasonal smoothing and ARIMA model identification quote from the front cover "Conrad takes the time to give the readers an easy-to-follow step-by-step understanding of the material, accompanied by clear illustrations, making this an excellent book to learn the material. I recommend this book to anyone wanting to gain more expertise in using and manipulating business data from within Excel." -Bob Umlas, Excel MVP
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 12
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    ISBN: 0789736683 , 9780789736680
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: "If you've never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you're already an expert and you're moving up to Excel 2007, this book will quickly show you features you've only dreamed of until now..." -Thomas 'Duffbert' Duff, Duffbert's Random Musings, http://www.twduff.com Develop your Microsoft Excel expertise instantly with proven techniques Master Excel Ranges Create Powerful Arrays Troubleshoot Formula Problems Validate Worksheet Data Perform What-If Analysis Model Your Business Track Trends and Make Forecasts Analyze Data Find Optimal Solutions Build Dynamic Loan Schedules Most Microsoft® Excel users learn only a small percentage of the program's features. They know they could get more out of Excel if they could just get a leg up on building formulas and using functions. Unfortunately, this side of Excel appears complex and intimidating to the uninitiated-shrouded in the mysteries of mathematics, finance, and impenetrable spreadsheet jargon. Sound familiar? If you're a businessperson who needs to use Excel as an everyday part of your job, then you've come to the right book. Formulas and Functions with Microsoft® Office Excel 2007 demystifies worksheet formulas and presents the most useful Excel functions in an accessible, jargon-free way. This book not only takes you through Excel's intermediate and advanced formula-building features, it also tells you why these features are useful to you and shows you how to use them in everyday situations. Throughout the book you'll find no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users. • Focuses like a laser on the four technologies that you must master to get the most out of Excel: ranges, formulas, functions, and data analysis tools. • Shuns spreadsheet theory in favor of practical know-how that you can put to use right away. • Provides numerous real-world examples and techniques to help you learn and understand the importance of each section. Introduction 1 Getting the Most Out of Ranges 2 Using Range Names 3 Building Basic Formulas 4 Creating Advanced Formulas 5 Troubleshooting Formulas II Harnessing the Power of Functions 6 Understanding Functions 7 Working with Text Functions 8 Working with Logical and Information Functions 9 Working with Lookup Functions 10 Working with Date and Time Functions 11 Working with Math Functions 12 ...
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 13
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    ISBN: 9780789736826 , 0789736829
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: "In this day and age of 'too much information and not enough time,' the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of." -Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you. Learn VBA syntax as easy-to-understand English Automate Excel's power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros Introduction 1 1 Unleash the Power of Excel with VBA 7 2 This Sounds Like BASIC, So Why Doesn't It Look Familiar? 29 3 Referring to Ranges 61 4 User-Defined Functions 75 5 Looping and Flow Control 101 6 R1C1-Style Formulas 121 7 What's New in Excel 2007 and What's Changed 135 8 Create and Manipulate Names in VBA 143 9 Event Programming 155 10 UserForms--An Introduction 177 11 Creating Charts 197 12 Data Mining with Advanced Filter 249 13 Using VBA to Create Pivot Tables 281 14 Excel Power 337 15 Data Visualizations and Conditional Fo...
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 14
    Online Resource
    Online Resource
    Upper Saddle River, N.J. : Prentice Hall | Boston, Mass. :Safari Books Online
    ISBN: 9780131482043 , 0131482041
    Language: English
    Edition: 2nd ed.
    Series Statement: Prentice Hall PTR international series in the physical and chemical engineering sciences
    Keywords: Microsoft Excel (Computer file) ; MATLAB ; Chemical engineering ; Problems, exercises, etc ; Biochemical engineering ; Problems, exercises, etc ; Chemical engineering ; Data processing ; Biochemical engineering ; Data processing ; Problem solving ; Numerical analysis ; Electronic books ; local
    Abstract: Problem Solving in Chemical and Biochemical Engineering with POLYMATH™, Excel, and MATLAB®, Second Edition , is a valuable resource and companion that integrates the use of numerical problem solving in the three most widely used software packages: POLYMATH, Microsoft Excel, and MATLAB. Recently developed POLYMATH capabilities allow the automatic creation of Excel spreadsheets and the generation of MATLAB code for problem solutions. Students and professional engineers will appreciate the ease with which problems can be entered into POLYMATH and then solved independently in all three software packages, while taking full advantage of the unique capabilities within each package. The book includes more than 170 problems requiring numerical solutions. This greatly expanded and revised second edition includes new chapters on getting started with and using Excel and MATLAB. It also places special emphasis on biochemical engineering with a major chapter on the subject and with the integration of biochemical problems throughout the book. General Topics and Subject Areas, Organized by Chapter Introduction to Problem Solving with Mathematical Software Packages Basic Principles and Calculations Regression and Correlation of Data Introduction to Problem Solving with Excel Introduction to Problem Solving with MATLAB Advanced Problem-Solving Techniques Thermodynamics Fluid Mechanics Heat Transfer Mass Transfer Chemical Reaction Engineering Phase Equilibrium and Distillation Process Dynamics and Control Biochemical Engineering Practical Aspects of Problem-Solving Capabilities Simultaneous Linear Equations Simultaneous Nonlinear Equations Linear, Multiple Linear, and Nonlinear Regressions with Statistical Analyses Partial Differential Equations (Using the Numerical Method of Lines) Curve Fitting by Polynomials with Statistical Analysis Simultaneous Ordinary Differential Equations (Including Problems Involving Stiff Systems, Differential-Algebraic Equations, and Parameter Estimation in Systems of Ordinary Differential Equations) The Book's Web Site (http://www.problemsolvingbook.com) Provides solved and partially solved problem files for all three software packages, plus additional materials Describes discounted purchase options for educational version of POLYMATH available to book purchasers Includes detailed, selected problem solutions in Maple™, Mathcad®, and Mathematica™
    Note: Prev. ed.: Problem solving in chemical engineering with numerical methods. Upper Saddle River, NJ : Prentice Hall PTR, 1999. - Includes bibliographical references and index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 15
    Online Resource
    Online Resource
    Berkeley, Calif. : Peachpit Press | Boston, Mass. :Safari Books Online
    ISBN: 9780321492388 , 0321492382
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Business ; Computer programs ; Electronic books ; local
    Abstract: Microsoft Excel is the world's most-popular spreadsheet program--used by schools, offices, and home users. In Excel 2007, Microsoft has completely redesigned the user interface, making it more intuitive and more attractive. But anyone needing to get started quickly without learning all the ins and outs of the software still needs a handy guide. And with Creating Spreadsheets and Charts in Microsoft Excel 2007: Visual QuickProject Guide they've got one. Excel expert Maria Langer walks readers through the new interface and teaches them the tools they will use throughout the project. From there, she helps them create their first workbook, using formulas, adding formatting, adding a visually rich chart. Readers also learn how to effectively print their spreadsheets and charts--something that's much more confusing than it sounds! Along the way all readers will learn how to create attractive, professional, and effective Excel documents. Each book in the Visual QuickProject Guide series now has a companion website featuring sample project files--making it even easier for users to work through each project as they read through the book. Other features on the companion website may include articles on getting the most out of the topic, a database of frequently asked questions, excerpts from the book, general tips, and more.
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 16
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596528329 , 9780596528324
    Language: English
    Series Statement: For starters
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Business ; Computer programs ; Electronic books ; local
    Abstract: Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to: Build spreadsheets Add and format information Print reports Create charts and graphics Use basic formulas and functions and more The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate. Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 17
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596527594 , 9780596527594
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Business ; Computer programs ; Electronic books ; local
    Abstract: Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them. Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 18
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596007663
    Language: English
    Pages: 1114 p , ill.
    Keywords: Microsoft Excel (Computer file) ; Microsoft Visual Basic for applications ; Microsoft .NET Framework ; Electronic books ; local
    Abstract: 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.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 19
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596100736
    Language: English
    Pages: 262 p
    Keywords: Microsoft Excel (Computer file) ; Commercial statistics ; Computer programs ; Electronic books ; local
    Abstract: As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don't know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues. Aimed primarily at experienced Excel users, the book doesn't spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following: Statistics Pivot tables Workload forecasting Modeling Measuring quality Monitoring complex systems Queuing Optimizing Importing data If you feel as though you're getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 20
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596008791
    Language: English
    Pages: 442 p
    Keywords: Microsoft Excel (Computer file) ; Databases ; Electronic books ; local
    Abstract: Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 21
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    ISBN: 078973611X , 9780789736116
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Electronic books ; local
    Abstract: Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version of Microsoft best-selling spreadsheet program. The author, "Mr. Excel " introduces you to the new interface, allowing you to quickly get back up-to-speed in performing your job, and will then introduce the powerful new features available in Excel 2007. Among other skills, you will learn how to create amazing data visualizations using conditional formatting and in-cell data bars. This is the only book you need on Microsoft Office Excel 2007! " Excel 2007 is the biggest, most exciting release of Excel ever. This book's straightforward approach explains the most important features of Excel 2007 in a thorough, easy-to-understand format. Further, it clearly compares older versions of Excel with Excel 2007, which makes for a seamless transition to this newest version of the program. It is a must-have desk reference for today's business professional." -David Gainer, Group Program Manager, Microsoft Excel THE ONLY EXCEL BOOK YOU NEED We crafted this book to grow with you, providing the reference material you need as you move toward Excel proficiency and use of more advanced features. If you buy only one book on Excel, Special Edition Using Microsoft® Office Excel® 2007 is the book you need. Does your life play out in a spreadsheet? Do numbers in columns and rows make or break you in the work world? Tired of having numbers kicked in your face by other Excel power users who make your modest spreadsheets look paltry compared to their fancy charts and pivot tables? If you answered yes to any of these questions, Special Edition Using Microsoft® Office Excel® 2007 is the bookthat will make it all better. Learn quickly and efficientlyfrom a true Excel master using the tried and true SpecialEdition Using formula for success. Here, you'll findinformation that's undocumented elsewhere-even inMicrosoft's own Help systems. You'll learn from finelycrafted, real-life examples built by an author who livesand dies by the integrity of his spreadsheets. Excel's backbone is its formulas and functions. Master those and you will master your spreadsheets. Special Edition Using Microsoft Office® Excel® 2007 provides more down and dirty help with your formulas and functions than you'll find in any other book! See how it's done in real life! Don't settle for lame pivot table and chart examples found in other books... This book provides beautifully detailed examples that not ...
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 22
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    ISBN: 0789736012 , 9780789736017
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic books ; local
    Abstract: This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours. Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability; quickly create analysis comparing sales this period to last period by product or region or both; easily summarize daily transactional data by month or quarter or year in a few mouse clicks-all without knowing any formulas! By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks. • Take advantage of the numerous pivot table recipes • Create powerful summary reports in seconds • Build ad-hoc query tools with ease • Enhance your Executive Reporting • Filter reports to top 10 customers or products • Add dynamic charts to reports • Quickly summarize daily data by month, quarter, or year Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 2 Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21 3 Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45 4 Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83 5 Performing Calculations Within Your Pivot Tables . . . . . . . . 117 6 Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141 7 Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167 8 Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189 9 Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201 10 Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215 11 Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231 12 Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291 A Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 23
    Online Resource
    Online Resource
    Indianapolis, Ind. : Que | Boston, Mass. :Safari Books Online
    ISBN: 078973642X , 9780789736420
    Language: English
    Keywords: Microsoft Excel (Computer file) ; Business ; Computer programs ; Electronic spreadsheets ; Electronic books ; local
    Abstract: How to use • Create workbooks more efficiently using a new results-oriented interface • Use data-analysis tools and techniques for better decision making • Use organizing, processing, and presenting tools to create data in Excel • Integrate data from external sources and add hyperlinks • Use conditional formatting to visualize results • Add impact to your data with PivotTable and PivotChart reports • Create organizational data reporting and publishing solutions • Organize information and add impact with clip art, SmartArt diagrams, tables, and charts • Use Groove and SharePoint Team Services to collaborate and share documents and information • Prepare for the Microsoft Certified Application Specialist (MCAS) exam • Practice your new skills with the useful workshops inside On the Web This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The Excel example files that you need for project tasks are available at www.perspection.com. Perspection has written and produced books on a variety of computer software-including Microsoft Office 2003 and XP, Microsoft Windows XP, Apple Mac OS X Panther, Adobe Photoshop CS2, Macromedia Flash 8, Macromedia Director MX, and Macromedia Fireworks-and Web publishing. In 1991, after working for Apple Computer and Microsoft, Steve Johnson founded Perspection, Inc. Perspection is committed to providing information and training to help people use software more effectively. Perspection has written more than 80 computer books, and sold more than 5 million copies. Includes MCAS Exam Objectives! This courseware meets the objectives for the Microsoft Certified Application Specialist (MCAS). Upon completion of this courseware, you may be prepared to take the exam for MCAS qualification. To learn more about becoming a Microsoft Certified Application Specialist, visit www.microsoft.com. Introduction xvii Chapter 1 Getting Started with Excel 1 Chapter 2 Basic Workbook Skills 35 Chapter 3 Working with Formulas and Functions 71 Chapter 4 Modifying Worksheets and Workbooks 109 Chapter 5 Formatting a Worksheet 131 Chapter 6 Viewing and Printing Worksheets and Workbooks 169 Chapter 7 Inserting and Modifying Graphics 185 Chapter 8 Drawing and Modifying Shapes 225 Chapter 9 Cr...
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 24
    Online Resource
    Online Resource
    Sebastopol, Calif. : Pogue Press/O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596101546
    Language: English
    Pages: 396 p , ill.
    Keywords: Microsoft Excel (Computer file) ; Electronic spreadsheets ; Computer programs ; Electronic books ; local
    Abstract: 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. Utterly practical and refreshingly funny, this down-to-earth guide gives you nothing more (and nothing less) than what you need to make Excel do exactly what you want it to do. It's a quick read you'll want to keep on hand for reference again and again.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
  • 25
    Online Resource
    Online Resource
    Sebastopol, Calif. : O'Reilly | Boston, Mass. :Safari Books Online
    ISBN: 0596009739
    Language: English
    Pages: 232 p , ill.
    Keywords: Microsoft Excel (Computer file) ; Microsoft Access ; Database management ; Electronic books ; local
    Abstract: 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 documentation 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 With Integrating Excel and Access , you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.
    Note: Includes index
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...