Data Consolidation

Using Consolidate you can summarize data from separate worksheets onto one master sheet.  Data Consolidation performs a statistical function (e.g. Sum, Average) on a series of ranges (lists). And the best part:  the lists need not have identical content.

Watch this 2+ min. video to learn all you need to know.

Performing the Data Consolidation

Logo_Microsoft_Excel_2013 Click  here to open Toy List Consolidation.xlsx sample spreadsheet

Prep: Sort each list by the first column and remove all blank rows and columns within the lists.

Tip: Use Define Name to set name each list.

  1. On the summary sheet, select the upper-left cell where the consolidation is to appear.
  2. On the Data tab, in the Data Tools group, click Consolidate.
  3. In the Function box, select function (i.e., Sum).
  4. In the Reference field, type the name or cell references of first list (including column and row headings), then click Add. Repeat this step for each list to be summarized.
  5. Check Use labels in Top row and Use labels in Left column.
  6. Click OK.

Cheers!

hɔuᴉnb

Related reading:

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Gmail and Google Calendar Are Now Downloadable (Just Not Your Brain — Yet)

Yea! Retain a backup of your Google data on your on own drive. Its about time!

Tech

Somewhere in a computer file system folder, tucked within a series of folders, locked in an archive compressed to a fraction of its original size (inside an encryption riddle, wrapped in a digital mystery) are all my old email files from when I used to use Lotus Notes, now known as IBM Notes. Lotus Notes! I realize some of you still use it, and this is not me chuckling quietly.

No, this is just me letting you know that Google in 2013 is finally going to catch back up with a program that’s been around since the late 1980s: until today, you couldn’t extract Gmail or Google Calendar information for archiving vis-a-vis an intuitive (and more importantly, native) Gmail or Google Calendar switch. You had to either trust Google to keep your stuff safe and backed up somewhere, or play a kind of digital version of Twister to extract said information by…

View original post 387 more words

Amazon’s drone delivery service

Incoming

What’s that buzzing? No cause for alarm, its just the latest installment of GTA flying at you. Catch!

Although not yet ready for primetime Amazon is hopeful that this small package delivery service will be start flying in 2016. If successful, it promises to drastically cut delivery time.

(Still no word on the flying cars we were promised)

Enjoy this video from Amazon.

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Happy Birthday, Windows

The year is 1985. Soviet leader Gorbachev meets with American President Reagan. Cocoa Cola unveils New Coke. Actor Rock Hudson dies of aids. Singer Madonna’s starts her first tour.

And on November 20, 1985, Microsoft releases Windows 1.0.

Unveiled in 1983, it would not be available for purchase until two years later. Arguably, that makes Windows 30 years old, but since many tricenarians, have a hard time with that milestone, we extend her two years grace..

Over time her share of sales and public favor has varied, as illustrated by this infographic.

Timeline: Windows Logo Evolution 

WindowsReleaseTimeline
(click to enlarge)

Going Retro

Like most twenty-somethings, the Windows logo has had her own experiments with styleHere’s a look back at fashions past.   

WinEvolution
animation by FORBiES

Flashback: notice how similar the current Windows 8 logo is to the original!

Sharing Win’s birthday:

Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

“404” and “fail” are the most popular words of 2013

“404”, “Fail” & “Hashtag; most popular words of 2013

Windows & iOS Tricks & Treats

Trick or Treat! 

In honor of Halloween I am handing out treats and tricks! So reach in and fill your bag with this odd collection of operating system tips!

Windows 8 Trick or Treats

TRICK TREAT
Hold windowsLogoKey (the Windows key) and Press M Shows DESKTOP
(aka Minimize All)
Hold windowsLogoKey and press R Opens RUN dialog
Hold windowsLogoKey and press E Opens Explorer window
Hold windowsLogoKey and press C Slide COFFEE CUP HOLDER out
(aka CD Tray)*
Hold windowsLogoKey and press Print Screen CAPTURE & SAVE SCREEN
The screen shot is saved automatically to your Windows Pictures Library; no filename/folder prompt

*requires Windows 8.1SB (Starbucks edition).

iOS Trick or Treats

TRICK TREAT
With two fingers on the keyboard, pull outward (left & right) Splits single keyboard into two for easier typing
On the lock screen, swipe the notification left to right After inputting your password/pin, opens the item from the notification
Tap and hold Number button, swipe and select punctuation, then release Select punctuation without requiring a switch between Numerica and Text keyboards
While holding down the menu button (the main button below the screen), press the power/lock button Saves screenshot of the active screen to your camera roll

And in case you missed it:
Google Celebrates Halloween With a Spooky Interactive Doodle

hɔuᴉnb

Comments and questions are always welcome!

Windows 8.1-What’s new?

Give me back my Desktop and Start Button! 

Yes, we all complained, and millions of voices could not be silenced. Newer wasn’t necessarily better, so Windows 8.1 has returned some old features and improved some others. The desktop is now much easier to access (yay!), but the Return of the Start button, misses the mark. START is back, but only as a means to access the much maligned START screen (boo!).

Return of the DESKTOP

The only thing on my Windows 8 Start screen I ever used was the Desktop tile. So going from boot-up to START screen, and then clicking on Desktop was an extra and unappreciated step. Now, with 8.1, you can re-enable booting up with Desktop.

Windows81a

Additionally, you can

  • Share the Desktop background with the Start screen,
  • Control the Corner Navigation ‘aka: hotspopts’

To access, RIGHT + CLICK  on the Taskbar , and select PropertiesNavigation.

Better SEARCH

With Windows 8.1 your Search includes not only your local drive and apps, but also your SkyDrive and web results. And speaking about SkyDrive, there is better integration and support for SkyDrive users.

Better CONTROL PANEL

The Windows 8 PC Settings was an abbreviated version of the familiar control panel. With limited settings available, To make a setting change one either had to search for it, or access the legacy windows Control Panel. Windows 8.1 has made more control panel applets accessible under Settings (although I still find it easier to use the search  option to locate the setting I am tweaking).

Easier TILING (aka ‘SNAP’)

The Windows 8 SNAP feature was (sorry) annoying, mostly in that you could not control the size of the windows you were tiling. Windows 8.1 improves this feature by allowing you to control the size of the tiled (oops, I mean SNAPPED) windows.

Additional articles to peruse:

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.