Go into command prompt
Move to the directory where your files are located
Type
Type copy *.csv name.csv
This will merge all of you Excel files into one file
Really easy and quick
Great way to merge and control data
-
-
In 2011 Google had some major changes in search results. Its important to remeber that there are probably 500+ minor changes a year with googles search algorythm. In an effort to clean up content farms and low quality content online google made some major changes. Initially called the farmer update it started in early 2011. Many article and duplicate content sites where hit hard. They lost hundreds of pages in google search results and there was a big shift.
Google released 23 questions any webmaster should ask themselves before putting up content online. So what is quality content ask yourself this.
- Would you trust the information presented in this article?
- Is this article written by an expert or enthusiast who knows the topic well, or is it more shallow in nature?
- Does the site have duplicate, overlapping, or redundant articles on the same or similar topics with slightly different keyword variations?
- Would you be comfortable giving your credit card information to this site?
- Does this article have spelling, stylistic, or factual errors?
- Are the topics driven by genuine interests of readers of the site, or does the site generate content by attempting to guess what might rank well in search engines?
- Does the article provide original content or information, original reporting, original research, or original analysis?
- Does the page provide substantial value when compared to other pages in search results?
- How much quality control is done on content?
- Does the article describe both sides of a story?
- Is the site a recognized authority on its topic?
- Is the content mass-produced by or outsourced to a large number of creators, or spread across a large network of sites, so that individual pages or sites don’t get as much attention or care?
- Was the article edited well, or does it appear sloppy or hastily produced?
- For a health related query, would you trust information from this site?
- Would you recognize this site as an authoritative source when mentioned by name?
- Does this article provide a complete or comprehensive description of the topic?
- Does this article contain insightful analysis or interesting information that is beyond obvious?
- Is this the sort of page you’d want to bookmark, share with a friend, or recommend?
- Does this article have an excessive amount of ads that distract from or interfere with the main content?
- Would you expect to see this article in a printed magazine, encyclopedia or book?
- Are the articles short, unsubstantial, or otherwise lacking in helpful specifics?
- Are the pages produced with great care and attention to detail vs. less attention to detail?
- Would users complain when they see pages from this site?
In 2012 the trend for the new year is more updates and focus on quality. Look for above the fold importance and keep developign within the 23 questions above.
-
If you are like me and usually have a bunch of open tabs on firefox reading multiple pages at once and you get interrupted but want to go back tot he pages firefox has a quick key solution for this.
How do you bookmark all sites open in the tabs……
In firefox you need to press the Ctrl+Shift+D which opens a new box asking to name the folder. All you open tabs will be despoited into this bookmark folder.
The other one is when you press Ctrl+D it will bookmark just the one open page.
Ctrl+U opens the source code of the page
Back Alt + ?
BackspaceForward Alt + ?
Shift + BackspaceHome Alt + Home Open File Ctrl + O Reload F5
Ctrl + RReload (override cache) Ctrl + F5
Ctrl + Shift + RStop Esc Editing
Command Shortcut Copy Ctrl + C Cut Ctrl + X Delete Del Paste Ctrl + V Redo Ctrl + Y Select All Ctrl + A Undo Ctrl + Z Search
Command Shortcut Find Ctrl + F Find Again F3
Ctrl + GFind Previous Shift + F3
Ctrl + Shift + GQuick Find within link-text only ‘ Quick Find / Close the Find or Quick Find bar Esc - when the Find or Quick Find bar is focused Search Bar Ctrl + K Select or Manage Search Engines Alt + ?
Alt + ?
F4Command Shortcut Close Tab Ctrl + W
Ctrl + F4- except for App Tabs Close Window Ctrl + Shift + W
Alt + F4Move Tab in focus Left Ctrl + ?
Ctrl + ?Move Tab in focus Right Ctrl + ?
Ctrl + ?Move Tab in focus to start Ctrl + Home Move Tab in focus to end Ctrl + End New Tab Ctrl + T New Window Ctrl + N Next Tab Ctrl + Tab
Ctrl + Page DownOpen Address in New Tab Alt + Enter - from Location Bar or Search Bar Previous Tab Ctrl + Shift + Tab
Ctrl + Page UpUndo Close Tab Ctrl + Shift + T Undo Close Window Ctrl + Shift + N Select Tab 1 to 8 Ctrl + 1to8 Select Last Tab Ctrl + 9 Tab Groups View Ctrl + Shift + E Close Tab Groups View Esc Next Tab Group Ctrl + ` - only for some keyboard layouts Previous Tab Group Ctrl + Shift + ` - only for some keyboard layouts History
Command Shortcut History sidebar Ctrl + H Library window (History) Ctrl + Shift + H Bookmarks
Command Shortcut Bookmark All Tabs Ctrl + Shift + D Bookmark This Page Ctrl + D Bookmarks sidebar Ctrl + B
Ctrl + ILibrary window (Bookmarks) Ctrl + Shift + B Tools
Command Shortcut Downloads Ctrl + J Add-ons Ctrl + Shift + A Web Console Ctrl + Shift + K Inspect Ctrl + Shift + I Scratchpad Shift + F4 Page Source Ctrl + U Error Console Ctrl + Shift + J Toggle Private Browsing Ctrl + Shift + P Clear Recent History Ctrl + Shift + Del Miscellaneous
Command Shortcut Complete .com Address Ctrl + Enter Complete .net Address Shift + Enter Complete .org Address Ctrl + Shift + Enter Delete Selected Autocomplete Entry Del Toggle Full Screen F11 Toggle Menu Bar (when hidden) Alt
F10Show/Hide Add-on Bar Ctrl + / Caret Browsing F7 Select Location Bar Alt + D
Ctrl + LMedia shortcuts (Ogg and WebM Videos Only)
See also Viewing video in Firefox without a plugin.Command Shortcut Toggle Play / Pause Space bar Decrease volume ? Increase volume ? Mute audio Ctrl + ? Unmute audio Ctrl + ? Seek back 15 seconds ? Seek back 10 % Ctrl + ? Seek forward 15 seconds ? Seek forward 10 % Ctrl + ? Seek to the beginning Home Seek to the end End Great list of keyboard shortcuts to help you surf faster
Tags: Firefox, Keyboard shortcuts
-
Search Engine Ranking Optimization is a never ending progression. The process in truth is at the start just before you build your first section of code. In the main planning stages you must start with a concept. In order to find something you must understand the place where you want to go. Establishing a checklist will help direct you.
What’s the purpose of your web page? What are you considering doing online, the reason for creating the site initially. Consider this first so that you can adjust your plan. The internet is centered on finding a certain area of interest and having a source for information about that area. You can’t be a professional in all area, begin small and be specific. You should have already got a effective idea of what you want to do online, the purpose of your internet site.
The most critical item relating to the checklist is keywords, the ever so important portion of the SEO process. Keywords tend to be the core of what you will find yourself doing on the net. Take your time to determine who your customer is. Consider through the mindset of your web site visitor, what would are the initial thing they ask in terms of your website. What concerns would they have about your services or products. Make blueprint about your site on top of that imagine what relates to these details. Think which of the concerns really pulls you in.
Analyze who your competitors are and pay attention to what they’re doing. Exploring at the terms they are using. Build a total listing of search terms. Think once more about your site how is it different, better than the competition. What is unique with regards to the service you offer what makes you stick out.
You will have a great concept of what your key terms are, write them out always check them over. You are ready to employ a keyword tool like Adwords keyword tool. Enter your keyword list within the tool. Perfect your list with keywords which use the top search results return on results and possess the least competition. Select your polished list, should be around 20-40 keyword phrases.
Utilizing this list now, and you’re theoretically in a position to process next steps of the web site setup and optimization. Keywords are crucial for a complete beginning with Website positioning.
Tags: Adwords, Ebusiness, Guide webmasters, Keywords, Marketing, Online, PPC, SEM, SEO
-
Has Flash really seen its last full year of existence, is HTML5 going to take over?
Flash was a marvelous must have component in the arsenal of web development. Its first added that flare, video ability and action. Flash made it simple to post video content, optimize bandwidth for animations and more. So what happened in the past few years to make this ever so wonderful tool come to an end.
Mobile!
Mobile is the fastest growing form of web content access, and the most popular type of mobile device iPhone, iPad don’t support Flash. They are the flash killers.
All mobile devices support HTML5 which makes it easier to embed video of any format. The monopoly for Flash is over and coming down hard like an unforeseen crash.
Adobe maker of Flash has announced it won’t be supporting it on mobile.
youtube and other video sites are already changing the format to has both Flash and other video formats available for HTML5 viewing.
Flash is over and will be missed.
RIP Flash
Tags: Flash, HTML5, Web design
-
Both are terms of how you design your web application, web site or overall application. They are both based on user interaction with your site.
UX is the user experience as an overall measurement. The better of an experience the user has the more your site is UX friendly. You can have a great site but is the user doesn’t feel the overall site experience is great then your UX is lacking.
Websites have been designed with useability, how your site links to all the posts and that was the design strategy. Changing of the strategy to more than just functionality to include user experience is important. Web applications have always strives to deliver an intuitive experience which makes sense. The easy it is to navigate something even if its the users first time the more better the user experience.
Look to design with good user experience as well as functionality.
Tags: UX, Web design, Webmaster
-
Several financial analysts had predicted 2011 as a year of recovery and possibly some growth in the economy. However, with widespread government spending cutbacks expected, 2011 may be somewhat early.
Web site design is quite a fast moving industry. Web design businesses are continuously trying to further improve their skills and their knowledge in an effort to get ahead of the competitors. This calls for a web site design firm to pay close attention to what the likes of Google are doing.
The pace of everyday life today is incredible. Google has obviously picked up on this because loading speed is now part of the Google algorithm. Some web sites contain huge quantities of information while others not a great deal, and both present challenges. For new internet sites your web design company should know about the most up-to-date Google algorithm and guarantee the website is designed and developed with it in mind.
Images are everywhere you look on web sites and they are prime examples of loading items which could impede your site. It really is essential that the image file size is kept to a bare minimum and that they are preferably formatted in JPEG and GIF.
Another obstacle for web-site designers and programmers is to make certain the web site being built works for the different screen resolutions available today. The can vary from 640 x 480 to 1024 x 768 and as technological innovation improves resolutions are simply going to get bigger and much better.
Additionally there is increasing interest in websites to utilize mobile devices such as the Apple iPad or Samsung’s Galaxy Tablet. Web designers are quite accustomed to having to conduct cross web browser tests. Cross platform testing is undoubtedly a growing element of website design and represents significant possibilities for many businesses.
The style of websites has changed so much in recent times. At first the net was all about bright flamboyant striking shades and fonts to grab the eye. Now, the top websites are the ones which use fairly neutral colours and fonts which you’ll find easy on the eye and simple to use. Take Google, the world’s most successful site, notice anything?
Tags: Developer, Web design, Webmaster Tips
-
First steps are the proper initial setup of the strategy, determining what the goals are and how they will be measured. Conversion goals are key in understanding what the path should be to achieve them.
The next step is then determining what assets can be used and the constraints on the deliverables.
In general look at key factors that may be influencing the conversion and see what is truly guiding the visitor through the website. Focus more specifically at bounce rate, the traffic time on site and where they exit. For more complex funnels and take into account the various steps and problems with those steps in achieving the end goal.
Once data is gathered, and areas of improvement are identified, setup split testing in order provide real data on what is observed.
Example : Real world website example when looking at the data, the data showed good traffic to the services page but then a disproportionate drop-off rate after they visited the services page. After looking over the page an immediate observation was the page length was long and the services were listed but each service had a long description giving the impressions that it may be the only one available. The theory is that people may come to the services page only see the top service and then hit back or leave since they don’t see the lower services. The suggestion is to update the top area of the page listing all the services and allowing the user to click using anchor or separate pages to the service they are looking for. Revisit this the following month to see if there is a better visitor flow though ot the conversion area after the services.
Tags: Digital Strategy, SEO, Web improvements, webmaster example of site improvement
-
Where does Search Engine Optimization fall, is it marketing or technology?
Technology you need to understand how to enter code and create your website. For on page optimization you need to have a strong understanding of technology. understanding of proper tagging and even hot htaccess works helps with creating a well working optimized website. Structure of your site as well as the navigation breadcrumbs and overall site design is essential for good search engine ranking.
Marketing is important as well, having an understanding of creating call to actions, leading people into the site and converting into a sale. Its complete process once someone first accesses your site and understanding marketing techniques is important in the site design as well. Keep visitors once they arrive is the job of marketing. Turn them into clients.
Both are required skills to be successful online, both onsite and offsite skills. A true SEO should have a good balance of both. Most SEO guru’s I know have come from a development background and have transcended into this mixed type of role. You need to be creative and technical. Think outside the box and get results.
Lars Svekis
Web 2.0 Digital Expert
Recent Comments