- Table View
- List View
Excel 2010 Basic Student Manual, First Look Edition
by Axzo PressExcel 2010 Basic Student Manual First Look Edition
Excel 2010 All-in-One For Dummies
by By Greg HarveyA comprehensive, up-to-date, user-friendly guide to Excel 2010 Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA. Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface For Dummies books are the bestselling guides to Excel, with more than three million copies sold Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA. Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.
Excel 2010: The Missing Manual (The\missing Manual Ser.)
by Matthew MacdonaldExcel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Excel 2007 VBA Programming For Dummies
by John Walkenbach Jan Karel PieterseStep-by-step instructions for creating VBA macrosHarness the power of VBA and create custom Excel applicationsMake Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.Discover how toGrasp essential programming conceptsUse the Visual Basic EditorNavigate the new Excel user interfaceCommunicate with your usersDeal with errors and bugs
Excel© 2007 VBA Programmer's Reference
by John GreenThis book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency--that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf #2)
by John WalkenbachThis 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 world’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.
Excel 2007 Pocket Guide, 2nd Edition
by Curt FryeMoving 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 is 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.
Excel 2007 Pocket Guide, 2nd Edition
by Curtis FryeMoving 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.
Excel 2007 Pocket Guide
by Curtis D. FryeMoving 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 toolsA section designed to give beginners enough information to dive right in and start creating rich Excel workbooks immediatelyQuick answers about how to perform specific tasks in Excel, such as working with files, editing data, formatting, summarizing and displaying dataConvenient techniques for connecting data across worksheets and projectsHelp 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.
Excel 2007 PL. Nieoficjalny podr?cznik
by Matthew MacDonaldKompletny podr?cznik dla u?ytkowników Excela -- odpowiedzi na wszystkie pytania w jednym miejscu Chcesz dowiedzie? si?, do czego s?u?š setki podstawowych i zaawansowanych funkcji Excela? Chcesz pozna? przydatne sztuczki znacznie przyspieszajšce prac?? Chcesz nauczy? si? wykonywa? z?o?one operacje na danych? Excel od wielu lat wyznacza standardy w dziedzinie arkuszy kalkulacyjnych i jest zdecydowanie najpopularniejszym produktem tego typu. Tak te? jest w przypadku najnowszej wersji, Excel 2007, która udost?pnia przebudowany i wygodniejszy interfejs, efektywniejsze wykresy czy nowe narz?dzia do zarzšdzania danymi. Jednak pomimo wielu wyda? program ten nie doczeka? si? kompletnego podr?cznika u?ytkownika, który opisywa?by zarówno jego podstawowe, jak i zaawansowane funkcje oraz umo?liwia? wykorzystanie pe?ni jego mo?liwo?ci. "Excel 2007. Nieoficjalny podr?cznik" ma wype?nia? luk? w obszarze wszechstronnych omówie? tego popularnego programu. Dzi?ki tej ksiš?ce krok po kroku poznasz zmieniony interfejs i nowe funkcje Excela 2007, a tak?e zaczniesz sprawnie porusza? si? w tej aplikacji. Dowiesz si?, jak efektywnie zarzšdza? informacjami, formatowa? komórki czy wykonywa? obliczenia o ró?nym poziomie z?o?ono?ci. Zobaczysz, jak tworzy? atrakcyjne i przejrzyste wykresy oraz stosowa? zaawansowane techniki analizy danych. Nauczysz si? tak?e wielu praktycznych sztuczek, które w znacznym stopniu przyspieszajš wykonywanie operacji w Excelu 2007. Przeglšd interfejsu Excela 2007 Zarzšdzanie danymi, arkuszami i skoroszytami Formatowanie komórek Wykonywanie oblicze? matematycznych i finansowych Manipulowanie datami, czasem i tekstem Tworzenie i poprawianie z?o?onych formu? Zaawansowana obs?uga i analiza danych Tworzenie szablonów i korzystanie z nich Generowanie efektownych wykresów Wspó?praca z bazami danych i innymi programami Programowanie w Excelu Poznaj mo?liwo?ci Excela 2007 i wygodnie zarzšdzaj informacjami zarówno w biurze, jak i w domu.
Excel 2007 PL. Leksykon kieszonkowy. Wydanie II
by Curt FryePodr?czne kompendium wiedzy dla u?ytkowników ExcelaExcel nale?y do grupy tych aplikacji, których u?ytkownicy wykorzystuj? niewielk? cz??? mo?liwo?ci, nie zdaj?c sobie sprawy, jak ogromny potencja? narz?dzia pozostaje jeszcze nieodkryty. Program kojarzy si? z grupowaniem danych, tworzeniem zestawie? i wykresów, wystawianiem faktur i rachunków. Jednak Excel to znacznie wi?cej. Ogrom jego mo?liwo?ci powinno odkrywa? si? z grub? ksi?g? zawieraj?c? opisy narz?dzi oferowanych przez t? aplikacj?, ale w codziennej pracy opas?e tomiska okazuj? si? kompletnie niepraktyczne W takich sytuacjach nieocenion? pomoc? staj? si? podr?czne zestawienia najwa?niejszych wiadomo?ci.Ksi??ka "Excel 2007 PL. Leksykon kieszonkowy. Wydanie II" to w?a?nie takie zestawienie. Zebrano w niej najistotniejsze dla u?ytkownika informacje dotycz?ce najnowszej wersji Excela, nosz?cej oznaczenie 2007. Czytaj?c j?, poznasz nowy interfejs u?ytkownika, budow? dokumentów Excela i narz?dzia autokorekty. Nauczysz si? wprowadza? dane, formatowa? je i wykorzystywa? do oblicze?. Skorzystasz z przydatnych funkcji i formu?, stworzysz wykresy i prawid?owo wydrukujesz arkusz na drukarce. Przeczytasz tak?e o tabelach przestawnych, sterowaniu sposobem wy?wietlania danych i publikowaniu arkuszy w sieci.Interfejs u?ytkownikaPasek narz?dziStruktura dokumentu ExcelaPraca z plikamiDrukowanieWprowadzanie i formatowanie danychFormu?y i funkcjeWykresyTabele przestawnePracuj efektywniej. Korzystaj z praktycznych porad zebranych w jednej, por?cznej ksi??ce.
Excel 2007 PivotTables and PivotCharts
by Paul McfedriesWelcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 130 key techniques for working with PivotTables and PivotCharts, including: Building PivotTables from Excel ranges Customizing PivotTable field lists Converting PivotTables to regular data Grouping numeric, text, or date/time values Developing various summary calculations Turning a PivotTable into a PivotChart Displaying data tables with a PivotChart Creating an OLAP cube data source Exporting Access(r) PivotTable(r) forms to Excel Using Microsoft Query with PivotTables EXTRA Apply It "Apply It" and "Extra" sidebars highlight useful tips High-resolution screen shots demonstrate each task Succinct explanations walk you through step by step Two-page lessons break big topics into bite-sized modules
Excel 2007 for Social Science Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach social science statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. <P> Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in social science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2007 for Social Science Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.<P><P> Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2007 for Educational and Psychological Statistics
by Thomas J QuirkThis is the first book to show the capabilities of Microsoft Excel to teach educational and psychological statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical problems using statistics. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and practitioners, is also an effective teaching and learning tool for quantitative analyses in courses in education and psychology. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2007 for Educational and Psychological Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand statistics problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2007 For Dummies (For Dummies Computers Ser.)
by Greg HarveyOne look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done. You’ll discover how to: Rearrange, delete and insert new information Keep track of and organize data in a single worksheet Transfer data between the sheets of different workbooks Create a chart using the data in a worksheet Add hyperlinks and graphics to worksheets And more! Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.
Excel 2007 for Biological and Life Sciences Statistics
by Meghan Quirk Thomas J Quirk Howard HortonThis is the first book to show the capabilities of Microsoft Excel to teach biological and life sciences statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical science problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in science courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2007 for Biological and Life Sciences Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand science problems. Practice problems are provided at the end of each chapter with their solutions in an appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Excel 2007 Data Analysis For Dummies
by Stephen L. NelsonShows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentationsNow revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XMLProvides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more
Excel 2007 Dashboards and Reports For Dummies
by Michael AlexanderWhat's the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You'll find out when you see the dazzling examples in Excel 2007 Dashboards & Reports For Dummies. And, before long, everyone's eyes will be riveted to your dashboards and reports too!This revolutionary guide shows you how to turn Excel into your own personal Business Intelligence tool. You'll learn the fundamentals of using Excel 2007 to go beyond simple tables to creating dashboard-studded reports that wow management. Get ready to catch dashboard fever as you find out how to use basic analysis techniques, build advanced dashboard components, implement advanced reporting techniques, and import external date into your Excel reports. Discover how to:Unleash the power of Excel as a business intelligence toolCreate dashboards that communicate and get noticedThink about your data in a new wayPresent data more effectively and increase the value of your reportsCreate dynamic labels that support visualizationRepresent time and seasonal trendingGroup and bucket dataDisplay and measure values versus goalsImplement macro-charged reportingUsing Excel 2007 as a BI tool is the most cost-efficient way for organizations of any size create powerful and insightful reports and distribute throughout the enterprise. And Excel 2007 Dashboards and Reports for Dummies is the fastest you for you to catch dashboard fever!
Excel 2007 Charts
by John WalkenbachExcel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a. Mr. Spreadsheet, clearly explains all these charting features and shows you how to choose the right chart for your needs. You'll learn to modify data within the chart, deal with missing data, format your chart, use trend lines, construct "impossible" charts, create charts from pivot tables, dress them up with graphics, and more.Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Excel 2007 Bible (Bible #358)
by John WalkenbachThis 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.
Excel 2007 All-In-One Desk Reference For Dummies
by Greg HarveyMaster the Ribbon, powerful graphics capabilities, and more! Your one-stop guide to great-looking spreadsheets that actually mean something Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more! Discover how to Create dynamic spreadsheets with style galleries Work with more than 40 new cell styles Automate formatting with Live Preview Share Excel data with other programs Use VBA to write custom Excel functions
Excel 2007 All-In-One Desk Reference For Dummies
by Greg HarveyMaster the Ribbon, powerful graphics capabilities, and more!Your one-stop guide to great-looking spreadsheets that actually mean somethingCreate colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!Discover how toCreate dynamic spreadsheets with style galleriesWork with more than 40 new cell stylesAutomate formatting with Live PreviewShare Excel data with other programsUse VBA to write custom Excel functions
Excel® 2007: Top 100 Simplified® Tips & Tricks
by Denise EtheridgeYou already know Excel 2007. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteedto make you more productive with Excel 2007. * Minimal text and maximum illustrations * Task-oriented, step-by-step approach * Navigational aids connect instructions to illustrations * Self-contained, two-page lessons * Uniform layout makes it easy to read less, learn more How easy is it? Look for these symbols marking the difficulty of each task. * Demonstrates a new spin on a common task * Introduces a new skill or a new task * Combines multiple skills requiring in-depth knowledge * Requires extensive skill and may involve other technologies
Excel 2007: The Missing Manual
by Matthew MacdonaldMicrosoft 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.
Excel 2007: The Missing Manual (The\missing Manual Ser.)
by Matthew MacdonaldMicrosoft 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.