Jun 12 2014

New Excel Formulas & Functions Free Webinar

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


Sign Up Here




TAGS:
May 3 2014

Upcoming Excel Webinar

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


TAGS:
Mar 2 2012

Change Case of Text in Excel

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.
Read More

TAGS:
Oct 9 2011

How to Make a Worksheet Very Hidden

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.
Read More

TAGS:
Aug 2 2011

Calculate Age in Excel

Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below.
Read More

TAGS: , ,
  • Expert Excel Consultants for Business
  • Advertise Here

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories