Reply
 
Thread Tools Rate Thread Display Modes
Old 08-04-2011, 05:50   #1
Lotak
Pai&Yakumo
 
Lotak's Avatar
 
Join Date: Oct 2007
Location: London, England, Earth
Posts: 8,539
Lotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond repute
Microsoft Excel / Access Guide

Does anyone know of a book / site that gives a guide and worksheets / problems for Microsoft Excel and/or Access?

I've got the MS for dummies, but that only acts as a guide and doesn't actually give problems to solve.
__________________
R.I.P. Lotak: 18/07/07 - 01:10 05/10/09

How moon/vio gems affect levelling skills
Calculators courtesy of GoNz

Quote:
Originally Posted by anpaff View Post
Thread fails when Lotak comes on; its deleted or closed because you have no poll.
PM me with any CO/forum questions
Suggestions that need recommending


Do NOT PM me about posting rights. I know nothing of how it works.
Lotak is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 06:51   #2
Jaxx..
Banned
 
Join Date: Dec 2010
Location: United Kingdom
Posts: 4,536
Jaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond repute
I did access for university. Its that damn annoying database programme.
Jaxx.. is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 08:15   #3
MillerZfuriouS
Kindly Off
 
MillerZfuriouS's Avatar
 
Join Date: Oct 2009
Location: Egypt, Alexandria.
Posts: 791
MillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond reputeMillerZfuriouS has a reputation beyond repute
Send a message via MSN to MillerZfuriouS


Table of Contents

Exam 77-881: Microsoft Word 2010

Chapter 1 : Sharing and Maintaining Documents
1.1 Apply Different Views to a Document
1.2 Apply Protection to a Document
1.3 Manage Document Versions
1.4 Share Documents
1.5 Save a Document
1.6 Apply a Template to a Document
Objective Review

Chapter 2 : Formatting Content
2.1 Apply Font and Paragraph Attributes
2.2 Navigate and Search Through a Document
2.3 Apply Indentation and Tab Settings to Paragraphs
2.4 Apply Spacing Settings to Text and Paragraphs
2.5 Create Tables
2.6 Manipulate Tables in a Document
2.7 Apply Bullets to a Document
Objective Review

Chapter 3 : Applying Page Layout and Reusable Content
3.1 Apply and Manipulate Page Setup Settings
3.2 Apply Themes
3.3 Construct Content in a Document by Using the Quick Parts Tool
3.4 Create and Manipulate Page Backgrounds
3.5 Create and Modify Headers and Footers
Objective Review

Chapter 4 : Including Illustrations and Graphics in a Document
4.1 Insert and Format Pictures in a Document
4.2 Insert and Format Shapes, WordArt, and SmartArt
4.3 Insert and Format Clip Art
4.4 Apply and Manipulate Text Boxes
Objective Review

Chapter 5 : Proofreading Documents
5.1 Validate Content by Using Spelling and Grammar Checking Options
5.2 Configure AutoCorrect Settings
5.3 Insert and Modify Comments in a Document
Objective Review

Chapter 6 : Applying References and Hyperlinks
6.1 Apply a Hyperlink
6.2 Create Endnotes and Footnotes
6.3 Create a Table of Contents
Objective Review

Chapter 7 : Performing Mail Merge Operations
7.1 Set Up Mail Merge
7.2 Execute Mail Merge
Objective Review

Exam 77-882: Microsoft Excel 2010

Chapter 1 : Managing the Worksheet Environment
1.1 Navigate Through a Worksheet
1.2 Print a Worksheet or Workbook
1.3 Personalize the Excel Environment
Objective Review

Chapter 2 : Creating Cell Data
2.1 Construct Cell Data
2.2 Apply Auto Fill
2.3 Apply and Manipulate Hyperlinks
Objective Review

Chapter 3 : Formatting Cells and Worksheets
3.1 Apply and Modify Cell Formats
3.2 Merge or Split Cells
3.3 Create Row and Column Titles
3.4 Hide or Unhide Rows and Columns
3.5 Manipulate Page Setup Options for Worksheets
3.6 Create and Apply Cell Styles
Objective Review

Chapter 4 : Managing Worksheets and Workbooks
4.1 Create and Format Worksheets
4.2 Manipulate Window Views
4.3 Manipulate Workbook Views
Objective Review

Chapter 5 : Applying Formulas and Functions
5.1 Create Formulas
5.2 Enforce Precedence
5.3 Apply Cell References in Formulas
5.4 Apply Conditional Logic in Formulas
5.5 Apply Named Ranges in Formulas
5.6 Apply Cell Ranges in Formulas
Objective Review

Chapter 6 : Presenting Data Visually
6.1 Create Charts Based on Worksheet Data
6.2 Apply and Manipulate Illustrations
6.3 Create and Modify Images
6.4 Apply Sparklines
Objective Review

Chapter 7 : Sharing Worksheet Data with Other Users
7.1 Share Spreadsheets
7.2 Manage Comments
Objective Review

Chapter 8 : Analyzing and Organizing Data
8.1 Filter Data
8.2 Sort Data
8.3 Apply Conditional Formatting
Objective Review

Exam 77-883: Microsoft PowerPoint 2010

Chapter 1 : Managing the PowerPoint Environment
1.1 Adjust Views
1.2 Manipulate the PowerPoint Window
1.3 Configure the Quick Access Toolbar
1.4 Configure PowerPoint File Options
Objective Review

