305 Microsoft Excel – Charts & Graphs

Microsoft Excel – Charts & Graphs

Charting: Creating a simple chart and learning that charts are dynamic and based up on the information stored somewhere else within the spreadsheet, Inserting labels for heading, the x & y axis, values and more. Learning how to chart mutliple rows and columns

Charting: Organising your sheet tabs, especially for new chart sheets, changing the data range within the chart wizard, charting several separate data ranges, charting options and different types of charts (pie charts)

Chart formatting: Understanding chart objects for the purpose of formatting, understanding the buttons in the chart toolbar, and using right-click to format. Formatting a data series, and parts of a pie chart, having 2 different data formats within the one chart and how to get charts into Microsoft Word documents.

Training Video List

Section 1 videos

Charting: Creating a simple chart and learning that charts are dynamic and based up on the information stored somewhere else within the spreadsheet, Inserting labels for heading, the x & y axis, values and more. Learning how to chart mutliple rows and columns

305101 – Opening exercise files (Length – 1:22)

305102 – Creating a basic chart (Length – 3:15)

305103 – Charts are dynamic (Length – 1:52)

305104 – Charts with labels (Length – 2:43)

305105 – Charts with more labels (Length – 2:45)

305106 – Charting multiple rows and columns (Length – 2:58)

Section 2 videos

Charting: Organising your sheet tabs, especially for new chart sheets, changing the data range within the chart wizard, charting several separate data ranges, charting options and different types of charts (pie charts)

305201 – Organising your sheet tabs (Length – 1:49)

305202 – Changing the data range in wizard (Length – 2:11)

305203 – Charting multiple data ranges (Length – 3:39)

305204 – Charting Options for labels (Length – 3:10)

305205 – Using a Pie chart (Length – 2:53)

Section 3 videos

Chart formatting: Understanding chart objects for the purpose of formatting, understanding the buttons in the chart toolbar, and using right-click to format. Formatting a data series, and parts of a pie chart, having 2 different data formats within the one chart and how to get charts into Microsoft Word documents.

305301 – Chart objects (Length 2:57)

305302 – Charting toolbar (Length – 3:09)

305303 – Right-click and format (Lengh – 2:19)

305304 – Format the data series (Length – 3:17)

305305 – Format pie charts (Length – 2:22)

305306 – Two or more chart formats (Length – 1:45)

305307 – Getting charts into Word (Length – 4:20)

 

Back to Microsoft Excel Training Courses outline Enrol now

 

The Australian Small Business Training and Support

Subscribe to our business blogCourses, Training and Support.

Get bookkeeping, marketing, operations, customer service, sales and finance knowledge via email. Keep up to date with new and emerging trends and technologies and get our free samples.

Enquiry Form

  • This field is for validation purposes and should be left unchanged.
Call Now Button
%d bloggers like this: