Excel Quick and Easy

Michael Alexander , Dick Kusleika 지음

Wiley 2025년 04월 29일 출간

작품소개

책소개

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 confidentl

목차

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

출판사 서평

작가정보

저자(글) Michael Alexander

저자(글) Dick Kusleika