Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. The course covers some useful tips of Microsoft Excel commonly used in the workplace
• Quick keyboard short-cuts for charts
• Chart types
• Chart terms
• Choosing an appropriate chart type
• Change the default chart format
• Creating charts using the Chart Wizard
• Plotting non-adjacent cells
• Adding unattached text
• Changing the appearance of the chart
• Changing the chart type
• Adding and removing data sets
• Exploding Pie Chart
• Pie of Pie Chart (Second Pie)
• 3-Dimensional charts
• Mixed Chart (combining two types of chart)
• The series function
• Resizing charts and chart objects
• Breaking axis
• Changing axis unit, value and position
• Using a secondary axis
• Plotting error bars
• Using Trendlines in a chart
• Formatting the chart area
• Formatting the data series
• Formatting the legend
• Formatting gridlines
• Formatting axes
• Picture charts
• Printing a chart
• Copying charts into Word or PowerPoint
• Inserting a linked or embedded Excel chart
• Common mistakes in charts
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
