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.
Hey folks! Welcome. Excel TV wishes you a very happy new year. Excel Author Jordan Goldmeier is ready with the first Excel challenge in 2016, but as usual before looking at this episode’s challenge, let us have a look at answer to previous episode’s challenge.
If you remember, last episode’s challenge was on Excel Colors. Jordan asked how the value of RGB (R,G,B) is calculated? So, here is the answer.
If you remember converting numbers from one number system to another number system in school, then this would help you to answer this challenge. Here you need to consider the base as 256.
So, RGB (R,G,B) is calculated as R*256^0 + R * 256^1 + R*256^2
Here, RGB (130, 210, 11) = 774786 is calculated in the same way.
Hope you got it! Interesting right?
Last episode’s winner is “Ryan Tretter”. Congratulations!
Now, Jordan comes up with this week’s Excel challenge and here it goes,
You can create in-cell Sparklines using the REPT formula and the “pipe” | symbol. There are two commonly used fonts in this trick that will make the bar look filled in and complete. Name one of those fonts.
You know the answer? Then what are you waiting for? Comment your answer below this post or answer us through Facebook. You can even tweet answer @ExcelTv. Hurry Up!
Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick
Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks
Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54
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