Microsoft Excel Training: Date, Text and Chart Features (Part 5)
Explore “Date, Text and Chart Features” in this Microsoft Excel Training lesson. Part 5 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Date and time functions
- Formula:-
- Text functions
- CHARTS & THEIR ELEMENTS
- All – Pastes the actual contents into the destination cell
Contents
- Read the original document
- Date and time functions
- Formula:-
- Text functions
- CHARTS & THEIR ELEMENTS
- It is used to give a condition on any one or more cells & then input a message & if that condition is wro
- All – Pastes the actual contents into the destination cell
- Sharing workbooks
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel Training: original teaching slides for this study series.
Date and time functions
Date and time functions
Formula:-
It is used to write the current date in any cell.
Formula:-
it is used to write the date & time in any cell.
Text functions
Text functions
Formula:-
=concatenate(text1,text2,………..). It is used to join the two words of different cells in one cell. CONCATENATE
CHARTS & THEIR ELEMENTS
CHARTS & THEIR ELEMENTS Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
A chart has many elements. Some of these elements are displayed by default, others can be added as needed. You can change the display of the chart elements by moving them to other locations in the chart, resizing them, or by changing the format. You can also remove chart elements that you do not want to display. The chart area of the chart. The plot area of the chart.
The data points of the data series that are plotted in the chart. The horizontal (category) and vertical (value) axis along which the data is plotted in the chart. The legend of the chart. A chart and axis title that you can use in the chart. A data label that you can use to identify the details of a data point in a data series.
It is used to give a condition on any one or more cells & then input a message & if that condition is wro
It is used to give a condition on any one or more cells & then input a message & if that condition is wrong then make alert by a comment.
All – Pastes the actual contents into the destination cell
All – Pastes the actual contents into the destination cell Formulas – Pastes only the formula. Values – Pastes only the values. Formats – Pastes only the formats. Comments – Pastes only the comments. Validation – Pastes only the validation. All except borders – Pastes everything except the four borders. Paste the value into the cell in the format and operations you specify. Paste special
Sharing workbooks
Sharing workbooks
Review questions and answers
What are the key points about Formula:-?
It is used to write the current date in any cell.
What are the key points about CHARTS & THEIR ELEMENTS?
CHARTS & THEIR ELEMENTS Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. A chart has many elements. Some of these elements are displayed by default, others can be added as needed. You can change the display of the chart…
What are the key points about It is used to give a condition on any one or more cells & then input a message & if that condition is wro?
It is used to give a condition on any one or more cells & then input a message & if that condition is wrong then make alert by a comment.
What are the key points about All – Pastes the actual contents into the destination cell?
All – Pastes the actual contents into the destination cell Formulas – Pastes only the formula. Values – Pastes only the values. Formats – Pastes only the formats. Comments – Pastes only the comments. Validation – Pastes only the validation. All except borders – Pastes everything except the four borders. Paste the value into the cell in the format and…
More lessons from this document
- Microsoft Excel Training — Part 1
- Microsoft Excel Training — Part 2
- Microsoft Excel Training — Part 3
- Microsoft Excel Training — Part 4
- Microsoft Excel Training — Part 5
Conclusion
The important points in All – Pastes the actual contents into the destination cell should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.