Blog

Outlook Reading Pane

Disabling the Word 2007 Mini-Toolbar

Excel Sheet Navigation

4Networking in Leeds East

Twitter - ReTweets

Twitter - Lists

Twitter - Mobile

Excel Paste Column Widths

PowerPoint Slide Master

Windows 'God Mode'

Excel Functions

Filling Alternate Cells

Microsoft Office Shortcut keys

Excel Negative Times

Word Reading Layout

Windows Shortcuts

Excel dropdowns

Quick sheet selection

Search files on Google

A - Z of Excel

Word 2003 to 2007

   Astradyne Blog/Tips and Tricks - Word Reading Pane/God Mode/Excel Functions

Hi,

In this section I'll be including more tips and tricks, along with some advice and stories from the world of PCs.

 

SP asked: When I open a Word attachment in Outlook, Word starts in Reading Layout.  Can I start Word normally?

Sean’s answer: Yes, no problem.  In Word 2003, on the Tools menu, choose Options, click the General tab, and then untick the Allow starting in Reading Layout check box.

In Word 2007, click the Office Button, choose Word Options at the bottom right corner of the menu.  Click Popular in the left hand panel, then untick Open e-mail attachments in Full Screen Reading view.

 

For those people that enjoy playing with our computer’s settings, Windows 7 and Vista have a hidden "God Mode" feature that lets us access all of the system's control panels from within a single icon and folder.

I wouldn’t recommend doing this on a Work’s computer though – settings for these machines are often protected.

To enable this feature, simply make a new folder in Windows 7 (for example on the Desktop) and use this name:

GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}

The icon changes to represent a Control Panel.

Though I’ve not tried it, this trick is also supposed to work in Vista, although there are warnings on the Internet that it can cause 64-bit versions of that operating system to crash.

 

Some common Excel functions, e.g. =sum( )

Ok, so I guess there are a lot of people that know the SUM function. Here are a few more that can help on your spreadsheets. I'm using B10:B30 as a sample range, make sure you change this to match your needs.

=sum(B10:B30)

Adds the numbers in the range B10:B30

=average(B10:B30)

Works out the average of the numbers in the range B10:B30

=count(B10:B30)

Counts how many numbers there are in the range B10:B30

=countA(B10:B30)

Counts how many filled cells there are in the range B10:B30

=max(B10:B30)

Returns the highest number in the range B10:B30

=min(B10:B30)

Returns the lowest number in the range B10:B30

Hope this helps.

 


Copyright ©2006-2013 Astradyne.com

vb training leeds, vba training leeds, excel vba, access vba, pc training in leeds, computer training in yorkshire, pc training in yorkshire, computer training in leeds, microsoft access vb, microsoft excel vb training, microsoft powerpoint training, microsoft training, microsoft word, office 2000, excel training leeds, access training leeds, office training leeds, office 2007, leeds vba, leeds visual basic, leeds training