New Distracted Driving Laws for Ontario

Many cities and countries around the world are having problems with distracted driving accidents. During 2016, Great Britain recorded 1,445 fatal crashes where one or more people were killed. One study completed in the town of St. Albans found that one in six drivers were engaged in some type of activity that took their focus away from driving.

Distracted Driving Ontario

In the United States, approximately nine people are killed on average each day due to distracted drivers. Another 1,000 people are injured with millions of dollars in property damage. In Toronto, there were about 7,500 distracted driving accidents during 2016. Of those, there were eight fatalities and 2,642 injuries with thousands of dollars in property damage.

In spite of public awareness campaigns, drivers continue to ignore these statistics. People tend to think that bad things only happen to others, so they go ahead and text or talk while driving. This has become such a problem that cities around the world have changed their distracted driving laws, increasing penalties and fines. Ontario is one those areas that have recently increased the penalties and fines for those caught.

What is Considered Distracted Driving?

Many people connect distracted driving with texting while driving. In fact, distracted driving covers any activity that causes the driver to divert their attention away from the roads and traffic. Studies have found that younger drivers are more likely to ignore laws and put everyone on the road at risk. Distracted driving includes:

  • Eating while driving
  • Changing the radio
  • Watching any type of media
  • Talking or texting while driving
  • Reading
  • Looking at a map
  • Smoking
  • Any activity that diverts the driver’s attention

Most cities are seeing a big rise in the number of tickets issued for distracted driving each year. Lawmakers feel that these penalties and fines will eventually cause drivers to realize that times have changed. Drivers must give their full attention to the road and avoid losing focus. Lives are at stake.

A Major Factor

One of the major factors that make distracted driving so deadly is speed. A car traveling at 60mph moves at 88 feet per second. Using simple math, we can see that if you turn your attention away from the road for only three seconds, your car will have traveled 264 feet. A football field measures 360 feet so you will have traveled approximately three-fourths the length of a football field, just to put things in perspective. That’s a great distance when you consider that there are autos moving at similar speeds all around you and on both sides of the road. If each driver looked away from their driving for three seconds, there would be dozens of crashes with multiple fatalities.

The truth is that each driver feels that they’re probably the only one on the road who is looking away for a few seconds. Surely with all the other drivers paying attention, there’s no need to worry – they’ll see you and take action in time to avoid an accident. This can be a deadly assumption.

An average vehicle weighs around 3,500 pounds, making it a very dangerous weapon in the wrong hands. Though more experienced drivers are less likely to be guilty of distracted driving, the truth is that everyone occasionally feels that a text message or phone call is important enough to take the risk.

This type of thinking has become an epidemic in Ontario, England, America and many other countries. For these reasons, legislatures and lawmakers have been forced to increase the penalties for these crimes.

Changes in Ontario’s Laws

New laws have recently taken effect in Ontario that increases the fines and penalties for failing to give your undivided attention to the road. Fines for a first offense can be as much as $490 with three demerit points on your license. If you decide to fight the ticket and lose, you could pay up to $1,000 in fines. If you’re a new driver with very little driving experience, you could lose your license for 30 days. With each conviction, novice drivers will have their license suspended for longer periods of time, up to 90 days. After that, a novice driver’s license could be revoked completely.

When is it Safe to Use the Phone?

Many drivers have had questions about these new laws. In Ontario, it’s not uncommon to see drivers pull off to the shoulder in order to take an important phone call. But is this legal? Or it is dangerous as well? Each city has its own unique laws when it comes to these types of issues. In Ontario, the law states that a driver may pull off the road to a safe location and take a phone call.

In some cases, moving to the shoulder of the road is not deemed safe. There may be workers there making road repairs. The shoulder of the road often has gravel, which can fly up and crack a windshield. Since each case is a bit different, it’s up to the driver to ensure that they are pulling off and re-entering the highway in a safe fashion. If a traffic officer feels that a driver has not pulled off the road in a safe manner, the driver may receive a traffic citation for this. At the end of the day, the traffic officer’s job is to make sure that all drivers are protected. Everyone wants to get home safely to their family each day and it simply is not worth it to put anyone in danger over a text message or phone call.

Tips for Avoiding Fines

We all want to get to our destination safely so what is the standard these days for using a phone while driving? According to the new laws in Ontario, drivers can use hands-free devices (Bluetooth) to talk on the phone while driving. However, you cannot pause to dial a number or answer a call unless you can do so using voice commands.

Most experts recommend turning your phone off while driving. That way, you will not be tempted to answer a call or text message. If you are leaving on a long trip, then email all your friends and tell them that you will be driving and will not be able to return calls until you stop for service or food.

Safe Driving Tips

Always be mindful if on the road with cyclists, emergency vehicles or buses. Pay special attention to the road, your driving and other drivers. Remember that although you may not be breaking the law, there are others on the road who are. There may be a teenager who wants to talk to his girlfriend while driving to school. These drivers present a special danger due to their limited experience behind the wheel.

There may be drivers who are under the influence of drugs or alcohol. This condition has been shown to slow a driver’s reflexes. Sometimes drivers are worried about being late, so they try to speed, take shortcuts or make erratic movements. When you put all these different drivers on the road at the same time, it can be dangerous.  It’s a good idea to bear these things in mind before getting behind the wheel.

Need To Refresh Your Accounting Software?

Here’s Some Up-to-Date Info That Should Be of “Interest”!

Accounting Software

Accounting software is much-needed tool today. Gone are the days of manually writing down copious amounts of figures in heavy, dusty logbooks, or using calculators to add up debits and credits. Our computers do this for us now. Accounting software makes the process of bookkeeping more efficient and accurate.

What else is different than in years past? Today’s newest accounting solutions are now cloud-based, and they provide many advantages.

No more shelling out a large amount of cash to purchase expensive business accounting software. Instead, you can pay for a web-based accounting service via a convenient subscription.

Online accounting services are used via the Internet rather than being installed on your organization’s computers. They allow you to access the information you need through an Internet browser like Internet Explorer, Firefox, Chrome or Safari. You can access the service from anywhere you have an internet connection, and it will always look like the same wherever you use it.

Plus, you won’t have to worry about technology requirements, if you have the right operating system, backing up your accounting data, installing updates or dealing with maintenance issues. You get all this and more handled for you–And all for a convenient monthly or annual fee.

Just like any accounting software, cloud-based accounting services allow you to perform all the accounting tasks your business needs, and they include features you’re familiar with like an online general ledger, invoicing and accounts receivable capabilities, purchase histories, business inventories and much more.

And, because upgrades and data backup are managed by the accounting service vendor, cloud-based accounting services are an attractive option for small businesses.

Although these new solutions are cloud-based, you can still buy desktop accounting software if you wish. But due to their popularity, most small businesses are now using online accounting services. Because of their anywhere availability via the Internet, crunching numbers is now much easier than ever before.

What Do Online the Different Accounting Services Have in Common?

Each solution is different, but they all have the following features in common.

They are available via a subscription. Accounting software has always been expensive and needs to be updated every year. With the online version, you pay for only as many users as you need, and you can pay on a monthly or annual basis. Many offer a free trial that converts when you sign up for a service. They cost anywhere from $5 to $70 a month depending on what you require. You won’t be locked into a contract, and all the upgrades are provided. Another plus is that your data will automatically be backed up to a secure cloud.

