Another Windows Tip: Paste Special

October 25th, 2010

Today, we’re going to follow up our last post about opening Excel documents in their own windows with another tip on working with Microsoft Windows and Microsoft Office (specifically Word and Outlook).  This one has to do with pasting data into either a Microsoft Outlook email or a Microsoft Word document.  As you may know, sometimes it is necessary to copy material from the internet, another document, or some other source and paste it into the Word document or Outlook email you’re working on.  We certainly do a good bit of that here at Aries Multimedia since email is the primary way we communicate with clients.

If you copy data from one location and try to paste it into either Word or an Outlook email, you’ll notice that, by default, the data retains its formatting.  If you copy from a web page, Word and Outlook try their best to make the data look the same in your document or email as it does wherever it comes from. In our experience, we would much rather have the data look like the destination document rather than the source document.  Microsoft provides for this through the “Paste Special” command.

The “Paste Special” command is located on the Home toolbar in Word and the Message toolbar in the Outlook email editor.  If you click on the arrow under the “Paste” button, you’ll get the “Paste Special” menu.  At this point, you can choose to paste your data as “Unformatted Text” and the data will be formatted like the rest of the destination document or email.  This is more difficult and involves more steps, however, than the simple Ctrl+V keyboard shortcut.  In order to speed things along, we have made pasting as Unformatted Text the default.

If you want to make pasting as unformatted text your default, just click on the Office button in the upper left of the screen and click on “Word Options” (Word) or “Editor Options” (Outlook Email Editor).  Click on “Advanced” and scroll to “Cut, Copy, and Paste”.   Here, you have the option to Keep Source Formatting (the default option) or “Match Destination Formatting”.  I have changed all of my values to “Match Destination Formatting”.  Now, with the Ctrl+V keyboard shortcut, whatever we paste into Word or Outlook looks exactly like the rest of the document or message.  This is one of those small fixes that has ended up saving us a good bit of time.

Bookmark and Share

Open Excel Files in Their Own Windows!

October 22nd, 2010

Many of our clients use Microsoft Windows and Microsoft Office.  We recently came across an interesting hint for using Microsoft Excel that we would like to pass along.  We use Excel for everything from loading new e-commerce products onto our customers’ websites to performing sophisticated statistical analyses of e-commerce customer data.  As an aside, if you would like to talk to us about doing any of this for your yet-to-be-developed or already existing e-commerce site, drop us a line.   As you might imagine, when we are doing this kind of work for customers, we often have many Excel files open at once.  If you look down at your task bar, however, you only see one one “Excel” tab listed.  This is because, by default, Excel opens each file within one single “instance” of the Excel  program.  We often like to have each file opened up in its own instance.  This has the advantages that you can look at files side-by-side across multiple monitors and you can see exactly what you have open on your task bar.  If you want to do this, you can find out here (credit where credit is due) or just follow these steps:

  1. Open Windows Explorer (you can do this pretty easily by pressing the “Windows” button and the letter “E” at the same time on your keyboard)
  2. Click on any folder
  3. Click “Tools”
  4. Click “Folder Options”
  5. Click the “File Types” tab
  6. Scroll down to the extension “XLS” and click on it
  7. Click “Advanced”
  8. Highlight “Open” and click on “Edit”
  9. Uncheck the “Use DDE” check box
  10. Change the “Application used to perform action” field to
    “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” “%1″
  11. Click OK
  12. Repeat steps 6-11 for the XLSX file extension if you are using Office 2007+

That’s it!  This relatively simple 12 step process will allow you to open Excel files in their own windows!

Bookmark and Share

ieiMedia

October 21st, 2010

This summer was an interesting one at Aries Multimedia, and we have a flurry of new projects coming online soon that we’re excited to tell you about.  The first one is the new web site for ieiMedia, LLC.  This company organizes and runs study abroad programs in multimedia journalism.  Many of the study abroad course instructors are versed in WordPress, and therefore we used WordPress to design the site.  The site features a user-managed photo gallery and a user-managed scrolling quote WordPress plugin.  We hope all of the students and instructors enjoy the new ieiMedia site.  Do you know some WordPress basics but need help developing a professional-looking site using WordPress?  Contact us and we can help you out!

