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
