Resources for State of Delaware Lunch and Learn
Quick Tips & Tricks for MS Excel, Word, and PowerPoint

Word

Quick Access Toolbor

Show/Hide

Page Break [Ctrl+enter]

Section Break [Ctrl+Shift+Enter]

Styles: applying, customizing

Auto Table of Contents

Images and Text Wrapping

Ctrl +C, Ctrl+V, Ctrl +X, Ctrl+P

Paste Special (text only)


PowerPoint

Image Editing

Save As jpg/png

Animation

Bullets

Graph (from Excel)

SmartArt

Audio

Video

Excel

Autofill

Ctrl+ drag (duplicate sheet)

VLookUp (zip codes and scores)

Charts (year-over-year) 

Pivot table data organization


Didn't get to these topics this time:

Macros (why use them. why they can be problematic)

Protecting formulas in a workbook



ĉ
Sandy McVey,
Sep 21, 2016, 5:55 AM
ć
Sandy McVey,
Sep 21, 2016, 5:54 AM
Ċ
Sandy McVey,
Sep 21, 2016, 5:55 AM
ą
Sandy McVey,
Sep 21, 2016, 5:55 AM
Ĉ
Sandy McVey,
Sep 21, 2016, 5:54 AM