Archives October 2013

Popular Tools in Excel 2013

Excel 2013 has easy access tools that generate professional-looking results quickly.  There are several new features with the new version that should not be overlooked.

Flash Fill

Flash Fill identifies and adapts to basic formatting to automatically input your data.  This tool performs several tasks such as merging information from multiple columns, adding formatting to current column and fixing anomalies with data.  Flash Fill will recognize and apply the selected format to your data but if data differs from row to row, it will not format correctly.

EFF1

Recommended Charts

rcRecommended Charts identifies data guides the user to choose the best chart type for their data.  The main objective of using a chart is to highlight your work in a significant way.

      1. Open the Excel Spreadsheet needed to create a chart.
      2. Select the Insert Tab.
      3. Select the Recommended Charts button to see suggested charts.

Recommended PivotTables

rptRecommended PivotTables are interactive tables that can analyze data, compare data and detect patterns/relationships.  In previous versions, PivotTables were too complex.

      1. Open the Excel Spreadsheet needed to create a table.
      2. Select the Insert Tab.
      3. Select the Recommended Charts PivotTables to see suggested tables. 

Quick Analysis

Quick Analysis is an additional way to generate a chart for data. To generate a chart to highlight your work in a significant way, select the data and click the Quick Analysis Icon.

Untitled

Timelines

Timelines let you filter through PivotTables, similar to a slicer.  The timeline will be embedded alongside the Pivot Table.

  1. Select the PivotTable.
  2. Click the contextual Analyze Tab.
  3. Select Insert Timeline (in the Filter Group).
  4. Then select OK.
  5. In the upper-right corner you can select years, quarters, months or days.

Excel_New_Ftrs.FigE

Cloud Support

Cloud Support by Microsoft allows users to save Excel files to SkyDrive or SharePoint site.  Saving to SkyDrive or a SharePoint site allows users to review and edit files from any device with an Office 365 subscription.

Apps for Excel

appsMicrosoft offers Apps for Excel to enhance what you can do with Excel.  Categories for Apps include Content Management, Financial Management, Productivity, Workflow and Process Management and many more. 

Present Online

Present Online is a way to share workbooks and allows others to update it.  Present Online requires the installation of Lync (if you have Office Professional Plus; Lync is already installed).

  1. Sign into Lync.
  2. Open all workbooks you need to share. (Close workbooks you do not want to share).
  3. In Excel, click the File Tab.
  4. In the left pane, choose Share.
  5. Click Present Online.
  6. Click Present.
  7. Select a Lync meeting or create a new one.
  8. Click OK.

 

National Cyber Security Awareness Month Tips

360px-US_Department_of_Homeland_Security_Seal.svg

October is National Cyber Security Awareness Month by Department of Homeland Security.

National Cyber Security Awareness Month encourages vigilance and protection by sharing tips and best practices in regard to how to stay safe.

Small businesses are a large target for criminals because they have limited resources dedicated to information system security.  Cyber criminals look for access to sensitive data.

Create a cyber security plan

The Federal Communications Commission offers a Cyber Planner for small businesses.  The planner guide allows specific sections to be added to your guide, including Privacy and Data Security, Scams/Fraud, Network Security, Website Security, Email, Mobile Devices, Employees, Facility Security, Operational Security, Payment Cards, Incident Response/Reporting and Policy Development/Management.

Generate a personalized Small Biz Cyber Planner Guide.

Establish Rules and Educate Employees

Create rules and guidelines for protecting information.  Educate employees on how to post online in a way that does not share intellectual property.  Clearly explain the penalties for violating security policies.

Network Protection

Deploy and update protection software, such a antivirus and antispyware software, on each computer within your network.  Create a regularly scheduled full computer scan.

Manage and assess risk

Cyber criminals often use small businesses that are less-protected to get to larger businesses.  Being a victim of a cyber-attack can have a huge impact on any business including financial issues, loss of possible business partner(s) and many more issues.

Download and install software updates

Installing software updates from vendors can protect your network for unwanted viruses and malware.  Vendors frequently release patches/updates for their software to improve performance and fine-tune software security.  (Example:  Adobe Reader, Adobe Flash and Java updates are critical for protection.)

Backup important business data and information

