Presentation Topics for Excel PowerUsers Talk

Maureen5433

Board Regular
Joined
May 13, 2002
Messages
111
Office Version
  1. 365
Platform
  1. Windows
All,

As part of my job, I have been tasked with giving a 30 minute presentation to present some Excel "PowerTips" to other associates in my department. PowerTips, to me, are key combinations, tools, and capabilities that Excel has built-in that most "standard" users don't know about. For instance, when I shared with the group the instructions for pulling unique entries out of a list using advanced sort, I was surprised that no one knew about the tool.

Sooo, since you are the experts, and definately power-users, I thought I might get some input from anyone willing to share a good power trick they might have learned or even a good lesson learned when using Excel. No macros - way too advanced for this group but tricks and tools that exist that few people know about.

As always, thanks for your help. I look forward to reading your replies.

Maureen5433
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
Maureen

Where to start!!!!

1) Double click a cell to see the parents.
2) To autofill a formula beside an existing column of data, double click the bottom right corner of the cell
3) To debug a formula, highlight parts of the formula to evaluate and press F9.
4) To move through sheets, CTRL PgUp/PgDn
5) To move through workbooks, CTRL Tab
6) To selected row(s) from a range of cells: Shift Space Bar
7) To selected columns(s) from a range of cells: Ctrl Space Bar
8) In graphs, use the drop down error bar to separate historical from forecast data
9) Standard Addins (to get extra functionality - especially dates)
10) Goal Seek and Solver
11) Data Validation
12) Named Ranges (both user defined and auto generated)
13) Grouping and outlining
14) User customised toolbars
15) Freeze panes and window splits
16) Right click options
17) Conditional Formatting

That should take at least 30 minutes!!!


Tony
 

Bubbis Thedog

Well-known Member
Joined
Jul 29, 2004
Messages
967
Hi, there!

A lot of people where I work want hyperlinks in cells --whether it be to other sheets, Word documents, etc. That's a neat thing to show 'em sometimes. Also, showing people how to link cells is quite popular for me.

Bubbis
 

SonicBoomGolf

Active Member
Joined
Aug 7, 2004
Messages
325
I would definetly include a list of all the shortcuts Excel has. You can save enormous amounts of time by learning these. Some of my favorites are F4 (Repeat Last), CTRL + Z (Undo, saved me more than a few times), CTRL + C (Copy) and CTRL + V (Paste). Even though they are very small time savers, when you do these processes a few hundred times a day it really adds up.

Here is a good link that details all the shortcuts.
http://www.asap-utilities.com/index.php?page=p_sh.php

Hope that helps.
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
If you deal with a lot of formulas, Control-` to toggle between normal view and formula view. (You'd be surprised how many Excel users don't know that one!)
 

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
What do your "standard users" typically do or need to do with excel. In talking with people that some of the excel functionalit I take for granted is not "standard" to everyone. Similarly, I find one small nuance of excel almost every day I read this forum. Do they crunch numbers? Do the manage lists of information? Do they like to make pretty pictures?

How much do your users, use excel? (how many hours per week?

Btw - I don't think I saw some of the more obvious answers in the lists above.

- normal filtering/sorting.
- Conditional formatting (with formulas for criteria),
- inserting comments (printing comments a the bottom of a sheet)
- SumProduct function for multi conditional counts and sums.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,670
Messages
5,597,483
Members
414,146
Latest member
marginmakerb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top