TimOwens.Com...
 

Microsoft Excel For Municipal Budgeting Made Easy
Excel 2007 / Excel 2003 (different webinars)


How to use the 17 most important formulas, functions and tasks for your Excel budgeting needs!

1-Hour Career Webinar — Excel 2007 - contact us to schedule this webinar for you.
1-Hour Career Webinar — Excel 2003  contact us to schedule this webinar for you.

(when you purchase we will email and ask which version you want to participate)
 

In this quick, fun, and fast - paced webinar you will learn the critical functions, formulas, and nested tables to help you use and understand Excel better when working on your Municipal budget in Excel. Focused primarily for Government budgets, all who attend will receive a complete and thorough understanding of the most important financial formulas in Excel.

Learn to quickly make sense of all the formulas, and find out how one of Microsoft Excel's most powerful — yet least used — tools can turn your budget into an understandable and accurate analysis. Attend this powerful 1-hour Webinar and discover the power the Excel and the use of budgets.

Can you relate to the following scenarios?

  • You open a spreadsheet and see IFERROR, ISERROR, HLOOKUP and don't know what it stands for?
  • You view nested functions (parenthesis within parenthesis) and wish you could decipher what they mean?
  • You have heard of the power of Macros but are not sure how to use them and are not sure how to create them?
  • SUMIF, COUNTIF, SUBTOTAL, LEFT FUNCTION, IF,AND, OR are all functions you need to understand and know more about?

If you're not already using Excel to help you work smarter, you risk misinterpreting critical data, losing precious hours out of your day, and getting left behind by the competition.

Formulas and Advanced Financial Formulas are the most underrated tool in the Excel arsenal. Many users are either afraid to ask for help or unsure of what exactly these FUNCTIONS do. They might sound complicated, but once you learn how to analyze data with these essential tools, you'll be working smarter and faster than ever before!

Do you find yourself inputting data with no clear purpose in mind? Have you ever wondered what your data could say if you could turn it around and look at it differently? Don't continue trudging though data trying desperately to decipher it all; use the power of Excel FOR MUNICIPAL BUDGETING to read between the lines and manage your data more effectively. Microsoft Excel For Municipal Budgeting Made Easy will show you how to turn a long list of formulas and functions into an understandable data infinitely more useful. You'll learn what types of data work best, how to put them together, and all the ways you can view them. Once you learn the three easy steps to create a FUNCTION from any data, you'll be armed with endless possibilities to spot trends, create summaries, and draw effective conclusions.

Who will benefit?
Managers, supervisors, financial professionals, administrative assistants, marketers — anyone and everyone who uses Microsoft Excel and is looking for a way to add hours back into each day!

In this 1-hour Webinar, you’ll gain the following insights:

Explain and demonstrate the following 17 functions:

ISERROR function

 IFERROR function

LEFT function

LOOKUP function

SUMIF function

COUNTIF function

 IF functions

 AND functions

OR functions

Explain and demonstrate
SUBTOTAL function

 VLOOKUP function

HLOOKUP function

Explain and demonstrate
Present Value function

Explain and demonstrate pivot tables

Review MACROS

How to create and assign
MACROS to buttons on your
spreadsheets
How to create and assign
MACROS to buttons on your
spreadsheets

Nested functions will be explained
in great detail
(example
immediately below)

=ROUND(IF(ISERROR(VLOOKUP(C364,'Facility'!D:Q,14,FALSE)),0,(VLOOKUP(C364,Facility'!D:Q,14,FALSE))),0)

  • Find out what all the fuss is about: learn what PivotTables are and why everyone needs them
  • FUNCTIONS AND FORMULAS  defined: Understand when, where, why, and how to use ADVANCED FINANCIAL FORMULAS
  • Go from plain data to a MACRO driving data with just a few  clicks of the mouse
  • Change your data in a snap with the Macro approach.
  • Understand nesting functions and how easy they are (once they are explained!)
  • Refresh your data seamlessly with one click of the mouse
  • Deposit just the right data on a separate worksheet ready for exporting or mail merging

In just one hour, you'll discover the true simplicity of FINANCIAL FUNCTIONS ... coupled with all the power that comes with them! Learn just how painless it is to use this translation tool, spot data before they become problems, and truly manage data more effectively than you thought possible! Microsoft Excel For Municipal Budgeting Made Easy, brought to you by the teacher of the world famous "Beverly Hills, California"

 100% SATISFACTION GUARANTEED!
As always, your satisfaction is our #1 priority. If for any reason you're dissatisfied, we'll arrange for you to attend another seminar, receive a different product, or receive a full refund — hassle-free!  

 Check back often for new and updated webinars

  • Windows 7! Quick and Easy
  • Microsoft PowerPoint: Presentation Secrets
  • Excel for the Beginner to Intermediate
  • Outlook: Not just for sending emails anymore

Ordering:

Type
Product
Code
Item
Price
Webinar Webinar & CD-ROM (Save $50!)
021010WCD
 US $348.00
Webinar Webinar Event Only
021010W
 US $199.00
Webinar CD-ROM CD-ROM Recording Only
021010CD
 US $199.00

 

Buyer Satisfaction Guarantee | Policies and Security | FAQ

Continuous learning from TIMOWENS.COM
. © 999-2009 All rights reserved.

 

 

 

Microsoft® Excel® FOR MUNICIPAL BUDGETING

Webinar
Start Time:

2 pm Eastern 1 pm Central
12 pm Mountain 11 am Pacific
10 am Alaskan  9 am Hawaiian


How does a Webinar work?

  1. You will receive a confirmation e-mail 2 days prior to the event containing your confirmation code, the Webinar URL link, and your downloadable note-taking guide. A reminder notice will be sent the morning of the Webinar.
     
  2. You will be connected to the Webinar and placed on hold until it begins. You will need to use the URL given to you to connect to the online portion of the Webinar. Your registration allows you one phone connection for unlimited participants.
     
  3. That's it ... sit back and enjoy the Webinar! If you have additional questions, please visit our .

 


Q&A Session

Immediately following the Webinar, the phone line will be opened up to conference participants who wish to submit questions to our speaker, time permitting.


Webinar Registration Information & Enrollment

  • Your e-mail address is required at registration. Your confirmation code will be e-mailed to you along with the toll-free number, Webinar URL, and note-taking guide.
     
  • An order acknowledgement will be sent within 24 hours of registration. This message will include an e-mail address that you may use to submit questions prior to the event.
  • A CD-ROM is made available of each Webinar. You may choose to purchase the CD-ROM with the Webinar, or separately. See ordering information below.
  • The CD-ROM will be available for shipment approximately 3 weeks after the Webinar.
  • NOTE: In order to receive your registration confirmation and phone number, you must make full payment in advance of the Webinar.
  • Question: Email us at tim@timowens.Com
New to TimOwens.Com? Please click to view over 25 letters of recommendations for this training! Enjoy