The app also includes tips from other passengers on where to eat or access Wi-Fi, and a quick links section for booking a cab or express train from the airport. This app lets you travel bag-free. Once you sign up, you'll pack your luggage once and ship the items to their warehouse.
For future trips, you can simply select what you'd like to pack from your virtual closet, which is basically an inventory of these items, and the company will clean, pack, and ship your bag to your final destination for you. I travel a ton-as much as 10,000 miles a month for work-which means I've made a whole slew of tech-related travel mistakes over the years. The good news is, now you don't have to. Here are my top ten tech-related travel gaffes all in one place, so that you can learn from my mistakes and have the best trip ever (whether for business or pleasure).
Excel More Less Note: To learn how you can get started creating a basic Excel workbook quickly, see Basic tasks in Excel. Top features to explore Get started quickly Templates do most of the set-up and design work for you, so you can focus on your data. Instant data analysis The new Quick Analysis tool lets you convert your data into a chart or table in two steps or less.
Preview your data with conditional formatting, sparklines, or charts, and make your choice stick in just one click. To use this new feature, see Analyze your data instantly. Fill out an entire column of data in a flash Flash Fill is like a data assistant that finishes your work for you. As soon as it detects what you want to do, Flash Fill enters the rest of your data in one fell swoop, following the pattern it recognizes in your data. To see when this feature comes in handy, see Split a column of data based on what you type.
Create the right chart for your data With Chart recommendations, Excel recommends the most suitable charts for your data. Get a quick peek to see how your data looks in the different charts, and then simply pick the one that shows the insights you want to present. Give this feature a try when you create a chart from start to finish. Filter table data by using slicers First introduced in Excel as an interactive way to filter PivotTable data, slicers can now also filter data in Excel tables, query tables, and other data tables.
One workbook, one window In Excel each workbook has in its own window, making it easier to work on two workbooks at once. Look for details in New functions in Excel Embed worksheet data in a web page To share part of your worksheet on the web, you can simply embed it on your web page. Other people can then work with the data in Excel for the web or open the embedded data in Excel.
This file format lets you read and write ISO dates to resolve a leap year issue for the year To learn more about it, see Save a workbook in another file format. New charting features Changes to the ribbon for charts The new Recommended Charts button on the Insert tab lets you pick from a variety of charts that are right for your data. Related types of charts like scatter and bubble charts are under one umbrella. With just a Design and Format tab, it should be easier to find what you need.
Fine tune charts quickly Three new chart buttons let you quickly pick and preview changes to chart elements like titles or labels , the look and style of your chart, or to the data that is shown. To learn more about it, see Format elements of a chart.
Richer data labels Now you can include rich and refreshable text from data points or any other text in your data labels, enhance them with formatting and additional freeform text, and display them in just about any shape. Data labels stay in place, even when you switch to a different type of chart.
You can also connect them to their data points with leader lines on all charts, not just pie charts. To work with rich data labels, see Change the format of data labels in a chart. View animation in charts See a chart come alive when you make changes to its source data.
Powerful data analysis Create a PivotTable that suits your data Picking the right fields to summarize your data in a PivotTable report can be a daunting task. Now you can get some help with that. To learn more about it, see Create a PivotTable to analyze worksheet data. Use one Field List to create different types of PivotTables Create the layout of a PivotTable that uses one table or multiple tables by using one and the same Field List.
Revamped to accommodate both single and multi-table PivotTables, the Field List makes it easier to find the fields you want in your PivotTable layout, switch to the new Excel Data Model by adding more tables, and explore and navigate to all of the tables.
Use multiple tables in your data analysis The new Excel Data Model lets you to tap into powerful analysis features that were previously only available by installing the Power Pivot add-in.
In addition to creating traditional PivotTables, you can now create PivotTables based on multiple tables in Excel. To learn more about it, see Create a Data Model in Excel. Use Power Query to easily discover and connect to data from public and corporate data sources.
This includes new data search capabilities, as well as capabilities to easily transform and merge data from multiple data sources so that you can continue to analyze it in Excel.
To learn more about it, see Discover and combine with Power Query for Excel. Power Map is a three-dimensional 3-D data visualization tool that lets you look at information in new ways by using geographic and time-based data. You can discover insights that you might not see in traditional two-dimensional 2-D tables and charts.
Power Map is built into Office ProPlus, but you'll need to download a preview version to use it with Office or Excel See Power Map for Excel for details about the preview.
Connect to new data sources To use multiple tables in the Excel Data Model, you can now connect to and import data from additional data sources into Excel as tables or PivotTables.
By using MDX queries, you can further leverage table relationships to create meaningful PivotTable reports. To learn more about it, see Create a relationship between two tables. Use a timeline to show data for different time periods A timeline makes it simpler to compare your PivotTable or PivotChart data over different time periods. Instead of grouping by dates, you can now simply filter dates interactively or move through data in sequential time periods, like rolling month-to-month performance, in just one click.
To learn more about it, see Create a PivotTable timeline to filter dates. Use Drill Down, Drill Up, and Cross Drill to get to different levels of detail Drilling down to different levels of detail in a complex set of data is not an easy task. Custom sets are helpful, but finding them among a large number of fields in the Field List takes time. To learn more about it, see Drill into PivotTable data.
No need to reach for the Excel Object Model—now you can create and manage calculated members and measures right in Excel. A standalone or de-coupled PivotChart lets you experience new ways to navigate to data details by using the new Drill Down, and Drill Up features.
To learn more about it, see Create a PivotChart. Simply click the Power View button on the ribbon to discover insights about your data with highly interactive, powerful data exploration, visualization, and presentation features that are easy to apply.
Power View lets you create and interact with charts, slicers, and other data visualizations in a single sheet. The Power Pivot data analysis engine is now built into Excel so that you can build simple data models directly in Excel.
The Power Pivot add-in provides an environment for creating more sophisticated models. Use it to filter out data when importing it, define your own hierarchies, calculation fields, and key performance indicators KPIs , and use the Data Analysis Expressions DAX language to create advanced formulas.
It helps you analyze and review your workbooks to understand their design, function, and data dependencies, and to uncover a variety of problems including formula errors or inconsistencies, hidden information, broken links and others. From Inquire, you can start a new Microsoft Office tool, called Spreadsheet Compare, to compare two versions of a workbook, clearly indicating where changes have occurred.
During an audit, you have full visibility of the changes in your workbooks. Expand your Office skills.