Blog

April 8th, 2014

Office365_Apr07_AOneNote is one of the Microsoft products that comes with most versions of the Office suite. It can also be installed as a standalone application for free. This program is available on various platforms, including Windows PC, Mac, Windows Phone, Android, and iOS devices. It is also accessible via your Web browser as part of OneDrive, which was formerly known as SkyDrive. OneNote acts as your digital notebook, allowing you to easily save and organize information and files.

If you are looking for a powerful note program, OneNote has some great features.

Access and edit notes anywhere

Windows PC, Mac, iOS, Android, and Windows Phone all support OneNote. Install the appropriate version and you can access your notebooks from any of these devices. Previous versions require that you manually sync your notebooks to make them accessible on all devices. However, with the latest version this is no longer required as your notes are automatically synced on your OneDrive. This means you can view and edit them anywhere where you have an Internet connection.

You can access notes on your mobile device that you originally created on your computer. If you have access to a computer that does not have OneNote installed you can easily find the application on the Web. If you go to OneNote’s page on the Web you can log in to the account linked with your installed versions of OneNote and use as you normally would.

Organize data in notebooks

OneNote is a great tool for organizing different data and files. You can create various notebooks that contain information on specific subjects. For instance, you could create a notebook for personal use, a notebook containing client information, etc. Each of these notebooks can then contain various sections with color coded tabs, making it easy to organize files.

This feature is helpful, especially if you are working with a large volume of data. Searching for specific information or data is also straightforward with a convenient search function. You can simply type your keyword in the search field and wait for the result. Click on your chosen result and you will be taken to that particular note.

Third party integration

The latest version of OneNote also has a new cloud API that allows third party applications to be used. This allows users to enjoy more features, as they are not just confined to the features that are native to OneNote. One of the apps that you can use is OneNote Clipper. Install this on your browser and use it to automatically save clippings from the Web in just one click.

Work on important tables

Tables are often used for creating databases or for comparing and listing data. Creating tables in OneNote 2013 is more convenient as it now allows you sort data within a table, designate header rows, as well as change the color of the cells. You can also insert an Excel spreadsheet into your notes.

Write handwritten notes

If you are using a touch capable device you can write notes or draw using a stylus or your fingers. This is especially helpful for jotting down quick notes or reminders about what to insert on a page. Circling or underlining a word or group of words is quick and easy to do.

Organized data and files are easy to access, which is vital when you need this information at your fingertips. OneNote keeps data in order so you can easily find what you need when you need it.

Find out how OneNote and other tech innovations and updates can support your business productivity. Get in touch today!

Published with permission from TechAdvisory.org. Source.

April 2nd, 2014

BusinessValue_Mar31_AThe website is one of the most important marketing and branding tools a small business can utilize. Potential and even current customers visit business websites looking for information and will often judge whether they will purchase from this point. That means that your site needs to be designed properly. In order to achieve this it pays to be aware of the common mistakes businesses make when designing their corporate website.

The business value of a business website is that it creates a solid online presence and boosts your brand image and market reach. Even if your business is not Internet based, a website can be used to create a certain impression and ultimately contribute to your bottom line. The key is to make sure you create the best impression. Here are six of the most common mistakes businesses make with website design:

Mistake 1: Building for the sake of building

Websites are important and some businesses believe that they should have a website, so they go ahead and simply build one. You should first take steps to define your target market - who is it that you want and expect to visit your website.

Once you have a defined target market you can then take time to build your site for your market. For example, if the majority of your target market uses mobile devices to browse the Web you should take steps to design your site so that it is viewable on mobile devices.

You should also determine what you want visitors to do on your site. Some companies want them to click through to another site, while others want them to sign up. By defining how you want your visitors to interact you can then develop your content and design around this.

Mistake 2: Designing a website that is too busy

It can be tempting to put all of your information on one page or even have a ton of images and videos. The truth is, this can be distracting largely because once someone lands on your page, they won't know how to get around, find the information they want, or even to know what they should do next.

