120 Microsoft Office Tips & Tricks for 2020 📊

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