Excel Tips and Tricks

1 / 11

Excel Tips and Tricks - PowerPoint PPT Presentation

Excel Tips and Tricks. James L. Baldwin, Assistant Dean of Academic Affairs, Registrar, and Director of Science in Motion jlb20@pitt.edu University of Pittsburgh at Bradford 300 Campus Drive Bradford, PA 16701 814.362.7602. Objectives:

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

PowerPoint Slideshow about 'Excel Tips and Tricks' - oakes

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

James L. Baldwin,

Assistant Dean of Academic Affairs, Registrar, and Director of Science in Motion

jlb20@pitt.edu

300 Campus Drive

814.362.7602

Objectives:

1. Demonstrate some of my favorite aspects of Excel including tips, tricks, shortcuts, and commonly used functions.

2. Create an open dialogue for participants to share their best tips and tricks and ask questions.

Super quick stats

Quick formatting

Drag and drop

Drag and copy tabs

Tool handle fill

Sort (numbers, letters, and colors)

Conditional formatting

SSNs

Topics-1

Merge and center alternative

Better and easier to read graphs

Sparklines

PivotTables

Speak Cells on Enter

Remove Duplicates

VLOOKUP

Topics-2

=+ - * / and order of operations

=End Value/Beginning Value -1 (% change)

& (and multiple &s)

=LEFT(Cell, Number)

=RIGHT(Cell, Number)

=FIND(Text, Cell, Number)

=TRIM(Cell)

=A1=A2 (True and False)

=IF (formula, value if true, value if false)

=IF (AND (formulas), value if true, value if false)

=IF (OR (formulas), value if true, value if false)

Formulas-1

=COUNT(Range)

=SUM(Range)

=AVERAGE(Range)

=MAX(Range)

=MIN(Range)

=COUNTIF(RANGE, “CRITERIA”)

=SUMIF(RANGE, “CRITERIA”, SUMRANGE)

=SUMIF(RANGE, “CRITERIA”, SUMRANGE)

Formulas-2

Ctrl+Shift+& draws a thin boarder around your selection

Ctrl+semicolon enters the current date

Ctrl+colon enters the current time

Ctrl+Alt+vPaste Special

Ctrl+z Undo

Ctrl+y Redo (or do again)

Ctrl+x Cut

Ctrl+c Copy

Ctrl+v Paste

Ctrl+b+u+i Bold, Underline, Italicize

Favorite Keyboard Shortcuts-1

Ctrl+ Home Key Takes you to A1

Ctrl+ Arrow Keys Takes you to the top, bottom, far left or far right of columns and rows

Ctrl+Shift+ \$ or % Format cells in \$ or %

‘ Forces text format

Favorite Keyboard Shortcuts-2

Questions

and Let’s Share

James L. Baldwin,

Assistant Dean of Academic Affairs, Registrar, and Director of Science in Motion

jlb20@pitt.edu