Bookmark and Share

Woozie Analytics

May 25th, 2010

sales_graph_2

We are pleased to announce that we have rolled out the first beta of a follow-on project for www.woozie.com.  The owners of the site were interested in finding ways to visualize some of their sales data.  They wanted a way to easily determine where they were and were not making sales and who was buying.  They also wanted a quick way to dump the data to Excel to make graphs and charts of their own.  Most importantly, they wanted to be able to pick date ranges for the sales data they were looking at.  We used a couple of different technologies to make this happen.   We used the flot library to create some great looking graphs on the fly.  We also used the Google Chart Tools API to create a nice heat map of the US to show where sales are and are not being made.  We plan on making these features even more interactive in the days to come.  If you are interested in looking at your E-Commerce data in different ways, let us know.  Whether you want to get the most out of your data for your own store or you want to be able to quickly identify trends and impress your boss, Aries Multimedia can help!

Bookmark and Share

WALK CHARLESTON
AM’s Latest Charleston Tourism Project

May 24th, 2010

Our most recent addition to the long line of Charleston tourism websites we have created is Walk Charleston.  The owner of the company, Sue Bennett, set out to create a site that would capture the nostalgic look and feel of Charleston as she remembered growing up.

Walk Charleston is unique in that the company is run by one guide who gives you an intimate tour through the heart of the historic district of Charleston.  Tour guide and Charleston native, Sue Bennett, is loaded with bits of information that will leave you with a new fascination for the city.

Bookmark and Share

Small Businesses and E-Commerce

May 10th, 2010

Everyone in the small business community has heard the word E-Commerce.  In fact, E-Commerce makes up a big part of what we do here at Aries Multimedia.  For new small business, or small business who have yet to expand their web presence into the world of E-Commerce, the word itself can be daunting.  What does it mean?  Do all businesses need to have an e-commerce component?  What can e-commerce add to my existing business or to my business idea?  Well, we’d like to share some of the insights we have from helping many small business get into the world of E-Commerce.  This is a giant topic, too big to cover comprehensively in one blog, and so big that thousands of books have been written about it.  We’ll try to give you a run-down of some e-commerce related information that our clients have found useful.  If you have any questions, please either comment on this post, or contact us.

The first question we must address is “what exactly is e-commerce”?  Well, basically, it’s all of the things that you might try to do on a website to try to connect with your customers.  The most basic function of e-commerce is to directly sell your products to your customers.  We will deal with the issues involved in setting up a great web-based store in a blog post later on this week, but for now we will note that setting up your web based store is not the only piece of the e-commerce puzzle.  To illustrate this point, let’s do a thought experiment.

Imagine that you want to open a bakery.  You buy or rent some space, you decorate it to make it look the way you want, and you start baking and selling your goods.  On the internet, this is like procuring hosting (the building), building a web page with a good design (the decorating), and setting up a web store (selling your baked goods).  Now how do you get people in your store?  Well, if you have a real-world store, you’re probably in an area where people walk or drive by fairly regularly and you have a nice sign out front.  Therefore, just by opening up your bakery, you might generate some sales.   However, on the internet, your store is practically invisible to people who may be looking for exactly what you’re selling.  Furthermore, you’re not only competing with bakeries in your town, but you’re also competing with bakeries all across the world.  To be successful, you need to get the word out about your site.  This brings us to the second ingredient of an e-commerce venture: marketing.  We will address some marketing strategies in upcoming blog entries.  Of course, Aries Multimedia can help you formulate a winning marketing strategy and help you get customers through your doors.  So right now, we have two pieces of the e-commerce pie: marketing and the web-store itself.   We’re not done yet, though.

