|
Course ID: 13344
| Course Duration: 1 Day
| CEUs: CEU Credits: 0.5 CPE Credits: 6
|
|
Course Dates:
|
| |
|
| |
Getting the Most from Microsoft Excel Training Class
Course ID: 13344
|
|
| |
|
|
| |
|
|
| |
Getting the Most from Microsoft Excel Training Seminar
Packed with practical, ready-to-use techniques and time-saving tips that will help you accomplish much more every time you use this powerful program-without using student computers. It's designed to teach specific "how-to" and problem-solving skills to users who already know the basics of computers and software.
Here's what you'll learn:
Excel essentials
10 techniques every power user should know
Data, reports, graphs
and formulas
Making the most of Excel's many talents
Excel printing made easy
How to solve print problems and get your
information to look like you want
Excel on the Internet?
Special ways to get even more out of this
powerful program
Excel tips, tricks and shortcuts
Get more done in less time and with
better results!
Spreadsheets, charts and more
Easy ways to make spreadsheets and figures into
colorful, clear and precise presentations
Full course schedule listed below!
Includes all versions of Excel for both Windows?? and Macintosh
What can this Workshop do for you?
You'll get more done in less time
Do you have more to do than you can get done each day? This new workshop will show you how to work smarter, not harder. You'll learn how to breeze through all types of spreadsheets, forecasts, graphs and other financial reporting using little-known shortcuts and time-saving techniques that will leave you with professional results and time to do other things.
You'll increase your abilities
Do you ever find yourself searching through an Excel manual ??? wishing you had an Excel expert to ask ??? or even giving up in frustration by "working around" features that you know Excel is capable of because you don't know how to use them? Well, this workshop will show you how to use (and remember) those important features, how to troubleshoot and fix common problems and how to end your Excel frustrations for good plus much more. After the workshop, you'll be the one others are coming to for advice and assistance!
You'll build skills and learn techniques you can use immediately
This workshop isn't full of dry theories or textbook explanations. It's a fast-paced, comprehensive day of practical, useful information ??? rich with details and "how-to" methods that reflect how real people use Excel to do their jobs every day. The instructors are great speakers, but they're also chosen for their real-world experience and plain-spoken teaching style, so what you get is exactly what you can use your next day at work.
You'll learn and retain more in one day than you can imagine
Studies of Excel training have been done to show that adults excel and retain that knowledge better through this unique "reinforced demonstration" teaching methods-without using student computers. After all, this workshop isn't about teaching beginners how to use the keyboard or increase "point-and-click" skills. It's designed to teach specific "how-to" and problem-solving skills to users who already know the basics of computers and software. Plus, you won't be waiting for others to finish so you can progress!
You'll get great resource materials
Not only will your head be full of useful information at the end of the day, you'll also go home with a comprehensive, detailed workbook full of examples, screen capture photos, step-by-step instructions and your notes from the day. Your workbook will be the perfect refresher for questions or clarification on what you've learned, and it's a great resource for any other Excel functions or operations you'd like to learn about.
This course comes with a money-back guarantee
This course guarantee you'll be happy with what you learn during this workshop or a return your registration fee. It's that simple-and the workshop is that good.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
WORKSHOP AGENDA Program hours: 9:00 a.m. - 4:00 p.m.
Excel essentials-10 techniques every
power user should know
_ Installation tips and tricks-including which installation options will enhance your productivity and which
ones are simply a waste of hard drive space
_ What you need to know about the Excel screen so you can get to work on your projects-fast
_ How to use both a worksheet and a workbook to organize related data in one convenient location
_ How to add flexibility and speed with special keyboard and mouse techniques
_ Discover the quickest methods for selecting cells or ranges of cells in your worksheet
_ Making sense of Excel's unfamiliar terms, tools and commands so you don't always have to refer to the
Help screen
_ Time-saving shortcuts you can substitute for those cumbersome pull-down menus
_ Keep the right information at your fingertips by learning how to name your worksheets effectively
_ How to get more out of the Help system ??? and stop spending valuable time searching through mounds of
Useless information
Data, reports, graphs and formulas-
Making the most of Excel's many talents
_ Understanding the difference between data and formulas and when to use each to make your life easier
_ Do your worksheets look the way you want them to? Here's how to use Excel's built-in formatting features
to make sure
_ How to put things in the correct order by using the Sort function
_ Dramatically speed up data input with the powerful AutoFill feature
_ How to quickly find the data you're looking for on a crowded worksheet
_ Unlocking the secrets of the mysterious fx button so you can easily create the right formula for the job
_ Format or Style? Which to use to get the look you want
_ Demystifying the Chart Wizard feature so you can create professional-looking graphs quickly
and easily
_ Learn how to make specific cells "stand out from the crowd" with the amazing Conditional
Formatting feature
_ Printing customized spreadsheets can be a pain unless you know the tricks of Report Manager!
_ Boost your productivity with fast and convenient toolbar formula buttons
_ Master the mysteries of relative and absolute cell addressing- "must-know" information for
working with formulas
Excel printing made easy-How to solve print problems and get your information to look like
you want
_ How to make sure your worksheet looks the way you want it to-without printing lots of "test"
copies
_ 3 great methods of using the View feature to see your spreadsheet in different ways
_ Too much data? Learn how to print just the section of the worksheet you need
_ Take a guided tour of the Page Setup dialog box and learn how to print your worksheets so
they're most useful to you
_ Can't get all of your information to print on one page? Learn this secret and you can!
_ Control your data layout with Excel's handy Page Break Preview function
_ Gridlines or no gridlines?
We'll show you how to print either way
_ How to get your pages numbered correctly-no matter what number you start with
_ How to choose the right fonts, borders and text alignments to create eye-catching documents
Excel on the Internet? Special ways to get even more out of this powerful program
_ Introducing the Web toolbar-how to find it and what it's used for
_ How to create and use hyperlinks and move from your spreadsheet to the
World Wide Web in a single mouse click!
_ How to cut down your "surfing" time by using Excel's versatile Favorites folder
_ 7 great built-in tools that'll make browsing faster and more efficient
_ Getting to know HTML-a "must" for working with the World Wide Web
_ How to quickly and accurately publish charts and data on the Internet
_ The quick way to search the Internet-right from within your spreadsheet
_ How to open publicly available workbooks on the Internet or your company's intranet
_ One simple tip that can save you lots of time-and it's just one button
Excel tips, tricks and shortcuts-Get more done in less time and with better results!
_ The secrets to using editing commands that will drastically reduce time consuming data re-entry
_ Paste or Paste Special?- which to use to get the result you really want
_ How to fix the 8 most common errors on the fly with AutoCorrect
_ Secrets of the Merge and Center button and how to use it to create professional-looking headings
_ Working faster and smarter with Excel's multilevel Undo and Redo functions
_ How to avoid needless duplication of effort by using OLE to link your spreadsheet with other Microsoft?? Office documents
_ Want faster editing than cutting and pasting? Try inserting rows and columns!
_ Learn how to format large blocks of cells quickly and efficiently with the power of Format Painter
_ How to maximize your efficiency by turning on only the toolbars you need
_ Automate your everyday tasks by designing your own custom Excel macros
_ Working on a lot of projects? We'll show you how to access more of your recently used files in just 2 steps
_ Multiply the power of the already amazing AutoFill feature by using Custom Lists
Spreadsheets, charts and more-
Easy ways to make spreadsheets and figures into colorful, clear and precise presentations
_ Bar chart, pie chart, line chart-how to choose and use the right graphic to get your point across
_ Using the special features of Chart Wizard to create customized graphs and charts for high-powered presentations
_ How to format data markers on a line chart for maximum clarity and visibility
_ Discover your formatting options and create charts and graphs that demand your audience's attention
_ It's simple-here's how to use Excel's preset fill options to add color and excitement to any chart or graph
_ Using the Series Order feature to rearrange your data for maximum clarity and impact
_ How to use the Trendline command to make complex data more understandable
_ Doughnuts, Bubbles, Radar and more-learn how advanced chart types can capture your audience's attention
_ Learn the graphic secrets to focusing attention where you want it by removing unnecessary screen elements
_ Fine-tune your charts and graphs for maximum readability with the indispensable Chart Options dialog box
Free to every workshop participant
Comprehensive workshop manual
You'll walk away from this workshop with a workbook containing materials, tips and techniques that took thousands of hours of research to put together-all in one convenient manual you can use over and over again.
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
This workshop qualifies for 6 contact hours (.6 CEUs) in accordance with guidelines set forth by the International Association for Continuing Education and Training-Authorized Provider number 3307. You must attend the entire program to qualify for CEUs. Many national, state and local licensing boards and professional organizations will grant Continuing Education credit for attendance at our workshops You may want to contact your own board or organization to find out what's required.
Registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Nashville, TN 37219-2417. This workshop qualifies for 6 CPEs. No prerequisite courses, advance preparation or
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Getting the Most from Microsoft Excel Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 13344
| Course Duration: 1 Day
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Business Skills courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|
| |
|
|
|
| |

|
|