They’re easy to navigate. Online accounting services try to make your job less taxing with intuitive, easy-to-navigate platforms where you can easily find the features you want. Toolbars, drop-down lists, fill-in-the-blank fields, buttons and icons, all help you enter the numbers for whatever calculations and financial forms you require.

They use language that you’re familiar with. Although we still refer to terms like credits, debits, and chart of accounts, online accounting solutions only use arcane financial language when absolutely needed. The developers are trying to use every-day language whenever possible. However, although centuries old, double-entry accounting is a process we all need to use, and it’s here to stay, the developers let the “wizards” handle the complex processes behind the scenes.

They provide mobile versions. If you’re on the road, traveling for business meetings, or even need to do a little work when you’re on vacation, you can access your web-based accounting services securely from your mobile devices.

You have the choice of different levels of service. Some of the best cloud-based accounting solutions provide more than one level of service at different prices. This way you can purchase just what you need and nothing more. If you need to switch to a different level, most allow you to do this easily.

You can integrate them with other solutions. As your business grows, you may find that you need to use a variety of cloud-based financial management solutions. In this case, many of the best cloud-based accounting solutions allow you to connect to other services that you may already be using.

Dashboards. Interactive home pages or dashboards will help you keep track of your finances by flagging tasks that need attention and providing visuals like graphs and charts to give you a high-level view of where you stand. They summarize data like income, expenses and cash flow in easy-to-read images, so you and your team can more easily comprehend data and can make decisions about what to do.

Which Solution is the Best for Your Business?

So, how do you decide which online accounting solution is best for your small business? You might not be able to find a perfect match, but because they are flexible and provided on a monthly basis, you can find the best one for you and tweak it along the way.

As mentioned, many offer a free trial, so you can “road test” them. Give them a try and consider the following questions when you do:

  • Can you import your existing data?
  • Are the tasks you perform most often supported? (recordkeeping, billing, purchasing, etc.)
  • Do you like the interface? Is it easy to navigate?
  • Will it support the number of users you need?
  • Are there any restrictions on actions you’ll need to take?
  • Is it customizable?
  • Is it scalable?
  • What is the quality of the mobile application?
  • Are add-ons supported?
  • Do they provide a help desk or support solutions?
  • Is the subscription fee something that your budget will allow?

While you’re at it, we did some homework for you. Below are some of the top online accounting services for small businesses.

Consider these and take advantage of the free trials they offer. Don’t worry if these might not work for you five years from now. Assess them based on your needs for the upcoming year.

Remember, you aren’t purchasing the product. Instead, you’re signing up for a subscription that you can change or upgrade/downgrade as you need. In other words, you aren’t stuck with these like you are with regular accounting software programs.

No matter which online accounting solution you choose, you’ll have peace of mind because you won’t have to worry about security. Online accounting services have stringent security requirements to ensure that your data is safely protected from hackers and any kind of loss. Even if your physical office is destroyed, or an employee accidentally deletes information, your online accounting service will be able to retrieve your data for you.

Can Enterprise Content Management (ECM) Improve Compliance?

In this age of information, it’s challenging to maintain compliance with so much data stored on many different devices. Most companies these days have remote workers, employees in various departments, third-party vendors, management, employees working in other countries, and more. These people have laptops at home and at work, smartphones, and tablet computers. All this information must be structured in a way that it can be stored or accessed successfully whenever needed. This is a massive task that seems impossible, yet with enterprise content management programs, it’s suddenly doable.

Enterprise Content Management

Information Overload

Americans are now overwhelmed with the massive amounts of data that exist in their world. But it’s not enough to have a world full of information available; you must know how to use it to achieve your business goals while adhering to compliance regulations. Though there are many ways to handle these tasks, the key is creating a system that’s user-friendly but safe from hackers. Compliance is all about protecting everyone’s data from the world’s cyber thieves.

Losing Control of Compliance

With so many different methods of storing and maintaining data, it’s easy to lose control of compliance issues. This is a problem for every business owner, large and small. Enterprise organizations are easily the most vulnerable simply for the sheer volume of data they must maintain. Our age of information can loom out of control with the simple act of one employee losing a computer. Suddenly, hundreds of records are at risk and the company is struggling to find out what information has been lost. These types of events occur much more often than most CEOs want to admit.

How ECMs Help

Enterprise content management systems can create a safe method of handling and control all this important data. A few of the solutions include:

  • Optimizing workflows using multifunction devices to reduce the number of machines and interfaces
  • Improving the security of all documentation
  • Ensuring ongoing compliance with industry requirements
  • Ensuring the best performance of hardware and software
  • Minimizing downtime to cut overall costs
  • Implementing green strategies with rules-based printing and cartridge recycling

The latest ECMs utilize additional resources to better manage conference rooms, mail rooms, help desks, procurement and many other areas where productivity can be radically affected. There’s much more to managing content than meets the eye.

Controlling the Data Flow

If you’re running a large business with hundreds or even thousands of employees, these types of issues can be extremely hard to control. Every company needs to achieve an optimal level of productivity. However, a healthy level of compliance has become an important factor in this mix. There’s just too much at stake these days if the personal information of millions of consumers is compromised.

In addition to your company’s internal rules and requirements, you may be forced to observe regulations from:

  • The Health Insurance Portability and Accountability Act (HIPAA)
  • The Affordable Care Act (ACA)
  • The Sarbanes-Oxley Act (SOX)
  • The Occupational Safety and Health Act (OSHA)

Audits Can Be Stressful and Expensive

Imagine the IRS showing up at your door and demanding your documentation to prove compliance in some or all of these areas. Where do you even begin? Your employees might have to sort through several data systems, search file cabinets, and reign in multiple records from dozens of computers and other devices. This scenario can be a nightmare that no one wants to endure. Missing paperwork and costly errors are just the beginning.

That’s why so many large companies are moving over to enterprise content management systems. These systems provide an efficient method of storing, tracking and managing large volumes of data. Everything is located in a single repository. This makes it far easier to locate important documents that prove compliance. Plus, important documents are protected from intrusion.

Easing the burden of complying with today’s wide range of regulations can give your company leaders peace of mind. It’s a real confidence boost for the stockholders as well. Using advanced robust technology, your organization can move forward more efficiently with a higher level of security.

Easy Search & Collaboration

The best enterprise content management systems are cost-effective, secure and easy for everyone to use. They support all common platforms and databases. Information should be easy to search with programs that seamlessly send a document to the scanner or printer. Most teams need to be able to collaborate in real and virtual meeting rooms. It can be very helpful to be able to find a document, then edit it live together with other teams. This helps everyone stay informed and up-to-date. Transparency in document editing is also important, especially in the event of an audit.

Maintenance & Certification

Another important element, various filters can determine when regular maintenance on the equipment or data is necessary. Alerts are sent out to the correct employees when they need new certifications. These seemingly small tasks keep things flowing and people on track. Once new certifications are obtained, copies are stored with their expiration dates. These documents are fairly easy for auditors to check and this makes everyone’s life a little simpler.

Greater Security

