A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
Hello Excel TV Fans! Have you answered the previous week’s Excel Challenge? If you are good at Excel Quick Access Toolbar, then this week’s Excel Challenge is very interesting. But, before that let us look at the answer for last week’s challenge.
Excel MVP Jordan asked to list down 2 Excel functions such that by changing the smallest number of characters in one function would result in the second function.
Correct answer is T() and N() are the two Excel functions which meets the condition mentioned in the Challenge.
T(value) – returns the text referred to by value.
N(value) – converts a value into a number.
This week’s winner is Heather Gray.
Congratulations Heather Gray! You won a cool looking mouse pad as said in the previous episode.
We know that, every icon on the Quick Access Toolbar has some functionality. We could know what it is, by just hovering the mouse on it. In such a way, you could see the snapshot of Jordan’s quick access toolbar in the video and you need to mention what each icon on that stands for.
Answer as many as you can and winner will be declared based on the most number of icons you have answered correctly.
Winner of this week’s Excel Challenge will get 12-month free subscription for Dashboard course of Mynda Treacy from www.MyOnlineTrainingHub.com
Then Hurry Up!
What are you waiting for? Go ahead and comment your answer in Excel TV blog post or Facebook or Excel Challenges forum of VBAExpress.com. You can even tweet to @ExcelTV. Come On!
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide