7/25/13

Tip #108 - Microsoft Office's Quick Access Toolbar

100 (or more) Computer Tips in 100 (or more) Days

Tip #108 - Microsoft Office's Quick Access Toolbar

When the 2007 version of Microsoft Office came out there was a lot of user frustration. Everything was moved off the menu area that people had come to know and love, or at least know if not love. The menus were gone, replaced by tabs and ribbons. As users became more familiar with the new interface they realized that familiar actions took a few more clicks than they used to but accepted, grudgingly, the new reality. But there is hope!

Microsoft left one customizable area in the Office suite, the Quick Access Toolbar. The Quick Access Toolbar is located along the upper left side in all of the Microsoft Office programs. This handy toolbar is very easy to customize and it is a place I head to when setting up client's computers. The first item I add to the Quick Access Toolbar is "Quick Print". Adding Quick Print enables the user to send the current document to the default printer to print one copy...all without seeing the print dialog box! Yea. You want two copies, click the button twice. This is the same "Print" button we had on the toolbar for years before the big change. 

Other options I like to add are "New" to create a new document with one click, "Open" to bring up the Open dialog box and, my all-time favorite, "E-mail" which will attach the open document to an email, even if the document has not been saved! I really love the E-mail button. It will work on most computers but not if you're using a public computer such as at a library. 

Depending on how the client uses specific programs I will often add the "Sort" buttons in Excel and the "Format Painter" in Word. The picture below is of my Quick Access Toolbar, see how I've added my favorite icons. 



Adding items to the toolbar couldn't be easier. Move your mouse on the down triangle on the right side of the Quick Access Toolbar and click. A menu of the most popular tools will appear. Click as many of these tools as you would like. The tools will be displayed in the order that you click them so give that some thought. You might uncheck some and then recheck them to change the order on the toolbar. If you don't see your favorite tool listed then click on the "More Commands" option. Every single command is listed here. 

When adding icons to the Quick Access Toolbar, you might consider adding options even though they are currently available on a tab. Keep in mind that the Quick Access Toolbar is visible no matter what your current tab might be so rather than changing to a specific tab just so that you can click on an option, add it to the Quick Access Toolbar and you don't have to change tabs. 

I hope customizing the Quick Access Toolbar makes it easier and quicker for you to use the Microsoft Office programs.

Happy computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 

7/23/13

Top Ten Posts for the Last Week

100 (or more) Computer Tips in 100 (or more) Days

Top Ten Posts for the Last Week







Want to know what posts your friends are looking at? Here's a list of the top ten posts for the past week. Have you checked all of these out?







It's amazing to me to see that the top tip is about basic mouse actions. It's also clear that Excel is a very popular topic. I will be posting additional Excel tips in the next week, along with some video clips of the techniques. 


Happy computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 

7/17/13

Tip #107 - Excel Pivot Tables

100 (or more) Computer Tips in 100 (or more) Days

Tip #107 - Excel Pivot Tables

Pivot tables are one of the most powerful features in the Excel program. They make it child's play to summarize and analyze large spreadsheets of related information. You can select which columns of information should be included in the analysis. Generally the pivot table is displayed on a separate worksheet in the document for easy reference.

The information in your worksheet should be continuous with no blank columns or rows. Blank columns and rows indicate to Excel that information on one side of the blank area is not related to information on the other side. I am going to be working with over 1,000 rows of sales information that is includes the product, customer, salesperson, region, quarter and amount. Creating related tables to analyze this type of information used to be time consuming and tedious. With just a few clicks this will be accomplished very easily. To see a video of how to create pivot tables in Excel scroll to the end of the page.

The data on the left pivots into the report on the right using the Pivot Table feature
To Create a Pivot Table:

1. Open the file that has the data you would like to analyze. Click any cell that has data in it so that Excel will know which area of the worksheet the data is to come from.

2. From the Insert Tab select Pivot Table. The Pivot Table dialog box will appear. You should not have to make any adjustments because Excel should have automatically identified the cell range and you would like the pivot table to appear on a new sheet.

3. Click OK. The pivot table appears on a new sheet. The new sheet has been inserted to the left of the previously selected sheet.

