Hello friends,
Let me stop our broadcast of Excel tips to bring an announcement.
Houston, we are going to get awesome
As you may know, I am doing 4 days of live masterclasses on Advanced Excel, Dashboards, Power Pivot & Data Analytics in Houston (Texas) this September.
- 15 & 16 September (Mon & Tue) on Advanced Excel & Dashboard Reporting
- 17 & 18 September (Wed & Thu) on Power Pivot & Data Analytics
This 4 day masterclass is aimed at managers, analysts, reporting professionals, executives in sales, marketing, customer service or anyone who wants to learn about Data Analytics, Advanced Excel, Dashboard reporting.
What to expect?
Expect lots of intense Excel tinkering. Expect to sky rocket your formula writing, data analyzing & chart preparation skills. Expect to get answers to your Excel questions. Expect to be amazed, entertained, nurtured and supported in your journey towards Excel awesomeness.
And of course, also expect,
- 2 (or 4) days of live tuition by Chandoo
- Lots of material (soft copies – Excel workbooks, PDFs, Presentation slides)
- Hands-on exercises, explanations & exploration
- Lunch, snacks, tea & coffee for both (or 4) days
- Opportunity to network with fellow Excel users, analysts & managers
Where is it?
The training is at MicroTek Houston. The address is:
11490 Westheimer Road
Suite 900
Houston, Texas 77077
My boss needs a little more convincing
I know. That is why we have prepared a course brochure for you. Please download it here. Send it to your boss.
Also, ask your boss to visit this page to get an idea on the kind of things you can do post the masterclass.
If you need any more information about this masterclass, email me at chandoo.d@gmail.com.
How to enroll?
Simple. Just head over to Masterclass 2014 page & book your spot.
Thank you
Thanks for your support to everything we do at Chandoo.org. Your enthusiasm to learn & be awesome motivates me to share as much as possible. Thank you once again for giving me courage & confidence to plan yet another masterclass. You are awesome.
PS: Tomorrow, lets go on a long bike ride. Here is a sneak peak.
15 Responses
Align charts to grid by holding alt while moving them. Same goes when resizing them.
please how can i debug a cell hidden with formula becos right now i just got a job but my predecessor lock all formular and no handover note . please i need to rescue my self becos there is a report to submitt this weekend
Ralph, Google unlock excel without password. You’ll find some VBA that will unlock everything for you
I still use this code to remove internal passwords:
http://www.mcgimpsey.com/excel/removepwords.html
Also, clicking format painter twice will keep it selected for multiple uses. Small thing but easy to miss
Wow! That’s a very useful tip – thanks a ton.
Wow ! Amazing. I never thought this would be possible at all. *THUMBS-UP !
Thanks for this Chandoo – very useful and a good reminder – sometimes forget all the available tricks!
Ralph,
Yo can try the unlcok VBA codes, that are simple, or you can open another excel sheet and get the data from the locked one. In the new one, the data will be unloced and unformated.
#5 question
how do i un-bug then again. when i press F9 i get the value but what shortcut can i press to get back the formula? Now i only know to press enter and press excel undo but i am sure there is a faster way.
thank you!
Press ESC. This will exit the formula editing mode and reverts to original formula.
#4 – CTRL+ENTER is a nice trick but be aware that it creates an array of the selected cells so that you cannot insert/delete the rows of columns of the array or edit an individual formula in the selected cells.
I think you are talking about CTRL+SHIFT+ENTER which is used to enter array formulas. CTRL+ENTER simply fills all the selected cells with same contents that you have in active cell of selected range(Constant values or formula both, as the case maybe). Also for CTRL+ENTER, the selected cells may or may not be a continuous range. If works on both continuous and non-continuous selections.
You are correct Ajesh. I read it as CTRL+SHIFT+ENTER instead of CTRL+ENTER. Both work in Chandoo’s tip but obviously CTRL+ENTER would be the better one to use. Thank you.
Dear Chandoo,
I want to know if it is possible to do the same pivot table “User interaction hacks”
Thx
CL