Excel 2002 für Dummies

Author: Greg Harvey

Publisher: Wiley-VCH

ISBN: 9783527700523

Category: Computers

Page: 352

View: 7390

Sie haben keine blasse Ahnung von Tabellenkalkulationen, möchten aber Ihre Zahlen endlich in den Griff bekommen? Oder zählen Sie zu diesen Excel-begeisterten Buchhaltern, die mit Spannung auf die neuen Features der 2002er Version warten, um Ihren Chef mal wieder zu beeindrucken? In diesem Buch führt Sie Greg Harvey Schritt für Schritt in die Welt der Tabellen-kalkulation ein und demonstriert Ihnen das grandiose Organisationstalent von Excel 2002: unterschiedliche Datentypen zusammenstellen, Berechnungen durchführen, anschauliche Diagramme fabrizieren. Sie erfahren: * Wo der Unterschied zwischen Arbeitsmappen und Arbeitsblättern liegt * Wie Sie Ihre eigenen Tabellenblätter erstellen, bearbeiten, formatieren und drucken * Wie Sie aus Excel direkt Tabellen, Arbeitsblätter und Mappen per E-Mail versenden können * Wie Sie Ihre Excel-Tabelle auf der Website Ihres Unternehmens veröffentlichen * Welche neuen Features Excel 2002 zu bieten hat: ClipArts in Ihr Tabellenblatt einfügen, Webseiten in Excel bearbeiten u.v.a.m. * Wie Sie Daten und Texte aus allen Office XP-Programmen in Ihr Excel-Sheet integrieren

Excel 2010 For Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 1118332156

Category: Computers

Page: 216

View: 6118

Crunch numbers, create spreadsheets, and get up to speed on Excel 2010! This friendly book gets you started with the basics of Excel 2010, such as creating a spreadsheet from scratch, selecting commands from the Ribbon, customizing the Quick Access toolbar, creating simple formulas, moving and copying data with drag and drop, using the AutoCorrect and AutoFill features, and more. Navigate effectively — see how the Ribbon interface and the Backstage View give you access to all the tools you need for every task Be a mover and a shaker — move and copy data with cut, copy, and paste or drag and drop Summing up — total columns and rows of numbers with the AutoSum button Making it pretty — format data tables, adjust column widths and row heights, hide columns and rows, and format with Styles or the Format Painter Safety net — save your work and recover spreadsheets after a computer crash Open the book and find: What's new in Excel 2010 How to surf an Excel 2010 worksheet and workbook Instructions for entering data in a worksheet Tips for keeping your data secure How to enter and edit formulas with built-in functions Tips for undoing or deleting data entry mistakes Learn to: Get comfortable with Excel 2010 and Backstage View Create and edit spreadsheets Format cells, create formulas, and fix data entry errors Copy, cut, move, paste, or delete data

Excel 2010 For Dummies Quick Reference

Author: Colin Banfield,John Walkenbach

Publisher: John Wiley & Sons

ISBN: 9780470871997

Category: Computers

Page: 240

View: 1908

Find the answers to your most important Excel questions with this reference John Walkenbach’s name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach—along with Excel expert Colin Banfield—answers your most common and important Excel questions in this easy-to-understand reference. You'll learn how to open, save, protect, and recover workbook files; add, copy, and delete worksheets; enter and edit data and text; create formulas and functions; audit, format, and print; and more. Highly organized and free of unnecessary jargon, this essential reference allows you to find the answers you’re looking for quickly and easily. Excel gurus Walkenbach and Banfield offer quick and easy answers to common Excel questions Offers information in a highly organized, easy-to-understand format so you can find exactly what you need Includes information on opening, saving, protecting and recovering workbook files; adding, copying, and deleting worksheets; entering and editing data and text; creating formulas and functions; auditing; formatting; printing; and more Covers navigating the user interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more Excel 2010 For Dummies Quick Reference enables you to spend more time working on your projects rather than trying to figure how to make Excel work for you!

Excel 2010 All-in-One For Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 0470489596

Category: Computers

Page: 792

View: 4633

A 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 Workbook For Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 9780470904763

Category: Computers

Page: 408

View: 8805

Reinforce your understanding of Excel with these Workbook exercises Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency. Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you. Excel is the world's most popular number-crunching program, and For Dummies books are the most popular guides to Excel The Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidance This guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial planners Also provides exercises on using formulas and functions, managing and securing data, and performing data analysis A companion CD-ROM includes screen shots and practice materials Excel 2010 Workbook For Dummies helps you get comfortable with Excel so you can take advantage of all it has to offer. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Excel 2010 For Dummies eBook Set

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 1118604725