In the past few years, everyone has been shaken by the enormous number of identities stolen in various data breaches. Security is paramount on everyone’s mind. Rules-based settings can be employed to allow access only to those with proper authorization. When you’re dealing with financial data and health records, you simply can’t be too careful. This data should be available whenever needed but safe from hackers. Many enterprise customers are moving to ECMs simply to improve their security. This has rapidly become an important part of doing business.

Proper Archival Procedures

The government requires certain tax forms to be on file for specific lengths of time. However, most documents will eventually need to be archived. The Department of Labor and IRS have many such requirements. Employees can become confused about the requirements resulting in significant fines. A good enterprise content management system eliminates these worries with automatic purge and archive features. Settings can be altered to meet any specific or preferred criteria.

Growing for the Future

With all these things in mind, search for an enterprise content management system that will grow with your company. In the future, compliance may become even more critical. Companies will certainly continue to expand all over the globe, making compliance even more difficult. If your company incorporates a good ECM from the beginning, these issues can be dealt with as you go along, avoiding any abrupt changes to your daily operations.

If You Don’t Know About These 3 Ways to Use Outlook 2016 More Efficiently, You’re Wasting Lots of Time

Microsoft Outlook is a professional email and calendar program that’s been used by businesses for over 15 years. It’s had many iterations over the years, but with 2016, and its integration with Office 365, Microsoft has taken Outlook to the next level. Today, small and medium-sized businesses that couldn’t afford the enterprise-level application can now benefit from Outlook 2016.

The following are 3 ways to help you use Outlook 2016 more efficiently.

1. Keyboard Shortcuts

Using keyboard shortcuts in Outlook on Windows will help you work more efficiently. It’s also handy for those who have mobility or vision disabilities because using keyboard shortcuts can often be easier than using a touchscreen or mouse. Here are some popular keyboard shortcuts you should try.

And there are more. Here are popular keyboard shortcuts for NAVIGATION:

When searching, try these handy keyboard shortcuts:

 

To create an item or a file keep these shortcuts in mind.

Shortcuts in Mail.

To see more Outlook 2016 Shortcuts go here.

2. Use Quick Steps

Right-click any email, choose Quick Steps and choose from the list.

We’re going to choose Team Email. The first time we use this, Outlook asks you to name your team and enter their email addresses.

Then create a Keyboard Shortcut for this. So, the next time you hit Control Shift 1, an email to your entire team can be composed.

You can also create new Quick Step. Simply choose Create New Quick Step.

Here are some other Quick Steps to try: 1

  • Move to Folder: This is essentially the same as Move To.
  • Categorize & Move: This moves the selected message to a specific folder, marks the message as read, and assigns a category color and name to the message.
  • Flag & Move: This moves the selected message to a specific folder, marks the message as read, and assigns a flag to the message.
  • New Email To: This opens a New Message form with the To field already filled out with a particular recipient.
  • Forward To: This is essentially the same as To Manager.
  • New Meeting: If you often send meeting invites to the same group of people, use this Quick Step to open a New Meeting form with the To field already filled in with the invitees.
  • Custom: This opens the Edit Quick Step dialog box so that you can create your own custom Quick Step.

3. Use Conditional Formatting

This is used to change the look of a particular email. You do this in the View Menu.

Here, we just click on Conditional Formatting and create an email called Microsoft.

Next, we choose a condition, where the word Microsoft appears anywhere in an email.

Then, we ask it to appear in a bold red font.

Now, any new email we receive with the word Microsoft in it will show up in red. This is a great way for us to recognize the importance of an email. You may want to do this for any email with your boss’s name in it!

And, there are more ways you can get the most from Outlook 2016. Here are a few ideas:

EMAIL

  • Change the color and contrast of Outlook: You can also use a picture or color as the background, add a text watermark to your emails.
  • Customize emails with the fonts you prefer: Change the default font for various email messages you send, or a particular font for messages that you forward or reply to.
  • Create signatures for your different email accounts: Create personalized signatures for your email messages: include text, images, your electronic business card, a logo, or even an image of your handwritten signature. Signatures can be added automatically to all outgoing messages, or you can choose which messages should use a particular signature.
  • Setup sound alerts when new emails come in: A sound can play when a new email message arrives. The default sound is a short .wav audio file, but you can change it to any .wav file of your choice.
  • Establish tracking options with delivery receipts: A delivery receipt confirms delivery of your email message to the recipient’s mailbox.
  • Use Outlook’s templates for your messages or create your own: Use email templates to send messages that include information that rarely changes from message to message. You can also insert icons, photos, and tables into your messages.
  • Embed voting buttons in your email to survey your recipients about a particular topic (such as, “When’s the best date and time for a meeting?”): Voting buttons are an excellent way to poll people, especially when communicating with large groups.
  • Use Quickparts to insert a standard set of words you often use: Use the Quick Parts Gallery to create, store, and locate content, including AutoText, document properties such as title and author, and fields.
  • Clutter: This is where you can place low priority emails you want to read later. Clutter helps you filter these low-priority emails saving time for your most important messages. Office 2016 remembers “Clutter” emails if you want.  If Clutter isn’t for you, you can TURN IT OFF.
  • Create folders and subfolders: You can base these on topics, senders, organizations, projects, etc.—Whatever works for you and organize your emails under the subjects you choose. Use folders in Outlook to move email messages, add a folder to your Favorites, and set a rule to move specific emails out of your inbox.

CALENDAR

Outlook 2016 calendars have all the tools and functionality you’ve relied on in the past, with improved features to help you manage your time. 

  • Set up multiple calendars (e.g., personal, business, health, etc.).
  • Create appointments quickly and share them with your contacts.
  • Scheduling assistant lets you access others’ calendars that you’re authorized to view (and vice versa).
  • Set reminders, reoccurring appointments/meetings, alerts, and more.
  • View your calendar by day, week, month, and year.

CONTACTS

  • You can also import contacts to Outlook from other email providers using the Outlook Import/Export wizard. Import a CSV file, Excel spreadsheet, or vCard.
  • Your contacts are linked to your email accounts, so you can simply key a name in the “To” field, and your contact’s email address will appear.
  • Set permission for a particular contact (delegate) to view your emails while you’re on vacation. Plus, you can give this person access to your calendar, tasks, and so on, as appropriate. One delegate can take care of your email, another your tasks, etc.

TOOLS

  • Always know how much space is left in your account.
  • Notify those emailing you that you aren’t available during a particular period with Out of Office. You set up a special message you want others to see.
  • Even set up different messages for people inside or outside your organization. (Outlook will remind you that the “Out of Office” message is turned on, so you don’t forget when you return.)
  • As mentioned above, similar to having an assistant help you manage your incoming paper mail, you can use Microsoft Outlook to allow a delegate, to receive and respond to e-mail messages and meeting requests and responses on your behalf.
  • You can also grant additional permissions that allow your delegate to read, create, or have more control over items in your Microsoft Exchange Server mailbox—And, set more than one delegate and permissions for various tasks.

TASKS

Outlook 2016’s task management helps you accomplish to-dos faster and easier.

  • Categorize your tasks with color codes.
  • Ping reminders for tasks.
  • Check-off tasks when complete.
  • Create tasks for others as well. Outlook integrates tasks with your emails so that you can assign a task to a recipient.  The task will show up on their task list.

To learn more about how you can get the most from Outlook 2016 contact us.

Big Changes For Google

If You Want to Be First on Google Searches, Be Sure to Employ Best Practices for Mobile-First Indexing

Google Changes

On March 26th, 2018, Google announced that after over 18 months of testing they will now begin migrating sites that follow best practices for their mobile-first indexing. This means that Google will now use the mobile version of content to index and rank all websites. Before now, they used the desktop version of a webpage’s content to evaluate how relevant it is to users’ Google searches.

NOTE: You won’t have to change anything if you have a responsive site or a dynamic serving site where the main content and markup is the same in both. However, if your site configurations are different on your mobile and desktop site, you should make some changes to your site. You can check the structured markup across your desktop and mobile versions by typing their URLs into the Structured Data Testing Tool and comparing them.

We’ve been getting a lot of questions about this, so we’re providing some answers for you below.

Why is Google doing this?

Today, most of us search on Google using our mobile devices. Yet, their ranking system is still based on the desktop versions of websites. This creates issues if the mobile pages contain less data than the desktop pages. In this case, the Google algorithms can’t properly evaluate the actual page that’s seen by the mobile device user.

So, to make their results more accurate, Google started experimenting with their index mobile first initiative. And now that it’s been launched, it will be the primary way Google will search for content, show snippets and rank pages.

How does this work?

Google’s Googlebots (or crawlers) search and index web pages. Crawlers are robots or spiders that automatically locate and read websites by “crawling” from one link to another.

Last summer (June 2017) Google advised website owners to switch their m-dot domains to “responsive” before the Mobile-First Indexing launch. If you didn’t do this, then Google will fully index your m-dot content and URLs. This means that the migration for your site will take longer than it should because Google will have to update the content on your pages.

If you have separate desktop and mobile content for your website, this means that you have a dynamic-serving or separate m-dot site specifically designed for mobile devices.

It’s good to have an m-dot site because you can use it to enhance the mobile experience on your site without compromising your desktop or mobile experience.

Ensure you follow Google’s best practices if you want your sites to rank well now with their mobile-first indexing.

Should our mobile content be different than our desktop content? No. It should be the same. And don’t limit it either. This could cause your ranking to decline. If your mobile site contains less content than your desktop site, it’s time to update it. Plus, be sure you include all of your photos, images, and videos in their original indexable and crawlable formats.

What about the structured data? Should we include it on both of our mobile and desktop versions? Yes. The URLs in the structured data on the mobile versions should be updated to the mobile URLs. If you use Data Highlighter for this be sure to check your dashboard regularly for any extraction errors.

How about the metadata? Do we need it on both versions? Definitely. Make sure that titles and meta descriptions are identical across both versions of your site.

Things that you should verify to meet Google’s new Mobile-First Indexing:

  • Verify both your mobile and desktop sites in Google’s Search Console. Now that Google has switched over to mobile-first indexing your sites may have experienced a data shift.
  • Make sure your mobile site’s hreflang points to the mobile URL and the desktop hreflang points to the desktop URL.
  • Make sure your website server has enough capacity for the potential increased crawl rate on your mobile version.
  • Use the robots.txt testing tool to be sure that the Googlebot can access your mobile version.
  • Be sure that your robots.txt directives work properly on both your mobile and desktop sites.
  • Ensure that you have the correct rel=canonical and rel=link elements between your mobile and desktop versions. However, Google says that you shouldn’t have to make changes to your canonical links because they will continue to use them as guides for users who search on either on desktop or mobile sites.
  • If you add structured data to your mobile site, don’t add a lot of markups that aren’t relevant to the information.

The Finer Details

  • To allow or block Google’s crawlers from accessing any of your content, be sure to specify Googlebot as the user-agent.
  • To block pages from Google, blocking the user-agent Googlebot will also block all Google’s other user-agents.
  • You can also get more fine-grained control, like having all of your pages show up in Google Search, but not the images in your personal directory. You can use robots.txt to disallow the user-agent Googlebot-image from crawling the files in your personal directory (while allowing Googlebot to crawl all files). Go here for more details on how to do this and for other examples.

Three important points to remember:

  1. If you only verified your desktop site in Search Console, you must do so for your mobile version as well.
  2.  If you only have a desktop site, Google will continue to index your desktop site but use the mobile agent to do so. This should be fine.
  3. If you are still in the process of constructing your mobile version, it’s better to keep using the functional desktop site rather than trusting an incomplete mobile version of the site until it’s ready to launch.

To Summarize:

Google’s ranking, indexing and crawling systems used to use desktop versions of a page’s content. Now, because this may cause problems for mobile searchers they’ll be using the mobile version of a page instead. Google will be showing the mobile version of pages in their Search results and Google cached pages. You should also expect to see increased crawl rates from the Smartphone Googlebot.

You don’t have to worry too much because Google will always present the URL that is most appropriate no matter if it’s a mobile or desktop URL. While their index will be built from mobile documents, they say they will continue to build a great search experience for all users, whether they come from mobile or desktop devices.

If you have any questions, feel free to contact us. Or you can always contact Google via their Webmaster Forum.

The Latest Expansions To Microsoft Office 365 Will WOW You!

The wildly popular subscription-based Microsoft Office 365 offers an ever-expanding application gallery. The latest additions to the line-up are sure to excite professional users.

Microsoft Office 365

The professional landscape today appears quite different from photos of workspaces and desktops 30 years ago. For one, shoulder pads are no longer as common! At one point, smoking and the occasional cocktail were quite acceptable in the workplace. Naps, too! But seriously, aside from the differences in the grainy photos – and the interesting hairstyles and wardrobe choices – you’ll notice major differences in staff count, communication style, office environment, and most importantly, technology.

The giant boxes that used to adorn desktops with the black screens and the giant white cursors that resembled a game of Pong. The ornately-framed diplomas and certificates on the walls of each office. Maybe a set of golf clubs in the corner? None of these are commonplace today. Why? First, let’s address the “office”. Gone are the days when a new college graduate receives an offer of employment and is escorted down a hallway to their own office on the first day – not since the explosive use of cubicles (we don’t mean that literally). Wall space in an office is nil because offices tend to be reserved for senior management in more modern set-ups. Pre-fab cubicles are the trend, being more flexible in design and layout, more economical in cost than construction of walls, and still offering the general guise of privacy in a professional workspace.

This type of environment is far from conducive to productivity – for some. Individuals have no control over noise level since there is no door that can be shut to block sound. While the cubicle was intended to also promote a more collaborative setting, the result is often disruptive. With the pressure on to maintain or increase productivity, professionals often resort to wearing headphones in an attempt to customize their environment to their needs – or just work remotely. In fact, a reliable Internet connection is all that is needed for a completely personalized work environment. Crank loud music or have silent surroundings, whichever is more helpful. Dim the lights or open every window, depending on the lighting that works best. It’s never too hot or too cold, and there’s never a wait for the bathroom. Lunches are never stolen out of the breakroom fridge if the fridge isn’t shared by a dozen other people!

