One of the most useful features in Excel is a "dashboard"
By changing data in a file, you can have many elements such as charts updated at the one time.
This is particularly handy for analysis, trends etc. and with the use of "slicers", it is a simple matter to filter information so you can see just what you need to see.
The dashboard would normally be the first sheet in the Excel file.
A full explanation and demonstration can be found on our YouTube channel. Click the graphic below to be taken to the lesson:
Many have requested a procedure to insert a comment in the footnote area.
Advising that this a limitation and cannot be done.
A workaround would be to place a comment next to the footnote reference in the body of the document. Not perfect but better than nothing
A sincere "Thank You" to the many visitors to my YouTube channel who have watched and used the Learn English uploads.
I have now added a "Word of the day" section to this blog. Remember to come back regularly to learn and widen your vocabulary. Why not place the page in your favorites for easy access ?
I extend you a warm welcome to the page.
Word of the Day
Quote of the Day
Article of the Day
This Day in History
A friend of mine asked the question recently along the lines of "I love Excel and I can type text into a worksheet. Why should I use Word?"
The answer was of course quite easy: Word is a program specially designed to manipulate text. Excel is a program designed to manipulate numbers.
I suggested to him that he might like to type three 5-line paragraph in Word, and then insert bullet points.
Then I asked him to repeat the performance in Excel. He was unable to do so.
I further asked him to perform three or four more Word operations and then repeat the same thing in Excel. Again he was unable to easily do so.
My friend soon agreed with me that I was right.,
Incidentally, bullet points can be inserted into an Excel cell. Visit this link to learn the procedure: https://youtu.be/UytAzptn63E
Many people ask the question as to when should they upgrade to later versions of Word or Excel, which of course are modules in the Microsoft Office suite of programs.
My answer is to ask the question, particularly for home users, "Does the program do what you want it to do at the moment?"
If the answer is in the affirmative, I generally suggest that they can save money by continuing to use their existing software.
This approach often applies to more senior users whose needs are well satisfied by the "things they know". Also the learning curve involved is often a hassle for this particular group.
I often find that many senior citizens mainly use the internet to send email to their loved ones and are really not interested in the advanced features of MS Office.
Of course there are the exceptions, and in their cases, upgrading may well be a positive option.
Where a business is concerned, the collaborative features which are often improved in upgrade versions may well assist a company to more efficiently use programs in a multi-user environment.
Learn to speak fluent English using our FREE YouTube content
Click the graphic below to be taken to the playlist where you can choose your lesson.
I recommend beginners start at Lesson 1 and work their way up.
Not only will you speak fluently, but you will master the theory of the English language as well !!
As in most languages, English has three tenses:- present, past and future.
Lets consider tense when we think about the verb "to be"
Present Tense Past Tense Future Tense
I am I was I will
You are You were You will
He/She is He/She was He/She will
We are We were We will
You are You were You will
They are They were They will
I am talking I was talking I will talk
He is talking He was talking He will talk
Nouns are things like people , countries, places, items
Some examples are:
Adjectives are words which describe nouns
A young boy
An old woman
A big city
A tall horse
An empty bottle
Verbs are "doing" or "action" words.
For example the words to speak is a verb
"to run" is another verb
A verb is mainly used with a "subject" such as I, you, he, she, we, you, they..These are called "PRONOUNS"
When we use those words as a subject, we also use a very important verb called "to be"
e also use NOUNS
The verb "to be" is then "conjugated" which means to give the different forms of a verb as they vary according to voice, mood, tense, number, and person.
are all examples of conjugation.
We then use "adverbs" to add to the meaning of the verb
I am speaking
You are speaking
He is speaking ....and so on.....the word "speaking" is an adverb
Using the verb "to be" is the main area where people who are learning English make the mistake of not using the verb.
For example, if a person is talking to his mother, they might say "I talk to my mother" instead of "I am talking to my mother"
If he is cooking the dinner, he might say "I cook the dinner" instead of "I am cooking the dinner"
or "I walk to the shop" instead of "I am walking to the shop"
You can see that in these examples, using the correct English sounds much better.
You can also look at the "Tenses" category to see how the verb "to be" is used for present, past and future English.