Talents Tips: How to split the worksheet in Windows Excel 2013

Although zooming on the worksheet can help with an overall view of your data in Excel 2013, it can’t split the worksheet into two separate windows so that you can compare their data on the screen. So to split the Worksheet area into separate panes and then scroll the worksheet in each pane so that they display the parts you want to inspect.
Splitting the window
To split a worksheet into two (upper and lower) horizontal panes, you simply position the cell pointer at the cell in the worksheet where you want to split the worksheet and then click the Split button on the Ribbon’s View tab or use the short cut Alt +WS.

split-spreadsheets-iimage-1

When the worksheet window is split, Excel displays a split bar (a thin, light grey bar) along the row or column where the window split is actioned.

split-screen-image-2jpg
You can increase or decrease the size of the current window panes by using the mouse to drag the split bar up or down or left or right. You can make the panes in a workbook window disappear by double-clicking anywhere on the split bar (you can also do this by selecting View and Split again or use the short cut key Alt +WS)

Peter is running two Continuing Education courses Beginners Guide to Intermediate Database Use and a Beginners Guide to intermediate level spreedsheet use both starting in November. To book on either of these courses click here https://goo.gl/mnGn4D

Talents Tips: Keyboard Shortcuts

Keyboard shortcuts by Peter Talent

Save Time

Essential shortcuts can increase your productivity and speed at which you work. Below are some important PC shortcuts.

Delete with assurance
Backspace can be both helpful and troublesome. Deleting a word or two is straight forward, but anything longer may turn a simple deletion into a difficult operation in stopping the curser before it removes a whole paragraph.
Ctrl + backspace allows you to delete an entire word at a time, or a whole sentence quickly.

keyboard-image-1

S.O.S.
From time to time programs crash, and freeze. You can avoid having to shutdown your computer by recovering documents with this three-button combo.

keyboard-image-2
Ctrl+Shift+Escape will open your computer’s Task Manager, allowing you to end theproblem program and continue on.
Learn to Quick-Pick
Alternating between different programs? Don’t let your mouse slow you down. This quick action shortcut allows you to seamlessly work across all of your essential programs without having to use the mouse. keyboard-image-3Holding Alt+Tab brings up the index of currently opened programs, and pressing Tab again allows you to cycle between them.

Changing to the desktop?

You might have more than a few different windows open on your computer. If you need quick access to a file/folder that’s currently on your desktop. keyboard-image-4jpg

Win+D Is the shortcut for you to quickly clear your screen and go to the Desktop screen that you need.

Using the snap key board.
This is a good useful keyboard combination for doing research, or writing. If you’re concurrently working in different windows.
WIN+left/right arrow keys makes the currently selected window “snap” to one half of the screen or the other. Apply left and right positioning to two windows and enjoy a perfect split screen setup.

keyboard-image-5

Peter Talent will be teaching a number of fantastic I.T. courses for Continuing Education this coming term including Become a Proficient User of MS Office 2013 and a Beginners Guide to Intermediate Level Database Use. To view a full listing of our I.T. courses click here https://goo.gl/DYbuBw

 

Talents Tips – Create a SmartArt graphic

By Peter Talent

Peter will be leading Become a Proficient MS Office 2010 User from Tuesday 2 February – for more information click here http://goo.gl/w8L9kV

A SmartArt graphic is a visual representation of your information that you can quickly and easily create, choosing from among many different layouts, to effectively communicate your message or ideas. You can create SmartArt graphics in

Talents Tips January image 1

You can create a SmartArt graphic in Excel, Outlook, PowerPoint, and Word. Although you cannot create in most other Office 2010 programs, (e.g. Access, Project) you can copy and paste SmartArt graphics as images into those programs.

Some layouts for SmartArt graphics contain a fixed number of shapes. For example, the Opposing Arrows layout in the Relationship type is designed to show two opposing ideas or concepts. Only two shapes can correspond to text, and the layout cannot be changed to display more ideas or concepts.

Talents Tips January Image 2

Create a SmartArt graphic and add text to it

On the Insert tab, in the Illustrations group, click SmartArt.

Talents Tips January image 3PNG

An example of the Illustration group on the Insert tab, in PowerPoint 2010

  1. In the Choose a SmartArt Graphic dialog box, click the type and layout that you want.
  2. Enter your text by doing one of the following:

v Click [Text] in the Text pane, and then type your text.

v Copy text from another location or program, click [Text] in the Text pane, and then paste your text.

Notes

  • If the Text pane is not visible, click the control.
  • Talents Tips January Image 4
  • To add text in an arbitrary position close to or on top of your SmartArt graphic, on the Insert tab, in the Text group, click Text Box to insert a text box. If you want only the text in your text box to appear, right-click your text box, click Format Shape or Format Text Box, and then set the text box to have no background colour and no border.
  • Click in a box in the SmartArt graphic, and then type your text. For best results, use this option after you add all of the boxes that you want.

An Example of SmartArt

Law acts through the ages

Talents Tips January Image 5

Talents Tips January Image 6