Resource Books home
Our downloads
NOTE: All document downloads are in PDF format. To download a file, right-click on a link and select 'Save Target As' or 'Save Link As' from the menu.
To view and/or print them you will need to have Acrobat Reader installed. Click here.
Simple Excel 2010: Popular Functions
Share | |
Simple Excel 2010: Popular Functions
Click here for larger image
Price: $19.50
Code: 9781877431524

Qty:

 :
PC Simplicity Series.
PB/262x200/IllusB&W. 56 pp
ISBN: 9781877431524

 Description
PC Simplicity Series
PB/262x200/IllusB&W. 56 pp
ISBN: 9781877431524

Microsoft Excel 2010 is a program designed to create and use a spreadsheet. This Guide book in the PC Simplicity Series will take you through the popular most-used functions and building your confidence in the skills needed to use the software productively.  It assumes you have the skills taught in the previous Guide. 

Table of Contents

Lesson 1
Inserting Rows
Borders
Format Cells - Font
Thick Line Borders
Drawing Borders
Erasing Borders
Copy & Paste
Average Formula
Maximum Formula
Minimum Formula
Number Formatting
Multiple Select
Creating a New Folder

Lesson 2
Save As
Displaying Multiple Sheets
Switching between Sheets
Select Entire Sheet
Gridlines & Headings

Lesson 3
Excel Options  Font Settings
Inserting Multiple Rows
Inserting Columns
Deleting Rows
Text Orientation
Multiple Column Widths
Sort - Ascending
Sort - Descending

Lesson 4
Add 1 Formula
Selecting an Entire Sheet
AutoFit Multiple Column Widths
Copy & Paste
Replace
Cut / Move

Lesson 5
Page Setup - Print Row Titles
Gridlines, Headers
Show Margins
Adjust Margins
Fit to One Page
Row and Column Headings
Headers and Footers
Dates, Page Numbers, File Path
Printing
Lesson 6
Absolute Referencing
Print Areas
Hide Columns

Lesson 7
Unhide Columns
Selecting Multiple Areas
Password Protection
Page Orientation
Headers and Footers
Normal View
Page Layout View

Lesson 8
Today Formula
Date Formats

Lesson 9
Formula with Brackets
Selecting Multiple Columns
Percentage Format
Freeze Panes
Show Formula

Lesson 10
Text Wrapping
Editing Sheet Tags

Lesson 11
Insert Sheets
Row Heights

Lesson 12
Inserting Comments
Editing Comments

Lesson 13
Customise Sort
Sort - Add Levels
Hide Rows
Filters
Clear Filters
Custom Filters – Greater Than
Removing Filters

Order now.


Note: Microsoft Windows, Office, Access, Excel, FrontPage, Outlook, PowerPoint, Publisher, Word are registered trademarks of Microsoft Corporation, USA.

Shipped: Usually next business day
Shipping: Can ship anywhere
Your Cart
Your shopping cart is empty. Its contents will appear here when you click on 'Add to Cart'.

Site © Resource Books Ltd, Waimauku, Auckland, New Zealand
Tel: Auckland (09) 411 9559 :: Fax: (09) 411-9556 ::