LibraryAware Table of Contents

Office Basics

Start and Exit Office Applications

(2)

Navigate the Program Windows

(2)

Work with the Ribbon

(2)

Customize the Quick Access Toolbar

(2)

Find Help with Office

(2)

Working with Files

Create a New File

(2)

Save a File

(2)

Open a File

(2)

Print a File

(2)

Check your File for Hidden or Personal Data

(2)

E-mail a File

(2)

Select Data

(2)

Cut, Copy, and Paste Data

(2)

View Multiple Files

(2)

Office Graphics Tools

Insert Clip Art

(2)

View Clip Art with the Clip Organizer

(2)

Insert a Picture

(2)

Resize and Move Objects

(2)

Rotate and Flip Objects

(2)

Crop a Picture

(2)

Add a Picture Border

(2)

Add a Picture Effect

(1)

Make Image Corrections

(1)

Make Color Adjustments

(1)

Apply Artistic Effects

(1)

Create a WordArt Object

(2)

Add SmartArt

(2)

Working with Office Files Online

Create a New Workspace

(2)

Upload a File to Office Live Workspace

(2)

Create a New File in Office Live Workspace

(2)

Edit a File in Office Live Workspace

(2)

Share a Workspace

(2)

View Shared Workspaces

(1)

Delete a File From Office Live Workspace

(3)

WORD

Adding Text

Change Word's Views

(2)

Type and Edit Text

(2)

Insert Quick Parts

(2)

Insert Symbols

(2)

Create a Blog Post

(2)

Formatting Text

Change the Font, Size, and Color

(4)

Align Text

(1)

Set Line Spacing

(1)

Indent Text

(2)

Set Tabs

(2)

Set Margins

(2)

Create Lists

(2)

Copy Formatting

(1)

Clear Formatting

(1)

Format with Styles

(2)

Apply a Template

(2)

Adding Extra Touches

Assign a Theme

(2)

Add Borders

100

(2)

Create Columns

102

(2)

Insert a Table

104

(2)

Apply Table Styles

106

(1)

Insert an Excel Spreadsheet

107

(1)

Add Headers and Footers

108

(2)

Insert Footnotes and Endnotes

110

(2)

Insert Page Numbers and Page Breaks

112

(2)

Mark Index Entries

114

(2)

Generate an Index

116

(2)

Generate a Table of Contents

118

(2)

Create a Bibliography

120

(2)

Reviewing Documents

Find and Replace Text

122

(2)

Scan Document Content

124

(2)

Check Spelling and Grammar

126

(2)

Work with AutoCorrect

128

(2)

Use Word's Thesaurus and Dictionary

130

(2)

Translate Text

132

(2)

Track and Review Document Changes

134

(2)

Compare Documents

136

(2)

Insert Comments

138

(4)

EXCEL

Building Spreadsheets

Enter Cell Data

142

(2)

Select Cells

144

(2)

Faster Data Entry with AutoFill

146

(2)

Turn On Text Wrapping

148

(1)

Center Data Across Columns

149

(1)

Adjust Cell Alignment

150

(2)

Change the Font and Size

152

(2)

Change Number Formats

154

(1)

Increase or Decrease Decimals

155

(1)

Add Borders

156

(2)

Format Data with Styles

158

(2)

Apply Conditional Formatting

160

(2)

Add Columns and Rows

162

(2)

Resize Columns and Rows

164

(1)

Freeze a Column or Row

165

(1)

Name a Range

166

(2)

Delete Data or Cells

168

(2)

Worksheet Basics

Add a Worksheet

170

(1)

Name a Worksheet

171

(1)

Change Page Setup Options

172

(2)

Move and Copy Worksheets

174

(1)

Delete a Worksheet

175

(1)

Find and Replace Data

176

(2)

Sort Data

178

(2)

Filter Data

180

(2)

Track and Review Worksheet Changes

182

(4)

Insert a Comment

186

(2)

Working with Factors and Functions

Understanding Formulas

188

(2)

Create a Formula

190

(2)

Apply Absolute and Relative Cell References

192

(2)

Understanding Functions

194

(2)

Apply a Function

196

(2)

Total Cells with AutoSum

198

(2)

Audit a Worksheet for Errors

200

(2)

Add a Watch Window

202

(2)

Working with Charts

Create a Chart

204

(2)

Move and Resize Charts

206

(2)

Change the Chart Type

208

(1)

Change the Chart Style

209

(1)

Change the Chart Layout

210

(1)

Add Axis Titles

211

(1)

Format Chart Objects

212

(2)

Add Gridlines

214

(1)

Change the Chart Data

215

(1)

Use Sparklines to View Data Trends

216

(4)

POWERPOINT