Busy or flashy websites with lots of animations or large amounts of text also usually don't scale all that well. So, when someone looks at your site on a mobile device they will likely find it too hard to navigate and leave, which is counter to what you are trying to achieve.

Instead, aim for a website that is simple and clean. Important information should be quick to find and read and it should be clear who you are, what you have to say, and what you want the visitor to do.

Mistake 3: Lacking call to actions

Most business related websites have a goal as to what they want visitors to do. Maybe it's download an app, call the company, or even sign make a purchase online. It is essential that you lead visitors toward what you want them to do in the most clear and concise way. The best way to do this is through a call to action. These are usually buttons at the bottom of sections or pages that motivate the user to click and follow the instructions on what to do next, be that sign up to something or get in touch.

The best calls to action stand out from the content, drawing the reader's eye and hopefully inspiring them to click. They should also be clearly written, simple, and direct. e.g., 'Call us today!' or 'Download now!'

Mistake 4: Misguided content

It may seem worthwhile to write in-depth content about your products or services but this isn't always the case. People skim read the basics on the Web and it's different than other mediums.

What you should do is condense down your content so that it only states the most important information. Tell the reader what your product or service does and provide a few of the most important benefits. What you are looking to do is develop enough interest so that visitors to your site will click on the call to action and connect with you.

If you have the time and profits, creating a more visual site where you showcase the products or show how you can help in a short video may lead to higher engagement and possibly higher customer conversions. Take a look at the popular software and service sites like Dropbox, Microsoft, and Google. The content is highly visible and simple, yet provides just enough information so the user knows what the service is and what they are expected to do.

Mistake 5: Static content

It can be tempting to invest the time to write a great website, get the content online then just leave it sitting there. The Internet changes and what might have been regarded as great website design and content a couple of years ago may not be seen in the same light today.

It is advisable to periodically update your site's design and content to reflect current trends; making it more modern. Another related aspect of your content is that you need to ensure that your content is up-to-date. If you are hosting a contest and put the information on your site, you should make sure to take it off of your site, or update it when the date passes. It looks a little unprofessional to have content that is still talking about 2012 or even 2013.

Mistake 6: Doing it yourself

The vast majority of small business owners and managers don't have in-depth Web design skills, yet are determined to build their company's website themselves. This can lead to unexpected problems or a website that doesn't meet your needs. We strongly recommend that you work with a qualified designer who can help ensure that your website is designed and built to high standards.

If you are looking to boost your website's design contact us today. We can help!

Published with permission from TechAdvisory.org. Source.

March 26th, 2014

Office365_Mar24_AExcel is one of the applications included in Microsoft Office, Microsoft's suite of office productivity software. Microsoft Office applications can run on almost every system businesses use, including Windows and Mac. Excel is specifically used for creating spreadsheets, basic databases, analyzing data, and even simplifying management. Many spreadsheets can be a challenge to navigate. One way to make your spreadsheets easier to get around is to name the cells.

Like other spreadsheet applications, Microsoft Excel documents are based on cells that can be arranged into rows and columns. It is within these cells that data is entered when creating a worksheet for various functions including data management and computations, etc. Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number.

For instance, the cell under column A that belongs to row 1 has the default name A1. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar. This name can actually be changed however.

Why name cells in Excel

As mentioned, the default name for each cell in an Excel spreadsheet is based on the relevant column and row. One of the reasons why you may want to change this name is to make it easier to find what you are looking for, especially when there’s a lot of information in a particular spreadsheet. For instance, if you name a particular cell 'Total', searching for this word is much faster than scrolling through the spreadsheet to find the correct cell or trying to remember its specific column and row.

This is also the case when creating formulas for computations. Instead of using the cells’ column letter and row number, it’s more convenient to use a name that you can easily understand. For example, naming one cell 'GrossIncome' and the other one 'Deductions' makes it easier for you to compute net income by subtracting Deductions from GrossIncome for the result.

