Microsoft Excel Formulas and Functions Webinar – FREE

Working with Microsoft Excel 2013 formulas and functions in is absolutely critical to building powerful financial and analytical worksheets and is probably the most important skill set for many Excel users.

Register today:
Excel has over 400 built-in functions, a potent set of power tools that simplify certain kinds of formulas and give you unlimited computational potential. Many Excel functions provide extended analytical capabilities and open the door to more efficient use of Excel, but with this many functions, it’s no easy task to know which functions are available and which ones you might have overlooked.

This session gives you perspective on what functions are available and explains (with extensive examples) how to use many of them, including: the IF function (with AND and OR), the powerful VLOOKUP function, selected Date, Statistical, Financial, and Mathematical functions, and the frequently overlooked Text functions.

All examples will be presented within the context of Excel worksheets based on real-life examples; numerous productivity tips, shortcuts, and accelerator tools will be presented throughout the session.
– Learn formula-building shortcuts and how to use formula-auditing tools
– Learn how to build 3-D formulas to tabulate totals from multiple worksheets
– Learn how to use the powerful IF function and the related AND and OR functions for programming-like capability
– Learn how to look up information in tables using the VLOOKUP function
– Use the AGGREGATE function to circumvent error-laden data
– Learn how to use selected Text functions to extract and manipulate character and numerical data for sorting and analytical purposes
– Learn how to harness the power gained from using multiple functions in a nested fashion
– Learn how and when to use the powerful COUNTIF/SUMIF family of functions
– Learn about new Excel 2013 functions – ARABIC, ISFORMULA, FORMULATEXT

Here is the webinar registration link:

Please send your questions, comments and feedback to: christopher@vbaexpress.com
How To Join The Webinar
Fri, Jun 20, 2014 2:00 PM – 3:30 PM EDT
Add to Calendar
1. Click the link to join the webinar at the specified time and date:

https://global.gotowebinar.com/join/8600084542765302273/864746873

Note: This link should not be shared with others; it is unique to you.
2. Choose one of the following audio options:
TO USE YOUR COMPUTER’S AUDIO:
When the webinar begins, you will be connected to audio using your computer’s microphone and speakers (VoIP). A headset is recommended.
–OR–
TO USE YOUR TELEPHONE:
If you prefer to use your phone, you must select “Use Telephone” after joining the webinar and call in using the numbers below.
United States
Toll: +1 (914) 339-0021
Access Code: 932-123-489
Audio PIN: Shown after joining the webinar
Webinar ID: 131-232-019
View System Requirements
To Cancel this Registration
If you can’t attend this webinar, you may cancel your registration at any time.

PASS BA Conference this week

By Zack Barresse

This week the Professional Association for SQL Server (www.sqlpass.org) will host the Business Analytics Conference in sunny San Jose, CA. This will be the first of their conferences I’ve attended and I’m very much looking forward to it.

Who, me?

It’s my opinion, possibly disillusioned, that my audience (you, the reader) are an Excel user, and may or may not be power users, and may or may not consider yourself a “data architect,” “big data hero,” etc. What I like to refer to us as “regular folk”. I’m all self-taught, and have only learned what I know from watching others and an insatiable curiosity for performance and cutting edge technology in the hands of everyone. It’s my hopes that this blog is directed at you. As such, I’m going to be sharing a series of blog posts covering the PASS BA conference. Since I’m not a SQL Server pro, or a database guru, these will be from the Excel pro in mind – those who want to leverage the best technology in Excel.

What’s the benefit?

There will be dozens of the most talented people in the business at the conference. Some big names many of you probably recognize. Here are a few:

  • Rob Collie
  • Javier Guillen
  • Chris Webb
  • Devin Knight
  • Alberto Ferrari
  • Jason Thomas
  • Grant Paisley
  • Kasper de Jonge
  • Amir Netz

While the list is much, much longer than this, these are the Who’s Who of the BI world. Some of the major informational topics will cover analytics and visualization, advanced analysis techniques, architecture, strategy and “big data”.

Why should I care, exactly?

And a fair question it is. For the Excel pro, a SQL Server conference might seem out of the normal area of interest. For me personally, I’m not a big SQL Server guy. I love the software, don’t get me wrong, but I’m far from a pro in this arena. But there are benefits for the Excel pro to look for:

  • Increase your analytical skills – weather it’s for a way to leverage your current data, or make those reports more interactive, or just to be more badass, the skills here will increase your repertoire
  • Learn from the movers and shakers in business analytics and intelligence – these are the people who write the blogs, push the envelope, and help shape future technologies
  • Stay ahead of the curve – ever get tired of the bleeding edge of technology? I don’t. I love shiny new things.
  • Build your network – about a thousand people have said it: if you want to be great, surround yourself with great people, and it doesn’t hurt to network a bit with the best-and-brightest
  • Be inspired – sharing your problems (and solutions) can not only validate you, but inspire you to reach farther and make your software do what you want it to