Creating a Presentation

Create a Photo Album Presentation

220

(2)

Create a Presentation with a Template

222

(2)

Build a Blank Presentation

224

(2)

Change PowerPoint Views

226

(2)

Insert Slides

228

(1)

Change the Slide Layout

229

(1)

Create a Custom Layout

230

(2)

Populating Presentation Slides

Add and Edit Slide Text

232

(2)

Change the Font, Size, and Color

234

(4)

Apply a Theme

238

(1)

Set Line Spacing

239

(1)

Align Text

240

(1)

Add a Text Box to a Slide

241

(1)

Add a Table to a Slide

242

(2)

Add a Chart to a Slide

244

(2)

Add a Picture to a Slide

246

(2)

Add a Video Clip to a Slide

248

(2)

Move a Slide Object

250

(1)

Resize a Slide Object

251

(1)

Assembling and Presenting a Slide Show

Reorganize Slides

252

(2)

Reuse a Slide

254

(2)

Organize Slides into Sections

256

(2)

Define Slide Transitions

258

(2)

Add Animation Effects

260

(2)

Create a Custom Animation

262

(2)

Record Narration

264

(1)

Set Up a Slide Show

265

(1)

Create Speaker Notes

266

(2)

Rehearse a Slide Show

268

(2)

Run a Slide Show

270

(2)

Package Your Presentation on a CD

272

(4)

Database Basics

Understanding Database Basics

276

(2)

Create a Database Based on a Template

278

(2)

Create a Blank Database

280

(2)

Create a New Table

282

(2)

Change Table Views

284

(2)

Add a Field to a Table

286

(1)

Delete a Field from a Table

287

(1)

Hide a Field in a Table

288

(1)

Move a Field in a Table

289

(1)

Create a Form

290

(2)

Change Form Views

292

(1)

Move a Field in a Form

293

(1)

Delete a Field in a Form

294

(1)

Apply a Database Theme

295

(1)

Format Form Fields

296

(1)

Add a Background Image

297

(1)

Adding, Finding, and Querying Data

Add a Record to a Table

298

(2)

Add a Record to a Form

300

(2)

Navigate Records in a Form

302

(1)

Search for a Record in a Form

303

(1)

Delete a Record from a Table

304

(1)

Delete a Record from a Form

305

(1)

Sort Records

306

(2)

Filter Records

308

(2)

Apply Conditional Formating

310

(2)

Perform a Simple Query

312

(4)

Create a Report

316

(6)

OUTLOOK

Organizing with Outlook

View Outlook Components

322

(2)

Schedule an Appointment

324

(2)

Schedule a Recurring Appointment

326

(2)

Schedule an Event

328

(2)

Create a New Contact

330

(2)

Create a New Task

332

(2)

Add a Note

334

(2)

Organize Outlook Items

336

(2)

Perform an Instant Search

338

(1)

Customize the To-Do Bar

339

(1)

E-mailing with Outlook

Compose and Send a Message

340

(2)

Send a File Attachment

342

(1)

Read an Incoming Message

343

(1)

Reply to or Forward a Message

344

(2)

Add a Sender to Your Outlook Contacts

346

(1)

Delete a Message

347

(1)

View Conversations

348

(2)

Clean Up a Conversation

350

(1)

Ignore a Conversation

351

(1)

Screen Junk E-mail

352

(2)

Create a Message Rule

354

(4)

PUBLISHER

Publisher Basics

Create a Publication

358

(2)

Create a Blank Publication

360

(2)

Zoom in and Out

362

(2)

Add Text

364

(1)

Add a New Text Box

365

(1)

Add a Picture to a Publication

366

(2)

Fine-Tuning a Publication

Change the Font, Size, and Color

368

(4)

Apply a Text Effect

372

(1)

Change Text Alignment

373

(1)

Add a Border

374

(1)

Control Text Wrap

375

(3)

Link Text Boxes

378

(1)

Move and Resize Publication Objects

378

(2)

Edit the Background

380

(2)

Add a Building Block Object

382

(2)

Create a Building Block Object

384

(4)

ONE NOTE

Taking Notes with OneNote

Navigate OneNote

388

(2)

Type and Draw Notes

390

(2)

Paste a Picture into OneNote

392

(1)

Attach Files to Notes

393

(1)

Insert a Screen Clipping

394

(2)

Record an Audio Note

396

(2)

Organizing and Sharing Notes

Create a New Notebook

398

(1)

Create a New Section

399

(1)

Create a New Page

400

(2)

Rename Sections and Pages

402

(2)

Group Sections

404

(2)

Search Notes

406

(2)

E-mail a Note Page

408

(1)

Convert Notes to PDF or XPS Format

409