Menu

21 Excel & 5 Outlook Tips and Tricks you’ve probably never seen before – FREE webinar

FREE online webinars run every few weeks for you to learn amazing new things in Microsoft Office

You can book on Eventbrite here and search for the course title or contact us to book your place

This free online demonstration demonstrates 21 features in Excel you probably never new existed and may not be shown on an Excel course. In addition to four Outlook tips and seven Windows 10 tricks that could save you time every day. 

Excel Tips and Tricks

Recovered unsaved documents (even if you select “don’t save”) 

Auto recover file (even if you select “don’t save” and not in 365) 

Quickly check workbooks for Hidden rows & columns, hidden worksheets, Comments, meta data, links, active filters, headers and footers, timelines or invisible content. 

Smart tags – the hated child – use them all the time 

Shortcuts to save workbooks, add up columns of numbers, add today’s date  

Hide formulas in protected worksheets 

Hide cell contents in protected worksheets 

The amazing world of tables and slicers 

F12 (File, Save as) 

Include day of the week and date in same cell 

Set up quick typing (eg. Type RW to insert Redwing Training) 

Increase all numbers by 10% (without a formula) 

Convert numbers to percentages (without a formula) 

Copy data from Rows to columns or columns to rows 

Copy and paste data retaining custom column widths  

Copy and paste to create a formula 

Check for features not supported by earlier versions of excel 

Set up hyperlinks to navigate around a worksheet 

Using excel without a mouse or touchpad 

Quickly Find cells with formulas 

Scribble in a workbook 

BONUS – How to remember hundreds of passwords without writing any down, or use an app 

Outlook tips and tricks

How to schedule up to 2 hours of focus time each day (and what that means) 

How to reuse text in different emails without using copy and paste 

How to create shortcuts to move emails to folders, set reminders and assign categories 

How to quickly date reminders and Calendar appointments 

Keyboard shortcuts to move from your Inbox, to Calendar to Tasks. 

An introduction to Taming Your Inbox – the amazing way to stay in control of emails