Microsoft excel intermediate tutorials

Group and ungroup data. Module 3: Working with Illustrations This module explains how to work with illustrations. U use Clip Art to illustrate your worksheets. Insert shapes into Microsoft Excel worksheets. Use SmartArt to illustrate your worksheets. Module 4: Visualizing Your Data This module explains how to work with charts, objects, and text boxes.

Choose what data is displayed in your charts. Show and hide data labels. Show and hide the legend. Show and hide the chart title. Add a picture or shape to a chart. Change the way text displays in a chart. Change the fill color of a chart. Add and format objects in a worksheet.

Module 5: Working with Tables This module explains how to work with tables. Modify Excel tables. Module 6: Advanced Formatting This module explains how work with formatting options in Excel. Quickly format tables using styles. Basically, Excel has different file extensions that you can use for saving a workbook.

In the same way, if you want to open a file that is saved on your system you can go to the FILE tab and click on the open. Every workbook consists of worksheets where you can add your data and analyze it and once you open an Excel workbook you can see there are tabs at the bottom of the window.

When you go to the FILE tab, you can find there is a print button that further includes all the printing options that you can use for printing data from a worksheet. The biggest power of Excel is its functions that you can use to perform a lot of calculations and below you have a list of top ten Basic Excel Functions :.

Once you start working on data probably you need to present it to someone, and a chart is one of the best ways for this. In Excel, you have a whole list of charts that you can create. Once you go to the Insert tab, and in the charts group you can find all the charts which are available to use. But to create a chart in Excel you need to have data in the right format, and then you need to select the right type of the chart make sure to check out this guide on chart types.

And in this case, the perfect chart would be a pie chart where you can present the quantity share of these products. You can also use the recommended charts button to let Excel recommend a chart type according to the data you have. You can customize a chart in different ways. Once you select the chart you will have Chart Design and Format tabs where you have all the options for customization. Excel gives you a powerful option to sort data. To open the sort option, you need to go to the Data Tab and then click on the Sort button.

You can also use more than one level of sorting. If you want to add a new level simply click on the Add Level and then define all the three things that we have discussed above. Just like any other application, Excel has its own find and replace option. On pressing it, it shows the shortcut keys for the options which are there on the ribbon, just like below. And from here you can download Excel Shortcuts Cheat Sheet that covers the top eighty keyboard shortcuts for Excel.

More Tutorials on Basic Excel Skills. Now once you master the basic stuff the next thing you need to understand is the Intermediate Excel Skills. Basically, these skills include options and methods to manage and work data in an efficient way. Group and ungroup data. Use Clip Art to illustrate your worksheets.

Insert shapes into Microsoft Excel worksheets. Use SmartArt to illustrate your worksheets. Choose what data is displayed in your charts. Show and hide data labels. Show and hide the legend. Show and hide the chart title. Add a picture or shape to a chart. Change the way text displays in a chart. Change the fill color of a chart. Add and format objects in a worksheet. Create a custom chart template. Modify Excel tables Module 6: Advanced Formatting This module explains how to work with advanced formatting features in Microsoft Excel.

Quickly format tables using styles. See all instructor-led courses.