Another benefit of naming cells is that it is easier for other users to understand. If you are sharing the spreadsheet or workbook with other colleagues or business associates, using cell names that are easy for everyone to identify reduces potential confusion.

How to name cells in Excel

Naming cells in Excel can be done in two ways. The first is by changing the name directly on the name box and the other one is by defining names under the Formulas menu. The difference is that when naming a cell through the define name feature of the menu you can select its specific scope.

This determines where the specific name will be recognized as having the same value, such as in the entire workbook or in a specific spreadsheet only. Changing the name in the name box will automatically determine the workbook as its scope rather than the whole spreadsheet.

Changing a cell name in the name box:

  1. Select the cell that you want to name.
  2. Go to the name box and type the name you prefer.
  3. Hit enter on your keyboard.

Defining a cell name:

  1. Select the cell that you wish to name.
  2. Click the Formulas menu.
  3. Choose Define Name.
  4. Type the name of the cell in the new window that pops up.
  5. Select the Scope.
  6. Click OK.
Remember that a cell name should not contain any spaces. The uppercase and lowercase letters R and C are also not available as cell names, since they represent column and row. Furthermore, aside from letters, the first character of a cell name can also be a backslash or an underscore. The rest can be a combination of letters, underscores, periods and numbers, which can be up to 255 characters.

If you have further questions about changing the cell name in Excel, please don’t hesitate to give us a call.

Published with permission from TechAdvisory.org. Source.

March 20th, 2014

Security_Mar17_ASecurity of a business's systems and networks should be important to many business owners and managers. In fact, an increasing number of companies are implementing security strategies. While these strategies do keep businesses secure, there is one critical element that could cause plans to fail, leading to an increased chance of a breach of security: The audit.

Auditing and the security security strategy

Auditing your company's security is important, the only problem business owners run across is where and what they should be auditing. The easiest way to do this is to first look at the common elements of developing security strategies.

These elements are: assess, assign, audit. When you develop a plan, or work with an IT partner to develop one, you follow the three steps above, and it may be obvious at the end. In truth however, you should be auditing at each stage of the plan. That means you first need to know what goes on in each stage.

During the assessment phase you or your IT partner will need to look at the existing security you have in place. This includes on every computer and server and also focuses on who has access to what, and what programs are being used. Doing an assessment should give you an overview of how secure your business currently is, along with any weak points that need to be improved.

The assignment phase looks at actually carrying out the changes you identified in the assessment phase. This could include adding improved security measures, deleting unused programs or even updating systems for improved security. The main goal in this phase is to ensure that your systems and networks are secure.

Auditing happens after the changes have been made and aims to ensure that your systems are actually secure and have been implemented properly. Throughout the process you will actually need to continually audit and adjust your strategy.

What exactly should be audited?

When conducting an audit, there are three factors you should focus on:
  1. The state of your security - Changing or introducing a security plan usually begins with an audit of sorts. In order to do this however, you need to know about how your security has changed in between audits. Tracking this state and how it changed in between audits allows you to more efficiently audit how your system is working now and to also implement changes easier. If you don't know how the state of your security has changed in between audits, you could risk implementing ineffective security measures or leaving older solutions open to risk.
  2. The changes made - Auditing the state of your security is important, but you should also be auditing the changes made to your systems. For example, if a new program is installed, or a new firewall is implemented, you will need to audit how well it is working before you can deem your security plan to be fully implemented. Basically, you are looking for any changes made to your system that could influence security while you are implementing a new system. If by auditing at this point, you find that security has been compromised, you will need to go back to the first step and assess why before moving forward.
  3. Who has access to what - There is a good chance that every system you have will not need to be accessed by every employee. It would be a good idea that once a security solution is in place, that you audit who has access to what systems and how often they use them. This stage of the process needs to be proactive and constantly carried out. if you find that access changes or system access needs change, it would be a good idea to adapt your the security strategy; starting with the first stage.
If you are looking for help developing a security strategy for your business, contact us today to see how our managed solutions can help.
Published with permission from TechAdvisory.org. Source.

Topic Security
March 20th, 2014

