TUTORIAL FOR EXCEL 2013 HOW TO

In this chapter, you will get to know how to use Excel charts and Excel formatting features on charts that enable you to present your data analysis results with emphasis. It also leaves a good impact on your presentation style.

However, if your data analysis results can be visualized as charts that highlight the notable points in the data, your audience can quickly grasp what you want to project in the data. The 2013 chart also allows you to change the color or style of the chart.You can display your data analysis reports in a number of ways in Excel. You will have to click one of these buttons (chart filters, chart styles, or chart elements) to reveal more chart options.

When the chart is selected, some icons show-up at the edge of the chart. However, the interface is more simplified in 2013, with only the format and design tabs to choose from. In earlier Excel versions, when selecting a chart, it usually shows additional tabs: Format, Layout, and Design. The backstage view also gives you the chance to use your SKyDrive account and helps you set up extra Sharepoints or SkyDrive accounts. With the open tab, you now have access to workbooks that were recently accessed. But it has been completely moderated to show you exactly the project you are working on, so you can select the right task. The backstage feature view was first introduced in the 2010 version of office word. The feature will hasten the process by writing, charting, and formatting formulas. Click the right option you wish to analyze. To make use of this feature, select the data you want to analyze and click the quick analysis icon that shows up in the bottom right corner of the data selected.Ī variety of analyzing tools such as Sparklines, Tables, Totals, Charts, and Formatting, will appear, allowing you to scroll over the choices to pick the most appropriate option, depending on what you are working on. The quick data analysis tool will help both the inexperienced and experienced users to select different options when working with data. Pick the appropriate option and your chart is automatically created. This will bring out a dialogue box that shows you how your data will look when you plot the chart. To make use of this tool, click on the data, go to the insert tab, and click on recommended charts.

This is very useful for new users because it will enable them to explain data to the viewers without confusing them. It shows only a fraction of charts that are relevant to the selected data. Recommended charts help you simplify choices when working on your spreadsheet. However, the new 2013 recommended pivot tables have made things easier than users can work with tables and charts with a simple click of the mouse. But new users find this tool difficult to create. Pivot tables are important tools that help users analyze and answer questions about the data they are working on. But I find it very useful to keep it available for use. You are at liberty to enable or disable the start screen.

There is also a list of templates that can help you easily start a project. Through the start screen, you can open other files located on the disk. The most recently used worksheet can be pinned on the recent list for easy access. With the start screen, your work will be done faster as all files you are working on will be located on one screen. Below is our top list of exciting features that will make your work easier and more efficient when working with Microsoft Excel 2013. With tools such as recommended Pivot Tables and recommended Charts, difficult tasks have become easier to accomplish. With these extra additions, there is always something both the experienced and new user will enjoy – particularly a more effective way of solving a problem that was too hectic in the past. There are different features that offer users a more fascinating experience with the application of Excel spreadsheet both at home and in the office. The new Microsoft 2013 package offers a wide range of interesting and user-friendly tools for dynamic web application. Microsoft Excel 2013, has a lot of features on offer to users and developers.

Tutorial for excel 2013