Transposing a Dataset with a PivotTable » Bacon Bits:

Transposing a Dataset with a PivotTable » Bacon Bits:

Creating a Frequency Distribution with a Pivot Table » Bacon Bits:

Creating a Frequency Distribution with a Pivot Table » Bacon Bits:

Free Microsoft Word Computer Course, 2007 to 2010 - Contents Page

Free Microsoft Word Computer Course, 2007 to 2010 - Contents Page:

http://www.homeandlearn.co.uk/word2007_2010/Word-2007-2010.html

A very nice website to learn Word 2007/2010

> Section One - Get Started with Microsoft Word
1.1 How to Open Microsoft Word

1.2 Finding Your Way Around

1.3 Typing Your First Letter

1.4 How to Save Your Work

1.5 Highlighting Techniques

1.6 Opening Word Documents

1.7 Add an Address To A Letter

1.8 Spelling and Grammar Checking

> Section Two - Document Formatting
2.1 Crime Statistics Document

2.2 Bold Text

2.3 Italics and Underline

2.4 Seting Tab Stop Positions

2.5 Creating Bulleted Lists

2.6 Working With Fonts

2.7 Setting Up Page Margins

> Section Three - Copy and Paste
3.1 Techniques for Cutting Text

3.2 Cut and Paste Techniques

3.3 Copy and Paste Techniques > Section Four - Clip Art
4.1 Inserting Clip art
4.2 How to Resize and Move Clip Art > Section Five - Multi-Page Documents
5.1 Downloading a Text File

5.2 Setting Up Page Margings and Tab Stops

5.3 How to Insert a Text File

5.4 Setting Up Headers and Footers

5.5 Print Preview in Word 2007 and Word 2010

> Section Six - How to Create a Booklet
6.1 Downloading the Stories

6.2 Creating Your Own Word Style

6.3 Page Breaks And Section Breaks

6.4 Adding a Cover Page

6.5 Adding a Contents Page

6.6 Working With Section Breaks

6.7 Headers And Section Breaks

> Section Seven - Word Shapes

7.1 Word Shapes - Create a Logo

7.2 Logo Continued

7.3 Word Art

7.4 Completing The Logo

> Section Eight - Letterheads and Templates
8.1 Create a Letterhead

8.2 Adding Columns to a Page

8.3 Saving Word Documents as a Template > Section Nine - Mail Merge
9.1 Create a Mail Merge Data Source
9.2 Create a Mail Merge Letter > Section Ten - Microsoft Word Tables
10.1 Tables in Microsoft Word
10.2 Table Styles

> Section Eleven - Document Collaboration
11.1 Document Collaboration
11.2 Accepting and Rejecting Changes > Section Twelve - Word Options
12.1 Displaying The Word Options

12.2 Changing The Language Settings

12.3 Proofing Options

12.4 Advanced Options

12.5 The Quick Access Toolbar

12.6 Keyboard Shortcuts

Pivot Table Data Crunching: Microsoft Excel 2010 | Wow! eBook - Blog

Pivot Table Data Crunching: Microsoft Excel 2010 (Free eBook)

Pivot Table Data Crunching: Microsoft Excel 2010

Book Details

• Paperback: 384 pages
• Publisher: Que (October, 2010)
• Language: English
• ISBN-10: 0789743132
• ISBN-13: 978-0789743138

• File Size: 30.2 MiB

Download book and Files Below

E-Book

[FP] QUE.Pivot.Table.Data.Crunching.Oct.2010.rar
[FREE] QUE.Pivot.Table.Data.Crunching.Oct.2010.rar

Paper Book

[Amazon] Pivot Table Data Crunching: Microsoft Excel 2010

Free Excel 2007 to 2010 Course - Contents Page

Free Excel 2007 to 2010 Course - Contents Page:

Online course
http://www.homeandlearn.co.uk/excel2007/Excel2007.html

TOPICS
> Section One - Make a Start with Excel
1 A first look at Excel 2007/2010
2 Excel Rows and Columns
3 Enter text and numbers in a Cell
4 How to Edit text in a Cell
5 How to Centre text and numbers
6 Font Formatting in Excel 2007/2010

7 How to change the colour of a Cell8 How to Save your work in Excel
9 Currency Symbols in Excel 2007/2010
10 How to Merge Cells
11 Review Number One
  > Section Two - A more complex spreadsheet
1 Introduction to Section Two2 How to use AutoFill in Excel 2007/2010
3 Entering Simple Addition Formula
4 The SUM Function in Excel
5 The SUM Function Continued
6 Copy and Paste

7 How to use Paste Special8 How to Multiply in Excel 2007/2010
9 Finishing your spreadsheet for this section
10 How to Add a Comment to a Cell
11 Review Number Two
  > Section Three - Excel 2007/2010 Charts
1 How to Sort Data in Excel2 Create an Excel Chart
3 Move and Resize your Chart
4 Chart Styles and Layouts
5 Chart Titles and Series Titles
6 Chart Layout Panel in Excel 2007/2010

7 The Format Chart Panel8 Create a Pie Chart in Excel
9 Add Labels to a Pie Chart
10 Format Pie Chart Segments
11 Create a 2D Line Chart in Excel
12 Format your Axis Titles
  > Section Four - Formulas in Excel 2007/2010
1 The SUM Function
2 How to Multiply in Excel
3 Subtract and Divide

4 Combining the Arithmetic Operators
5 A Budget Spreadsheet
  > Section Five - Functions in Excel 2007/2010
1 The Average Function
2 The Date Function
3 Time Functions in Excel

4 A TimeTable Project5 Financial Functions
6 The Student Averages Project
  > Section Six - Conditional Logic in Excel
1 The IF Function
2 Conditional Formatting in Excel 2007/2010

3 CountIF4 SumIF

 > Section Seven - Processing Data in Excel
1 Data Tables in Excel 2007/2010
2 A Second Data Table
3 Excel Scenarios
4 Goal Seek

5 Absolute Cell References
6 Named Ranges in Excel 2007/2010
7 Excel Pivot Tables
8 Pivot Tables, Part Two
  > Section Eight - Advanced Excel 2007/2010
1 Data Forms in Excel 2007/20102 Drop Down Lists in Excel
3 Add your own Error Messages
4 Excel and Web Integration

5 Hyperlinks in Excel6 Object Linking and Embedding
7 Reference other Worksheets
8 Insert Drawing Objects
All Course Material ©Copyright of Home and Learn

Excel 2000 to 2003 for Beginners: What is a Pivot Table?

Excel 2000 to 2003 for Beginners: What is a Pivot Table?:

'via Blog this'

MrExcel.com | Microsoft Excel Tips, Tricks and Support

MrExcel.com | Microsoft Excel Tips, Tricks and Support:


Sample files for Book