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.

Recommended Charts

Recommended 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

Recommended 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.

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.

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

Microsoft 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.

On Monday, June 10, 2013 Apple exposed iOS 7 at the Worldwide Developers Conference.  The new OS will be available for multiple devices including  iPhone 4 and up, iPad 2 and up and the iPad Mini.

New features for iOS 7 include:

Control Center:  By swiping from the bottom to the top will now allow you to adjust your settings

AirDrop:  For Apps that allow sharing, AirDrop will encrypt data that a user shares to friends within a close distance.

Activation Lock:  To prevent smartphone crimes, when disabling “Find My iPhone” the phone will be locked and only the correct Apple credentials will unlock the phone.

Multitasking:  Apps can develop patterns based on usage.  These patterns will allow the iOS 7 to update apps in the background based on network connections.

Car integrated iOS:  For 2014, many car manufacturers are integrating iOS with the car display.

Safari:  Safari has been updated with navigation, smart search and iCloud Keychain.

Siri:  Siri can now operate more of the iPhone including voicemail, Wikipedia, Twitter, Bing and many others.

Camera:  Photos are well-organized as Moments.  Also, the camera has new photo filter options.

App Store:  The App Store can organize Apps based on age and geographical location.  Also, background updating will eliminate manual updating. 

Music:  Music, Movies and TV Shows are now stored together in your Library.  

iTunes Radio:  A streaming music service that will be available with iOS 7.