Hardware_Mar17_AIt’s hard to imagine printers completely disappearing in offices. While no one can refute how most documents are now housed in the digital realm, there will always be a need to have these documents printed out for one reason or another. While offices do have printers, it may be confusing to pick a new printer when you need a new one.

These three printers below are the most common printers found in offices these days.

Multi Function Printers (MFP)

Multi Function Printers are also commonly known as all-in-one printers. With this type of device, your printing, scanning, faxing and photocopying needs are covered! These printers usually come in a variety of sizes with many being small enough to fit onto a small desk.

Aside from the multi function features that MFPs have, these are the common benefits that business owners can gain from this type of printer.

  • They take up less room.
  • They are usually lower in cost. Though it may seem expensive compared to the other types of printers, if you consider buying a fax machine, scanner, photocopier and a printer, you’ll find that buying an MFP is actually a lot more affordable.

Inkjet Printers

Inkjets print documents by spraying ink onto paper, and can usually produce prints with a resolution of 300dpi (dots per inch) with some actually able to print documents as high as 600dpi. This makes them ideal for printing saller images and reports.

What most business owners like about inkjet printers is the fact that they are usually affordable, making them an ideal device for businesses that just want printers. Since most offices (if not all) have computers, you’ll most likely see inkjet printers in the majority of offices. Here are some more benefits that people like about inkjet printers.

  • Fast printing speeds.
  • Can produce really high quality print.
  • Easy to use.
  • They can produce vivid colors.

Laser Printers

If there’s one very notable feature that you’ll love about laser printers, it would be the printer's capability of producing very high quality documents. In fact, laser printers can produce copies with a resolution of 600 dpi - 1200 dpi.

One of the main differences that laser printers have is the fact that they use toner (colored or black powder) instead of the inks that are used in most other printers.

Laser printers offer users many enticing benefits including:

  • Very high resolution.
  • Fast results.
  • High volume printing.
  • No smears at all.

What type of printer should my business get?

If you are looking for a new printer, it can be a little confusing as to which you should get. If you don't have a scanner or fax machine, it would be a good idea to look into a Multi Function Printer. Looking to print smaller or shorter documents or only occasionally? An Inkjet would probably be a better choice. If you need to print on a regular basis, or print in mass quantities a laser printer could be the best choice.

With all the types of printers available in the market, choosing a specific printer to use in your office can be quite confusing. If you need help in choosing which printer to go for, then give us a call and we’ll give you our expert advice on the matter.

Published with permission from TechAdvisory.org. Source.

Topic Hardware
March 19th, 2014

BCP_Marc17_AA business without a DRP (Disaster Recovery Plan) is like a circus acrobat without a safety net. The question is, are you willing to take that kind of a risk with your business? Considering how attacks to your business can come in many forms be it cyber, natural disaster or man made (among many others), it makes perfect sense to have an effective DRP in place.

While there are several facets to a DRP that are going to determine whether it will be effective or not, making sure that you’ve considered these 5 tips is definitely a good start.

1.) Commitment from management

Because the managers are the ones who will coordinate the development of the plan and be the central figures who implement the recovery plan, it’s crucial that they are committed to it and are willing to back it up.

They will also be responsible for setting an allocated budget and manpower to creating the actual plan. That said, it’s very important that they know the concept behind it and how huge of an impact a DRP can have on a business.

2.) A representative on each department should be available when creating a DRP

It’s unthinkable to believe that your DRP is well optimized when you haven’t had a representative from each department coordinate with you while creating the recovery program.

Considering how they themselves are the front line of your organization with the best knowledge about how their department works, it’s a huge plus that you should take advantage of when creating a DRP.

With the representatives on your team, you’ll be able to see things from their perspective and gain first-hand knowledge from those who do the actual work.

3.) Remember to prioritize

In an ideal world, you should be able to restore everything at the same time after a disaster strikes. But since most businesses usually have a limited amount of resources, you will usually have to recover systems one at a time.

