This video shows you how to use PowerPoint to record your screen. This is great if you need to demonstrate something on your screen or produce a training slide with video.
Keyboard Shortcuts for Basic Outlook Navigation
Using the Ctrl key plus a number key 1 to 7 you can easily switch between the component parts of Outlook as follows:
Switch to Mail view Ctrl+1
Switch to Calendar view Ctrl+2
Switch to Contacts view Ctrl+3
Switch to Tasks view Ctrl+4
Switch to Notes Ctrl+5
Switch to Folder list in the Folder pane Ctrl+6
Switch to Shortcuts Ctrl+7
Audio available here
Conditional Format and Minimum Function to Find Best Quote
This video show one way to identify the best price from a range of products and a range of suppliers using conditional formatting and the Minimum Function
How to have a non-numbered paragraph in the middle of a numbered list in Microsoft Word.
How to navigate the programs pinned to the Taskbar
The programs that are pinned to the Windows taskbar and the open programs that have been minimised to the taskbar can be opened by holding the windows key down and then pressing a number key.
Windows Key + 1 = the first pinned program
Windows Key + 2 = the second pinned program
and so on.
Audio available for this post
Find Formula issues with the Evaluate Formula Tool – How to use the tool
This video shows you how to use the Evaluate Formula Tool in Microsoft Excel. This is a great tool if you have created a formula and it’s not quite working properly or you have inherited a spreadsheet and you want to see what is happening with a rather complex formula.
How to use the Access Zoom Box
The Access Zoom Box allows you to temporarily change the font properties within the zoom dialog box e.g. colour and size of font in order to make viewing or editing easier.
How to Cut or Copy to Spike in Word
The Spike is a feature I don’t see used very often. When you normally copy and paste the copy goes into the clipboard, but you can only copy one section at a time. The spike allows you to copy several sections one at a time and stacks them together so when you past from the spike all the sections are pasted. This also removes the copied sections from the spike.
Change Prices or Values on Spreadsheet without using Formulas
If you have an Excel spreadsheet with lots of values and you want to change them all very quickly then watch this video. You can add, subtract, multiply or divide all the values in one go.
Remove Page Break Lines in Excel
This video explains how to remove those really annoying page break lines on an Excel worksheet using one line of VBA code. Any level of user can do this.
Download the Code here>>>
New – Sales Training Courses Milton Keynes
InIT Learning is pleased to announce our new one and two day Sales Training Courses delivered at your company site. Our trainer has many years experience in the world of sales and sales management up to director level both nationally and internationally. He has been directly involved in Direct Sales and Channel and therefore has a wealth of experience to pass on to your team. Our one day and two day InIT Learning sales training workshops are NOT your normal “vanilla” flavoured “one strategy fits all” sales training courses. In fact, they are not even courses. They are interactive workshops designed around the specifics of YOUR company and YOUR sales professionals. For more information please click here>>>