Synopses & Reviews
The worlds most popular spreadsheet program is now more powerful than ever, but its also more complex. Thats where this Missing Manual comes in. With crystal-clear explanations and hands-on examples, Excel 2013: The Missing Manual shows you how to master Excel so you can easily track, analyze, and chart your data. Youll be using new features like PowerPivot and Flash Fill in no time.
The important stuff you need to know:
- Go from novice to ace. Learn how to analyze your data, from writing your first formula to charting your results.
- Illustrate trends. Discover the clearest way to present your data using Excels new Quick Analysis feature.
- Broaden your analysis. Use pivot tables, slicers, and timelines to examine your data from different perspectives.
- Import data. Pull data from a variety of sources, including website data feeds and corporate databases.
- Work from the Web. Launch and manage your workbooks on the road, using the new Excel Web App.
- Share your worksheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn.
- Master the new data model. Use PowerPivot to work with millions of rows of data.
- Make calculations. Review financial data, use math and scientific formulas, and perform statistical analyses.
Excel is the worlds most popular spreadsheet program and the de facto standard for numerical analysis. But this complex program can take a lifetime to learn without the right guide. Thats where Excel 2013: The Missing Manual comes in. With crystal-clear explanations, hands-on examples, and lots of undocumented tips, tricks, and workarounds, this jargon-free book helps you master Excels raft of impressive features.
The important stuff you need to know:
- Go from novice to ace. Learn everything from writing your first formula to analyzing data.
- Perform a variety of calculations. Enter raw data and have Excel perform financial analyses, math operations, and statistical analyses
- Illustrate trends. Bring your data to life using charting, summarizing, and data visualization options in the Quick Analysis feature
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Pinpoint the data you need. Use the handy timeline filter to browse specific date ranges in a mass of pivot table data
- Share your spreadsheets. Store Excel files on SkyDrive and collaborate with colleagues on Facebook, Twitter, and LinkedIn
About the Author
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
Table of Contents
The Missing Credits; About the Author; About the Creative Team; Acknowledgments; The Missing Manual Series; Introduction; What You Can Do with Excel; The New Features in Excel 2013; About This Book; Online Resources; Part 1: Worksheet Basics; Chapter 1: Creating Your First Spreadsheet; 1.1 Starting a Workbook; 1.2 Adding Information to a Worksheet; 1.3 Using the Ribbon; 1.4 Using the Status Bar; 1.5 Going Backstage; 1.6 Saving Files; 1.7 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Handy Timesavers; 2.3 Dealing with Change: Undo, Redo, and AutoRecover; 2.4 Spell-Check; 2.5 Adding Hyperlinks; Chapter 3: Moving Data; 3.1 Selecting Cells; 3.2 Moving Cells Around; 3.3 Adding and Moving Columns or Rows; Chapter 4: Managing Worksheets; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; Chapter 5: Formatting Cells; 5.1 Formatting Cell Values; 5.2 Formatting Cell Appearance; Chapter 6: Smart Formatting Tricks; 6.1 The Format Painter; 6.2 Styles and Themes; 6.3 Conditional Formatting; Chapter 7: Viewing and Printing Worksheets; 7.1 Controlling Your View; 7.2 Printing; 7.3 Controlling Pagination; Part 2: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Functions; 8.3 Formula Errors; 8.4 Logical Operators; 8.5 Formula Shortcuts; 8.6 Copying Formulas; Chapter 9: Math and Statistical Functions; 9.1 Rounding Numbers; 9.2 Groups of Numbers; 9.3 General Math Functions; 9.4 Trigonometry and Advanced Math; 9.5 Advanced Statistics; Chapter 10: Financial Functions; 10.1 The World of Finance; 10.2 Financial Functions; 10.3 Depreciation; 10.4 Other Financial Functions; Chapter 11: Manipulating Dates, Times, and Text; 11.1 Manipulating Text; 11.2 Manipulating Dates and Times; Chapter 12: Lookup, Reference, and Information Functions; 12.1 The Basic Lookup; 12.2 Advanced Lookups; 12.3 Information Functions; 12.4 Tutorial: Generating Invoices from a Product Catalog; Chapter 13: Advanced Formula Writing and Troubleshooting; 13.1 Conditions in Formulas; 13.2 Descriptive Names for Cell References; 13.3 Variable Data Tables; 13.4 Controlling Recalculation; 13.5 Solving Formula Errors; Part 3: Organizing Your Information; Chapter 14: Tables: List Management Made Easy; 14.1 The Basics of Tables; 14.2 Sorting a Table; 14.3 Filtering a Table; 14.4 Dealing with Duplicate Rows; 14.5 Performing Table Calculations; Chapter 15: Grouping and Outlining Data; 15.1 Basic Data Grouping; 15.2 Grouping Timesavers; Chapter 16: Templates; 16.1 Using the Office Online Templates; 16.2 Rolling Your Own Templates; Part 4: Charts and Graphics; Chapter 17: Creating Basic Charts; 17.1 Charting 101; 17.2 Basic Tasks with Charts; 17.3 Practical Charting; 17.4 Chart Types; Chapter 18: Formatting and Perfecting Charts; 18.1 Chart Styles and Layouts; 18.2 Adding Chart Elements; 18.3 Formatting Chart Elements; 18.4 Improving Your Charts; 18.5 Advanced Charting; Chapter 19: Inserting Graphics; 19.1 Adding Pictures to a Worksheet; 19.2 Excel's Clip Art Library; 19.3 Drawing Shapes; 19.4 SmartArt; Chapter 20: Visualizing Your Data; 20.1 Data Bars; 20.2 Color Scales; 20.3 Icon Sets; 20.4 Sparklines; Part 5: Sharing Data with the Rest of the World; Chapter 21: Protecting Your Workbooks; 21.1 Understanding Excel's Safeguards; 21.2 Data Validation; 21.3 Locked and Hidden Cells; Chapter 22: Worksheet Collaboration; 22.1 Your Excel Identity; 22.2 Preparing Your Workbook; 22.3 Distributing Your Workbook; 22.4 Adding Comments; 22.5 Tracking Changes; 22.6 Sharing Your Workbook; 22.7 Reviewing Workbooks with Inquire; Chapter 23: Using Excel on the Web; 23.1 Putting Your Files Online; 23.2 Using the Excel Web App; 23.3 Sharing Your Files; Chapter 24: Exchanging Data with Other Programs; 24.1 Sharing Information in Windows; 24.2 Embedding and Linking Objects; 24.3 Transferring Data; Part 6: Advanced Data Analysis; Chapter 25: Scenarios and Goal Seeking; 25.1 Using Scenarios; 25.2 Using Goal Seek; 25.3 Solver; Chapter 26: Pivot Tables; 26.1 Summary Tables Revisited; 26.2 Building Pivot Tables; 26.3 Multi-Layered Pivot Tables; 26.4 Fine-Tuning Pivot Table Calculations; 26.5 Filtering a Pivot Table; 26.6 Pivot Charts; Chapter 27: Analyzing Databases; 27.1 Excel and Databases; 27.2 Creating a Data Connection; 27.3 The Data Model: Boosting Pivot Tables; Chapter 28: Analyzing XML and Web Data; 28.1 Understanding XML; 28.2 Retrieving Information from XML; 28.3 Creating Web Queries; 28.4 Connecting to Online Data Services with OData; Part 7: Programming Excel; Chapter 29: Automating Tasks with Macros; 29.1 Macros 101; 29.2 The Macro Recorder; 29.3 Macro Security; 29.4 Creating Practical Macros; Chapter 30: Programming Spreadsheets with VBA; 30.1 The Visual Basic Editor; 30.2 Understanding Macro Code; 30.3 Exploring the VBA Language; Part 8: Appendix; Customizing the Ribbon; Adding Your Favorites to the QAT; Personalizing the Ribbon;