slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Excel Tips and Tricks PowerPoint Presentation
Download Presentation
Excel Tips and Tricks

Loading in 2 Seconds...

play fullscreen
1 / 11

Excel Tips and Tricks - PowerPoint PPT Presentation


  • 92 Views
  • Uploaded on

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:

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

PowerPoint Slideshow about 'Excel Tips and Tricks' - oakes


An Image/Link below is provided (as is) to download presentation

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
slide2

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

slide3

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.

topics 1

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
topics 2

Merge and center alternative

Better and easier to read graphs

Sparklines

PivotTables

Speak Cells on Enter

Remove Duplicates

VLOOKUP

Topics-2
formulas 1

=+ - * / 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
formulas 2

=COUNT(Range)

=SUM(Range)

=AVERAGE(Range)

=MAX(Range)

=MIN(Range)

=COUNTIF(RANGE, “CRITERIA”)

=SUMIF(RANGE, “CRITERIA”, SUMRANGE)

=SUMIF(RANGE, “CRITERIA”, SUMRANGE)

Formulas-2
favorite keyboard shortcuts 1

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
favorite keyboard shortcuts 2

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
slide10

Questions

and Let’s Share

slide11

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