Category: Computers

Page: 1824

View: 4511

Two complete e-books covering beginning- to intermediate-level Excel for one low price! This unique value-priced e-book set brings together two bestselling For Dummies books in a single e-book file. Including a comprehensive table of contents and the full text of each book, complete with cover, this e-book set gives you in-depth information on Excel from basic worksheet creation to data management, data analysis, and VBA programming for custom applications. Best of all, you'll pay less than the cost of each book purchased separately. You'll get the complete text of: Excel 2010 All-in-One For Dummies, which covers Navigating the interface, customizing Excel, and using Backstage View Building, formatting, editing, proofing, managing, and printing worksheets Using formulas and functions Creating charts, sorting and filtering data, and performing what-if analysis Excel 2010 VBA Programming For Dummies, 2nd Edition, which shows you how to Use the essential tools and operations for Visual Basic for Applications Work with range objects and control program flow Handle errors and eliminate bugs in your code Develop custom user interfaces for your applications, including dialog boxes About the authors Greg Harvey, author of Excel 2010 All-in-One For Dummies, is an experienced educator and the author of all editions of Excel For Dummies. John Walkenbach, author of Excel 2010 VBA Programming For Dummies, is a leading authority on spreadsheet software and the author of more than 50 books on Excel, including Excel Bible.

Excel Formeln und Funktionen für Dummies

Author: Ken Bluttman

Publisher: John Wiley & Sons

ISBN: 3527802533

Category: Computers

Page: 399

View: 5234

In Excel 2016 gibt es mehr als 400 Funktionen, von ABRUNDEN bis ZZR. Aber welche der vielen Funktionen erleichtert Ihnen Ihre Arbeit? Wie setzen Sie die Funktionen richtig ein? Wie lautet die Syntax? Dieses Buch stellt Excel-Einsteigern die 150 nï¿1⁄2tzlichsten Excel-Funktionen ausfï¿1⁄2hrlich vor. Der richtige Gebrauch wird anhand von Alltagsbeispielen deutlich. Hier sind nur drei: Lï¿1⁄2schen Sie ï¿1⁄2berflï¿1⁄2ssige und unschï¿1⁄2ne Leerzeichen in Ihren Tabellen, analysieren Sie die Leistungsverteilung in einer Schulklasse (oder einem Verkaufsteam), vergleichen Sie Kredite mit unterschiedlichen Laufzeiten und ermitteln Sie mit ZZR die Anzahl der Zahlungsperioden bei einer vorgegebenen Rï¿1⁄2ckzahlungsrate.

Excel 2016 für Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 3527802304

Category: Computers

Page: 389

View: 9785

Man denkt zuerst an Excel, wenn man an Tabellen denkt, zumindest wenn man sie auf dem Computer erstellt. Greg Harvey stellt Ihnen in diesem Buch die neue Version des Tabellenkalkulationsprogramms vor. Er f?hrt Sie Schritt f?r Schritt in die Welt der Tabellen, Diagramme, Formeln und Funktionen ein und gibt Ihnen zahlreiche Tipps und Tricks an die Hand, wie Sie Ihre Arbeit mit Excel so effizient wie m?glich gestalten k?nnen. Dank dieser gelungenen Anleitung kommen Excel-Neulinge und Umsteiger auf die Version 2016 schnell und sicher mit dem Programm zurecht.

Excel 2010 ELearning Kit For Dummies

Author: Faithe Wempen

Publisher: John Wiley & Sons

ISBN: 111811079X

Category: Computers

Page: 368

View: 992

Master the leading spreadsheet and data analysis tool with this book-and-CD package! Learn step by step to create worksheets, work with formulas and functions, format data, use financial functions, and more.

Excel 2010 Just the Steps For Dummies

Author: Diane Koers

Publisher: John Wiley & Sons

ISBN: 9780470622896

Category: Computers

Page: 240

View: 7621

Pick your Excel task, find it fast, and get it done with Just the Steps! If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one place—no flipping pages! Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, building macros, integrating Excel into other Office programs, and—whew!—still more. Explains essentials tasks for Excel 2010, the spreadsheet application that is part of the Microsoft Office 2010 suite Shows you just the steps for numerous Excel tasks using an easy-to-follow, two-column page layout, with step-by-step instruction on one side and illustrations and screenshots on the other Covers entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, and building macros Walks you step by step through collaborating in Excel and integrating or using Excel with Word, PowerPoint, and Access Make your tasks easier, improve your Excel skills, and get better results with this step-by-step guide.

Office 2010 für Dummies

Author: Wallace Wang

Publisher: John Wiley & Sons

