coffee break microsoft office efficiency...
TRANSCRIPT
![Page 1: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/1.jpg)
COFFEE Break
Microsoft Office
Efficiency Hacks
![Page 2: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/2.jpg)
Welcome
● MS Word
● MS OneNote
● MS PowerPoint
● MS Excel
● Questions
![Page 3: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/3.jpg)
Microsoft Word
References
Table of Contents
Track Changes
Helpful Hotkeys
![Page 4: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/4.jpg)
References
Ribbon (References) Insert Citations > Add New Source
![Page 5: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/5.jpg)
References
Create
Bibliography/
Reference
Sheet
![Page 6: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/6.jpg)
Table of Contents
Use headings for your text
![Page 7: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/7.jpg)
Table of Contents
● Ribbon (References)
Table of Contents >
Choose format option.
● The resulting Table of
Contents will be
clickable to easily
navigate the document.
![Page 8: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/8.jpg)
Track Changes
Ribbon (Review) > Track Changes
![Page 9: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/9.jpg)
Track Changes
Using the Review Pane: See changes and comments
made to the document. Helpful when editing or working
with others.
![Page 10: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/10.jpg)
Helpful Hotkeys
● To increase font size press Ctrl + [ or ]
● To change the letter case press Ctrl + Shift + A
● To change the boldness press Ctrl + Shift + B
● To change the italics press Ctrl + Shift + I
● To change the underline press Ctrl + Shift + U
● To insert the current date press Alt + Shift + D
![Page 11: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/11.jpg)
OneStop OneNote
OneNote is a file service that can be shared among
members of your organization.
Uses: Wiki, Training Materials, Daily Tasks
Password Protect Sections
Capturing Audio & Video
Email directly from OneNote
Have you ever wanted to take text from a picture?
![Page 12: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/12.jpg)
OneStop OneNote
This was an in product demo. If you have questions
please contact Cristopher Gibson.
![Page 13: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/13.jpg)
Microsoft PowerPoint
● Find CSP Branded PowerPoint
● Insert Screenshot
● Add Animation
● Reading View
● Combining Shapes
● Remove background from a picture
● Transitions/Timing on slides
● Kiosk Presentation
● Screen Recording
● Extras
![Page 14: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/14.jpg)
CSP Branded PowerPoint
● Go to https://concordia.csp.edu/marketing/brand/university-powerpoint-template/
● Download the PowerPoint template file (potx) and save it to your desktop
● Open PowerPoint
● Click the File tab
● Click options
● Click save
● Paste C:\Users\UserName\AppData\Roaming\Microsoft\Templates\ in the Default personal templates
location box
● OK
![Page 15: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/15.jpg)
Feature 1 – Insert Screenshot
● Click the insert tab on the ribbon
● Select the dropdown arrow on the Screenshot Icon
● Select the window you would like the screenshot of
![Page 16: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/16.jpg)
Feature 1 – Insert Screenshot
![Page 17: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/17.jpg)
Feature 2 – Add Animation
● Click on the Animations tab
● Click Add Animation
● Add animation and/or timing in the animation pane
![Page 18: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/18.jpg)
Feature 2 – Add Animation
![Page 19: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/19.jpg)
Feature 3 – Reading View
Reading View will preview the slide without having to run the whole presentation.
The icon is found in the bottom right corner or on the View Tab
![Page 20: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/20.jpg)
Feature 3 – Reading View
![Page 21: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/21.jpg)
Feature 4 – Combine Shapes
● Select pre-created shapes from the Insert Tab
● Position them on the Slide
● Select all object to merge
● Click Drawing Tool – Format Tab – Merge Shapes Menu - Combine
![Page 22: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/22.jpg)
Feature 4 – Combine Shapes
![Page 23: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/23.jpg)
Feature 5 – Remove Background of a Picture
● Insert a picture into a slide using the Insert Tab
● Click the Picture Tools Tab
● Format Tab
● Click remove background
![Page 24: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/24.jpg)
Feature 5 – Remove Background of a Picture
![Page 25: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/25.jpg)
Feature 6 – Transition timing on slide
● Click Transitions Tab
● Duration - Set a time for how long a slide will show (in seconds)
● Click Apply to All
![Page 26: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/26.jpg)
Feature 6 – Transition timing on slide
![Page 27: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/27.jpg)
Feature 7 – Kiosk Presentation
Runs presentation in a loop with human intervention
● Click the Slide Show Tab
● Select Set Up Slide Show
● Check the box for Browsed at kiosk (full screen)
● Check the box for Loop continuously until ‘ESC’
![Page 28: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/28.jpg)
Feature 7 – Kiosk Presentation
![Page 29: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/29.jpg)
Feature 8 – Screen Recording
● Insert Tab
● Media Selection
● Screen Recording
● Right click on image on slide to select start automatically
![Page 30: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/30.jpg)
Bonus Features
● Slide Sorter – Help see the flow of the presentation
● Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without
having to open in design view)
● Notes are available for each slide. Run presentation select Show Presenter View
to see notes on computer and have the presentation on screen.
![Page 31: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/31.jpg)
Feature 7 – Kiosk Presentation
![Page 32: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/32.jpg)
MS Excel
AGENDA
Formula vs Function
Function Argument
Window
Helpful Features
![Page 33: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/33.jpg)
Formula vs Function
Function Argument
Window
Helpful Features
MS Excel
An Excel function is a pre-built formula with
a specific purpose. Excel provides
hundreds of functions in various categories
like dates and times, text, statistics, lookup,
financial, engineering, etc.
An Excel formula is a way of defining a specific calculation in a
worksheet. In Excel, all formulas must begin with an equals sign
(=).
![Page 34: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/34.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
OR
![Page 35: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/35.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
![Page 36: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/36.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
![Page 37: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/37.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
![Page 38: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/38.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
![Page 39: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/39.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
![Page 40: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/40.jpg)
The default cell references are relative
references and they change based on the
relative position of rows and columns.
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
$ Cell Reference $Relative Cell References
Absolute Cell Reference
When you don’t want the reference to
change in a formula, setting an absolute
reference is required. This can be done by
pressing the F4 key.
Moving the formula to a new cell will change
the cell references.
Moving the formula to a new cell will now
only change the reference in column B.
![Page 41: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/41.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
Status Bar
Customization
![Page 42: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/42.jpg)
MS Excel
Formula vs Function
Function Argument
Window
Helpful Features
Status Bar
Customization
Right
Click
So
MANY
Options!!!
![Page 43: COFFEE Break Microsoft Office Efficiency Hacksconcordia.csp.edu/.../28/MSOffice-Efficiency-Hacks.pdf · Save as .PPSX to save as PowerPoint Show (starts the PowerPoint without having](https://reader034.vdocuments.us/reader034/viewer/2022042302/5ecd87e8d525a4298018ec63/html5/thumbnails/43.jpg)
THANK YOU!!!!!!!