Some organizations even maintain an entirely remote – or, distributed – workforce, where all employees work remotely. Staff may be in the same city and meet for the occasional coffee or brainstorming session, or be across the globe and only see each other via video conference. The number of distributed organizations in the United States continues to grow, including organizations like Automattic. The 400-strong staff are spread across more than 40 nations and are able to collaborate effectively, considering the company is valued at over $1 billion. The current count of companies with distributed workforces varies, but it’s estimated that as many as 200 U.S.-based brands are run entirely remotely. That means someone is potentially promoting a brand while wearing pajamas!

The professional landscape has evolved due to the modern technology. Boy, that’s an understatement! Thinking back to that giant boxy desktop computer in that grainy photo and comparing it to the sleek laptop or tablet today is a clear indicator of just how far we’ve come. We won’t lose our Internet connection when someone picks up the telephone, nor do we have to pay by the hour for dial-up service – in fact, high-speed connectivity is the standard in metropolitan areas. With high-speed Internet, remote staff have the connectivity to send or access shared files, send emails or instant messages, or have audio or video conferencing sessions with clients, customers, or colleagues.

The availability of productivity apps is astounding. Basic word processors that were the desktop staple haven’t been replaced, but have evolved from requiring installation from a CD-ROM to not even requiring a downloaded program file anymore! Yes, Microsoft Word, the workplace word processing darling, is accessible online through subscription-based Microsoft Office 365, which has a multitude of integrated apps designed for the flexible workforce. Create documents in Microsoft Word or spreadsheets in Microsoft Excel and save them to SharePoint or OneDrive, send emails through Microsoft Outlook, design innovative and edge presentations with PowerPoint, and the list goes on.

The list of apps that integrate with Office 365 expands every day! Considering Microsoft Office 365 now includes Microsoft Teams and Microsoft Flow, the possibilities are incredible. If you’ve not yet experienced either of these apps, you’re truly missing out.

Microsoft Teams

Microsoft was rumored to be interested in acquiring the techie-favorite collaborative platform Slack in 2016, but instead, release Microsoft Teams in 2017 as an updated and improved alternative to its Skype for Business. Microsoft viewed its Teams release as everything users loved about Slack and a “fix” to those areas where Slack wasn’t sufficient. Was Slack for sale? Probably not. But it didn’t matter – Microsoft decided to invest in a proprietary solution rather than re-do someone else’s established product. The even better news with this decision? Complete compatibility with the full family of Microsoft products is guaranteed, and integration with productivity apps!

Microsoft Flow

Do you love rules in Microsoft Outlook? If a new email comes in, is from a specific sender, includes a group of words in the subject line, or is from a specified domain, then treat the email with a certain process – the same way, every time. Whether this is forwarding to someone else, deleting the email, or moving to a folder to organize messages, the process will remain the same until the user changes the rule. Microsoft Outlook users love rules. Well, Microsoft Outlook users will love Microsoft Flow. Microsoft Flow is basically one big “if, then, then” rule app – but don’t let us oversimplify this for you – it’s so much better! Why? Glad you asked! It’s much better because these rules aren’t restricted to Outlook. Microsoft Flow is one giant automation machine. Rules in Microsoft Outlook are essentially automated processes the user defines, and Microsoft Flow helps users turn repetitive tasks into specific step-by-step workflows – hence the name – and automate these multistep workflows into templated processes to increase productivity and efficiency. Plus, don’t you get tired of doing the same things over and over again? Users can set up a plethora of cool processes – Flows:

  • If an email from your biggest customer comes in, get a push notification on your smartphone
  • Save any attachments that come in through an email in Microsoft Outlook to Microsoft OneDrive or SharePoint.
  • Track items like working hours or social media posts or responses in an Excel spreadsheet

Microsoft Project

If your Microsoft Office 365 subscription is an Enterprise, Government, or Academic account, Microsoft Project is available to use. Microsoft Project is a fantastic project management solution, facilitating in keeping projects, teams, and resources on track and centralized in one organized location. As with other Microsoft Office 365 products, Microsoft Project is easily integrated with Microsoft productivity apps.

There you have it! Microsoft Office 365 just keeps adding to its arsenal of productivity apps for professionals, and we love it. Whether you work remotely or not, Microsoft caters to the needs of busy professionals with modern apps – no shoulder pads required!

7 Surprising Ways To Prepare Your Website For Cyberattacks

Keep hackers from turning you and your business into a victim with these cybersecurity best practices.

Cyber Attack Websites

Cyberattacks come in many forms, and no part of your business seems to be safe from them. You work for months to prepare your website. You go into painstaking detail over each section and prepare for your go-live date. You are so proud to show your corporate baby to the world. Then a few months later, you go to log into your website to find it has been hacked. Not only does this affect your business data and reputation, but also your position in Search engines. How do you keep this hypothetical from becoming your reality?

What type of website you have can determine what kind of attacker targets you – for example, WordPress website customers are targeted by hackers using one of three options: a single bot, a person, or botnets. A single bot is an automated program that is used to search for vulnerabilities; once it finds vulnerabilities, it exploits them. A person will be manually searching for weaknesses. While this seems old-fashioned or slow, it is usually the method of choice for high-value websites. Lastly, Botnets are groups of machines that run numerous programs that collaborate. Similar to how a single bot works, botnets work as a high functioning team to carry out a vast number of attacks simultaneously. With so many different types of attackers, how does one protect themselves and their website?

 Stay Up-to-date With Cyberattack News

The best offense is a good defense. To prepare for, respond to, and recover from an attack, you need to know what you are up against. You can prepare for Cyberattack by keeping up to date on current cyber threats to your company. Over 2 million new malware attacks are launched every day, with recent examples including the Meltdown and Spectre bugs. Both Spectre and Meltdown could allow potential attackers to access to data, but these aren’t your only threats. You need to also prepare for other Cyberattacks such as Ransomware, crypto, and malware attacks. Forbes magazine reports these are the top cybersecurity threats to look out for in 2018.

Update Security On Your Login Page

Similarly to your email password, you should take great care in protecting your website admin access. You should use strong passwords so they can’t be easily guessed or forged. Secondly, you should memorize your website passwords, rather than write them down, as this poses another security risk. Thirdly, remember to change the password frequently – it is recommended that you do so every two months.

 Update Software

Updates always seem to come when we are at our busiest.  Whenever there’s an opportunity to update, it’s essential to do so. Updating is like having a secret security group continually working to keep your business safe. Updates provide protective patches that safeguard your data from the latest cyber attacks, such as Meltdown or Spectre. Plus, they keep your computers and systems running optimally.

Security Plugins

Security plugins offer your website features that range from protection against malware attacks to an added firewall and database security. Each plugin comes with own cost and features – for example, one of the highest-ranking WordPress plugins is WordFence. This plugin continually scans your folders and files on your website for signs of malware infection. Once it finds an infection, it can rapidly notify you as it blocks the malware. Another WordPress plugin that packs a lot of features into a small package is Sucuri Security. Through this plugin, you can have security activity auditing, file integrity monitoring, malware scanning, blacklist monitoring, as well as a website firewall.

 HTTPS Instead Of HTTP

