Our weekly handy top tips on Microsoft Office, Adobe CC and many more.. e.g. Excel, Word, Office 365, InDesign, Photoshop.
13 April 2018
To Add Guest Accounts in Microsoft Teams
Teams are listed on left
1 R-click on Team name, select Add Members
2 Enter persons email address (if outside your company, Teams will auto add them as guest)
3 User accepts the request and can log in and use Teams just like a standard user.
3 April 2018
How long have I worked here? Excel length of service formula where D5 = Joining date:
=DATEDIF(D5,TODAY(),"y")&" years, "&DATEDIF(D5,TODAY(),"ym")&" months, "&DATEDIF(D5,TODAY(),"md")&" days"
28 February 2018
Windows 10 - Sticky Notes
No Post IT notes to hand - use the free one supplied in Windows 10.
1. Click in 'Type here to search' box on taskbar
2. Start typing stic
3. Click on Sticky Notes from the listed items!
28 February 2018
Get rid of alerts every time you receive new email.
File, Options, Mail, untick “Display a Desktop Alert”, OK.
20 February 2018
Quickly select all cells containing a word/phrase
1. Ctrl + F
2. Type in the word/phrase you are looking for
3. Click Find All
4. Click on any of the shown matches
5. Ctrl + A (to select them all)
6. Close the Find & Select window
14 February 2018
Windows 10 tip
TO get rid off irrelevant menu items:
1 In Explorer go to this folder
2 C:\ProgramData\Microsoft\Windows\Start Menu\Programs\
3 delete any folders/software icons as required.
14 February 2018
Conditional formatting Pivots eg data bars
1 Select Pivot Table column
2 Conditional Formatting, Data Bars, & pick a colour
3 MUST – Click the little icon at the bottom of the data and apply the formatting rule to the PIVOT FIELDS
14 February 2018
Filter x number of items in a Pivot table
1 Select the items you want (can be non-contiguous )
2 R-click, Filter, Keep Only Selected Items
You can also do the reverse and hide the items:
R-click, Filter, Hide selected items
11 February 2018
#Win10 - Change Icon Sizes on Desktop
1. R-click in any empty space on the desktop.
2. Select View.
3. Choose Large icons, Medium icons, or Small icons.
5 February 2018
Office 365 PPT - turn your mouse icon into a laser pointer.
You can use your mouse as a fake laser pointer:
Slide show, Set up Slide show, Laser Pointer colour, OK
Now to use it during your slide show simply hold down CTRL and press the left mouse button
4 February 2018
Print File/Folder lists in Windows Explorer
1- go to the folder you want to print contents list
2- In address bar type CMD, & Enter
(command prompt opens)
3. Type dir>files_folders.txt
4. Press Enter
Now just open your txt file or import into Excel!
18 January 2018
Did you know you can use Slicers in a filtered table?
1. Create a list
2. [Home], Format as table
3. [Data], Filter
4. [Insert], Slicer
5. Tick the Fields you want to use
24 December 2017
Turn Off video Autoplay in Firefox
Type “about:config” in location bar.
Opens new window with a warning, just ignore it & view config options.
Search 4 “autoplay”.
Theres a preference called “media.autoplay.enabled” with value of True. Double click on it to switch it to False.
4 December 2017
Microsoft teams shortcuts
Press R key on keyboard to reply to a thread
Press Alt-A to attach a file to a message
View all keyboard shortcuts – press Alt-/ (Alt and forward slash) in Windows.
27 November 2017
Excel – stop Enter key moving down – its really annoying!
File, Options, Advanced, untick the ‘After Pressing Enter, Move Selection’ box, OK
10 November 2017
Outlook recall and replace a message
1 Sent Items folder, Open message that you want to recall
2 Actions > Recall this Message
3 Delete unread copies of this message
20 October 2017
Windows 10 – delete all empty folders
Open Explorer, Search tab – Click on Kind & select folder, click on Size, select 0 and click Search
28 September 2017
Replace empty cells with zero values in a chart
R-click chart, Data, Hidden and Empty Cells, Zero, OK, OK
12 September 2017
Add bullets in Excel
Within A Cell – press Alt + 7 (number must be from the number pad)
5 July 2017
Excel Keyboard shortcuts on a Mac
Absolute – ⌘T
Fill Down – ⌘ D
Fill Right – ⌘ R
Format cells dialog – ⌘ 1
Close active file – ⌘ W
2 June 2017
Shift + F2 – Add cell comment
CTRL + F1 – Collapse/Expand ribbon
CRTL + 1 – Format Cells dialog
CTRL + ; – Insert today’s date
23 May 2017
Outlook 2016 Mark Items as Read Timer
File, Options, Mail, Reading Pane button, Mark items as read when viewed in the Reading Pane, 60sec,OK
28 April 2017
Excel: See all characters in font set
Put this formula in A1 =CHAR(ROW())
Copy this down 265 places
24 April 2017
MOS: Microsoft Office Specialist 2016
All you need to know can be accessed here:
17 March 2017
#Windows10 – Stop annoying adverts
Settings, Personalization, Start, “Occasionally show suggestions in Start” = Off.
1 March 2017
Defer sending email
File, Manage Rules&Alerts, New Rule, Apply rule on messages I send, Next, Defer delivery by number of minutes, 2, ok
10 February 2017
Double-click anywhere on page and start typing (does not matter if area is blank).
6 February 2017
Use CONVERT function e.g. imperial to metric measures or Temperatures
Loads of options
23 January 2017
Word2016 tip – Insert File folder location into the footer
Click in footer area, Design, Document Info, File Path
12 January 2017
Office 2010 onwards – Keep important documents pinned
File, Open, click on push-pin icon on the right hand side of the selected file.
6 December 2016
#MSWord quick tips
Ctrl + click selects current sentence.
Horizontal line – type 3 hyphens and Enter.
CTRL+backspace deletes preceding word
18 November 2016
Windows10 Update error 0x800706d9
Firewall is not activated
R-Click Start, Control Panel, System & Security, Windows Firewall, Turn it on
17 November 2016
Excel Dates tip
Use Text to Columns feature to convert dates from US to UK format.
Use Step 3 of the process to select date format required
8 November 2016
Select data, F5, Special.., Row Differences, OK
7 November 2016
#Excel Quickly move between many sheets
R-click the VCR Control area (bottom left) and a sheet list of all tabs will show up!
21 October 2016
Excel Date formulas
Last day in month =EOMONTH(B6,0) – Use zero to give last day of month as per cell B6.
1=next month or -1 previous month
14 October 2016
Word Spell check not working properly
Too much to put into Twitter – check this out its marvelous!
20 September 2016
Delete a table without losing the data or formatting
Design tab, (Tools group), click Convert to Range, Yes
7 September 2016
#SharePoint365 autosize col width to fit any text
6 September 2016
F11 – change Default chart style
1. Design tab click Change Chart Type
2. R-click Chart you want, Set as Default Chart, OK
15 August 2016
Delete the Windows.old folder
type Cleanup in search box
Clean up system files
tick – Previous Windows installation(s)
29 July 2016
More Enliten IT Training Retweeted Richard Adams
Bit draconian methinks!
Obviously the head never taught English!!!Enliten IT Training added,
26 July 2016
Rename multiple files at once – Windows
1 Select files to rename
2 r-click one & select Rename
3 Type name, Enter.
20 July 2016
#Pivots Dynamic range to capture added lines
1. Ctrl-T to create a Table
2. Design, Summarize with PivotTable
3. Build as pivot as normal
17 June 2016
Excel Autosum shortcut
Windows – ALT + = (the equal sign).
OS X – Command – Shift – T by default
15 June 2016
Need to convert data from one measurement system to another? Don’t fret use the CONVERT function
1 June 2016
Excel Arrange Windows (little known method)
Shift Key & r-click on Excel icon on the Windows Task Bar – you get options for arranging !!
27 May 2016
Office 365, user photos stored
low-res (<100KB) ThumbnailPhoto attribute in Active Dir
high-res in root dir of user Exchange Online mailbox
20 May 2016
ALT + = (Autosum)
CTRL + Shift (Drag a shape in line)
ALT and drag a shape/chart (Snap to grid)
19 May 2016
Add Folder to Library
File Explorer, select folder in Libraries, Manage tab, Manage library, Add select a folder/drive, Include folder, OK
12 May 2016
#AutoCAD2016 shortcut for TOGGLES:
F10 Polar Tracking
5 May 2016
Turn off Protected View
File, Options, Trust Center, Settings, Protected View tab, Enable protected view for files originating from internet
25 April 2016
#Excel Date Maths
Take one date from another will give a minus no if one is a future date. To see no of days (without minus sign =ABS(A1-B1)
1 April 2016
More Enliten IT Training Retweeted Barclays UK Help
so how do I find out how it’s progressing?Enliten IT Training added,
Barclays UK Help
31 March 2016
Clear browsing history shortcut
Ctrl, Shift and Delete (and pick your options) – works in IE; Chrome, Firefox
Ctrl, Alt and E – Safari
21 March 2016
Outlook – Auto Delete Mail Selectively
In any folder, R-click on email, Rules, Always Move Messages From:, select Deleted Items folder, OK
8 March 2016
Press Ctrl+Enter to place the same text/formulae in multiple cells
29 February 2016
Sheet protection – You cant sort protected cells!
Create macro to turn Protection off, do the sort and then put protection back on
26 February 2016
Excel, Copy Subtotals
1. Create Subtotal & goto level 2
2. Select subtotal cells
4. F5, Special, Visible cells only, ok
22 February 2016
Hide rows (Ctrl+9); Unhide rows (Ctrl+Shift+9);
Hide Cols (Ctrl+0); Unhide cols (Ctrl+Shift+0);
9 February 2016
Ever shut down a tab in Internet Explorer accidently?
No problem – to get it back press:
27 January 2016
#Explorer Send To: options missing?
Goto – C:UsersUSERAppDataRoamingMicrosoftWindowsSendTo
& delete the Bluetooth option (0 bytes)
7 January 2016
No Outlook contacts in TO:
R-click Contacts subfolder, Properties, email address book folder, Tick “Show this folder as email address book”
9 December 2015
#Win10 Disable Bluetooth
Windows key + R, type in devmgmt.msc, Enter, Bluetooth, r-click on your Bluetooth adapter, Disable
2 December 2015
More Enliten IT Training Retweeted Watson Martin
#HRqualsEnliten IT Training added,
23 November 2015
Create autonumbering sequence e.g. 1-100 that deals with deleted cells
A. In A4 type 1
B. In a5 type =COUNTA($A$4:A4)+1
16 November 2015
Excel 2016 use data analysis add-ins
File, Options, Advanced, tick Enable Data Analysis add-ins: Power Pivot, Power View, and Power Map, ok
13 November 2015
Big patch update coming out today..
3 November 2015
Office2016 – add Google Drive to Save As
1 install free Google Drive plug-in for Office (driveforoffice.exe)
2 Launch Word, follow wizard
26 October 2015
Win10 – ISO images
No 3rd party software needed 4 ISO images.
R-click on ISO file, click ‘Mount’.
ISO images are now virtual discs
7 October 2015
#Excel tip – Remove annoying clip art/icons pasted from web.
[Home], Find and Select, Go To Special, tick Objects box, OK
5 October 2015
Windows Safe Mode boot
Use Shift + Restart (works in Windows 8 & 8.1) to force a safe boot with advanced options
24 September 2015
Stop Outlook using pop-up windows
File, Options, Mail, Replies and forwards, tick Open replies and forwards in a new window
27 August 2015
#SharePoint tip Sync SharePoint Calendar with Outlook
Open calendar, Click CALENDAR tab, Connect to Outlook (Connect & Export Group)
20 August 2015
You can now copy/paste in Command Prompt!
Open command prompt, R-click title bar, Properties.
Enjoy.. the new options
18 August 2015
ISO files – How to read them.
Use Windows 8.x to mount an ISO file easily by:
Select the ISO file, Right-click and select Mount.
13 August 2015
Huge file size but not much in it? a format issue Remove all formatting & redo.
1 Select whole sheet
2 Home, Clear, Clear Formats
7 August 2015
Win key+Ctrl+D – Add virtual desktop
Win key+Ctrl+Left/Right arrow – Switch virtual desktops
Ctrl+Alt+Tab – View open apps
29 July 2015
Want to highlight a complete block of data quickly e.g. for a pivot table?
Ctrl + Shift + 8 (put cursor anywhere in block)
22 July 2015
16 disgruntled holiday makers. Fiasco stranded in Sorrento port. Package trip a disaster. No reps available. POOR SHOW
7 July 2015
Office 365 – Share file from Office desktop app
File, Share, Invite People, select people, select permissions, type message, click Share.
23 June 2015
CTRL+0 – Zoom to 100%
CTRL+J – View downloaded files
CTRL+SHIFT+P – InPrivate browsing
CTRL+SHIFT+Delete – Del browsing History
19 June 2015
#Excel tip – Moving around blocks of data
Double click on a cell border to get to the bottom/top/left/right end of a list of data
29 May 2015
Want to edit an existing email?
1 Open email
2 [Message ribbon], Actions, Edit message
3 Make changes
4 Press ESC key, Yes
28 May 2015
If you have highlighted a bunch of cells:
Press Ctrl+. (period) to move the active cell clockwise to the next nearest corner.
21 May 2015
New doc use Calibri/double spacing by default.
Right-click Normal stylesheet icon, Modify, New Docs based on this template
29 April 2015
Comments – Highlight portion of text, [Review], New Comment
AutoBullets – type an asterisk & hit spacebar
Thesaurus – Shift+F7
27 April 2015
Microsoft do a free Tip of the Day for Office 365 – get it from this link
20 April 2015
Want to locate all your formulas? This easy command will highlight them all for you..
[Home], Find & Select, Formulas
15 April 2015
Calculating persons age?
where C2 is the persons DOB.
13 April 2015
4k Training Grants available in Essex for new starters.
https://www.essex.gov.uk/Business-Partners/Business-Advice-Support/funding-business/Skills-for-economic-growth/Pages/Default.aspx … … @halfon4harlowMP @Harlowstar
8 April 2015
CTRL+F – Send a file
CTRL+W – Show/Hide IM area
CTRL+R – Show participants
CTRL+Shift+I – Mark as Important
2 April 2015
#Office_2013 Download your free Microsoft Office 2013 quick reference cards from here.
30 March 2015
Lotus Domino file locations and troubleshooting tips
23 March 2015
Add frequently used folders to your Library in Explorer
1. R-click on the folder
2. Include in Library, pick the 1 you want
18 March 2015
InfoPath- create dynamic label
1.Add Text Box control & D-click it
3.Display tab, tick Read-only, OK.
Rules/filters 2 change text in field
13 March 2015
Win 8 – Keyboard Shortcuts
Maximise window – Windows logo key and up arrow
Minimise window – Windows logo key +Down Arrow
12 March 2015
#Office2013 Ribbon choices
Click Ribbon Display options icon (top right next to ?)
Show Tabs and Commands (default)
10 March 2015
#Office2013 – Disable start screens
File > Options > General > untick the box “Show the Start screen when this application starts” > OK
3 March 2015
#MSProject: move completed task parts back 2 Status date
File,Options,Advanced, Move end completed parts after status date back status date
2 March 2015
Outlook2013 tips Calendar weather options:
23 February 2015
Ctrl+6; Insert Sticky Note
Shift+Ctrl+D; Delete Pages
Ctrl+R; Show/Hide Rulers
Ctrl+U; Show/Hide Grid
17 February 2015
File, Save for Web – use Image Size controls to resize pic (width/height pixels, or % value.
Great 4 sharing pic on blog etc
16 February 2015
Windows 8.1 & Acrobat – if View, Preview Pane activated you cant delete the PDF file (basically it’s in use). Disable preview pane!
10 February 2015
Download & distribute to your colleagues – Free Microsoft Office 2013/Office 365 quick reference cards:
9 February 2015
Press Shift+Esc to view the Chrome Task Manager
R-click on a tab you can choose to pin it to the browser.
29 January 2015
Not sure what your quota is?
R-click status bar, Click Quota Information
Ur available quota shows bottom left side status bar
26 January 2015
To set up social networking in #Outlook
File, Account Settings, Social Network Accounts and follow the onscreen instructions
23 January 2015
Free technical ebooks from Microsoft Virtual Academy to download
22 January 2015
Well it’s going to be a free upgrade when released (but only for the first year!).
Might encourage business to finally adopt.
20 January 2015
#Win8.1 tip – show Administrator account
Activate the Command prompt and type in:
net user administrator /active:yes
19 January 2015
#Win8.1- Always Start Application as Administrator
R-click App/Shortcut, Properties, Compatibility tab, Run this program as administrator,ok
15 January 2015
Registered Trademark (®) =Option+R(Mac); Alt+0174(Win)
Trademark™ =Option+2(Mac); Alt+0153
Copyright © =Option+G(Mac); Alt+0169
12 January 2015
Want to remove your password?
Settings, Change PC settings, Accounts, Your account, Disconnect, follow prompts
9 January 2015
#OutlookWebApp – Recover deleted emails
In the email folder list, r-click Deleted Items, click Recover deleted items…
6 January 2015
Create multiple evenly spaced same shapes
1 copy shape (Ctrl+Drag)
2 Ctrl+Y & repeat X times
copy this row X times 2 create grid
18 December 2014
#Word_tip REMOVE all formatting quickly
1 copy text & paste into Notepad
(Notepad only uses unformatted text)
2 copy & paste back into Word
16 December 2014
#Lync2013 Share file presentation
open file, File, Share, Present Online, Present
select scheduled meeting or Start a new Lync meeting, OK.
12 December 2014
#Word Online tips
Ctrl+Z – Switch to Zoom control
Ctrl+G – Switch to page-number control
Ctrl+Period – Bulleted list
Ctrl+E – Align centre
10 December 2014
#Office2010/13 tip Recover unsaved documents:
File, Open, Recent Documents, Recover Unsaved Documents (bottom of screen), follow prompts..
8 December 2014
#Acrobat Combine pages from several docs
File, Combine, Merge Files into a single PDF, Add Files, pick docs, choose ur pages, Combine Files
4 December 2014
Lock Position/Unlock Position F6
Bring to Front F5
Bring Forward Ctrl+F5
Send to Back Shift+F5
Send Backward Ctrl+Shift+F5
1 December 2014
#Win8.1 Boot 2 desktop
Rclick desktop toolbar, Properties, Nav tab, “When I sign in/close all apps on screen, go 2 desktop instead of Start”
24 November 2014
Learn PowerQuery from Microsoft.
19 November 2014
#Office2010tip – Show the Location of a File
File, Options, Quick Access Toolbar, Commands not in the ribbon, Document Location, Add>>, OK
17 November 2014
CTRL + Enter – Page Break
SHIFT + Enter – Line break (good with bullets/numbers)
CTRL + Tab (move to tab in a Table)
13 November 2014
Don’t bother typing lots of dash lines – use the Repeat function
12 November 2014
Can’t find cloud shapes?
View, Shapes, More Shapes, Search for Shapes, type ‘cloud’, choose from the list
11 November 2014
Use N function to add a Comment in a cell formula
e.g. =B24*5%+N(“we think this pay increase amount is reasonable”)
10 November 2014
We like donkeys so are going to sponsor a Donkey! #theDonkeySanctuary
Lots to pick from – still deciding!
Make a donkeys day – get involved!
30 October 2014
To scroll the page in jQuery:
28 October 2014
Adjust Type Size – CMD + Shift + < or > to increase/decrease
Changing Fonts – Use CMD + 6 makes cursor goto font being used
27 October 2014
stop sentence capitals
File, Option, Proofing, AutoCorrect Options button, untick Capitalize first letter of sentences box, OK
23 October 2014
convert numbers stored as text:
1 Select cells
2 Click warning indicator (next to top-most cell)
3 Click Convert to number
21 October 2014
label all objects b4 creating Drag&Drop!
Coz If u want to add/edit names after Drag&Drop links created, you’ll break the links
17 October 2014
SharePoint setup alerts (email/SMS) whenever things change.
Click Alert Me button; choose context, scope, and time for alerts
16 October 2014
R-click Windows icon, Control Panel, System&Security, Windows Update, click optional, R.click any updates you dont want, Hide updates
15 October 2014
Hard page break – Ctrl + Enter
Soft page break – Shift + Enter
10 October 2014
Set emails to auto destruct after x days:
1. Start email
2. File, Properties, Expires after, put in a date & time, Close
8 October 2014
D-click Shape tool to select all nodes of selected object.
ALT with Shape tool (F10) lets u select nodes in freehand mode
7 October 2014
IE has two page clippers: Send to OneNote & Link to OneNote.
It preserves page formatting, timestamps, and adds the source URL
6 October 2014
Use Sumproduct to calculate arrays
3 October 2014
1. explicit phrases enclose in quote marks eg “Saab cars”
2. Exclude specific words with the minus sign eg F1 -Vettel
23 September 2014
Ctrl + J = downloads
Ctrl + H = History
Ctrl + N = New tab window
Ctrl + Shift + N = new Incognito window
Ctrl + D = Bookmark
22 September 2014
Mark as read – CTRL+Q
Mark as unread – CTRL+U
Send – CTRL+ENTER
Look for people in ‘Search Address Books’ – F11
19 September 2014
1 File, Security, User Security, P/W, Log In
2 Change Password, enter current P/W, Log In
3 Type new P/W, Generate Password
15 September 2014
Make sure the analysis toolpak is installed for more functions.
File, Options, Add-ins, Go, tick the ones you want, ok
11 September 2014
Get rid of outdated updates
2. type CLEANMGR, Enter
3. OK to C: and wait
4.Tick “Windows Update Cleanup”, OK
10 September 2014
To quickly rotate images in Windows Explorer
1. Select images
3. Rotate clockwise/counter clockwise
8 September 2014
Turn data in columns to rows (or vise versa)
1. copy the row or column
2. r-click destination cell
3. Paste Special, Transpose OK
2 September 2014
Copy & Paste an image/shape in ONE command!!
29 August 2014
to set the default font on all docs
2. Pick a font
3. Set as Default
4. All docs based on normal.dotm template
28 August 2014
Find duplicates in 2 lists
1 Select cells in both lists
2 Conditional Formatting, Highlight Cells Rules, Duplicate Values
20 August 2014
Delete unused Auto-suggested names:
1 Start typing name/email address.
2 Pick unwanted (use Up/Down Arrow)
3 Press Delete key.
19 August 2014
CRM 4 Outlook user settings:
Tick checkboxes appointment, task etc. to get CRM customised form rather than standard Outlook form.
6 August 2014
Group – Ctrl+G
Lock/Unlock Position F6
Bring to Front F5
Bring Forward Ctrl+F5
Send to Back Shift+F5
5 August 2014
Windows+N shortcut provides the options to send a screen clipping to OneNote or to create a new quick note.
4 August 2014
Drag email onto Calendar icon to quickly add details to your diary..
31 July 2014
CTRL+Shift+P – Format Painter On/Off
CTRL+Shift+dot – Increase font
CTRL+Shift+comma – Decrease font
29 July 2014
Sorry to say that MapPoint is being discontinued at the end of this year!
Online support will last until at least July 2015.
28 July 2014
F6 – Dynamic UCS
F7 – Grid
F8 – Ortho
F9 – Snap
F10 – Polar
F11 – Object snap tracking
F12 – dynamic input mode
24 July 2014
Ctrl+D – add site to favourites
Ctrl+Shift+P – InPrivate browsing
Ctrl+0 – Zoom 100%
Ctrl+K -Duplicate tab
Ctrl+T New tab
22 July 2014
#MSOfficetip Draw perfect circle:
1 – hold Shift key whilst drawing oval shape
2 – Ctrl & Shift to centre the circle at point u clicked
18 July 2014
#Outlook2010tip Empty the rubbish automatically.
File, Options, Advanced, Tick ‘Empty Deleted Items folders when exiting Outlook’, OK
15 July 2014
After applying filter in Gantt chart press F3 to view all tasks again.
Alt-Home in Gantt chart 2 position to start of project
14 July 2014
neat trick to get a textbox linked to cell value.
Select the box, click in formula bar, enter your formula eg =F6
7 July 2014
Neat idea – I think we will get a few around the office!!
4 July 2014
Zoom to Region
Ctrl + Shift + Left Mouse-drag (just drag a net around the area that you want to zoom into)
1 July 2014
1.Select all shapes. (primary shape=thick pink edge that rest align 2)
2.Shape, Align Shapes
3.pick left, middle or right, OK
19 June 2014
To add the Ruler:
1 CTRL N
2 QAT dropdown, More Commands, “Choose commands from” = All commands, Ruler, Add>>, OK
18 June 2014
From start screen – to pin any application to the taskbar just right-click on it; from App Bar click Pin to taskbar.
16 June 2014
Is it just me or are the MOS 2013 exams really badly written and confusing?
12 June 2014
Articulate Engage 13 shortcuts:
Ctrl+G – Add new segment to Circle Diagram or Pyramid interaction
F12 Preview interaction from beginning
9 June 2014
Microsoft Office Ribbon tip
Add shortcuts to your Quick Access Toolbar (QAT) easily.
1. R-click on any icon
2. Add to Quick Access Toolbar
6 June 2014
Use search “groups” (everything, people, conversations) to narrow your search scope to just specific types of content.
5 June 2014
Use CTRL-PageDown and CTRL-PageUp to move through worksheet tabs
4 June 2014
Q – Keep losing the leading 0 when typing in phone numbers?
A – Simply enter an ‘ (apostrophe) first then your phone number!
23 May 2014
Windows key +
spacebar – peak desktop
up arrow – maximise
down arrow – minimise/restore
M – minimise all windows
E – My computer
21 May 2014
MSAccess Field Validation Rules
Accept a-z letters only – Is Null OR Not Like “*[!a-z]*”
Exactly 8 characters – Is Null OR Like “????????”
19 May 2014
Adobe Certified Associate (ACA) exam – free preparation materials
16 May 2014
Excel 2010/13 AutoRecover Settings:
13 May 2014
Speed up tips
1 Primary key on all tables
2 Add secondary indexes to fields
3 Sharing on network? use Access Database splitter
8 May 2014
Convert a table back to a range (normal cells)
Right-click in the table, Table, Convert to Range, Yes.
6 May 2014
Type in any of the following symbols followed by enter to get horizontal lines
3 ___ (underscore)
30 April 2014
Internet Explorer hit headlines.
29 April 2014
Internet Explorer Favourites
Press Ctrl+D to add a web page to your Favourites list
23 April 2014
#DreamweaverCC web font browser – Edge Web Fonts.
Choose Modify, Manage Fonts, Adobe Edge Web Fonts tab, tick typeface you want, Done.
17 April 2014
Photoshop CS6 background flickering In Windows8 problem fix:
Edit, Preferences, Performance, Advanced Settings, Basic, OK
11 April 2014
Remove multiple Outlook calender entries
1 Click Calendar (nav panel)
2 Click View, Change View, List
3 Select events (Ctrl-A =all)
10 April 2014
Now WindowsXP has no support a few customers have asked when will Windows 7 go?
Policy supposed 2b 10 yrs from release so expect it 1/1/2020
7 April 2014
CTRL+M – Open a new window
CTRL+SHIFT+M – Open a small window to create a side note.
CTRL+SHIFT+R – Show/hide rule lines
1 April 2014
When deleting look 4 message stating the item is being sent to Recycle Bin. If not you nor your IT depart can restore it
27 March 2014
Ctrl+ S Split document
Ctrl+ R Rotate doc 90° to right
Ctrl+ I Display index entries
Ctrl+ Y Print with annotations
26 March 2014
After applying a Filter in a Gantt chart press [F3] to view all tasks again instead of applying the All Tasks filter
25 March 2014
#Visio2013 Getting fuzzy AutoCAD imports at high level zooms?
Install SP1 and your problem will be fixed
24 March 2014
You can protect sections with sensitive data in them e.g. bank details etc. Use:
File, Password Protect this Section.
20 March 2014
SQL Server 2014 RTM available April 1
19 March 2014
#XLtip Highlight precedent cells
Use Ctrl+[ to move from the current formula cell to precedent cell/s (if there are any) of that formula.
18 March 2014
Excel Freeze Panes – lock your data on screen
Rows r locked above cursor
Cols r locked to left of cursor
[View, Freeze Panes, Freeze Panes]
17 March 2014
#Pivots – Stop Pivots retaining old data no longer referenced
R-click, PivotTable Options, Data tab, Number items to retain per field=None
13 March 2014
Pivit Tables – Simply double-click on any number in a table and it will show you an itemised list of how that number was derived.
7 March 2014
Transpose (flip) row/cols
1 Select range & CTRL+C
2 In blank cell
3 [Home], Paste, choose Transpose icon (or Paste Special, Transpose, OK)
6 March 2014
Office Ribbon taking up too much space?
CTRL+F1 to hide/unhide it
3 March 2014
“The bitterness of poor quality remains long after the sweetness of low price is forgotten”
YOU GET WHAT YOU PAY FOR..
28 February 2014
Word 07/10 Redaction Tool – download from:
It will be added to the Review tab.
(Note:NOT officially supported by MS)
26 February 2014
PPT Presentation tips:
1.Ask questions, interact with audience
2.Use diagrams & graphs & pictures
3.Avoid bucket loads of text!
25 February 2014
Outlook 2010 PST errors? Use the Inbox Repair Tool (scanpst.exe) found on 32-bit pcs in:
C:Program FilesMicrosoft OfficeOffice14
20 February 2014
#MSProject: A simple way to link tasks is to select tasks and use CTRL+F2.
To unlink CTRL+SHIFT+F2 http://ow.ly/nEbC5 for training
17 February 2014
#Outlook 2010 tips
Send message CTRL+ENTER
Mark as Unread – CTRL+ U
14 February 2014
XL Pivot table – Grouping a Number Field:
R-click any value in the field, click Group.
Type in Start, End and By numbers, OK
10 February 2014
#Wordtips quick select
Word – Double-click it
Sentence – Ctrl+click it
Paragraph – Triple-click it
Whole doc – Ctrl+click in left margin
30 January 2014
Leaving your PC temporarily?
Press the Windows key+L to lock your computer screen so that no-one else can access it while you away.
24 January 2014
Keep Row/Col permanently displayed.
Rule – Freezes Above & to Left of cursor position.
Select View, Freeze Panes, Freeze Panes
23 January 2014
Excel – copy formula by double clicking Fill Handle (black + symbol on bottom corner of cell) to the end of the data in that column.
20 January 2014
Win8, Apps folder:
3.Open folder 2c ur installed apps
17 January 2014
Microsoft App Store
FREE Office 365 Tip of the Day app
You might just discover something useful!
15 January 2014
Good article on SEO and online directories – are they still relevant?
10 January 2014
Remove all hyperlinks in document
1. Ctrl-A – select whole document.
2. Ctrl-Shift-F9 – removes all underlying fields
8 January 2014
Free ColorPic (http://www.iconico.com/colorpic/ ) for RGB colour specs.
Eyedropper icon, point to the colour you want & it displays the RGB numbers.
30 December 2013
Crop image to save space.
Format tab, Crop button. Use crop handles to drag inward around image. Click outside to finish.
18 December 2013
Pin frequently used files – click the pin symbol (right of file name). Files remain at top of list in Recent Documents
11 December 2013
Fed up with Office 2013 start-up screens?
File, Options, General, remove tick next to ‘Show the Start screen when this application starts’
10 December 2013
Print to OneNote – Ctrl +P, in printers select Send to OneNote 2010.
Stored in “Unfiled Notes” tab, move to where you want it.
9 December 2013
Remember people cant read a slide and listen to a presenter at the same time.
To stop them reading ahead put one point per slide!
3 December 2013
Axis problems caused by missing data (e.g. dates) make bad looking charts.
Change Axis Type to be ‘Text Axis’ – problem solved.
27 November 2013
Insert a blank page – CTRL+SHIFT+Q
Add a bookmark – CTRL+B
Show/Hide ruler – CTRL+R
Load Preflight – CTRL+SHIFT+X
21 November 2013
Free PPT templates for use with Articulate ’13 for rapid eLearning development
18 November 2013
#WORDtips Selecting text
Double-click a word.
CTRL & click anywhere for a sentence. Triple-click anywhere to select entire paragraph.
13 November 2013
Zoom In 2x: Ctrl + Shift + Left Mouse-click
Zoom Out 2x: Ctrl + Shift + Right Mouse-click
11 November 2013
Don’t forget Undo does not work if you delete a sheet or link between files. So if not sure just save 1st to be on the safe side
8 November 2013
Cant remember the shortcuts then select
Edit, Keyboard Shortcuts or
MAC: Alt / Option+Shift+Cmd+K
5 November 2013
Alt F12 Debug in Primary Browser
Alt F8 View Site map
F8 View site files
Ctrl F8 Check links Sitewide
30 October 2013
Adobe moves 2 subscription model from next month.
Obviously trying to make it easier to get more than 38 million hacked next time chaps?
25 October 2013
#Outlooktip Outlook Email Multi Sort
Click column header to sort (eg from), then hold SHIFT key & click 2nd header (eg “received”).
24 October 2013
Unique Count available 4 Pivots.
Insert, Pivot table, tick “Add this data to the Data Model”, OK
Summarise values=distinct count
23 October 2013
#Exceltip To REALLY hide a sheet
Alt-F11 to VB Editor
Select sheet to hide
Properties Window, Visible property box
Set to xlSheetVeryHidden
21 October 2013
#Excel Save time highlighting data blocks quickly.
Start in top left corner – press & hold SHIFT+CTRL then click down arrow & right arrow
17 October 2013
To display the current month numerically, use =MONTH(TODAY())
16 October 2013
Its a pain when the Excel formula tool tip gets in the way (especially on long formulas).
So pick it up at the edge & move it out of the way
9 October 2013
Ctrl+1 – Change to single line spacing
Ctrl+2 – Change to double line spacing Ctrl+5 – Change to 1.5 line spacing
9 October 2013
9 Oct 2013
L&D professionals must understand technology and know how to exploit it @timbuckteeth #learningpoollive
3 October 2013
Use F11 to toggle the Navigation pane.
Keyboard is king!!
1 October 2013
Outlook continuing to run after exit? It can’t close properly if another app is accessing its message store
Culprit is add-ins! Disable them
27 September 2013
Excel 2013 Pivot tables – At last you can sort column fields in A-Z order!
In PivotTable Fields section, click Tools icon, Sort A-Z.
24 September 2013
#HTML – The type attribute in HTML4 is not supported in HTML5.
Use CSS instead!
23 September 2013
Quick Excel Tip – Want to highlight selected cells only and not the hidden ones as well?
F5, Special.. Visible Cells only – job done!
17 September 2013
Lend youngsters a helping hand
Developing your Business through Microsoft Apprenticeships: Event on 26 Sept, London
6 September 2013
“If opportunity doesn’t knock, build a door!”