A simple and accurate Excel desk reference for everyone With step-by-step walkthroughs of the most important Excel tasks described in the Excel Bible series, Excel® Quick and Easy is your shortcut to spreadsheet and data mastery. A team of Excel MVPs explain the features that Excel superusers rely on every day, from functions to charts, graphs, formulas, and more. This whirlwind tour of Excel contains easy demonstrations of: * Creating new spreadsheets and workbooks * Entering and editing worksheet data * Making calculations and drawing useful conclusions from your data * Visualizing and…mehr
A simple and accurate Excel desk reference for everyone With step-by-step walkthroughs of the most important Excel tasks described in the Excel Bible series, Excel® Quick and Easy is your shortcut to spreadsheet and data mastery. A team of Excel MVPs explain the features that Excel superusers rely on every day, from functions to charts, graphs, formulas, and more. This whirlwind tour of Excel contains easy demonstrations of: * Creating new spreadsheets and workbooks * Entering and editing worksheet data * Making calculations and drawing useful conclusions from your data * Visualizing and presenting data with intuitive charts and graphs Excel® Quick and Easy is a one-of-a-kind resource that's perfect for people who are completely new to the software, people migrating from Google Sheets and other spreadsheet software, and even more experienced Excel users interested in expanding their skillset. You'll find: * Step-by-step guides to Excel features, tools, and functions you'll use every day, from navigating the interface to crunching numbers * Tips for transforming your Excel data into a compelling story with visualizations, like charts, graphs, and tables, that can be used to persuade and inform * Instructions for using formulas and functions to unlock fresh insights from your Excel spreadsheets Get ready to supercharge your productivity with Excel® Quick and Easy. It's the best way to get up to speed on the basics, learn new skills and features, and become the go-to Excel expert that every workplace is looking for.
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.
Inhaltsangabe
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
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
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Internetauftritt der buecher.de internetstores GmbH
Geschäftsführung: Monica Sawhney | Roland Kölbl | Günter Hilger
Sitz der Gesellschaft: Batheyer Straße 115 - 117, 58099 Hagen
Postanschrift: Bürgermeister-Wegele-Str. 12, 86167 Augsburg
Amtsgericht Hagen HRB 13257
Steuernummer: 321/5800/1497
USt-IdNr: DE450055826