Because of this, you need to have a hierarchy or a sense of priority when determining which systems should be recovered first. That way, the most important systems are immediately brought back up while the less important ones are then queued in order of their importance.

4.) Determining your recovery strategies

This is one of the main focal points of a DRP since this phase tackles the actual strategies or steps that you’ll implement to recover your systems.

When determining your actual strategies, it's important that you brainstorm and think about all the options that you have to recovering your systems. Don’t simply stick with the cheapest possible strategy or even the most expensive ones.

You have to remember though that the simplest strategy to implement is probably the best one. That is, as long as the simplest strategy covers the critical aspects of your system recovery.

That said, avoid over complicating your strategies as you might face unnecessary challenges when it comes to the implementation of the recovery strategy.

5.) Do a dry run at least once a year

Your DRP shouldn’t end with the concept alone. No matter how foolproof you think your strategy is, if you haven’t tested it you most likely have missed something important.

It's during the dry run phase that the need for extra steps (or the removal of one) are made even more evident. You can then start polishing your strategies according to how your dry run plays out. It would also be a good year to practice your plan each year and update it accordingly.

These tips will help you ensure that your DRP will remain effective should a disaster occur. If you’re having a hard time figuring out how to go about the process of creating a DRP, then give us a call now and we’ll help you with the process.

Published with permission from TechAdvisory.org. Source.

March 11th, 2014

Office365_Mar10_AThere is more to a PowerPoint presentation that just adding words and images to your slides. If you aren’t careful, chances are your audience will end up sleepwalking while you're in the middle of your presentation. While that may sound scary, you don’t necessarily have to experience that. Given that you follow the tips we’ll be sharing, your PowerPoint presentation should end up becoming an effective one.

Choose a font size and style that can be seen by your audience from a distance

There is no point in creating a PowerPoint presentation if your audience can’t even see or understand what’s on your slide. One of the best ways to ensure that your audience does in fact understand what’s written is for you to use the proper font size and a simple font style.

You have to consider how far back your audience might be sitting when watching your presentation along with the technology you will be presenting on. For example, if you are in a theater using older projection technology, it may be hard to read certain types of font, colors, etc. So it is better to use a larger font size and contrasting colors.

If you can, try to practice the presentation ahead of time and sit at the back to see whether your slides can be seen and read.

Emphasize on the information and not the look of your slides

Don’t ever compromise how your information is presented for the sake of how the slides look. Remember that the point of doing the presentation is to convince your audience to act and not to impress them with a beautifully made presentation.

In order to do this simply create your presentation with only the information your audience needs. Leave out any visuals and focus on outlying the information first. Once you have the information on the slides, then you can add the effects and visuals, being sure to keep them minimal so the information shines and is highlighted.

Avoid handing out printouts of your presentation

One of Seth Godin’s - a marketing and presentation guru - tips for avoiding a really terrible PowerPoint presentations that focus on selling products or services, is to have a maximum of 6 words or lines per slide. The slides are more for points that you will talk about and expand upon. Anymore than that is less than ideal.

Now imagine what would happen if you give your audience a print out of your presentation. They probably won’t be able to make out what your message is since there are only a maximum of 6 words per slide. Beyond that, note packages often lead to people reading ahead and paying attention to the notes in front of them, rather than you, the speaker. Plus, the rustling of paper when people flip pages can also be distracting for the audience and presenter alike.

What we suggest is instead at the beginning of the presentation note that you will make the presentation available online after the presentation is over and providing scrap paper or notebooks for people who wish to take notes. That being said, if the presentation you are giving in educational, notes with a copy of the slides would be a good idea, but be sure to keep the content of the actual slides minimal, more just talking points.

Be consistent

Whether we’re talking about the message that you’re trying to convey, the theme of your slides or the tone/pacing of your presentation, you have to be consistent.

The more consistent you are, the more focused your audience will be. This is because consistency helps establish and give clarity to your message, making sure that it doesn’t fall through the cracks.

Phrase your points in a way that it talks directly about the benefits

