Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Excel Tips and Tricks

No description
by

Tracy Ryan

on 28 April 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Excel Tips and Tricks

2013 Assessments
2012 Assessments
Assessor's Desk
Tracy Ryan and James Cumming
Topics Covered
Vlookups
Absolute cell references
Naming Ranges
Validation lists
Security
Conditional formatting
Creating charts and pivot tables
IF statements and nested if statement
etc...
Overview
EXCEL TIPS AND TRICKS

FOR ASSESSORS

Alberta Assessors' Association Workshop
April 28 - May 2, 2014

This course is developed as a tool to assist assessors in their everyday job duties.

Basic shortcuts and steps will be introduced on some of the tools available in excel



Note: This is not an advanced course and we are by no means experts in Excel. All concepts introduced are meant to be tools to assist assessors in their everyday job duties.
CTRL + C
CTRL + X
CTRL + V
CTRL + Z
CTRL + Y
CTRL + B
CTRL + I
CTRL + U
CTRL + A
ALT + ENTER
copy
cut
paste
undo
redo
bold
italicize
underline
select entire sheet
Create new line in cell
SHORTCUT KEYS
Introduction to EXCEL
IMPORTANT FORMULAS COVERED



=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=UPPER(text)
=LOWER(text)
=PROPER(text)
=IF(logical_test, [value_if_true], [value_if_false])
=CONCATENATE (text1,text2,...)
WORKSHEETS
TOOLBAR
Formula bar
Full transcript