How much difference can one letter make? Between an HTTPS and HTTP, surprisingly it makes a massive difference for security. Hyper Text Transfer Protocol Secure is the version of HTTP which transfers data from your browser and your website. The difference is that one letter “S” – secure. This means that any and all communication between your browser and your site is protected with encryption.

 Secure Webhosting

Another way to strengthen the security of your website is by using a secure web hosting company. There are lots of big and small names to choose from when deciding on a web hosting provider. This is where it is essential to use your list of non-negotiable features that you want from your host to narrow down your choices. For example, you could look for a host that offers a Virtual Private Server, which conceals the identity of your service and improves privacy. Another important feature to look for when deciding is how many users it can support.

 Lock Files/Folders

One of the simplest ways to improve the security of your website is by locking or hiding files. You can place passwords on files or folder, that way they cannot be opened without your key. Additionally, you can also encrypt them so that they are unreadable without your password. You can do this by using a password-protection system or using file permissions that are already in place. Check to see what features your web host offers.

With all the ways that a hacker can gain access to your business’s data, it is crucial to stay one step ahead. Remember the importance of securing your website as well. Something as simple as a secure password for your admin page or locking specific files can make a huge difference for you and your business.

 

Hey You – STOP Giving Your Time Away For Free!

Technology has made it possible for you to get more done in less time. Are efficiency and productivity always a good thing?

Freelancer

Technology and telecommute: Two fabulous words that start with the same letter, and one is very much dependent on the other. The “tele” in “telecommute” certainly isn’t short for “telepathy” – though imagine how telepathy would impact professional relationships! On second thought, don’t.

The professional world changes and evolves, of that, there is no question. No longer is physical presence a requirement for staff, as more organizations migrate to a distributed workforce. What has become clear in the last decade is the location is no longer as important as the output. The focus on productivity is essentially a focus on the individual and catering to the needs of the one for the benefit of the whole. This individual-centric mentality seems counterproductive, but it’s quite the opposite. It would be impossible to cater one office building or workplace to the needs of many individuals for whom environmental factors differ. One requires silence for concentration, while another works better with loud music playing. Does one wear headphones? This is one option, but if this method stifles even one professional, the sacrifice may not justify the means.

One practice that more Americans are embracing is freelancing: individuals contract themselves with a person or organization to offer their time, skills and expertise in exchange for money. The person remains an independent contractor, and the organization is released from any legal obligations, like payroll taxes or insurance benefits. This is a cost-effective way for a business to meet their needs without taking on the full responsibility of onboarding.

There are estimates that more than a third of Americans participate in independent contract agreements. In fact, according to the Internal Revenue Service, over 10 million Americans rely on freelancing for more than half of their total income stream. That translates into more than 10 million Americans essentially being their own brand, running their own organization, and being a one-person operation while managing all sales, marketing, and accounting tasks. By the way, “accounting” also means handling their own payroll and other practices a business would otherwise task a Human Resources department to oversee. These freelancers operate like sole proprietors and CEOs of a business and take on great responsibilities to manage their time efficiently.

In juggling these processes, are freelancers losing time due to inefficiency? Lost time directly results in lost earnings. The best thing a freelancer can do to protect their time is finding the right combination of technology to help maximize productivity and minimize downtime. The great news is, with the incredible technological advancements in recent years, there is a huge variety of productivity apps available for this exact purpose.

Running your own business can be time-consuming, and you don’t have time to waste! Here are apps to help.

Apps to Get Paid

You have a multitude of options for processing payments now. From to to to, small business owners have a variety of apps catering to simplified payment processes, whether the purpose is sending or accepting a payment.

  • Due is a free problem solver when it comes to the need to process payments online. With a simple user interface, Due boasts encryption for secure data and transactions.
  • You’ve seen Square, the little white square box that plugs into a tablet or smartphone and uses a data connection to process a transaction. Square is limited to the transaction process, but they also offer Square Register for a point-of-sale system.
  • Start a Wave! Wave is like an all-in-one solution for tracking sales and expenses, processing payments, keeping track of payroll and customer invoices, you name it. The app is free to download, but like with any other transaction-based solution, there are fees for credit card processing.
  • FreshBooks has a name much like its well-known competitor but approaches payment processing with a “Fresh” outlook. Freshbooks acts much like a basic accounting platform with built-in functionality for transactions, but the invoicing and customizable reporting are a nice feature, too.

Apps to Get Organized

If only one app could do it all for you: email, scheduling meetings, maintaining files, the list goes on. Actually, the way you need to look at an app isn’t if the app can do it all for you, but if it can do it well! Sometimes, all you need is a little integration – and more apps are recognizing this need.

  • Basecamp has long been an industry darling for businesses: Collaborating, setting up projects, connecting team members, and offering a centralized location to chat about the projects but also a one-on-one privatized chat option for less public matters. Email communication and built-in customizable notifications are a great feature, too!
  • Slack is a far more economical option than Basecamp, but keep in mind that you get what you pay for. High on communication and organization, Slack is what most newer platforms were designed after. Slack is idolized by techies and creatives alike, but for freelancers and small business owners that have another focus, Slack may not be the best solution.
  • Asana is right there with Slack, offering the lower entry price point for a collaborative option, and even integrates with Slack if there is ever the need for both.

Apps for Communication

We already mentioned Basecamp and Slack, which offer exemplary communication tools in a collaborative workspace, but there are other apps to increase productivity with a focus on communication for freelancers and small business owners.

  • For small teams or large groups, Fuze offers real-time communications with voice, messaging, and perhaps its strongest offering, high-definition video conferencing.
  • The famous G Suite: The go-to suite of apps for productivity for professionals everywhere. From email to document storage, from calendars to shared documents, and integrated with Hangouts, the video conferencing solution, Google’s G Suite has earned its reputation. With the lowest entry price point around, seamless integration with Microsoft’s Office 365, and the simple user interface everyone has already been using for years now, what else is there to say?

Apps for Automation

Find ways to automate processes and require less of your hands-on attention.

  • If you use Gmail or Outlook for email and scheduling meetings, to is a fantastic free solution for arranging meetings in a single email. No more back-and-forth emails on what times work on which days – install the extension and grant access to your calendar!
  • Microsoft Flow is an amazing automation tool that lets a user automate processes using connectors for integrated apps. Establish your parameters, and voila!
  • Zapier is a simplified Microsoft Flow and has a cult following that sings its praises. Zapier follows much of the same practices as Microsoft Flow, so check both out and see which works better for your needs.

Who doesn’t love a little extra help? There’s always room for more when you’re running the show on your own. While the ideal answer is to clone yourself, the reality is there’s only one you. Try a few of the apps here to give yourself a hand. Spend less time on the workflow and more time on the work you’re getting paid for – in billable hours!

Let’s Play “Tech Truth Or Dare”!

Your cybersecurity practices shouldn’t be treated like a game of chance unless you are 300% certain you’re going to win. What can you do to make sure your business isn’t the ultimate loser?

Cyber Security

Is technology today the endless cycle of cat-and-mouse, with the bad guys always one step ahead? A quick search for “cybersecurity best practices” will yield millions of results, all with their ideas of what you can do – but does any of it make sense? Someone busy running a company faces a complex dichotomy: Being too busy running their company to worry about something that won’t directly generate revenue, but not giving enough time and attention to something that could directly impact revenue. Those are two very distinct and different thoughts, but still closely related.

