Excel Quick and Easy - Dick Kusleika

. .

Résumé :

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:

• Create new spreadsheets and workbooks by entering and editing worksheet data
• Simplify working with large amounts of data by naming and moving ranges
• Make calculations and draw conclusions from your data by using formulas
• Visualize and present your data by creating functional charts

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

• Step-by-step guides to the most commonly used and productive Excel tasks, from basic worksheet operations to formatting spreadsheets for hardcopy printing
• Intuitive explanations for making your data tell a compelling story with visualizations, including charts, graphs, and tables
• Advanced number-crunching techniques, including formulas and functions, that help you unlock fresh insights and new conclusions from your data

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....

Biographie:

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....

Sommaire:

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