We all like to be on the receiving end of something good right? If you focus on telling your audience about the benefits that they can acquire, chances are they’ll be very attentive because your presentation is all about their benefits.

These PowerPoint presentation tips can help you get more results out of your presentations. If you are looking to learn more about how you can leverage PowerPoint for better presentations, contact us today to see how we can help.

Published with permission from TechAdvisory.org. Source.

March 5th, 2014

BusinessValue_Mar03_AThere are many ways businesses can improve not only their value but how they connect with their customers. Sure, having a website is a great step, as is having a social media presence, but you need to produce quality content to post on your site or profiles in order to get people to keep coming back. One of the best ways to do this is with blogging.

If you're looking to get people more involved and connected with your company, spread your brand image and message, and perhaps establish your company as an industry leader, then blogging might just be the answer.

There is little doubt that companies that blog effectively do see an increase in overall value. That being said, it can be a challenge to develop and maintain a successful blog.

Here are 7 tips for businesses looking to start a blog or develop an existing one into a more successful platform:

1. Define your topics and your audience

As with almost every business process, there needs to be a solid foundation on which to build your blog, such as the topics you write about and your audience.

Take a minute to establish who your target audience is, such as your average customer. Pick some basic characteristics that cover the majority of this group. Focusing on who you are writing articles for can make writing not only easier but more relevant and effective.

Many of the most successful business blogs choose blog topics based on their services or products and news. The key is to select topics based on what you think your audience will find useful or interesting. You might not want to spread your blogs over too many topic areas as these can be hard work to cover on a regular basis. About 4-8 is a good amount to aim for.

2. Be consistent

With defined topics and a target audience in mind, you are well on your way to establishing a solid foundation for your blog. The next element is to devise a calendar of how often you write blogs and cover certain topics. If, for example, you picked four topics this could equate to one article a month for each topic.

What you are striving for is consistency. You should be writing and posting a new article at least once a week, or more. If you establish a calendar based around your topics you will find it easier to write content on a regular basis and soon it will become a natural part of your weekly tasks.

3. Be relevant

Even with defined topics, it can be a struggle to come up with new ideas for blogs. It can be tempting to write about a new product or feature, but you have to be careful that it doesn't read too much like boring marketing material.

Instead, focus on what your audience would like to read. Often the most successful articles are those that answer common questions asked by clients, or talk about how a product or service can help a client. Other articles could be related to your products rather than directly about them. For example, if you own a coffee shop then writing about food that goes well with coffee might be an interesting blog idea.

Personal opinions can provide an interesting perspective and many readers find these types of business blogs refreshing. However, you do need to be careful of ostracizing those who might not agree with you or putting people off with negative blogs.

4. Don't forget the CTA

Remember, your business blog needs to have a purpose: You want to not only develop interest in the company, but to drive business. At the end of most if not all of your articles you can include a call to action (CTA) that suggests to the reader to contact you, come in for a visit or email.

5. Keep articles easy to read

It can be tempting to write a 4,000 word article with a ton of great information. Google and many search engines do look positively at long-form content and this might work well for your search rankings. The only problem is that when many of us read articles online we skim them, looking for salient points and skipping up to 90% of the article.

To that end, keep articles on the shorter side - around 500-1,000 words. Use shorter sentences and headings like H3 and bold to separate content and make it more scannable. Writing a longer article? Split it into two, three or even four parts. This helps drive interest to return to check out the new parts when they are posted.

6. Promote and share your content

Share your blog content on your social media profiles. This increases the reach of your blog, but also drives traffic to your website. You can put an easy to see link to your blog on your homepage and even in email headers.

Many writers also find success in contributing, or writing a blog for other websites. This helps not only spread your ideas, content, and company name, but can also help find content for your blog as other writers contribute to yours. Try contacting friends and colleagues to see if they would like you to write a post for their blog.

7. Remember you don't have to be the only contributor

Finally, you don't have to be the only person writing your blog. Ask your employees if they have any article ideas they would like to write about. The more writers contributing, the more content there is. This also takes the pressure off of you having to develop, write, and post everything, as well as offering a different voice for variety.