Not only is cybersecurity a critical focus of business today, but it’s also the easiest way to fail. Cybercriminals – hackers – are usually one step ahead of us good guys, but that’s the “cat and mouse” game to them. We respond to cybersecurity breaches that make the news with preventive measures to avoid the same fate and do our best to have enough safeguards in place to protect every element we can.

Hackers seek a cybersecurity vulnerability to exploit to their advantage. Their reasons don’t matter – it’s the result that affects their victims. Why do we still have vulnerabilities when we know better?

Myth: Half of small businesses think they’re “too small” for a hacker to target.

Truth: Small businesses make easier targets for many reasons. They often don’t have the tech budgets that the Fortune 500 companies do in order to take every precautionary measure to avoid being hacked.

Smartphones are major targets of hackers now, given more than half of all web traffic is reported to take place via mobile devices. Smartphones don’t have the same level of protection, making them easy targets, and therefore easy points of entry to a cybersecurity vulnerability. Imagine pressing a thumbtack into a hairline fracture on a porcelain plate – this one weak spot has the potential for this singular action to shatter the plate into thousands of pieces. Now, imagine this plate is your proprietary data, and this thumbtack is a hacker. Can you see the potential damage?

Myth: Employees of small businesses know more about the company and are more invested in its success, therefore take the time to safeguard their actions.

Truth: The dedication of staff to their employer has nothing to do with cybersecurity.

Modern cybercriminals are targeting critical data: consumer information, accounts with intellectual property, financial information about both the company and consumers. Three out of every four small businesses have no formal cybersecurity policies or protocols in place for staff, nor training to discuss the latest threats and how to thwart them. Hackers know this – oh, yes, they know – and they also know the small business is less protected than those Fortune 500 companies. This is a lethal combination.

  • Nearly two-thirds of small businesses have yet to address security regarding mobile devices or enact formal policies for mobile device use as it pertains to professional operations.

Myth: Small businesses can bounce back faster after a breach.

Truth: Half of all small businesses don’t have a disaster preparedness plan in place for recovery should they be impacted by a cybersecurity threat, a “data breach”.

It’s reported that less than half of all small businesses back up their data weekly. Let that sink in. The data loss in the event of a hack could have catastrophic results for as many as half of all small businesses. In the event of a breach, companies of any size consider the data loss and downtime to have the greatest impact, followed by the revenue loss – but most of the time, the impact to a company’s reputation isn’t considered until already in clean-up mode.

If you’re ready to win at “Tech Truth or Dare”, here are the new rules of the game:

Do you know what needs to be protected?

What data do you store? How is your data stored? What protective measures and security protocols are in place? Where are the “holes”? This last question is the most important, and it’s a smart decision to hire an expert to help you with this one.

What formal policies need to be updated – or put in place?

Every business needs an official cybersecurity policy. This policy should also be updated annually, at the minimum. Formalizing a policy can make sure everyone that has access to your data follows the same procedures and the strongest safeguards are in place.

This should include:

  • Password protocols
    • Passwords should be unique, complex, and changed regularly
  • System updates
    • Check for the latest updates to all applications and security releases
  • Privacy settings
    • Verify that users have the most secure privacy settings on their desktop and laptop computers, and smartphones and mobile devices

What is your plan for how to handle a disaster?

Perhaps an extension of the previous question, but no less important is how to handle a hack or breach should one occur. You’ve taken all the necessary steps and precautions, but you still had a disaster – now what? Best practices include daily back-up of your critical resources – which you’ll need to identify – and then test the process to ensure it’s sufficient, just in case.

Talk to experts.

You are an authority in what you do, and your sales pitch to your customers focuses on your expertise. Why wouldn’t you hire experts to protect your business?

Is your training sufficient?

Make sure your staff is aware of the steps needed for Internet safety, email security, network threats, and how to detect and protect in the event of each. Equally important is what need to be done if something happens and they suspect a threat.

Prevent your business from becoming a victim of a hacker this year and win the game!

Make 2018 the year you have an ironclad cybersecurity program, for your home and your office!

You Too Can Use Excel Like A Pro – Here’s Part 2 of Our Series to Show You How

With the 2016 version of Excel, Microsoft has really upped its game for people who aren’t great with numbers. You can now easily use one-click access that can be customized to provide the functionality you need.

This is the second of our three-part series about using Microsoft Excel 2016 to help you identify trends, construct helpful charts, and organize information to maximize the value of your data.

 

Did you know that you can use Excel Worksheets and Workbooks in conjunction with programs like Microsoft Access and PowerPoint? Excel 2016 possesses many capabilities that aren’t readily apparent. That’s why we’re providing this three-part series for you.

If you missed Part 1 of our series, you can find it on YouTube at: https://www.youtube.com/watch?v=zA8X9wqrn1I

In this, Part 2 of our series we’ll be discussing:

  • Working with Multiple Worksheets and Workbooks
  • Managing Lists
  • Working with Dates
  • Formatting and Conditional Formulas
  • The IF, AND and OR Functions

Why would you want to use Excel?

If you or your employees work with financial data, it’s a great tool to use for:

  • Basic mathematical operations like adding, dividing, and multiplying.
  • Finding values like profits or losses.
  • Calculations like averages, percentages and number counts.

Performing calculations in Excel is only the tip of the iceberg. There’s much more you can do like creating charts and graphical layouts to make it easier to recognize trends and more easily analyze data.

What is Excel and how is it organized?

Excel is an electronic spreadsheet program that’s used to store, organize and manipulate data. You enter data into Workbooks that are made up of individual Worksheets. In the Worksheets, you enter data into cells that are organized into rows and columns. Excel data can consist of text, numbers, dates, times and formulas.

Working with Multiple Worksheets and Workbooks

Before you build your worksheets and workbooks think through the process and ask yourself:

“How do you want to see and analyze the results?”

“How much detail is needed to draw a conclusion?”

“What is the most important data for decision makers?”

To access or create a Worksheet, go to the tabs at the bottom left of the screen and click the one you want to activate. Or use Control Page Up or Control Page Down to move among your Worksheets using the keyboard.

You can move or copy a worksheet by going to the tab, right-clicking, and you’ll be presented with a dialog box where you can select your function. You can move your worksheet to a different Workbook by entering its name in the space above.

Use the scrollbars on the right to make other selections like making a copy. Simply click the checkbox for the action you wish to take.

Working with Formulas Across Worksheets

You can calculate different formulas across a worksheet with what Microsoft Excel calls 3D formulas. 3D formulas allow you to calculate data throughout a workbook using multiple worksheets. It refers to the same cell (or range of cells) on multiple worksheets.

Think of a 3D formula as a cross-reference to data in a different Worksheet.

It’s a great way to build summaries and Master Worksheets to bring them together in one place. And it’s a must if your labels and data types vary between worksheets.