4. Drag the fields from the pivot table list on the right side of your screen down to the report filter/column/row/values boxes below the list. Do not use the check boxes. If you do use the check boxes Microsoft will just put the items where it thinks you would like them...not necessarily where you want them.

Drag fields down to the Report Filter, Column Labels, Row Labels and
Values fields to create the Pivot Table Report

If you don't like the order that the information in the pivot table is being grouped you might consider switching the order of the fields around. If you have more than one field in the column or row box, drag one field above or below the other to change the order.

One thing to note, there are no formulas in pivot tables. As a result, if you change the data that the pivot table is based on you must use the refresh button on the Pivot Table Tab.

That's it! You now have a Pivot Table. Move the fields around until you get the report you need.




Happy computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 


7/12/13

Tip #106 - Facebook Graph Search Feature

100 (or more) Computer Tips in 100 (or more) Days

Tip #106 - Facebook Graph Search Feature

Mark Zuckerberg (Credit: AP/Jeff Chiu)
Facebook Graph Search is a feature of Facebook that rolled out earlier this week (July 8, 2013). It uses information that you have added to your to your Facebook profile to create easy searches. It uses the "Search for people, places and things" box to allow you to search for friends who "Live in Connecticut and like to cycle" or "Friends who like to eat sushi". 


After each search you are presented with a page full of profile pictures, many of whom are people you have never seen before because Graph Search looks through your "friends of friends" network, which is vastly larger than just your friends network. After you've done a few searches you might be surprised about which of your friends fall into different categories.  Beware this search tool becomes a little addictive after a while.

Keep in mind that it's not just profile information but pictures, music, movies, games, etc. that Facebook has put into a giant database to make the information searchable. Of course one of the first questions I'm sure you have is, "Can I control any of this?" and the answer is a big maybe. There are some privacy settings you need to check on, including limiting visibility to old posts. 

Past Posts
To limit the visibility of your old posts with one click you can go into your privacy settings (use the cog icon in the upper right side of the Facebook page) and click on "Limit Past Posts". Here you should be able to make everything that was once public limited to only your friends. 

Present Posts
Go through your Profile (click Edit Profile just under your profile picture in the upper left side of the screen) and check the audience selectors in the various sections. You can limit what information is public and included in strangers' Graph Searches. Pay particular attention to the interests sections (movies, music, books, games, etc.) since this is where much of the searchable information comes from. Setting all of these to Friends, Friends Except Acquaintances or Only Me would be good choices.

Future Posts
Each time you post on Facebook you have an opportunity to choose the audience. Remember that the default setting for this is Public so you should have changed this by now. If you haven't, go back to the Privacy Settings area and make this change to friends as the default. You can also create lists that can be selected so that a specific post is only visible to a limited group of people you specify. Directions for this can be found in Tip #44. Friend Lists in Facebook

I know change is difficult for most of us and Graph Search seems like we've made one giant step forward (backward!) in the Big Brother society but if you make the changes that need to be made as to what is included in other people's searches for your information, you might feel a little better.

Happy computing!

Diane

Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com


7/6/13

[Hack] Order Up!! To Go v1.52


Application Name: Order Up!! To Go
Current Version: 1.52
iTunes Url: https://itunes.apple.com/us/app/order-up!!-to-go/id472934148?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 55,000,555 Silver Coins
-- 55,000,555 Gold Coins
-- Remove Adverts

Read more »

7/5/13

[Hack] Ice Rage v3.8


Application Name: Ice Rage
Current Version: 3.8
$0.99
iTunes Url: https://itunes.apple.com/us/app/ice-rage/id481028647?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- Unlock Skar & Santa Player Pack
-- Unlock Gebetto & Skeleton Player Pack

Read more »

[Hack] OLO game v1.32


Application Name: OLO game
Current Version: 1.32
$1.99
iTunes Url: https://itunes.apple.com/tw/app/olo-game/id529826126?l=zh&mt=8

Hack for Non-Jailbroken and Jailbroken.

-- Unlock In-App Purchases
Mega bundle, Safari, Robots, Fairytale, Horror

Read more »

[Hack] Tentacle Wars [iPhone/HD] v2.0