Chapter 2 : Creating a Slide Presentation
2.1 Construct and Edit Photo Albums
2.2 Apply Slide Size and Orientation Settings
2.3 Add and Remove Slides
2.4 Format Slides
2.5 Enter and Format Text
2.6 Format Text Boxes
Objective Review

Chapter 3 : Working with Graphical and Multimedia Elements
3.1 Manipulate Graphical Elements
3.2 Manipulate Images
3.3 Modify WordArt and Shapes
3.4 Manipulate SmartArt
3.5 Edit Video and Audio Content
Objective Review

Chapter 4 : Creating Charts and Tables
4.1 Construct and Modify Tables
4.2 Insert and Modify Charts
4.3 Apply Chart Elements
4.4 Manipulate Chart Layouts
4.5 Manipulate Chart Elements
Objective Review

Chapter 5 : Applying Transitions and Animations
5.1 Apply Built-In and Custom Animations
5.2 Apply Effect and Path Options
5.3 Manipulate Animations
5.4 Apply and Modify Transitions Between Slides
Objective Review

Chapter 6 : Collaborating on Presentations
6.1 Manage Comments in Presentations
6.2 Apply Proofing Tools
Objective Review

Chapter 7 : Preparing Presentations for Delivery
7.1 Save Presentations
7.2 Share Presentations
7.3 Print Presentations
7.4 Protect Presentations
Objective Review

Chapter 8 : Delivering Presentations
8.1 Apply Presentation Tools
8.2 Set Up Slide Shows
8.3 Set Presentation Timing
8.4 Record Presentations
Objective Review

Exam 77-884: Microsoft Outlook 2010

Chapter 1 : Managing the Outlook Environment
1.1 Apply and Manipulate Outlook Program Options
1.2 Manipulate Item Tags
1.3 Arrange the Content Pane
1.4 Apply Search and Filter Tools
1.5 Print an Outlook Item
Objective Review

Chapter 2 : Creating and Formatting Item Content
2.1 Create and Send Email Messages
2.2 Create and Manage Quick Steps
2.3 Create Item Content
2.4 Format Item Content
2.5 Attach Content to Email Messages
Objective Review

Chapter 3 : Managing Email Messages
3.1 Clean Up the Mailbox
3.2 Create and Manage Rules
3.3 Manage Junk Email
3.4 Manage Automatic Message Content
Objective Review

Chapter 4 : Managing Contacts
4.1 Create and Manipulate Contacts
4.2 Create and Manipulate Contact Groups
Objective Review

Chapter 5 : Managing Calendar Objects
5.1 Create and Manipulate Appointments and Events
5.2 Create and Manipulate Meeting Requests
5.3 Manipulate the Calendar Pane
Objective Review

Chapter 6 : Working with Tasks, Notes, and Journal Entries
6.1 Create and Manipulate Tasks
6.2 Create and Manipulate Notes
6.3 Create and Manipulate Journal Entries

DOWNLOAD LINK TORRENT
http://www.demonoid.me/files/download/2595040/7314947
__________________
Proud of being Egyptian

Watch your thoughts, they become words.
Watch your words, they become actions.
Watch your actions, they become habits.
Watch your habits, they become character.
Watch your character, they become destiny.

If you are not part of the cure, then you are part of the problem.
MillerZfuriouS is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 08:32   #4
ProEgy♥
Banned
 
Join Date: Jan 2011
Location: Off-topic
Posts: 1,574
ProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond repute
Quote:
Originally Posted by Jaxx.. View Post
I did access for university. Its that damn annoying database programme.
stfu you arrogant egyptian!
ProEgy♥ is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 08:34   #5
Jaxx..
Banned
 
Join Date: Dec 2010
Location: United Kingdom
Posts: 4,536
Jaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond reputeJaxx.. has a reputation beyond repute
Attached Thumbnails
1309087471769.jpg  
Jaxx.. is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 08:51   #6
Lotak
Pai&Yakumo
 
Lotak's Avatar
 
Join Date: Oct 2007
Location: London, England, Earth
Posts: 8,539
Lotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond reputeLotak has a reputation beyond repute
Can we please not flame each other in this thread. I don't care who started it and who is finishing it. This is important!

No flaming otherwise I will have to get my banhammer.
__________________
R.I.P. Lotak: 18/07/07 - 01:10 05/10/09

How moon/vio gems affect levelling skills
Calculators courtesy of GoNz

Quote:
Originally Posted by anpaff View Post
Thread fails when Lotak comes on; its deleted or closed because you have no poll.
PM me with any CO/forum questions
Suggestions that need recommending


Do NOT PM me about posting rights. I know nothing of how it works.
Lotak is offline   Reply With Quote Share with Facebook
Old 08-04-2011, 09:00   #7
ProEgy♥
Banned
 
Join Date: Jan 2011
Location: Off-topic
Posts: 1,574
ProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond reputeProEgy♥ has a reputation beyond repute
Quote:
Originally Posted by Lotak View Post
Can we please not flame each other in this thread. I don't care who started it and who is finishing it. This is important!

No flaming otherwise I will have to get my banhammer.
I'm joking with him. o_o

Small piece of info, have you tried the 'help center' function in excel/access? o.0
ProEgy♥ is offline   Reply With Quote Share with Facebook
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -7. The time now is 08:51.