101 Microsoft Excel 2013 Tips, Tricks & Timesavers (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
298
Utgivningsdatum
2013-07-08
Upplaga
1
Förlag
WILEY
Illustrationer
black & white tables, figures
Dimensioner
234 x 188 x 18 mm
Vikt
468 g
Antal komponenter
1
Komponenter
3:B&W 7.5 x 9.25 in or 235 x 191 mm Perfect Bound on White w/Gloss Lam
ISBN
9781118642184

101 Microsoft Excel 2013 Tips, Tricks & Timesavers

av John Walkenbach
Häftad,  Engelska, 2013-07-08
284
Köp
Spara som favorit
  • Skickas från oss inom 5-8 vardagar.
  • Fri frakt över 249 kr för privatkunder i Sverige.
Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks.
  • Reveals ways to maximize the power of Excel to create robust applications
  • Draws on John Walkenbach's years of experience using Excel and writing more than 50 books
  • Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation
  • Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables
101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!
Visa hela texten

Passar bra ihop

  1. 101 Microsoft Excel 2013 Tips, Tricks & Timesavers
  2. +
  3. Python Crash Course, 3rd Edition

De som köpt den här boken har ofta också köpt Python Crash Course, 3rd Edition av Eric Matthes (häftad).

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

Kundrecensioner

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

Fler böcker av John Walkenbach

Visa alla böcker av John Walkenbach »

Övrig information

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including the bestselling Excel Bible, Excel Formulas, and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at www.spreadsheetpage.com.

Innehållsförteckning

Introduction 1

What You Should Know 1

What You Should Have 1

Conventions in This Book 2

Formula listings 2

Key names 2

The Ribbon  2

Functions, procedures, and named ranges 3

Mouse conventions 3

What the icons mean 3

How This Book Is Organized  4

How to Use This Book  4

About the Power Utility Pak Offer  4

Part I: Workbooks and Files

Tip 1: Changing the Look of Excel 7

Cosmetic changes   7

Hiding the Ribbon   8

Using options on the View tab  8

Hiding other elements 9

Hiding the status bar 9

Tip 2: Customizing the Quick Access Toolbar 10

About the Quick Access toolbar 10

Adding new commands to the Quick Access toolbar 10

Performing other Quick Access toolbar actions   13

Tip 3: Customizing the Ribbon 14

How to customize the Ribbon  14

Tip 4: Understanding Protected View 17

What causes Protected View? 17

Printing and copying 18

Forcing a file to open in Normal view  18

Tip 5: Understanding AutoRecover 20

Recovering versions of the current workbook 20

Recovering unsaved work  20

Tip 6: Using a Workbook in a Browser 22

Tip 7: Saving to a Read-Only Format 24

Send a printed copy 24

Send an electronic copy in the form of a PDF file 24

Send an MHTML file 25

Tip 8: Generating a List of Filenames 27

Tip 9: Generating a List of Sheet Names 29

Tip 10: Using Document Themes 32

Applying a theme 34

Customizing a theme 35

Tip 11: Understanding Excel Compatibility Issues 37

The Excel 2013 file formats  37

The Office Compatibility Pack 37

Checking compatibility 38

Tip 12: Where to Change Printer Settings 39

Part II: Formatting

Tip 13: Working with Merged Cells 43

Other merge actions 44

Potential problems with merged cells 44

Locating all merged cells 45

Unmerging all merged cells 46

Alternatives to merged cells 47

Tip 14: Indenting Cell Contents  48

Tip 15: Using Named Styles 50

Using the Style gallery 50

Modifying an existing style 51

Creating new styles 52

Merging styles from other workbooks 53

Tip 16: Creating Custom Number Formats 54

Parts of a number format string 55

Custom number format codes 55

Tip 17: Using Custom Number Formats to Scale Values 58

Tip 18: Creating a Bulleted List 60

Using a bullet character 60

Using SmartArt 61

Tip 19: Shading Alternate Rows Using Conditional Formatting 62

Displaying alternate row shading 62

Creating checkerboard shading 63

Shading groups of rows  64

Tip 20: Formatting Individual Characters in a Cell 65

Tip 21: Using the Format Painter 66

Painting basics 66

Format Painter variations ...

Du kanske gillar