Excel 2016 All-in-One For Dummies

Häftad, Engelska, 2015

AvGreg Harvey,California) Harvey, Greg (Mind Over Media, Point Reyes Station

349 kr

Beställningsvara. Skickas inom 7-10 vardagar. Fri frakt för medlemmar vid köp för minst 249 kr.

Your one-stop guide to all things Excel 2016 Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent. Written by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before. Serves as the ideal reference for solving common questions and Excel pain points quickly and easilyHelps to increase productivity and efficiency when working in ExcelFully updated for the new version of ExcelCovers basic and more advanced Excel topicsIf working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again.

Produktinformation

Utgivningsdatum2015-12-04
Mått185 x 234 x 41 mm
Vikt1 066 g
FormatHäftad
SpråkEngelska
Antal sidor816
FörlagJohn Wiley & Sons Inc
ISBN9781119077152

Tillhör följande kategorier

Affärsapplikationer inom Data och IT

Introduction 1Book I: Excel Basics 11Chapter 1: The Excel 2016 User Experience 13Chapter 2: Customizing Excel 2016 43Book II: Worksheet Design 75Chapter 1: Building Worksheets 77Chapter 2: Formatting Worksheets 127Chapter 3: Editing and Proofing Worksheets 185Chapter 4: Managing Worksheets 233Chapter 5: Printing Worksheets 269Book III: Formulas and Functions 297Chapter 1: Building Basic Formulas 299Chapter 2: Logical Functions and Error Trapping 341Chapter 3: Date and Time Formulas 363Chapter 4: Financial Formulas 379Chapter 5: Math and Statistical Formulas 393Chapter 6: Lookup, Information, and Text Formulas 413Book IV: Worksheet Collaboration and Review 435Chapter 1: Protecting Workbooks and Worksheet Data 437Chapter 2: Using Hyperlinks 459Chapter 3: Sending Workbooks Out for Review 467Chapter 4: Sharing Workbooks and Worksheet Data 495Book V: Charts and Graphics 519Chapter 1: Charting Worksheet Data 521Chapter 2: Adding Graphic Objects 553Book VI: Data Management 581Chapter 1: Building and Maintaining Data Lists 583Chapter 2: Filtering and Querying a Data List 607Book VII: Data Analysis 649Chapter 1: Performing What-If Scenarios 651Chapter 2: Performing Large-Scale Data Analysis 675Book VIII: Macros and VBA 721Chapter 1: Recording and Running Macros 723Chapter 2: VBA Programming 735Index 759