Enliten IT Training

Enliten IT delivers computer training courses on Microsoft, Adobe, Oracle, IBM Notes, AutoDesk, Articulate, Quark and other vendor software products.

[Enliten IT Training @enlitenit]

Every Friday 11:00 - £3 per session - Over 50s

https://t.co/VByOlYj5m8

[Enliten IT Training @enlitenit]

Outlook Mail
Recall option only works if you use MS Exchange account and the recipient also does!
Control is lost when sending to gmail/Microsoft/etc. or other email server accounts.

[Enliten IT Training @enlitenit]

Web Browser keyboard shortcuts - comparison chart
https://t.co/eusHZIG4W8

Excellent stuff!!

[Enliten IT Training @enlitenit]

MS Outlook keyboard shortcuts:
Mail: [Ctrl] + 1
Calendar: [Ctrl] + 2
Contacts/People: [Ctrl] + 3
Tasks: [Ctrl] + 4
Notes: [Ctrl] + 5
Folder List: [Ctrl] + 6

[Enliten IT Training @enlitenit]

@chris_furnell https://t.co/w2lXRiKhcq
Top guys!

[Enliten IT Training @enlitenit]

Web site scrolling - tired of using a mouse?
Press the SPACEBAR to go Down one page
SHIFT + SPACEBAR to go Up a page

[Enliten IT Training @enlitenit]

Excel - use tick marks and crosses
Type in the following:
Capital O = cross
Capital P = tick
Then format both the O & P to Wingdings2 font.
Colour the tick green and the cross red - Job done!!

[Enliten IT Training @enlitenit]

Excel Tables - Override local formatting
Local formatting is preserved by default even if you apply a style. You can override this by:
Right-click any style and choose "Apply and Clear formatting".

[Enliten IT Training @enlitenit]

Want a better Office? Want a new formula? Got some suggestions for Microsoft on how to improve?
Help or File ribbon, Feedback, Send a suggestion, fill out the relevant details!

[Enliten IT Training @enlitenit]

Office 365 - Check to see what’s new
File, Account, Whats New
or
Check the MS site @
https://t.co/WOQbaOnMui

[Enliten IT Training @enlitenit]

@spingordy You won't fit you bike in that Gordon 😇
Drop us an email with the house/France updates

[Enliten IT Training @enlitenit]

Excel tip
Want to add/delete cells (not rows/cols) then use Shift key with Autofill

[Enliten IT Training @enlitenit]

Outlook O365 Sept 2018 Build
To stop seeing reminders for past events:
File, Options, Advanced, "Reminders" section, tick the "Automatically dismiss reminders for past calendar events" box, OK

[Enliten IT Training @enlitenit]

MS Word shortcuts
* and Spacebar: to create a bulleted list

Quick Styles - Format text, click “Styles Pane” dropdown, Create a Style, give it a name, OK.

[Enliten IT Training @enlitenit]

@happyhenry @YourLPI @Dreamflight Henry, I though you were more Cyberman!!😂

[Enliten IT Training @enlitenit]

All good and dandy if you have O365. No good if Office 2016 desktop install.
Come on #Microsoft - lets update everyone!!

[Mark Egge @mnegge]

I just found the new love of my life: TEXTJOIN() in @msexcel

[Enliten IT Training @enlitenit]

Outlook tip
Create a sticky note by pressing Ctrl + Shift + N

[Enliten IT Training @enlitenit]

Toggle between app and desktop.
Just press Windows key + D twice

[Enliten IT Training @enlitenit]

Excel - Hide formulas
Home, Format, Format Cells, [Protection] tab, tick Hidden box, OK.
Home, Format, Protect Sheet, apply password if needed, OK.

[Enliten IT Training @enlitenit]

MS Word Tips
1. Hold Ctrl and press Backspace - delete entire words at a time
2. Type three hyphens and press enter = a horizontal line
3. Shift + F3 to change case between lower/upper/capital
4. File, Protect Document, Mark as final, makes it read-only