Make the Most out of the Various Microsoft Applications—Attend Our FREE Webinar, This Thursday!!!

(Click here for full details)

A Webinar to Build Businesses

As part of its initiative to enhance the local economy and help companies succeed, the Irvine Chamber of Commerce created Irvine Build Businesses, a series of free webinars it hosts every week. These events provide interactive educational opportunities for interested business owners, entrepreneurs, and individuals in Irvine and beyond. To offer valuable information for these people, the Chamber of Commerce seeks the assistance of experts in their industries, who share their skills with participants. The Excel Consultant team provided our first webinar for Irvine Builds Businesses last month on November 5. If you missed it, you can check out a recording of it here. We are proud to partner with the Chamber of Commerce to help boost local businesses and empower employees.


Integration Innovation: What We’ll Cover

The title of this webinar is “Power Tips for Microsoft Office.” You’re probably fairly familiar with each Microsoft application in the Office Suite—you can write documents in Word, calculate spreadsheets in Excel, make presentations in PowerPoint—but you may not know how to combine programs to unlock their full potential. At Excel Consultant, we’ve found that learning how to integrate applications is a simple but important ability that can be quite beneficial in a business setting. For more advanced cross-functionality, you may need to dig into the code of the programs, but we can show you how to do a lot without even using VBA (Visual Basic for Applications, one of the more basic programming languages in Microsoft).

With the click of a few buttons in the existing interfaces of your favorite Microsoft applications, we can show you how to transform your workflow. For example, we can help you send large tables from Excel to Access (Microsoft’s database management system), email through Outlook from Excel, or place an Excel chart in a PowerPoint presentation.

We’ll begin by teaching you the most common (and useful) keyboard shortcuts, so you no longer have to click or find the right tab to complete everyday operations. Next, we’ll show you how to send emails from Office applications using filing and sharing. This can make office and client communications much simpler and more streamlined.

Furthermore, we’ll instruct you to how automatically share data between Office applications, linking from Word to Excel, Excel to Word, PowerPoint to Excel, and Excel to PowerPoint. We’ll explain how to get data from Word or Excel to Access and use Word mail merge from Excel or Access. During the webinar, we’ll also demonstrate how to import and export tables and other formatted content between applications, using copy/paste, special values, source formatting, and destination formatting. These functions will make analyzing your numbers, creating promotional materials, communicating with coworkers, and more a lot easier.

Finally, we’ll discuss how you can leverage the power of the Cloud to collaborate and increase efficiency in your office. We’ll discuss the Personal and Business versions of Microsoft OneDrive.

Full Agenda: Power Tips for Using Microsoft Office
•Common keyboard shortcuts ◦​Control A, C, F, G, H, I, K, N, O, P, S, U, V, W, X, Y, Z

•Sending Emails from Office Applications ◦​File, Share

•How to automatically share data between Office applications ◦​Linking from ◾​​Word to Excel
◾​​Excel to Word
◾​​PowerPoint to Excel​​

◦​Getting data ◾​​Word or Excel to Access
◾​​Word mail merge from Excel or Access

•Importing and exporting tables and other formatted content ◦​Copy, PasteSpecial ◾​​Values
◾​​Source Formatting
◾​​Destination Formatting

•Using the power of the Cloud to collaborate and increase efficiency ◦​OneDrive, Personal or Business

About Your Instructor

As with our last webinar, “Use Excel Like a Pro and Master Your Data,” your Microsoft master will be Paul Delke. He is the Senior Project Manager and Programmer at Excel Consultant and the President of Talon Corp, a fellow firm and esteemed Microsoft Certified Partner since 1994. Paul has spent the past 30 years helping clients utilize Microsoft programs to their full potential, so he understands what companies need to know about these advantageous applications.

Do You Want to Attend This Webinar?

Paul will be presenting this webinar to the Irvine Chamber of Commerce and its members, but it is also open to anyone who wishes to attend. Any person or company can watch, listen, ask questions, and learn online. No matter what type of venture you have or where you’re located, you can benefit from his advice and expertise. All you’ll need is a computer with the ability to download and run Fuze, an advanced webinar platform. Once you’ve got your system set up, all you’ll have to do is log in at or before noon on December 10. Paul will most likely lecture for approximately 45 minutes before answering any questions attendees have. As with our first webinar, you will be able to view a recording of this event on YouTube after it occurs.

FREE Webinar on Microsoft Excel Pivot Tables – Part One

Microsoft Excel 2013 Pivot Tables Webinar – Part One

By Dennis Taylor

Hosted on

Coming on August 22nd, 2014, 2pm-3pm EST

Registration is Open – Register Now

Excel 2013 Pivot Tables Webinar – Part One:
Join us for an hour-long webinar covering Microsoft Excel Pivot Tables. This webinar gives you dozens of techniques and tips to get the most out of Excel’s most powerful analytical tool.
•Learn how to summarize volu-minous data into concise tables that reveal the relationship between multiple data categories
•Consolidate data from multiple worksheets and workbooks; group data by date/time measures; create ad hoc groupings as needed
•use Slicers to filter results interactively and create calculated fields for additional summary information
•use Conditional Formatting with PivotTables to highlight data with special emphasis
•Learning to use PivotTables gives you creative opportunities for unparalleled data analysis

Dennis Taylor is a master when it comes to Excel training. Once you attend part one you will have a strong desire to attend part two.

Excel users who need to analyze database-like data can only go so far with sorting, filtering, and inserting subtotals. They need ways to create multiple totals in columns and rows and have the capability to interchange these fields, add other fields, sort results without using lengthy command sequences and creating complicated formulas. Attendees will see how a PivotTable gives them all of these capabilities plus dozens more display and manipulation features. Learn this and more.

Space is Limited – Register Now

Free Excel Tables Webinar

By Zack Barresse

To spread the joy about Excel tables, I will be giving two webinars at VBA Express (VBAX). In them I will be covering the basics of Excel tables, some of their key features, some of their downfalls, as well as working with them with VBA. Both will be at 2 PM Eastern Standard Time (11 AM Pacific) and is scheduled for an hour. We’ll try to keep it to that time frame, but will stick around if there are questions.

Registration links:

Excel Tables (webinar #1 – Aug 8, 2014, 2PM EST)

Some of the topics covered will be:

  • Various ways to create a table
  • Applying and modifying table styles
  • Demystifying table formulas
  • Common workarounds with structured referencing
  • Easily filter and sort your data
  • Things to avoid when using tables

Excel VBA with Tables (webinar #2 – Aug 15, 2014, 2PM EST)

Some of the topics covered will be:

  • Working with table objects
  • Why the macro recorder fails with tables
  • Parts of a table
  • Table structure properties
  • Creating and naming a table
  • Adding multiple rows or columns
  • Looping through rows and columns
  • Custom table procedures


In both webinars we’ll be covering some cool table tricks for sure. Check out the info at VBAX to see the highlights (click on the image below).



I’ve also written another blog post on it here. We’ll be using GoToWebinar, and there is limited seats available. It’s filling up quickly so be sure to register as early as you can for it.

And yes, I wrote the book on Excel tables.:)

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:
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:

Note: This link should not be shared with others; it is unique to you.
2. Choose one of the following audio options:
When the webinar begins, you will be connected to audio using your computer’s microphone and speakers (VoIP). A headset is recommended.
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 ( 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


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

Click Here to Register Now

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.