ISBN: 3527639012

Category: Computers

Page: 427

View: 1366

Wenn Sie Ihren Schreibtisch nicht unbedingt mit riesigen W?lzern zustapeln wollen, sondern eine kurze Einf?hrung in das Office 2010-Paket suchen, ist dies das richtige Buch f?r Sie. Bestseller-Autor Wallace Wang erkundet mit Ihnen die f?nf beliebten Office 2010-Programme und stellt Ihnen s?mtliche Neuerungen vor. Sie werden staunen, wie schnell Sie mit der neuen Benutzeroberfl?che zurechtkommen und wie leicht Sie Office nun an Ihre Bed?rfnisse anpassen k?nnen. Erstellen Sie ?bersichtliche Dokumente, packende Pr?sentationen, n?tzliche Tabellen und informative Datenbanken - kurz: Organisieren Sie Ihr Office! - Wie Sie sich mit dem Men?band in Office 2010 bewegen und in der Backstage-Ansicht alles im Blick haben - Wie Sie Ihre Texte in Form bringen: Formatvorlagen, Designs, Effekte & Co. - Wie Sie Daten grafisch darstellen und neueste Trends mithilfe von Sparklines schnell erkennen - Wie Ihnen die neuen Datenbankvorlagen die Arbeit erleichtern - Wie Sie Kontakte und Termine optimal in Outlook managen

Word 2010 für Dummies

Author: Dan Gookin

Publisher: John Wiley & Sons

ISBN: 352763889X

Category: Computers

Page: 397

View: 548

Mit Word 2010 kann man mehr als nur Texte verfassen. Der Bestsellerautor Dan Gookin weiht Sie in die Geheimnisse von Word 2010 und in seine neue Benutzeroberfl?che ein. Er zeigt Ihnen Schritt f?r Schritt, wie Sie Texte formatieren und strukturieren, Schriftarten ?ndern, mit Formatvorlagen arbeiten sowie Tabellen einf?gen. Au?erdem verr?t er viele Tricks, wie Sie mit Word noch effektiver arbeiten und welche Abk?rzungen Sie ?ber die Tastatur nehmen k?nnen. Mit diesem Buch kommen Word-Neulinge und Umsteiger auf die Version 2010 schnell und sicher mit diesem Programm zurecht.

Excel 2007 VBA-Programmierung für Dummies

Author: John Walkenbach

Publisher: Wiley-VCH

ISBN: 9783527704118

Category: Computers

Page: 385

View: 9183

Um noch mehr aus Excel herauszuholen, empfiehlt sich die VBA-Programmierung, mit der Sie Excel auf Ihre Bedürfnisse zuschneiden können. John Walkenbach zeigt Ihnen in "Excel 2007 VBA-Programmierung für Dummies", wie Sie Excel-Berechnungen mit VBA automatisieren. Er erklärt Ihnen zunächst die notwendigen VBA-Grundlagen und wichtigsten Werkzeuge sowie VBA-Abläufe des VBA-Editors. Außerdem erhalten Sie eine Übersicht über die wichtigsten Bestandteile und Begriffe, die für die VBA-Programmierung in Excel relevant sind, und Sie erfahren, wie Sie Programmierfehler ausfindig machen und beheben.

iPod & iTunes für Dummies

Author: Tony Bove

Publisher: John Wiley & Sons

ISBN: 3527706038

Category: Computers

Page: 292

View: 7972

Ihr iPod ist so cool wie die Songs, die Sie geladen haben. Aber mal ehrlich: Nutzen Sie die vielen Features, die Ihr iPod Ihnen bietet? Tony Bove und Cheryl Rhodes stellen Ihnen die verschiedenen Modelle vor. Sie zeigen Ihnen, wie Sie Ihren iPod einrichten, iTunes installieren und dann legal Musik herunterladen, Podcasts uploaden oder CDs brennen. Und sollte Ihr iPod mal nicht so wollen wie Sie, erhalten Sie Tipps und Tricks fürs Troubleshooting.

Office 2016 für Dummies Alles-in-einem-Band

Author: Peter Weverka

Publisher: John Wiley & Sons

ISBN: 3527805524

Category: Computers

Page: 839

View: 2419