Here we want to bring in the formula from another worksheet to this one. We have three worksheets for our inventory costs. We have a breakdown for our Fruits Dept. But we want to bring in the costs for our Bakery and Meats. So, we go to the cell we’ve created, select =sum, hit the left parenthesis ( then navigate to the Bakery Worksheet tab at the bottom, click on the cell where we want the formula to appear and hit Enter. Then the inventory cost automatically appears.

All 3D formulas are based on this syntax: Sheet1:Sheet4!A2:B5.
If you copy or insert a new worksheet after Sheet1 the reference will automatically include it.

Similarly, if you delete a worksheet it will be excluded.

Consolidate Data

You can consolidate data from separate worksheets into one Master Worksheet. They can be in the same workbook or from other Workbooks. Let’s say you have a sales team and a worksheet with their weekly report data, and you want to consolidate this data into a monthly report. There are two ways to consolidate this data:

1. Consolidate by Position: This is when the data in the source areas is arranged in the same order and uses the same labels. You use this method to consolidate data from a series of worksheets that have been created from the same template.

2. Consolidate by Category: Use this method when the data in the source areas is not in the same order but uses the same labels. Here you consolidate data from a series of worksheets that have different layouts but have the same data labels.

We are only going to demonstrate Consolidate by Position because it’s an organizational best practice.

Here’s our example Workbook. Data is in the same order and uses the same labels.

Creating a clean master worksheet for this is best. But if you use a worksheet with pre-existing data make sure you have a blank area where the consolidated data can appear.

To start, click in the upper left-hand corner and click Consolidate. A window will open. By default, SUM will be your option, although there are others to choose from. Average is the next most common function people use.

Now we want to choose our ranges from each of the worksheets. We’ll collapse the Consolidate box and click on Week 1. Select the entire range.

Bring back the dialog box and add this week to the references.

Now, when you click on week 2 to do the same, it’s already pre-selected. Just click Add. And do the same for the next two weeks. Now you’ve told Excel what data you want to consolidate.

Creating Links

You must choose between automated and manual updates. If you want Excel to consolidate your worksheets automatically when you change data, you must tell it to do so by checking this box: “Create links to source data.”

Press OK and Excel will generate the consolidation. It’s up to you to format it the way you want. But you’ll only have to do this once if you used “create links.” If so, Excel automatically updates any changes.

Notes:

You can’t create links if the source and the data are on the same worksheets. This means it’s smart to group data into worksheets in smaller periods. In this case, we did it by weeks.

If the information you want to consolidate is in a different Workbook, you want to browse for that Workbook before you begin the consolidation process. Then you can select the reference in the same way we did above. Excel will create the path for you.

Linking Workbooks

Up to this point, we’ve been working in one Workbook with several worksheets. Just like we pulled data in from multiple worksheets, we can do the same with multiple Workbooks.

Remember our 3D formula? When this same type of linking crosses over to a different Workbook it’s called an “External Reference.” Sticking to our Sales worksheet example, you may have a Workbook for each month or each year.

We now want to compare how our Sales Team did month to month instead of week to week. We are going to add a link to last month’s total. Just like before: select =sum, hit the left parenthesis ( and navigate to the Workbook you want. (Here’s it’s the Monthly Sales Workbook.)

You’ll see that single quote marks have been added to the syntax. This is because there is a non alpha-numeric character in the name (space). You’ll need these when links are broken as well.

Here’s how to do it in the opposite way. Start in your first file, go to copy or Control C.

Go back up to Conditional Formatting and grab your Workbook and do a “Paste Special.”

And down at the bottom left click “Paste Link.”

And here it is.

Managing Lists

Excel lists don’t typically use formulas. They use filtering and sorting instead. So, it’s important that lists have column headings and that there are no empty rows in your lists.

First, we’ll do a simple sort: From the list below, we’re going to organize who had the most wins.

  • We click the column header for Wins.
  • Go up to Sort & Filter in the top right and sort from highest to lowest.

Next, we’ll sort by multiple columns:

Select your columns.

Go to Sort & Filter > Custom Sort

And we’re going to sort by Earned Run Average (ERA).

You can see below that it worked. (ERA sorts smallest to largest because a smaller number is better.)

Auto Filtering

This is how you can include or exclude any row data.

Select any column or header and under Sort & Filter choose Filter.

To the right of any column header there’s a drop-down menu.

We’re going to see who was selected for the HOF (Hall of Fame.)

Click the drop-down and deselect everything.

Then choose Y (for yes).

Click OK and now you’ll see just the players who were selected for the Hall of Fame.

The Filter Icon is an easy way to see that a column is filtered.

Now we’ll customize the filter by Strike Outs.

Click the drop-down next to Strike Outs.

Choose Largest to Smallest.

And now the list is ordered by Strike Outs.

We want to see how many Wins they had. Go to the Wins and click the drop-down menu. Under Number Filters.

Choose Less Than and enter 20 > OK

Now we see the pitchers who won less than 20 games.

Sum Up Totals

Click in the cell where you want the Sum to appear and choose AutoSum>Enter.

And if you decide to take off all the filters, the Sum will recalculate automatically.

Working with Dates

Dates and times are the most common functions people work within Excel, but they can be frustrating because Excel uses a serial number to represent a date instead of the typical 01/02/18 format and hours, minutes and seconds that we’re used to. It’s further complicated because dates are days of the week.

For example, In this system, the serial number 1 represents 1/1/1900 12:00:00 a.m. Times are stored as decimal numbers between .0 and .99999, where .0 is 00:00:00 and .99999 is 23:59:59. The date integers and time decimal fractions can be combined to create numbers that have a decimal and an integer portion. For example, the number 32331.06 represents the date and time 7/7/1988 1:26:24 a.m.

The Date Function will help. It’s on the Formula part of the Ribbon under Date & Time.

The TODAY() Function and the NOW() Function

The TODAY function returns the serial number of today’s date based on your system clock and does not include the time. The NOW function returns the serial number of today’s date and includes the time.

Here we are using the Today function. Excel will always use the exact date. The Today function is useful for calculating intervals. You might use this function to calculate someone’s age.

For example, we entered =YEAR(TODAY())-1965

And the age Excel came up with is 53.

TODAY always had the () following it.

The NOW () function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and want that value updated each time you open the worksheet.

Formatting Dates

This is found on the Home Ribbon.

Under DATE you can see many ways you can display your information.

Formatting and Conditional Formulas

Conditional formatting highlights important information in a spreadsheet. But sometimes the built-in formatting rules aren’t enough. Adding your own formula to a conditional formatting rule helps you do things the built-in rules can’t do.

Here we want any ERA lower than 2 to be highlighted in red.

Highlight the column and click on Conditional Formatting.

We selected Cells Less Than 2.00

The IF, AND, and OR Functions

IF

The IF function helps you make logical comparisons between a value and what you expect. For example: IF(Something is True, then do something, otherwise do something else)In this sense an IF statement can have two results. The first result is if your comparison is True, the second is if your comparison is False.

Below we’re going to determine our WINNER based on a calculation of IF:

Based on our IF formula, Chester is our WINNER!

OR

Use the OR function, to determine if any conditions are TRUE.

Here we use a formula that tells us if someone is SAFE or FIRED.

That’s it until next time! To View this Demo on YouTube visit:

https://www.youtube.com/watch?v=ONeVQplb_bM&feature=youtu.be

To View Part One of this Series, visit: https://www.youtube.com/watch?v=zA8X9wqrn1I