Pizza

Did I mention there’s a pizza night? Yeah. Pizza, learning, networking, all in one place.

There are two conferences I’ve attended in my lifetime which I would rate as the absolute best and do-not-miss-for-your-life, which are going to be my measuring stick for this one. We’ll see if I sign up to return next year. J

Excel POWER Tips & Shortcuts Webinar – $10 Off !!!

Excel POWER Tips & Shortcuts

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 we 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. We’re excited to have Dennis with us for our first webinar.

Click Here to Register Now
FOR A LIMITED TIME, RECEIVE $10 OFF WHEN YOU USE THE PROMO CODE VBAX10

FREE Amazon Kindle Download Today and Today Only.

Everyone likes free. And for today, and for today only you can download a FREE Kindle version of Excel University Volume 2 on Amazon! Yes, that is right, 100% free, no strings attached, full edition of this book. But you must download it by midnight tonight.

Please share the links with those you know, have them download the book, and if they find it to be of use, great.

Why is VBAExpress.Com offering the book to the site visitors? Because we like free, no strings attached offerings as much as the next guy. And this is a great book for those into Excel. (If you have free offerings for our members, please send them to Christopher)

Book details are below.

Excel University Volume 2 – Featuring Excel 2010 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals (Excel University – Featuring Excel 2010 for Windows)

Building on the firm foundation established in the first volume, the second installment in the Excel University series continues to explore the Excel features, functions and techniques relevant to accounting and finance professionals. Volume 2 focuses on how to automate recurring-use reports. Amounts in hands-free reports update the instant updated data is inserted into the workbook, for example, when an updated trial balance is pasted into the data sheet. This volume covers the Excel items needed to build and automate reports, including lookups, dynamic headers, mapping tables, error trapping, conditional summing, and date related functions. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

Here are all the links:

Free Kindle download of EU Volume 2:

Rate and Post Reviews:

The free download ends tonight at midnight.

Webinar on Microsoft Excel Power Tips & Shorcuts

Microsoft Excel Webinar Coming Up on May 9th, 2014

Excel POWER Tips & Shortcuts

Registration is now live!

CLICK HERE TO SIGN UP TO THE EVENT!

image

Course Description:
This unique course is filled with dozens of tips (not found in standard courseware) that let you achieve immediate productivity gains.

Most Excel users are not utilizing the full power of this software – you need these shortcuts and techniques to make you a proficient and powerful Excel user. Learn to display formulas instantly, audit formulas with keystroke shortcuts, copy/move/paste with simple dragging, build date lists effortlessly, and adjust values without formulas. You’ll also get a list of over 100 Excel keystroke shortcuts.

About Dennis:
• Over 25 years of teaching experience throughout the US and Canada
  • Over 25 years of teaching experience throughout the US and Canada
  • Author/Presenter of over 350 webinars on various Excel topics
  • Author/Presenter of numerous Excel courses (video, CD, DVD) starting in the mid-1990’s
  • Author/Presenter of online Excel courses for Lynda.com (Excel 2007, 2010, 2013), available at http://www.lynda.com/dennistaylor
  • Author of Teach Yourself Microsoft Excel 2000; co-author of five other books on spreadsheet software

How do I signup?

Follow the link below to register for the webinar. Hurry—space is limited.

PASS Business Analytics Conference

By Zack Barresse

So, what is it?

The Professional Association for SQL Server (PASS) is an independent, non-profit organization, which is free to register with, committed to helping deliver high quality content and professional development. One of the great features of this conference is what you are paying for. The registration fee actually stays in the community and supports business analytics programs and events.

They are putting on a BA/BI conference in San Jose, CA this year on May 7-9, 2014. Last year’s conference was a big hit, with some well-known names in attendance, including Bob Phillips, Rob Collie, Chris Webb, and many, many more. A lot of them are reprising their speaking roles again this year as well. In fact, Rob Collie is “doubling down”, as he puts it, delivering two speaking sessions. (May even do a third!)

Even though the organization is SQL-based, there are many things about this conference geared towards the Excel pro. With Microsoft’s new BI offerings in Excel (i.e. Power Pivot, Power Query, etc.), business intelligence has come full force into the Excel world.

WIIFM?

Well, there are over 70 sessions available. If you’re into using Excel for analytics, there are sessions designed just for you. If you use Excel and are into analytics, this conference is designed for you. If you’re working with data, you’ll find benefit in this conference.

Discount code for $150 off registration: BABT9H. This can’t be used with any other discounts.

 

If you don’t want to use this discount code there are others. Rob Collie has another discount code. In fact, if you want to use his code (they track usage), feel free. He’s got a great bunch of information in his blog post and it’s definitely worth the read.

What to look for

If you’re planning on attending, there are some great sessions you don’t want to miss. Here are some sessions (not all are listed) which piqued my interest:

Registration is pretty easy. Hope to see you there!