Excel 2016 In Depth (includes Content Update Program) (häftad)
Fler böcker inom
Häftad (Paperback)
Antal sidor
234 x 184 x 31 mm
997 g
Antal komponenter
Excel 2016 In Depth (includes Content Update Program) (häftad)

Excel 2016 In Depth (includes Content Update Program)

Häftad Engelska, 2015-10-28
Skickas inom 5-8 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 1 format & utgåvor
Excel 2016 In Depth is the fastest, smartest way to master Excel 2016s full power and updated interface. Students will discover how to leverage Excels new tools for charting, business analysis, data visualization, forecasting, and more.
Visa hela texten

Passar bra ihop

  1. Excel 2016 In Depth (includes Content Update Program)
  2. +
  3. Excel For Auditors

De som köpt den här boken har ofta också köpt Excel For Auditors av Bill Jelen, Dwayne K Dowell (häftad).

Köp båda 2 för 568 kr


Har du läst boken? Sätt ditt betyg »

Bloggat om Excel 2016 In Depth (includes Content Upd...

Övrig information

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his half-day Power Excel seminar around the world. He has produced more than 1,900 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 45 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches-working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company. He lives in Merritt Island, Florida, with his wife, Mary Ellen.


Introduction 1

Part I The Excel Interface

Chapter 1 Whats New in Excel 2016 (and 2013) 5

Color Returns to the Excel Interface 5

The Data Model from Excel 2013 Is the Most Important Feature in 2016 6

Clean Your Data with Power Query 7

Pivot Your Data on a Map with 3D Maps 8

View Your Data Using Six New Chart Types 8

Forecast the Future Using a Forecast Sheet 9

Important Features from Excel 2013 10

Oddities Added to Excel 2016 11

Chapter 2 Using the Excel Interface 15

Using the Ribbon 15

Using the Quick Access Toolbar 20

Using the Full-Screen File Menu 23

Using the New Sheet Icon to Add Worksheets 29

Navigating Through Many Worksheets Using the Controls in the Lower Left 29

Using the Mini Toolbar to Format Selected Text 29

Expanding the Formula Bar 30

Zooming In and Out on a Worksheet 31

Using the Status Bar to Add Numbers 31

Switching Between Normal View, Page Break Preview, and Page Layout View Modes 32

Chapter 3 Customizing Excel 33

Performing a Simple Ribbon Modification 33

Adding a New Ribbon Tab 35

Sharing Customizations with Others 36

Questions About Ribbon Customization 36

Introducing the Excel Options Dialog 37

Options to Consider 40

Five Excel Oddities 41

Chapter 4 Keyboard Shortcuts 43

Using Keyboard Accelerators 43

Using the Shortcut Keys 47

Using My Favorite Shortcut Keys 56

Using Excel 2003 Keyboard Accelerators 58

Part II Calculating with Excel

Chapter 5 Understanding Formulas 69

Getting the Most from This Chapter 69

Introduction to Formulas 70

Entering Your First Formula 71

Three Methods of Entering Formulas 77

Entering the Same Formula in Many Cells 80

Use the Table Tool to Copy a Formula 82

Chapter 6 Controlling Formulas 85

Formula Operators 85

Understanding Error Messages in Formulas 88

Using Formulas to Join Text 90

Copying Versus Cutting a Formula 91

Automatically Formatting Formula Cells 92

Using Date Math 92

Troubleshooting Formulas 93

Chapter 7 Understanding Functions 99

Working with Functions 99

Getting Help with Excel Functions 102

Using AutoSum 105

Chapter 8 Using Everyday Functions: Math, Date and Time, and Text Functions 111

Math Functions 111

Date and Time Functions 114

Text Functions 116

Examples of Math Functions 119

Examples of Date and Time Functions 142

Examples of Text Functions 157

Using the T and VALUE Functions 175

Chapter 9 Using Powerful Functions: Logical, Lookup, Web, and Database Functions 177

Examples of Logical Functions 183

Examples of Information Functions 188