|
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?
- 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.
- 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.
- 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 |
|