Sie kï¿1⁄2nnen viel Zeit und Nerven sparen, wenn Sie sich mit Office immer besser auskennen! Grund genug, um sich von Peter Weverka in die Programme und die Funktionen von Office 2016 einfï¿1⁄2hren zu lassen. Sie finden in diesem umfassenden Werk ï¿1⁄2bersichtliche Anleitungen fï¿1⁄2r die tï¿1⁄2glichen Aufgaben mit Office und vielfï¿1⁄2ltige Tipps und Anregungen, die Ihnen helfen, Ihre Arbeit effektiver zu gestalten. Das Buch ist ï¿1⁄2bersichtlich strukturiert, sodass Sie schnell finden, was Sie brauchen. Lernen Sie neben den Grundlagen auch die weiterfï¿1⁄2hrenden Techniken fï¿1⁄2r die wichtigsten Office-Programme kennen: Word, Excel, PowerPoint, OneNote, Outlook, Access und Publisher.

Project 2010 For Dummies

Author: Nancy C. Muir

Publisher: John Wiley & Sons

ISBN: 0470871970

Category: Computers

Page: 432

View: 3413

A friendly reference guide to Microsoft Project, the leading enterprise project management software As project management software, Microsoft Project allows you to oversee your business activities effectively. You can manage resources, share project info, perform modeling and scenario analysis, and standardize reporting processes. This easy-to-understand guide is completely updated to cover the latest changes and newest enhancements to Project 2010 and shows you how to get Project 2010 to work for you. After an introduction to basic project management concepts, you’ll discover the mechanics of using Project software to create and manage projects. Other topics covered include working with calendars, using and sharing resources, budgeting, formatting taskbars, gathering and tracking data, working with reports, and creating templates. Microsoft Project allows you to manage resources, share project information, perform scenario analysis, and standardize reporting processes Offers completely updated coverage of the new Project 2010, which is expected to implement the Office Ribbon Reviews formatting taskbars, gathering and tracking data, and working with reports Addresses using and sharing resources, creating templates, and managing projects Let the friendly For Dummies writing style guide you through maximizing the new features of Project 2010.

Excel 2010 Basics and Advanced For Dummies eLearning Course Access Code Card (6 Month Subscription)

Author: Faithe Wempen

Publisher: For Dummies

ISBN: 9781118446324

Category: Computers

Page: N.A

View: 1176

**The purchase of this card includes an access code that is entered and fulfilled at the For Dummies eLearning Center. You will receive access to the course for six (6) months from date of access code entry. Details are inside the card. For Dummies eLearning Courses are the perfect way to get you up-to-speed on a new skill! With integrated audio and video instruction, including screencasts, illustrations, animations, and video, as well as course interactivity to immediately reinforce what you’ve learned, For Dummies is making learning easier. In this complete Basics-to-Advanced course, you’ll learn it all: the basics of creating Excel spreadsheets, creating and using formulas and functions, and formatting worksheets, discovering how worksheets work, how to add and edit content, what formulas and functions do, and how to format your spreadsheet to best demonstrate your data. Moving at your own pace, you’ll go on to create and format several types of Excel charts, present data clearly, store and manage data in tables and lists, work with PivotTables and PivotCharts, and correct, protect, and share your workbook data. In each of the 11 lessons, you’ll find clear, expert instruction, interactive quizzes, hands-on activities, summaries, and a way to review topics so you can progress at your own pace. The course covers: • Creating an Excel worksheet and entering cell content • Understanding workbooks • Adjusting rows and columns and formatting cells • Using formulas and functions such as square roots, sines, cosines, and tangents • Using advanced formatting techniques to make your Excel data accessible • Tackling common financial chores such as calculating loan payments and interest • Applying Excel’s tools for sophisticated data analysis • Creating and formatting PivotTables and PivotCharts • Correcting, protecting, and sharing the data in your workbooks • Tips and tricks to make you more productive

Access 2010 For Dummies

Author: Laurie Ulrich Fuller,Ken Cook

Publisher: John Wiley & Sons

ISBN: 9780470632710

Category: Computers

Page: 456

View: 6274

A friendly, step-by-step guide to the Microsoft Office database application Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily. In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more. As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite Access 2010 For Dummies walks newcomers through building and using their first database Covers linking information in a database, setting relationships, modeling data, and building tables Explores how to extract data from Access and get specific answers, create forms, and export data in reports A section for more experienced users looks at analyzing errors and creating an interface Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application.

Excel 2010 für Dummies

Author: Greg Harvey

Publisher: John Wiley & Sons

ISBN: 352763892X

Category: Computers

Page: 392

View: 5431

Wer an Tabellen denkt, denkt automatisch an Excel, zumindest wenn er sie auf dem Computer erstellt. In diesem Buch stellt Greg Harvey das neue Excel vor, das 2010 auf den Markt kommt. Mit dieser gelungenen Anleitung werden die Leser auch ohne Vorkenntnisse schon bald wundersch?ne Tabellen und Diagramme erstellen k?nnen.