Excel 2013 Absolute Beginner's Guide (häftad)
Fler böcker inom
Häftad (Paperback)
Antal sidor
228 x 177 x 25 mm
612 g
Antal komponenter
Excel 2013 Absolute Beginner's Guide (häftad)

Excel 2013 Absolute Beginner's Guide

Häftad Engelska, 2013-04-10
Skickas inom 3-6 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 1 format & utgåvor
Make the most of Excel 2013without becoming a technical expert! This book is the fastest way to master Exceluse it to build powerful, trustworthy, easy-to-understand workbooksdiscover hidden patterns and make better decisionsvisualize data so everyone understands itshare and present workbooks on the web, tablets, anywhere! Even if youve never used Excel before, youll learn how to do what you want, one incredibly clear and easy step at a time. Excel has never, ever been this simple!


Who knew how simple Excel 2013 could be?


This is the easiest, most practical beginners guide to using Microsofts incredibly powerful new Excel 2013 spreadsheet programsimple, reliable instructions for doing everything you really want to do! Heres a small sample of what youll learn:


  • Quickly create, edit, and format workbooks
  • Enter formulas and use functions effectively
  • Enter data more rapidly, easily, consistently, and accurately
  • Master powerful ways to sort, filter, consolidate, or group data
  • Visualize information through great charts, PivotTables, and Sparklines
  • Illustrate workbooks with images, shapes, and SmartArt
  • Explore and analyze data more easily with Excel 2013s amazing new Power View
  • Share, print, present, and secure your workbooks
  • Store your workbooks online with SkyDrive
  • Work with macros
  • Build immense power into worksheet cells with UDFs
Visa hela texten

Passar bra ihop

  1. Excel 2013 Absolute Beginner's Guide
  2. +
  3. C++ Primer

De som köpt den här boken har ofta också köpt C++ Primer av Stanley B Lippman, Jose Lajoie, Barbara E Moo (häftad).

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


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

Bloggat om Excel 2013 Absolute Beginner's Guide

Övrig information

Tracy Syrstad is the project manager for the MrExcel consulting team and also handles many of the tech support calls. She's been helping people with Microsoft Office issues since 1997 when she discovered free online forums where anyone could ask and answer questions. She discovered she enjoyed teaching others new skills, and when Tracy began working with the MrExcel team, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions.



Who Should Read This Book 3

How This Book Is Organized 3

Downloading the Example Files 3

Conventions Used In This Book 4

Special Elements 4

1  Understanding the Microsoft Excel Interface 5

Taking a Closer Look at the Excel Window 6

Customizing the Excel Window 12

Moving Around and Making Selections on a Sheet 19

Installing Optional Components 21

2  Working with Workbooks, Sheets, Rows, Columns, and Cells 27

Managing Workbooks 28

Using Templates to Quickly Create New Workbooks 33

Working with Sheets and Tabs 36

Working with Rows and Columns 40

Working with Cells 43

3  Getting Data onto a Sheet 47

Types of Data You Enter into Excel 48

Entering Different Types of Data into a Cell 48

Controlling the Next Cell Selection 50

Using Copy, Cut, Paste, Paste Special to Enter Data 52

Using Text to Columns to Separate Data in a Single Column 54

Inserting Symbols and Equations into a Cell 58

Using Web Queries to Get Data onto a Sheet    59

Using Series to Quickly Fill a Range 60

Editing Data 62

Working with Tables 64

Fixing Numbers Stored as Text 67

Spellchecking Your Sheet 69

Finding Data on Your Sheet 69

Using Data Validation to Limit Data Entry in a Cell 71

4  Formatting Sheets and Cells 75

Adjusting Row Heights and Column Widths 76

Changing the Font Settings of a Cell 77

Aligning Text in a Cell 79

Reflowing Text in a Paragraph 83

Applying Number Formats with Format Cells 85

Creating a Custom Format 88

When Cell Formatting Doesnt Seem to Be Working Right 95

The Number Group on the Ribbon 95

Adding a Border Around a Range 96

Coloring the Inside of a Cell 98

Creating Hyperlinks 99

Quick Formatting with the Format Painter 101

Dynamic Cell Formatting with Conditional Formatting 101

Using Cell Styles to Quickly Apply Formatting 109

Using Themes to Ensure Uniformity in Design 109

5  Using Formulas 113

The Importance of Laying Out Data Properly 114

Adjusting Calculation Settings 114

Viewing Formulas Versus Values 115

Entering a Formula into a Cell 116

Three Ways of Entering a Formulas Cell References 118

Relative Versus Absolute Formulas 118

Using a Cell on Another Sheet in a Formula 119

Using R1C1 Notation to Reference Cells 119

Using F4 to Change the Cell Referencing 121

Mathematical Operators 122

Copying a Formula to Another Cell 123

Using Names to Simplify References 125

Inserting Formulas into Tables 128

Using Table Names in Table Formulas 129

Writing Table Formulas Outside the Table 130

Using Array Formulas 132