Hi Friends,
Today somebody asked me about Pictograph and I thought I should share with you all.
Sometimes we get tricky situations in Excel which left us with "What to do" voice
Presenting some tips which will be very useful for freshers and professionals. In this post we will cover
1) Date Format
2) Pictograph
3) Play with Comment Box
4) Auto Correct Options
******************************************************
Change Date format
You got one notepad file and you are trying to open in Excel and one of the column surprise you.
******************************************************
This is about Pictograph
1) Create column chart
2) Paste one picture in Excel File
3) Copy that picture
4) Select Series button in Chart
5) And paste (Ctrl + V)
6) And Pictograph is done
******************************************************
Play with Comment Box
There are so many features available in Excel which we normally don't use in our normal life but it is good to know about those features. And one of them is "Add Picture as a Comment Box"
See Below Picture
Now See Below Picture
Here's how you can do it:
1) When the comment is selected by the border, click the new Change Shape tool.
2) Select the Box and click on Format Comment
3) Select color and Lines Tab
4) Click on Fill Effects
5) Click on Picture Tab
5) Select Picture
6) Click Ok
******************************************************
Auto-correct Options
We can save a lot of time by entering shortcuts for commonly used
terms in Excel. e.g Most of the time I use Sanjay Bakshi word in
Excel and I wanted to create shortcut for this so whenever I will
type SANJ, automatically Excel will change text to "Sanjay Bakshi".
1) Click on Excel Options
2) Click on Proofing
3) Click on auto correct options
4) Write shortcut word in "Replace" Text Box
5) Write new word in "With" Text Box
6) Click OK
Today somebody asked me about Pictograph and I thought I should share with you all.
Sometimes we get tricky situations in Excel which left us with "What to do" voice
Presenting some tips which will be very useful for freshers and professionals. In this post we will cover
1) Date Format
2) Pictograph
3) Play with Comment Box
4) Auto Correct Options
******************************************************
Change Date format
You got one notepad file and you are trying to open in Excel and one of the column surprise you.
This is about Pictograph
1) Create column chart
2) Paste one picture in Excel File
3) Copy that picture
4) Select Series button in Chart
5) And paste (Ctrl + V)
6) And Pictograph is done
Play with Comment Box
There are so many features available in Excel which we normally don't use in our normal life but it is good to know about those features. And one of them is "Add Picture as a Comment Box"
See Below Picture
1) When the comment is selected by the border, click the new Change Shape tool.
2) Select the Box and click on Format Comment
3) Select color and Lines Tab
4) Click on Fill Effects
5) Click on Picture Tab
5) Select Picture
6) Click Ok
******************************************************
Auto-correct Options
We can save a lot of time by entering shortcuts for commonly used
terms in Excel. e.g Most of the time I use Sanjay Bakshi word in
Excel and I wanted to create shortcut for this so whenever I will
type SANJ, automatically Excel will change text to "Sanjay Bakshi".
1) Click on Excel Options
2) Click on Proofing
3) Click on auto correct options
4) Write shortcut word in "Replace" Text Box
5) Write new word in "With" Text Box
6) Click OK
That's all for Today, see you tomorrow with new learning.
Sanjay Bakshi
mesanjaybakshi@gmailcom
mesanjaybakshi@gmailcom
(Keep Calm & Keep Learning)
No comments:
Post a Comment