Difference between revisions of "Microsoft Excel"

From Sustainability Methods
(Created page with "- Category:Skills_and_Tools")
 
(cleaned up)
Line 1: Line 1:
- [[Category:Skills_and_Tools]]
+
{|class="wikitable" style="text-align: center; width: 100%"
 +
! colspan = "4" | Type !! colspan = "4" | Team Size
 +
|-
 +
| [[:Category:Collaborative Tools|Collaborative Tools]] || '''[[:Category:Software|Software]]''' || '''[[:Category:Personal Skills|Personal Skills]]''' || '''[[:Category:Productivity Tools|Productivity Tools]]''' || '''[[:Category:Team Size 1|1]]''' || [[:Category:Team Size 2-10|2-10]] || [[:Category:Team Size 11-30|11-30]] || [[:Category:Team Size 30+|30+]]
 +
|}
 +
 
 +
== What, Why & When ==
 +
 
 +
== Getting Started ==
 +
 
 +
 
 +
{{#ev:youtube|https://www.youtube.com/watch?v=ItXOGe7kVhY%7C1000%7Cright%7COur YouTube Tutorial|frame}}
 +
 
 +
 
 +
=== Shortcuts ===
 +
 
 +
Okay, here's some very useful shortcuts, descendingly ordered by subjective importance.
 +
 
 +
{| class="wikitable"
 +
|-
 +
! Shortcut !! Keyboard Combination !! Usage
 +
|-
 +
| Undo & Redo || CTRL + Z, CTRL + Y || The bread and butter shortcuts for everyone who messes up sometimes (which is everyone). This works in almost all software ever created by the way.
 +
|-
 +
| Copy Commands || CTRL + C, CTRL + X, CTRL + V || The C copies, the X cuts, and the V pastes. I hope you knew this already, but if you didn't, make use of it!
 +
|-
 +
| Fancy keyboard navigation || CTRL and Arrow Keys || Instead of trying to move your mouse exactly behind that word, try to get used to pushing your cursor around with the arrow keys. If you use CTRL and the arrow keys (to the ← left or the right →), you jump between words instead of letters. This works everywhere by the way.
 +
|-
 +
| Make heading || Alt + 1, Alt + 2, Alt + 3 || This makes the selected piece of text a level 1 heading. Can be used with 2 and 3 as well. Very useful for quickly structuring your document!
 +
|-
 +
| Show paragraphs and stuff || CTRL + Shift + * || This shortcut shows you linebreaks, tabs, pagebreaks and formatting. Very useful when you're trying to figure out why your document is a mess.
 +
|-
 +
| Page Break || CTRL + Enter || Inserts a pagebreak, saves you the trouble of inserting to many line breaks.
 +
|}
 +
 
 +
== Links & Further reading ==
 +
Of course, our own video covers everything you need to know: https://www.youtube.com/watch?v=ItXOGe7kVhY
 +
 
 +
----
 +
[[Category:Skills_and_Tools]]
 +
[[Category:Personal Skills]]
 +
[[Category:Software]]
 +
[[Category:Team Size 1]]
 +
 
 +
The [[Table of Contributors|author]] of this entry is Matteo Ramin.

Revision as of 15:20, 1 September 2022

Type Team Size
Collaborative Tools Software Personal Skills Productivity Tools 1 2-10 11-30 30+

What, Why & When

Getting Started


Shortcuts

Okay, here's some very useful shortcuts, descendingly ordered by subjective importance.

Shortcut Keyboard Combination Usage
Undo & Redo CTRL + Z, CTRL + Y The bread and butter shortcuts for everyone who messes up sometimes (which is everyone). This works in almost all software ever created by the way.
Copy Commands CTRL + C, CTRL + X, CTRL + V The C copies, the X cuts, and the V pastes. I hope you knew this already, but if you didn't, make use of it!
Fancy keyboard navigation CTRL and Arrow Keys Instead of trying to move your mouse exactly behind that word, try to get used to pushing your cursor around with the arrow keys. If you use CTRL and the arrow keys (to the ← left or the right →), you jump between words instead of letters. This works everywhere by the way.
Make heading Alt + 1, Alt + 2, Alt + 3 This makes the selected piece of text a level 1 heading. Can be used with 2 and 3 as well. Very useful for quickly structuring your document!
Show paragraphs and stuff CTRL + Shift + * This shortcut shows you linebreaks, tabs, pagebreaks and formatting. Very useful when you're trying to figure out why your document is a mess.
Page Break CTRL + Enter Inserts a pagebreak, saves you the trouble of inserting to many line breaks.

Links & Further reading

Of course, our own video covers everything you need to know: https://www.youtube.com/watch?v=ItXOGe7kVhY


The author of this entry is Matteo Ramin.