It’s an easy program to pick up and most people become comfortable using it very quickly.
The only problem is there are a LOT of shortcuts far too many to list them all here.
Justpress ALTto show which key you need for a tab on the ribbon (e.g.
Don’t press them all together do each key successively.
If you want to see keyboard shortcuts for specific tasks, Microsoft has anice listfor all versions of Excel.
Simply place the mouse cursor over thebottom right corner of the cell the cursor will change shape and color.
Here are a few tips to keep your data visualizations looking clean and crisp.
Data from sets of continuous variables (e.g.
reaction rates vs. concentration) should be displayed using XY scatter graphs.
choose the row, column, or cells you want to add the same value into.
You’ll now have a raft of new cells all nicely filled in!
And speaking of pivot tables…
7. tap on the drop-down menu arrow, opt for bottom option, and hey presto!
You’ll see the option to Define Name and clicking this will open up a new window.
you might quickly edit or remove names by the Name Manager (ALT, M, N).
Highlight everything you want to change and then copy it (CTRL+C).
Then select a cell somewhere in the spreadsheet, right-click and selectPaste Special.
punch any of them and that figure will be copied to the clipboard for later use.
You may also want to check out ourTop 10 Hacks for Microsoft WordandTop 10 Hacks for PowerPoint.
