Microsoft Word & Excel 2016/365 Tips, Tricks & Shortcuts Webinar

Описание: Fast track your productivity with this quick Microsoft Word & Excel webinar.
Check the time stamps below for specific topic locations.

Subscribe to this channel to be notified of regular tips and shortcut videos I release each week.

Want step by step instructions?
Download the workbook for only $9.95 at https://www.donnahanson.com.au/youtubewb.

#exceltips #productivity #msoffice #exceltutorial #freetraining #businessproductivity #msword #freetutorial #exceltricks #excelhacks

Time Codes
0:00 Webinar Introduction
0:57 Word – Selection Techniques
1:39 Word – Resizing Text Shortcuts
3:00 Word – Setting Default Typeface and Font Size
3:35 Word – Word Keyboard Shortcuts
3:40 Word – How to use the Format Painter
4:34 Word – Understanding bullets in Word
5:00 Word – What is a Soft Return and how to use it
5:42 Word – How to see non printing characters using show hide marker
6:30 Word – Multi Level Bullets & Numbers
7:50 Word – Quick Line Creation Tips
8:00 Word – Formatting Tips
8:42 Word – Headers & Footers
10:39 Word – Inserting Page Breaks
11:35 Word – Inserting a Table
14:39 Word – Repeat Table Header Rows
15:11 Word – Templates
17:00 Word – Inserting data that is landscape from Excel into Word
21:48 Word – Inserting page numbers on a landscape page in a Word document
24:23 Word – Styles
26:21 Word – Table of Contents
28:48 Excel – Understanding date options in Excel
30:11 Excel – Leverage Excel to create a list of just weekdays
30:45 Excel – Tip to quickly insert rows in a spreadsheet
31:20 Excel – Adding Numbers – Autosum
32:35 Excel – Graphs
35:45 Excel – Seeing up data lists for analysis in Excel
36:47 Excel – Merge and Center
37:55 Excel – Splitting data from one cell into multiple cells (Text to Columns)
40:12 Excel – Adding data from cells together into one cell using the Concatenate Function
42:30 Excel – Changing data casing using Proper Function, Upper Function and Lower Function
43:33 Excel – Sorting & Filtering data lists
44:48 Excel – Using SubTotal feature to total data in a list
46:18 Excel – Understanding and using a basic pivot table
47:37 Excel – Pivot Table Slicers
48:15 Excel – Pivot Table Timelines
49:07 Excel – Copying or Duplicating Worksheets with formatting
49:54 Excel – Naming and Coloring Worksheet tabs
50:26 Excel – Add across multiple worksheets to create a total using 3 Dimensional Formulas
52:18 Excel – How to separate an individual worksheet to send to someone
52:52 Excel – Range names and VLOOKUP Function
57:02 Excel – How to create and run a macro
59:25 Excel – How to turn the macro into a button on the quick access toolbar


Follow me social media
LinkedIn: www.linkedin.com/in/donnahanson
Facebook: www.facebook.com/donnahansonspeaks
Find out more about Donna at: www.donnahanson.com.au
Short Courses: www.donnahanson.com.au/courses