Create a backup plan for all data including documents, databases, files, HR records and accounting files.  A regularly scheduled backup can be a full, differential or incremental.

  • Full Backup:  Backup of all data.
  • Differential Backup:  Backup of all data that has changed since the last full backup.
  • Incremental Backup:  Backup of all data that has changed since the last full or incremental backup.

Control physical access

Protecting physical property is a very important role in protecting intellectual data.  Create a physical security plan to prevent unauthorized access to business computers and components. 

Secure Wi-Fi

Securing your Wi-Fi network consists of a few configurations.  Configure a device administrator password for your wireless access point (WAP) or router, require a password for Wi-Fi access and do not allow the WAP or router to broadcast the Service Set Identifier (SSID), also known, as network name.

 

Tips to Troubleshoot Outlook

microsoft-outlook

Microsoft Outlook can connectivity issue with Microsoft Exchange.  Troubleshooting and fixing these issues can range from a simple reboot to creating a new mail profile.

Restart Outlook and/or Computer

Many connectivity problems with Outlook can be resolved by simply restarting Outlook and/or the Computer.

  1. Restart Outlook.
  2. After restarting Outlook, verify connectivity.
  3. If there are still connectivity problems, restart Computer.
  4. Once computer is up and running, verify connectivity in Outlook.

Outlook3

Offline Mode

 Outlook 2010 and newer:

  1. Click the Send/Receive tab.
  2. Locate the Work Offline button.
  3. Click the Offline button. 

Outlook 2007 and older:

  1. Click File Menu.
  2. Uncheck the Offline box.

At the bottom of your Outlook Window there will be a “Trying to Connect” prompt.  If  Outlook is “Connected” the problem is solved.

Rebuild PST or OST File

OST File

  1. Close Outlook.
  2. Open the Control Panel.
  3. Select Mail icon.
  4. In the next window, click Data Files.
  5. Locate your data file, select and click Open File Location.
  6. Locate the data file using Windows Explorer.
  7. Rename the file extension from .OST to .OLD
  8. Close these windows and open Outlook

PST File

  1. Search for scanpst.exe using Windows Explorer.
  2. Double click scanpst.exe to run the application.
  3. In the next window, click Browse.
  4. Locate your .pst file.
  5. Click Start.
  6. Scanpst will scan the data file eight times.  
  7. If the scan finds errors, there will be a prompt to repair. For backup purposes, check the Make Backup Of Scanned File Before Repairing box.
  8. Click Repair.
  9. Close these windows and open Outlook

outlook2

Repair Software Install

  1. Open Control Panel.
  2. Click Programs and Features.
  3. Scroll down and highlight the Microsoft Office installation.
  4. Click Change.
  5. Select Repair.
  6. Click Continue.
  7. Allow the repair to complete.
  8. Reboot your computer. 

outlook

Recreate Mail Profile

  1. Open Control Panel.
  2. Click Mail.
  3. Select Show Profiles.
  4. Click Add.
  5. Name the new profile.
  6. Follow the steps for the Outlook Account Setup Wizard.
  7. Verify the new profile and set as the default or delete old profile. 

 

Second Generation Surface Tablets

mss2_1

Microsoft has offically announced that the release date for the second generation surface tablets, Surface 2 and Surface Pro 2, will be October 22, 2013.  Pre-order for Surface 2 and Surface Pro 2 is available.

Both new Surface tablets will have a dual-angle kickstand and multiple connectivity options such as Bluetooth 4.0, Wi-Fi 802.11, USB 3.0, micro-SD expansion and HD video-out port.

The new Type and Touch Covers will be released with both tablets.  Both Covers include backlighting and additional sensors.  Also, Microsoft has designed a Power cover that is designed to add additional battery life to both Tablets.

mss21

The Surface 2 has a 10.6 Clear Type Full HD (1920×1080) Display and will run Windows RT 8.1 Operating System on an nVidia Tegra 4 Processor. The Surface Pro 2 has two storage options including, 32 GB and 64 GB.  Surface 2 is priced at $449.

sur2

Pre-order a Surface 2 Tablet.

mss22

The Surface Pro 2 has a 10.6 Clear Type Full HD (1920×1080) Display and will run Windows 8.1 Pro Operating System on an Intel Core i5 Processor. The Surface Pro 2 has multiple storage options including 64 GB, 128 GB, 256 GB and 512 GB.  Surface Pro 2 is priced at $899.  

surp2

Pre-order a Surface Pro 2 Tablet.