Archive | Techo Tips RSS feed for this section

Modifier Keys

24 Sep

The key to maximizing your “computer” work-life is to comprehend, to retain and to implement a knowledge of modifier keys so that:

  • You can accomplish your work tasks in a fraction of the time
  • You can streamline repetitive tasks

There are 4 modifier keys that you should learn or know:

Alt – This modifier key (along with a second key) will help you to activate all your menus and even use the new Windows 7 ribbon. I remember it this way (A LT (looks like “a list”)

Control – This key is a power house key (using the control key with arrows or with the Home / End key) is like charging your keyboard with the energizer bunny. (BAAAM!)

Shift – is the anchor key (something that is held down with weight). By using this key you can highlight text.

Windows –  is used with the Operating System not necessarily with the applications.

Part 2 of this next month . . .

Learning to Run

22 Jun

For us “newer” guys on the block, the run command is an old tool that has been around a long time.

However, it has the teeth to do neat and quick functions.

You can access the control panel through the run command by using the word

control and then adding other words as well such as:

control admintools

control color

control desktop

To access wizards you will use two components:

an abbreviation and the letters “wiz” and “.cpl” for control panel; i.e.

Accessibility Controls                       access.cpl

Add Hardware Wizard                       hdwwiz.cpl

Add/Remove Programs                   appwiz.cpl

Date and Time Properties                timedate.cpl

Display Properties                              desk.cpl

You may also quickly access you application (must be installed), like

Adobe Acrobat                           acrobat

Adobe Photoshop                      photoshop

Basic Media Player                    mplay32

Windows Media Player            dvdplay

Calculator                                     calc

Chrome                                          chrome

Firefox                                            firefox

Internet Explorer                      iexplore

Access                                            msaccess

Infopath                                        infopath

Publisher                                      mspub

Excel                                               excel

Outlook                                         outlook

Word                                              winword

Power Point                                powerpnt

Notepad                                       notepad

Skype                                          “C:\Program Files\Skype\Phone\Skype.exe” (with quotes)

Likewise you can go directly to your drives and folders, if you know the path:

C: Drive                                                 c://Auto (only on my drive)

And then for your experts, the run commands can take you to your services and  utilities:

Check Disk Utility                              chkdsk

Character Map                                    charmap

Disk Cleanup Utility                        cleanmgr

Disk Defragment                                dfrg.msc

Clipboard Viewer                              clipbrd

Component Services                       dcomcnfg

Computer Management                  compmgmt.msc

Compare Files                                     comp

DDE Shares                                          ddeshare

Device Manager                                 devmgmt.msc

Disk Partition Manager                  diskmgmt.msc

Highlight Shortcut and QAT

22 Jun

Highlight Shortcut

Create macro to highlight a row:

  1. Open Excel
  2. Go to Developer tab (Alt +L)
  3. Create new macro
  4. Create Macro Name and Shortcut key(optional) and click OK
  5. Select Use Relative References button (Developer ribbon)
  6. Select any cell
  7. Click Home tab and Font Color and choose yellow
  8. Go to Developer ribbon and stop recording

Place button on quick access task (qat) bar and assign macro:

  1. Right click quick access toolbar
  2. Choose Customize Quick Access toolbar
  3. Make sure the left-nav selection is Customize
  4. Choose, Choose commands from and select Macros
  5. Click on your Macro name (per above) and add to 2nd column and press OK
  6. Optional: Click Modify button (at bottom of 2nd column to change icon)

How to use:

As you open your excel you will find a new icon in your quick access task bar and when you click the Alt key you will see a number attached to your new button. To highlight choose a cell, row or column (Shift + spacebar, Control + spacebar) and use the Alt Key and number combination to highlight.

Introduction – I stand on the shoulders of Giants

22 Jun

 I got bit by the IT bug a few years ago and whatever knowledge I have obtained and “now share”  . . . the Truth is I stand on the shoulders of Giants in the IT industry.

From the household names of Jobs and Gates to the gurus (Mr. Excel) and scientist that “started this whole thing ” Blaise Pascal“. And kudos to Chris, Caio and Bill the three best developers I ever had to chance to manage! Also a Big THANKS to Dr. Andrew Boswell who nudged me and encouraged me to implement new computer technologies into my day to day activities and to Tim Kachuriak who gave me a chance and invited me into the IT/SharePoint world! And Purna Duggirala at  Chandoo.org and Amit Agarwal at Digital Inspiration and John Walkenbach.

To the hometown heroes that helped me when my computer crashed and taught me things beyond the Microsoft world (Don).

I offer my sincere THANKS!

About Me

6 Jun

My name is Hugh Knight and I am a IT and Computer Enthusiast. I have over 20 years combined experience in the non-profit and for profit business arena.

I am digitally distinct! Visit onlineIDCalculator.com

Flavors.Me

Vizify

Wordle: Hugh Knight Wordle Profile