Last month’s webinar, Excel POWER tips and tricks was a blast! We had a great turn out from all of you. We’re excited to host another one this month on Microsoft Excel formulas and functions presented by Dennis Taylor.
And, we’re excited to welcome Dennis back for this next Webinar! As you might remember, Dennis has over 25 years training experience in Microsoft Excel. His videos are featured on Lynda.com, and he’s even written several books on Excel. For this month’s webinar, he’ll take us behind the scenes of Excel 2013 functions.
Do you know what AGGREGATE does? How about ISFORMULA? What about 3-D formulas that tabulate results across several workbooks?
This webinar is for you. So come join us Friday June 20th at 2pm to learn about Excel’s formulas and functions from the master, Dennis Taylor
Have you ever used Excel and thought to yourself there must be a faster way to this?
Now, with the Excel POWER Tips & Shortcuts webinar, taught by Excel expert Dennis Taylor—and offered by VBAExpress.com—you can learn the tricks, tools, and secrets the experts employ when they use Excel. You’ll be hard pressed to find these tricks in any book.
This isn’t one of those canned webinars offered by the big-box training companies. At VBAExpress.com, they find the best talent out there; experts and practitioners with years of experience who leverage their wisdom, intuition, and yes, wit to educate and help others.
Dennis has over 25 years training experience across North America. He’s a published author on using Excel and has even developed video courseware.com.
Click Here to Register Now
FOR A LIMITED TIME, RECEIVE $10 OFF WHEN YOU USE THE PROMO CODE VBAX10
One question I get all the time is how to change the case of text in Excel. Some applications require case-specific text to make a match with its data. Or you may just want to clean up your data to make it consistent across the document. Excel provides three quick formulas to accomplish the text-case change we are talking about.
Today we will review two ways that you can hide a worksheet in your workbook. The simple way is very easy for the end user to unhide the worksheet; the same spreadsheet that you didn’t want them to see in the first place. To hide a worksheet this way, just select from the main menu: Format > Sheet > Hide. To unhide, you just need to select Format > Sheet > Unhide and select the sheet you want to see. As you can see, that method is not very secure. Now we will go over a second method to more permanently hide worksheet.