Find files on your computer faster than you can say Benedict Cumberbatch

Keyboard

Wouldn’t it be great if you could find information on your own computer as quickly as you find information on the internet? Read this article and discover the one thing that will make your computer experience faster than ever before.

You can easily find any file or program on your computer by using the built-in index search tool.

Very similar to how Google indexes the internet for quick searches, your computer indexes the hard drive for amazingly fast searches. You will see your search results instantly as you type what you are looking for.

On Windows 7, click the Start button and type your search in the Search Box located at the bottom of the Start Menu.

For you Windows 8 users, simply tap the Windows Key on your keyboard to activate the Start Screen and then start typing your search (no need to click or select, just start typing after you see the Start Screen)

On the Macintosh, click the magnifying glass in the upper right corner of the screen, or use the keyboard shortcut ‘Command+Space’, then type your search in the Spotlight field.

What does this super fast search mean for you?

Since most of us use files and programs stored on our computers, these indexed searches can locate our files and programs instantly.

The operating system automatically locates all your files, including programs and stores information about them in a database called an index. When you search your computer for files or programs, you are actually searching a super fast database (the index), not your very slow hard drive.

You can search for a file name, a program name, or the contents of almost any file. Yes, even if you search for words INSIDE of a file, such as a letter, resume or spreadsheet the indexed file will be located for you instantly.

Armed with this search knowledge, you don’t have to be a detective to find a file, or search for a program you want to run. Just type what you are looking for and your files and programs are just one click away.

You can now stop navigating to all your computer stuff and let your computer bring it to you.

How does Google find what you are looking for so quickly?

The Earth

When we search the internet, it’s common for Google to return 35 million hits in less than 1/2 a second. Wow! Now that’s fast. How is this possible? Does Google actually have the ability to search the world wide web in less than a second?

The answer is no. Google cannot search the world wide web that quickly. No search engine can search the internet that quickly. Not Yahoo, not Google, not even Microsoft’s Bing. So what’s really going on when we do an internet search?

When information is stored in a database, results from a search can be returned in an instant. Search engines such as Google and Yahoo have created a database to store information about internet sites. Programs called “web robots” are designed to crawl all over the internet, gathering information from every web site they touch, storing the gathered information in a database.

Although we may feel like Sherlock Holmes every time we search the “internet”, we are not really sleuthing the internet, but rather we are searching a database filled with the information gathered by these web robots.

This is why Google can supply you with 74 million hits in 1/2 of a second when you search for the term “boats”, 7 million when you search for “doberman puppies” and 500 million hits for an “iPad” search. Try it! You can see the number of “hits”, and how long (or short) it took Google to find them directly under the search box on www.google.com.

As you have probably figured, the whole internet is not stored in the Google database. No, instead these web robots gather only certain information from the crawled web sites such as it’s name, keywords, description and image names. Other information may be collected as well, and stored in the Google search engine database.

Each of us can search the Google database, and find information as quickly as the database can retrieve it. In fact, as you type, Google is updating your search results at each keystroke.

So why am I writing about how Google and Yahoo and Bing store information for internet searches?

How would you like to channel your inner Sherlock allowing you to search your own computer files as quickly as you search the internet?

Click here and learn an amazing search tip that will allow you to find files on your computer faster than you can say Benedict Cumberbatch.

Excel for the College Graduate (or anyone else who needs to Excel)

Excel Spreadsheet

I have published a course designed to help the college graduate who has book smarts about Excel but may lack the business smarts needed to make a favorable impression as a new business worker. Using Excel and all it’s amazing tools can be overwhelming. Knowing which aspects of Excel to study is not an easy task.
I have put together a series of videos on Udemy. You can go directly to the Excel for the college graduate videos here or you can browse all of Udemy’s great videos here.

Use PowerPivot for amazing data analysis in Excel 2013

Microsoft Excel 2013 comes with PowerPivot built in. To access PowerPivot tools, open Excel 2013 then open the ‘FILE’ tab, select ‘Options’ then ‘Add-Ins’. Look to the bottom of the ‘Add-Ins’ dialog and locate the ‘Manage’ drop down menu. Select ‘COM Add-ins’ and then click ‘Go’. Place a check mark next to ‘Microsoft Office PowerPivot for Excel 2013’, and while your there you might as well place a check mark next to the ‘Power View’ option.

Now that you have turned on the PowerPivot Add-In, you will see the ‘POWERPIVOT’ tab on the Ribbon.

So, what can you do with PowerPivot that you can’t do with standard Pivot Tables? For starters, you’re not limited to the 1,048,576 rows of Excel. In fact your limit of rows is, well, way more. Second, you have the option to create data set links, allowing for one-to-many relationships across data sets. Third, you can now take advantage of the robust power of DAX functions. These functions are designed for speed, crunching through huge data sets in no time at all.

After you set up all your formulas, DAX functions and measures, you can now build KPIs, Pivot Tables, charts, Slicers and Timelines that make awesome, interactive data analysis dashboards. Your numbers will never look the same!
ppReport

pp