If you are looking to launch a blog, contact us to see how we can help.

Published with permission from TechAdvisory.org. Source.

February 28th, 2014

BI_Feb24_ABusiness Intelligence (BI) has become an essential function of many businesses. Those who employ some form of BI often see increased sales, or at the very least the ability to make quicker informed decisions more often. When looking into BI solutions however, you will likely come across a number of terms that may be a little confusing. Three of these somewhat puzzling terms relate to data - data mart, data warehouse and data mining.

What is a data warehouse?

The concept of a data warehouse is an interesting one and also a difficult one to define and pin down largely because it can cover such a broad area. The most concise definition we can give is that it is a database that integrates data from many different locations and databases into one consolidated database.

Data warehouses store both current and historical data, and rarely contain unique data. Instead, they aggregate data from other sources in order to make this more accessible. They might store important information from sales, marketing, ERP, customer interactions, and any form of database in order to quickly generate BI related reports.

The name undoubtedly conjures up the idea of a large warehouse-like building storing infinite amounts of data. However, most data warehouses are actually tables which are created by taking data from various sources and cleaning it up so that relevant data is stored in the warehouse in a way that makes it easier to reach when needed.

What is a data mart?

A data mart is a smaller data warehouse that stores data. These are based on a specific area or business function e.g., finance or marketing, etc. In fact, most modern data warehouses are actually made up of a series of smaller data marts.

The key difference between a data mart and a data warehouse is that data marts are usually smaller, focusing on one specific area, while a data warehouse covers the whole organization.

What is data mining?

When talking about Business Intelligence, many experts will refer to data mining. This is the act of analyzing data in order to identify patterns. The data that is mined can then be transformed into useable information. Many companies store this mined data in databases, a data warehouse, or a data mart.

Want to learn more about these terms and how your company can benefit from a BI solution? Contact us today.

Published with permission from TechAdvisory.org. Source.

February 26th, 2014

Office365_Feb24_AWith every Office 365 subscription, you are given access to Web-based versions of Microsoft's programs. With familiar functions, users still feel right at home. If you are planning to utilize the Excel Web App for times when you are out of the office then you have come to the right place. The platform has changed, but the application is pretty much the same.

Thumbs up for the ease of familiarity

The basic shortcut keys are pretty much the same across all Microsoft applications, regardless of the platform. If you’re already familiar with the shortcut keys, the Excel Web App is going to be a breeze for you.

Those who need a refresher will find some helpful shortcuts as we go along. Keep in mind that when collaborating on a file, you need to check the share settings and make sure that you have permission to edit that workbook or many of the shortcuts may not work.

Commonly-used shortcuts

The familiar Ctrl + C and Ctrl + V still work for copy and paste respectively. While Ctrl + Z and Ctrl + Y work for undo and redo. Ctrl + X moves an item from one cell to another.

Remember that when you copy the contents of a cell and paste it into another cell within the same workbook, the characteristics or formatting of the source will also be copied into the destination cell. Whereas, if you paste an item from outside the Excel Web App, the item is inserted as plain text and you will have to apply formatting.

Tables and hyperlinks can also be inserted into Excel. Ctrl + K inserts a hyperlink, while Ctrl + T inserts a table.

The arrow keys remain the same, allowing you to move from cell to cell e.g., right, left, up or down.

There is also no change with the formatting shortcuts such as Ctrl + B for Bold, Ctrl + I for Italics, and Ctrl + U for Underline.

A tip for spreadsheet presenters

If your spreadsheet involves charts and visuals, you might want to consider using the Excel Web App version as the visuals appear sharper. While there isn't a huge difference, even a little boost in visuals can make a huge difference to the overall effectiveness of a presentation.

Using the Web versions of Office programs is a great way to stay on top of your game beyond office hours, as workload necessitates. What can Excel and Office 365 do for your productivity? Get in touch and we'll show you.

Published with permission from TechAdvisory.org. Source.