Schweitzer Fachinformationen
Wenn es um professionelles Wissen geht, ist Schweitzer Fachinformationen wegweisend. Kunden aus Recht und Beratung sowie Unternehmen, öffentliche Verwaltungen und Bibliotheken erhalten komplette Lösungen zum Beschaffen, Verwalten und Nutzen von digitalen und gedruckten Medien.
A fast, up-to-date, and convenient desk reference for Excel users of any skill level
Drawn from the most important tasks in the latest bestselling Excel Bible , Excel Quick and Easy is your ticket to data mastery. Excel veterans Michael Alexander and Dick Kusleika distil the most essential and useful tasks you need to understand about the world's most popular spreadsheet program, from functions to charts, graphs, formulas and more.
Prepare for a whirlwind tour of Excel, packed with simple and step-by-step guides to common and lesser-known Excel features. This book shows you how to:
The secret weapon in your productivity arsenal
Being great at Excel is quickly becoming a standard expectation for a ton of employers and organizations, in all sorts of industries. Sharpening your skills can boost your workplace performance and make it easier to land promotions or find new roles. Excel Quick and Easy makes it a breeze to develop the proficiencies that help you stand out from your peers.
Unique features of this book
Excel Quick and Easy is the perfect reference for brand-new Excel users trying to get up-to-speed quickly and confidently. It's also a must-read for anyone migrating from another spreadsheet program, like Google Sheets, or more experienced Excel users who need to solidify and improve their skills.
If you're tired of stumbling through your spreadsheets and just "surviving" in Excel, grab a copy of Excel Quick and Easy and supercharge your productivity. You'll refine your understanding of the basics, learn brand-new skills and features, and become the Excel expert that every office desperately needs.
MICHAEL ALEXANDER is a senior consultant at Slalom Consulting with more than 15 years' experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.
DICK KUSLEIKA has been working with Microsoft Office for more than 20 years. He was formerly a Microsoft MVP, having been awarded 12 consecutive years. Dick has written several books about Excel and Access.
Chapter 1: Introducing Excel 1
Understanding What Excel Is Used For 1
Understanding Workbooks and Worksheets 2
Moving Around a Worksheet 3
Chapter 2: Creating Your First Excel Workbook 7
Getting Started on Your Worksheet 7
Filling In the Month Names 7
Entering the Sales Data 8
Formatting the Numbers 9
Making Your Worksheet Look a Bit Fancier 10
Summing the Values 11
Creating a Chart 11
Printing Your Worksheet 12
Saving Your Workbook 12
Chapter 3: Entering and Editing Worksheet Data 15
Exploring Data Types 15
Entering Text and Values into Your Worksheets 17
Entering Dates and Times into Your Worksheets 19
Modifying Cell Contents 20
Chapter 4: Introducing Formulas and Functions 31
Understanding Formula Basics 31
Entering Formulas into Your Worksheets 38
Editing Formulas 43
Using Cell References in Formulas 44
Chapter 5: Moving Beyond Formula Basics 49
Introducing Formula Variables 49
Correcting Common Formula Errors 52
Using Advanced Naming Techniques 54
Working With Formulas 59
Chapter 6: Performing Basic Worksheet Operations 61
Learning the Fundamentals of Excel Worksheets 61
Working With Rows and Columns 69
Chapter 7: Working with Excel Ranges 75
Understanding Cells and Ranges 75
Copying or Moving Ranges 85
Using Names to Work with Ranges 97
Chapter 8: Working with Tables 103
Understanding a Table's Structure 103
Creating a Table 105
Adding Data to a Table 106
Sorting and Filtering Table Data 107
Changing the Table's Appearance 113
Using Formulas in Tables 116
Chapter 9: Formatting Worksheets 121
Getting to Know the Formatting Tools 121
Formatting Your Worksheet 124
Using Named Styles for Easier Formatting 135
Understanding Document Themes 139
Chapter 10: Using Conditional Formatting 145
Specifying Conditional Formatting 145
Using Graphical Conditional Formats 146
Creating Formula-Based Rules 150
Conditional Formatting Formula Examples 152
Working with Conditional Formats 155
Chapter 11: Getting Started with Excel Charts 157
What Is a Chart? 157
Basic Steps for Creating a Chart 164
Modifying and Customizing Charts 170
Chapter 12: Understanding Chart Types 175
Choosing a Chart Type 175
Newer Chart Types for Excel 187
Chapter 13: Printing Your Work 197
Doing Basic Printing 197
Changing Your Page View 198
Adjusting Common Page Setup Settings 202
Adding a Header or a Footer to Your Reports 211
Appendix: Excel Keyboard Shortcuts 215
Dateiformat: PDFKopierschutz: Adobe-DRM (Digital Rights Management)
Systemvoraussetzungen:
Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist. Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.
Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!
Weitere Informationen finden Sie in unserer E-Book Hilfe.