Let’s continue with our bakery example.  Let’s say that you’ve built your store (or website) and have put the word out that you’re open for business.   There’s one more piece of the puzzle that can help make your web-based business successful: knowing your customers.  Knowing who is buying from you and who isn’t buying from you is important in any business, and web-based business are no different.  However, with a properly set up web-based business, you can generate huge amounts of data about your customers and potential customers.  You can gear your store towards the likes and dislikes of groups of people, open yourself up to new markets and new customers, and keep a very close eye on efficiency, costs, and sales.  Aries Multimedia, with a wealth of mathematical skill and the ability to crunch numbers to answer any question about your business, is uniquely positioned to help you gather and make sense of the data that will help you make your business run at its full potential.

We have now identified three main aspects of e-commerce: setting up a system to make sales, marketing your products, and studying your customers.  All of these things are important to traditional business, and all are important to a successful e-commerce strategy as well.  Keep an eye on this blog in the next few weeks for more on these topics, and as always, please let us know if you have any questions.  We’d love to help you set up your new e-commerce venture or help you get the most out of your current online business.  Contact us for free initial consultation and proposal and let us help you help your business take off!

Bookmark and Share

Aries Multimedia Now Has Templates!

April 28th, 2010

amlogoAt Aries Multimedia, we like to keep on top of what our customers want.  We’re excited to announce that we are now offering web design templates for sale through our site.  If you just need a good design idea to get started on your site, take a look at what we have available.  You can spend a relatively small amount of money and get a quality design.  You can also spend more money to get the design and have it removed from the site permanently.  No one will be able to buy that template again!  Of course, if you need any assistance on anything from ordering a domain name and hosting to intelligently placing content in your designs, just let us know and we can help you out.  In the mean time, happy template browsing!

Bookmark and Share

NV Dance Lounge

April 22nd, 2010

header2 What could be more fun that doing a site for a new dance lounge in lovely downtown Charleston?  We’re not sure, but if you think you know, let us know so that we can take it on!  NV Dance Lounge had its grand opening this month and needed a site to help them get the word out.  We gave them a unique design, embedded some songs by DJ NattyHeavy (the NV DJ) and gave them some tools to help manage the content of the site.  Check out the site at http://www.nvcharleston.com and, if you’re ever in Charleston, go and see the hottest new dance lounge in the city!

Bookmark and Share

Historical Education Forum

February 16th, 2010

At Aries Multimedia, there are some organizations we just love to work with.  We  just finished a site for one of these organizations, the Heritage Education Forum.  The goal of this non-profit group is to promote the many cultural locations in and around Charleston, SC.  If you want to know more about what they do, visit their site and contact them.

Bookmark and Share

Dan Thomas Realty

February 16th, 2010

Dan Thomas Realty

Aries Multimedia, LLC is proud to introduce Dan Thomas Realty, the latest site that we have helped with.  Mr. Thomas is a builder and Realtor in the Greenville, NC area.   He came to us having designed a good site himself using Microsoft Expressions Web 3; he just didn’t have time to add some functional features for his site.  We added some drop-down menus, changed the color scheme and banner a bit, and added some interactive features including a third party mortgage calculator, interest rate widget, and weather widget.  We also helped him gather information from prospective customers in exchange for those potential customers accessing Mr. Thomas’ MLS listings.

Over the past few months, we have been involved in more site revamping than building sites from scratch.  This is a great option for business or individuals like Mr. Thomas who have a good start on a site, but have hit a wall in terms of making the site do what they want it to do, not just look how they want it to look.  Site revamping is also great for keeping content fresh, changing your branding, or just making your site more appealing.  We can modify your site in a way that lets you update the content without damaging the layout like we did for Mr. Thomas.  If you aren’t quite sure where to go with your revamp, we will consult with you about what you like and don’t like and offer our expertise in where you should go with your site redesign.  Check out Dan’s site, let us know what you think, and contact us if you would like to complete a site or make some changes to your current site!

Bookmark and Share