- Online tutorial for excel 2013 how to#
- Online tutorial for excel 2013 upgrade#
- Online tutorial for excel 2013 free#
The first image simply has the data for each quarter by our Sales staff. The next three graphic images illustrate how Recommended Charts can be beneficial in quickly analyzing Sales by Quarter information for your team. Finally, filtered data can be viewed with live preview via “Chart Filters”. For instance, by using “Chart Elements” you can add or remove elements like axis titles, whereas with “Chart Styles” you can change the color of the chart. These related buttons in Microsoft Excel 2013 are “Chart Elements”, “Chart Styles”, and “Chart Filters”, and pressing them enables you to use extra formatting options.
Not to mention, you will also have an additional set of icons on the top right corner of the chart you select. Now you only have the Design and Format tabs which make the interface of Excel less cluttered. If you remember from the earlier Excel versions, selecting a chart would make 3 extra tabs appear in the Chart Tools tab. To create a Chart, simply click “OK” and your work will be done. If you click on a chart, you will have a preview of how the data will appear on it. You will now see a dialog box on the screen which has all the chart options. Next, click “Insert”, followed by “Recommended Charts”. Highlight the information that you want to work on in MS Excel 2013. Here in this Excel 2013 Tutorial, we show how you can use this tool. So even if you are not good with making charts, this feature will help you find the most suitable one without barging in the whole screen. Basically this intuitive option displays just the breakup of chart types that maybe relevant to the information you have entered in Excel. Next the “Recommended Charts” new feature in Excel 2013 illustrates the fact that while fresh features have been incorporated in Excel 2013, they do not meddle with the usability.
Online tutorial for excel 2013 how to#
Recommended Charts – How to Select, Insert, and Format Unselect “Show the Start Screen when this application starts” in the “Start up options”. To disable the start screen in Excel 13, open a new document and go to “File”, followed by “Options”. Note that while the Start Screen presents a host of benefits, you can even disable it if necessary.
Online tutorial for excel 2013 free#
Users who have limited or no experience working with Microsoft Excel will especially benefit from the template options, while regular users will appreciate the “Recent” file list along with hassle free access. We have included a screen capture from the newly designed Start Menu in Excel 2013 right below. If you find a template suitable, you can pin it for easy future access as well. Excel also provides a list of suggestions in case you are not sure about which template to use. If you want to start a project right away, Excel 2013 provides various templates on the screen that you can choose from, along with enabling you to search the internet for more templates. To access Excel in the cloud, you can find your SkyDrive cloud storage account on the top right edge of the screen. You can also click “Open Other Workbooks” to open files from the cloud or external storage such as a disk. In addition, you can even pin these worksheets to the “Recent” list so you can view them at all times. If you want to access worksheets you have used recently, they can be found on the left edge of the screen. Let’s start this Excel 2013 Tutorial by navigating the new Start Screen in Excel 2013, which allows you to work more efficiently.
How do you access spreadsheets, use templates, and disable the Screen in Excel? If you are interested in Microsoft Excel 2016, check out our Excel 2016 Tutorial. In this Excel 2013 Tutorial, you will learn all about Excel and how you can use it to make your data management simpler.
Online tutorial for excel 2013 upgrade#
If you use Microsoft Excel regularly, you should upgrade to the 2013 version immediately. We have included the screen capture from the new “Metro” style interface above. But despite being with loaded with these functions, the application has become more organized and user-friendly. Microsoft Excel 2013 comes packed with some new features. Excel 2013 Basics, Features and Usability