Application Name: Tentacle Wars
Current Version: 2.0
$0.99
iTunes Url: https://itunes.apple.com/us/app/tentacle-wars/id537969013?mt=8

Application Name: Tentacle Wars HD
Current Version: 2.0
$1.99
iTunes Url: https://itunes.apple.com/us/app/tentacle-wars-hd/id497919725?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 999,999,999 Metrics

Read more »

Top 10 Posts

100 Computer Tips in 100 Days

Top 10 Tips To Date

Today, July 5, 2013, some time between 2 AM and 7 AM (ET), my blog had its 10,000 page view. Woohoo!!!  It is a very exciting day for me. When I started writing my blog I didn't know how many people would be reached by it but I see that it was well worth my taking the time to do this.












Big news! In the next week or two I will be making the entire blog available as one PDF document for downloading. I'm putting the finishing touches on that document. Thank you for coming along on the journey. I hope you feel you are a better, more effective computer user as a result of reading my blog.

Here'a a list of the top ten tips based on the number of views they have had. Have you read all of them? Please feel free to send this link to anyone you think might benefit from using any of these.


Tip #1.      Basic Mouse Actions

Tip #3.      Using Tabbed Browsers

Tip #76.    Lock Your Windows

Tip #43.    Making Word Clouds

Tip #93.    Excel Scenario Manager


Happy Computing!

Diane



Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 

7/4/13

[Hack] Highborn HD Lite v1.3.9


Application Name: Highborn HD Lite
Current Version: 1.3.9
iTunes Url: https://itunes.apple.com/us/app/highborn-hd-lite/id389422026?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- Unlock Chapter 1, 2, 3

Read more »

[Hack] Real Racing 3 v1.2.0


Application Name: Real Racing 3
Current Version: 1.2.0
Itunes Url: https://itunes.apple.com/us/app/real-racing-3/id556164008?mt=8


Hack for Non-Jailbroken and Jailbroken.

-- 50,000,000 RS
-- 10,000 Gold


Read more »

7/3/13

[Hack] Doodle God™ [iPhone/HD] v2.0.5


Application Name: Doodle God™
Current Version: 2.0.5
iTunes Url: https://itunes.apple.com/us/app/doodle-god/id376374689?mt=8

Application Name: Doodle God™ HD
Current Version: 2.0.5
iTunes Url: https://itunes.apple.com/us/app/doodle-god-hd/id577436947?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 55,000,555 Mana

Read more »

[Hack] Storm of Magic v1.0.5


Application Name: Storm of Magic
Current Version: 1.0.5
iTunes Url: https://itunes.apple.com/us/app/storm-of-magic/id610282912?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 15,535,000Magic Crystals

Read more »

[Hack] Ridiculous Fishing - A Tale of Redemption v1.01


Application Name: Ridiculous Fishing - A Tale of Redemption
Current Version: 1.01
$2.99
iTunes Url: https://itunes.apple.com/us/app/ridiculous-fishing-tale-redemption/id601831815?mt=8

Hack for Non-Jailbroken and Jailbroken.

--955,555 Cash

Read more »

[Hack] Gone Fishing v1.23


Application Name: Gone Fishing
Current Version: 1.23
iTunes Url: https://itunes.apple.com/us/app/gone-fishing/id519622634?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 211,300,000 Gold
-- 211,300,000 Silver

Read more »

[Hack] Time & Territory: For Our Clan [iPhone/HD] v0.4.3


Application Name: Time & Territory: For Our Clan
Current Version: 0.4.3
iTunes Url: https://itunes.apple.com/us/app/time-territory-for-our-clan/id597352385?mt=8

Application Name: Time & Territory: For Our Clan HD
Current Version: 0.4.3
iTunes Url: https://itunes.apple.com/us/app/time-territory-for-our-clan-hd/id627840865?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 1,999,999 Coin
-- 99,999,999 Diamonds

Read more »

7/2/13

[Hack] Robot Unicorn Attack 2 v1.1.1


Application Name: Robot Unicorn Attack 2
Current Version: 1.1.1
Itunes Url: https://itunes.apple.com/us/app/robot-unicorn-attack-2/id541672969?mt=8


Hack for Non-Jailbroken and Jailbroken.

-- 555,000,555 Coin


Read more »

[Hack] Cover Orange [iPhone/HD] v2.6


Application Name: Cover Orange
Current Version: 2.6
$0.99
iTunes Url: https://itunes.apple.com/us/app/cover-orange/id405229260?mt=8

Application Name: Cover Orange HD
Current Version: 2.6
$0.99
iTunes Url: https://itunes.apple.com/us/app/cover-orange-hd/id397731774?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- Unlock Unlimited Helmets

Read more »

Tip 105 - Alt Code Reference Sheet

100 (or more) Computer Tips in 100 (or more) Days

Tip #105 - Alt Code Reference Sheet


Have you ever wondered how people inserted special characters such as smiley faces, hearts, arrows, etc. into their emails, Tweets, Facebook posts or worksheets? They probably used Alt codes to accomplish it. 

Alt codes have been around for decades and were used by early programmers. I have compiled a list below for your use. For best results you should save the picture by clicking on it with the right mouse button and choosing "Save Image As" or "Save Picture As" and saving it on your desktop. You can then double click the image on your desktop and print from there. 


After this was posted my Apple friends were very sad that they couldn't do this fun stuff with the Alt key. There are a few alternatives for them that I wanted to include here. Rather than doing a new tip card I've included links to a couple of websites where Apple people can get help on this. Check out this page for accent codes that you accomplish with the Option key, sometimes in concert with the Shift key. Here's a second resource that shows you how to make the Character Palette available to insert special characters. Hope this helps my Apple friends.

Happy Computing!

Diane 


Don't forget to click the Subscribe to 100 Computer Tips in 100 Days via email link on the right side of the screen so you get email alerts when Diane adds a new post.

Want more tech news or interesting links? You'll get plenty of both if you keep up with Diane McKeever, the writer of 100 Computer Tips in 100 Days, by subscribing to her Facebook posts or visiting her web page, www.dianemckeever.com . 

[Hack] My Moviestar: Venuce v3.0.0


Application Name: My Moviestar: Venuce
Current Version: 3.0.0
iTunes Url: https://itunes.apple.com/us/app/my-moviestar-venuce/id525680112?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 999,999,999 Cash
-- 999,999,999 Coin

Read more »

[Hack] Cartoon Defense v1.9.0


Application Name: Cartoon Defense
Current Version: 1.0.9
iTunes Url: https://itunes.apple.com/us/app/cartoon-defense/id334557703?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 888,888,888 GP
-- 65535 Prisoners

Read more »

7/1/13

[Hack] Leaping Legend v1.1


Application Name: Leaping Legend
Current Version: 1.1
iTunes Url: https://itunes.apple.com/us/app/leaping-legend/id643595653?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 555,000,555 COINS-
-- 999 Items

Read more »

[Hack] Icebreaker: A Viking Voyage [iPhone/HD] v1.0.0


Application Name: Icebreaker: A Viking Voyage
Current Version: 1.0.0
$0.99
iTunes Url: https://itunes.apple.com/us/app/icebreaker-a-viking-voyage/id656163700?mt=8

Application Name: Icebreaker: A Viking Voyage HD
Current Version: 1.0.0
$0.99
iTunes Url: https://itunes.apple.com/us/app/icebreaker-a-viking-voyage-hd/id656637359?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 610 Fingers of the Gods
-- 610 Gravity of the Gods
-- 610 Magnets of the Gods

Read more »

[Hack] Monsters University v1.0.0


Application Name: Monsters University
Current Version: 1.0.0
iTunes Url: https://itunes.apple.com/us/app/monsters-university/id617023144?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 55,000,555 Coins

Read more »

[Hack] Zombie Road Trip v3.1


Application Name: Zombie Road Trip
Current Version: 3.1
Itunes Url: https://itunes.apple.com/us/app/zombie-road-trip/id591192887?mt=8


Hack for Non-Jailbroken and Jailbroken.

-- 999999999 Brains


Read more »

[Hack] Block Block Block v1.0


Application Name: Block Block Block
Current Version: 1.0
iTunes Url: https://itunes.apple.com/us/app/block-block-block/id644071206?mt=8

Hack for Non-Jailbroken and Jailbroken.

-- 5,550,555 Hints

Read more »