Whats new in Excel 2. Windows. This initial release provides the first availability of the Office 2. Version 1. 50. 9 Build 4. Six new chart types. Visualizations are critical to effective data analysis as well as compelling storytelling. In Excel 2. 01. 6, weve added six new chartswith the same rich formatting options that you are familiar withto help you create some of the most commonly used data visualizations of financial or hierarchal information or for revealing statistical properties in your data. Click Insert Hierarchy Chart on the Insert tab to use the Treemap or Sunburst chart, click Insert Waterfall or Stock Chart for Waterfall, or click Insert Statistical Chart for Histogram, Pareto, or Box and Whisker. Or click Recommended Charts All Charts to see all the new charts. Get and transform QueryBefore analysis can begin, you must be able to bring in the data relevant to the business question you are trying to answer. Excel 2. 01. 6 now comes with built in functionality that brings ease and speed to getting and transforming your dataallowing you to find and bring all the data you need into one place. These new capabilities, previously only available as a separate add in called Power Query, can be found natively within Excel. Access them from the Get Transform group on the Data tab. One click forecasting. In previous versions of Excel, only linear forecasting had been available. In Excel 2. 01. 6, the FORECAST function has been extended to allow forecasting based on Exponential Smoothing such as, FORECAST. ETS. This functionality is also available as a new one click forecasting button. On the Data tab, click the Forecast Sheet button to quickly create a forecast visualization of your data series. Sometimes we build an Excel spreadsheet that has a number of worksheets or tabs that are the same layout. No matter how well we have designed our spreadsheet, there. 4. Click on the link in the email or enter the URL into a browser to open the workbook in the Excel Web app. Multiple users can edit the workbook at the same time in. Download Free Excel Templates, Chart Templates, Tutorials, Help Workbooks and Spreadsheets from Pointy Haired Dilbert one of the finest and most exhaustive. From the wizard, you can also find options to adjust common forecast parameters, like seasonality, which is automatically detected by default and confidence intervals. D Maps. Our popular 3. D geospatial visualization tool, Power Map, has been renamed and is now available to all Excel 2. Excel. This innovative set of storytelling capabilities has been renamed 3. D Maps and can be found along with other visualization tools by clicking 3. D Map on the Insert tab. Calendar Insights. Financial templates. Take advantage of the new My Cashflow template, and the Stock Analysis template. These templates track what you earn, how much you spend, and where your spending occurs. Plus, quickly analyze and compare the performance of selected stocks over time. Template. View your calendar as a dashboard and drill into the data. Youll get a better handle on how you spend your time, and identify ways to get more out of your days. Pivot. Table enhancements. Excel is known for its flexible and powerful analysis experiences, through the familiar Pivot. Table authoring environment. With Excel 2. 01. Excel 2. 01. 3, this experience was significantly enhanced with the introduction of Power Pivot and the Data Model, bringing the ability to easily build sophisticated models across your data, augment them with measures and KPIs, and then calculate over millions of rows with high speed. Here are some of the enhancements we made in Excel 2. Automatic relationship detection discovers and creates relationships among the tables used for your workbooks data model, so you dont have to. Excel 2. 01. 6 knows when your analysis requires two or more tables to be linked together and notifies you. With one click, it does the work to build the relationships, so you can take advantage of them immediately. Creating, editing and deleting custom measures can now be done directly from the Pivot. Table fields list, saving you a lot of time when you need to add additional calculations for your analysis. Automatic time grouping helps you to use your time related fields year, quarter, month in your Pivot. Table more powerfully, by auto detecting and grouping them on your behalf. Once grouped together, simply drag the group to your Pivot. Table in one action and immediately begin your analysis across the different levels of time with drill down capabilities. Pivot. Chart drill down buttons allow you to zoom in and out across groupings of time and other hierarchical structures within your data. Search in the Pivot. Table field list helps you get to the fields that are important to you across your entire data set. Smart rename gives you the ability to rename tables and columns in your workbooks data model. With each change, Excel 2. DAX formulas. Multiple usability improvements have also been made. For example, delayed updating allows you to perform multiple changes in Power Pivot without the need to wait until each is propagated across the workbook. The changes will be propagated at one time, once the Power Pivot window is closed. Multi select Slicer. Now you can select multiple items in an Excel Slicer on a touch device. This is a change from prior versions of Excel where only one item in a Slicer could be selected at a time using touch input. You can enter Slicer multi select mode by using the new button located in the Slicers label. Publish and share your analysis with Power BIA report is not complete without being able to share it with the right people. Once youre finished preparing your data analysis, you can share it with your workgroup or clients through Power BI with just one button. Once published to Power BI, use your data models to quickly construct interactive reports and dashboards. With Excel Online support built into Power BI service, you can also display your fully formatted Excel worksheets as well. Quick Shape Formatting. This feature increases the number of default shape styles by introducing new preset styles in Excel. Insert pictures with the correct orientation. With automatic image rotation, once you insert an image into Excel, it automatically rotates the picture to match the cameras orientation. You can manually rotate the image to any position after insertion. Note that this only affects newly inserted images and does not apply to pictures in existing documents. Do things quickly with Tell Me. Youll notice a text box on the ribbon in Excel 2. Tell me what you want to do. This is a text field where you can enter words and phrases related to what you want to do next and quickly get to features you want to use or actions you want to perform. You can also choose to get help related to what youre looking for, or perform a Smart Lookup on the term you entered. Insights into what youre working on. The Insights pane, powered by Bing, offers more than just definitions. When you select a word or phrase, right click it, and choose Smart Lookup, the insights pane will open with definitions, Wiki articles, and top related searches from the web. You can also get to Smart Lookup any time by going to Review Smart Lookup and entering a query there. Ink Equations. Including math equations has gotten much easier. Now, you can go to Insert Equation Ink Equation, any time you want to include a complex math equation in your workbook. If you have a touch device, you can use your finger or a touch stylus to write math equations by hand, and Excel will convert it to text. If you dont have a touch device, you can use a mouse to write, too. You can also erase and select and correct what youve written as you go. Simpler sharing. Choose Share on the ribbon to share your spreadsheet with others on Share. Point, One. Drive, or One. Drive for Business. These changes bring together two key aspects of collaboration who has access to a given document and who is currently working with you on the document. Now you can view both pieces of information in one place from the Share dialog box. Improved version history. Now you can go to File History to see a complete list of changes that have been made to your workbook and access earlier versions. Note This feature is only supported for files stored on One. Drive for Business or Share. Point. New Themes. There are now three Office Themes that you can apply Colorful, Dark Gray, and White. To access these themes, go to File Options General, and then click the drop down menu next to Office Theme. Data Loss Protection DLP in Excel. Data Loss Protection DLP is a high value enterprise feature that is well loved in Outlook. We are introducing DLP in Excel to enable real time scan of content based on a set of predefined policies for the most common sensitive data types e. US bank account number. Editorial Content Calendar. Editors note Weve published a newer post on this popular topic, which includes bonus tips and information. Read it now As a content marketer, you have no doubt heard that marketers need to think like publishers, but how exactly does that translate into action If you are asking yourself this question, read Jeremy Victors fantastic post on this very topic. Next to developing buyer personas, I think the most useful exercise to help you think like a publisher is creating an editorial calendar. A lot has been written about the need for an editorial calendar, and you can certainly find online magazines that publish their editorial calendar, but I havent found many calendars that are geared towards the marketer. Regardless of where you are in your content marketing efforts, its important to have an editorial calendar to keep your content consistent and relevant. It also helps keep your marketing team on the same page and is a great reference for your management. While a basic editorial calendar that simply tracks the date and content topics you are planning like the example we offer here is a fantastic start, the editorial calendar I like to use tracks additional details to help you see connections in your content, generate ideas on what content to create or what you can repurpose, and ensure you are including key information, such as SEO. UPDATE Some readers asked for the template. You can see a sample below or download the blank Excel spreadsheet of the CMI editorial calendar template. A few notes on editorial calendars Your editorial calendar is going to differ depending on the type of content you produce and what is important for you to track. The program you use to track this information will likely depend on your organization and its requirements. For instance, while some people like to use Google spreadsheets, some companies dont allow access to this program. Other companies require that you use a proprietary program. Personally, I use Excel. As Joe mentions in his post on managing the content marketing process, its helpful to have two editorial calendars a master calendar where you can see everything at a glance and separate calendars for specific activities. I use one spreadsheet with multiple tabs to keep everything together. Have a master editorial calendar to view all content at a glance. The master editorial calendar provides an overview of all content that is planned by day and by week Track key dates such as events, holidays or other things that may impact which content you want to share when. If you have an international audience, include holidays in the various countries you serve as well. Include a brief overview of all of the content that is planned by content type. Heres a snapshot of the template for a master editorial calendar click to enlargeLooking at all of your key dates and planned topics can give you ideas for topics and help you think about how you can repurpose content in multiple sources. For instance, if you have a new white paper or case study planned, you can plan one or a series of blog posts around that. Or, if you have an event, you can plan to develop an e. Book based on the top 3. Seeing the calendar at a glance helps these connections jump out more easily and helps you remember which dates to avoid. Need help setting up your editorial calendar or other key processes for content creation management Download our step by step workbook, Launch Your Own Content Marketing Program. Have separate editorial calendars to track specifics of all other content types. Have separate spreadsheets or tabs for each specific type of content you are creating. For instance, you may have one tab for your blog, another for your newsletter and another for the additional types of content you create, such as e. Books, white papers and case studies. How you break this up will depend on how you manage each of these content types. Each of the separate tabs includes more specifics about all of the content activities you have planned and will vary based on what you offer. For instance, if you have a blog, you may want a specific tab that tracks all of the info for each post, such as Post date. Author. Tentative title. Keywords. Categories. Tags. Call to action. Status. Tracking more than topic and date helps you make sure to include the key elements you need for SEO, digital optimization, and conversion. Use your editorial calendar to track content ideas. While outside the technical scope of an editorial calendar, I also like to track a few other types of content in separate tabs Existing content I can use as a call to action. Ideas for content I can repurpose. Ideas for new content I have an additional tab that I use to track blog post ideasContent I can curate. Use an editorial calendar to help with complex buying cycles. On a final note, if you are a B2. B marketer who is helping customers progress through a complex buying cycle, Ardath Albee has a must read post on editorial calendars, where she suggests that you track additional details such as the following Cliffhanger In what way have you created anticipation for future engagement Or, sign up for our series on XBuying stage Status Quo, Priority, Research, Options, Step Back, Validation, Choice. Distribution website, Twitter, Linked. In, Facebook, blog, nurture email send, syndication, etc. This will also include notes about linkages to other content on the calendar e. Accompaniments Includes messaging for related emails in the case of nurture sends, associated Tweets, landing page content for white papers, webinar invitation text and registration page content, etc. Id love to hear how you organize your editorial calendar. What tools do you use What data do you track Please share your experiencesor questionsin the comments below. For a comprehensive guide on working with editorial calendars, check out A Content Marketers Checklist Editorial Calendar Essentials. Cover image by Viktor Hanacek via Picjumbo.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |