120 Microsoft Office Tips and Tricks – 2020 – Instant Efficiency – Microsoft Office Crash Course




About this tutorial:

Video duration: 03:22:41
120 powerful tips and tricks for Microsoft Office. Smart. Fast. Efficient. 3 hours of powerful content by Dr. Nitin Paranjape.

0:00:00 – Introduction
0:02:47 – OneDrive ==================
0:02:47 – Always store files on OneDrive
0:04:21 – Auto Save – No file corruption
0:07:06 – Share links – Not attachments
0:09:07 – Automatic versioning
0:10:11 – Use on Mobile / Tablet / Browser
0:10:34 – Excel ==================
0:10:47 – Create one Excel sheet by default – not 3
0:11:40 – Notice and correct all Green Marks
0:14:31 – Understand how to capture GOOD data
0:15:36 – Use Flash Fill to clean data instantly
0:18:04 – Get and Transform to clean up data
0:18:59 – Always use Excel Tables
0:19:11 – Automatic Formulas and Charts update
0:21:27 – Excel 3D maps
0:24:24 – Recommended Charts
0:25:56 – Sparklines
0:27:16 – DO NOT use subtotals
0:28:18 – Use Pivot Tables for analysis
0:30:07 – Use Show Values As
0:32:21 – Calculated Fields / Items
0:35:01 – How to learn Excel functions
0:38:42 – Learn PV, FV, PMT Excel Function Tutor
0:39:47 – Learn Goal Seek
0:41:49 – Stocks and Geography
0:43:50 – Conditional Formatting
0:45:03 – Instant Forecasting
0:49:37 – Quick Analysis
0:51:29 – Use Excel Print Layout (not print preview)
0:52:38 – Importance of “” and – sign in Google Search
0:53:51 – Outlook ==================
0:54:12 – Start using Calendar
0:54:54 – Understand Focus mode
0:56:28 – Tasks Folder – Master list of work
0:58:26 – Find time to execute the Tasks
0:59:34 – Use color while communicating on email
1:00:00 – If you want inputs, create a table
1:01:22 – OneNote ==================
1:01:22 – Use OneNote for all types of note taking
1:02:36 – Link notes to meetings
1:04:51 – Convert notes to Tasks
1:05:50 – Browser Copy Paste to OneNote
1:06:30 – Record audio during Meetings
1:08:56 – Use OneNote Calculator
1:09:34 – Print to OneNote and search printed text / pictures
1:11:28 – Use Handwritten notes
1:12:47 – PowerPoint ==================
1:12:53 – Never use bullets
1:13:28 – Create 3D Objects with Windows 10 Paint
1:15:39 – Use 3D Clipart
1:17:06 – Use Selection Pane
1:19:23 – How to Crop
1:22:10 – Remove background without Photoshop
1:24:19 – Use AI – Design Ideas
1:27:24 – Manage presentations using Sections
1:30:24 – Create interactive menu with Insert Zoom
1:31:56 – Use SmartArt instead of text
1:35:33 – Learn all SmartArt diagrams
1:36:47 – Use Icons instead of old clipart
1:37:18 – Use and Customize Slide Layouts
1:38:22 – Learn All Animations
1:40:11 – Understand the Animation Pane
1:40:15 – Learn all Transitions
1:42:14 – Use Morph
1:45:50 – Screen Recording within PowerPoint
1:46:25 – Record narration in a presentation
1:47:02 – Create video from PowerPoint
1:47:29 – Embed fonts in presentation
1:48:14 – Slides should not replace you… Use Presenter view
1:49:00 – Word ==================
1:49:03 – Shift Enter
1:50:04 – Vertical Selection
1:50:05 – Correct copy paste technique
1:51:16 – Get 24 Clipboards
1:52:19 – Use Styles – no more manual formatting
1:53:33 – Word Navigation Pane
1:54:53 – Automatic Table of Contents
1:55:26 – Use Sections
2:01:06 – Find word forms
2:02:13 – Find text with similar formatting
2:04:01 – Never use Tabs for alignment
2:05:12 – Create / Draw Tables
2:09:25 – Table Autofit
2:10:13 – Repeat Header Rows
2:11:53 – Images autofit
2:13:14 – Custom Toolbar – QAT
2:16:22 – Word to PowerPoint
2:18:42 – Add to QAT
2:20:27 – Dialog Launchers
2:22:59 – Hyperlinks Ctrl K
2:24:38 – Cross reference
2:24:40 – Use Templates for common needs
2:27:57 – Quick Parts in Word
2:30:25 – Always use Theme color
2:33:24 – Word Smart Lookup
2:34:08 – Shift F7 Thesaurus
2:34:50 – Word Grammar Editor
2:38:05 – Word Researcher
2:40:33 – Use Bibliography Feature
2:43:40 – How to zoom out in Word – multiple pages
2:44:39 – Ask for inputs in Comments with @
2:46:49 – More topics
YouTube TOC cannot show more links after this.
Use this timeline as a reference to move to specific topics.

2.48.53 – Three ways to use Find in Word
2.53.20 – Encrypt files with password
2.54.10 – Understand Save as Final
2.55.42 – Track changes
2.57.57 – Compare documents without track changes
2.59.18 – Combine documents with multiple tracked changes
3.00.21 – Use Format Painter (double click)
3.02.05 – Browser editing of Office files
3.03.01 – Reading view in Word
3.04.43 – Focus mode in word
Assorted topics ==================
3.05.05 – Pin Office to Taskbar and Pin files + folders
3.08.00 – Build Visual Vocabulary
3.10.21 – Brain, Who is helping whom
3.10.57 – How to learn
3.12.01 – Use a password manager
3.13.42 – Always use 2 factor authentication / Windows Pin / Hello
3.14.21 – Mouse Right Drag
3.15.23 – Shift Ctrl V = Paste Special
3.15.49 – How to learn shortcuts
3.17.28 – Learn typing
3.18.48 – Use a mouse (not touchpad)
3.19.39 – Install all mobile apps
3.20.08 – Google, Apple, Microsoft
3.21.18 – Buy Office 365

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads