Program Description:
This webinar will help you to maximize your productivity using Excel 2003/XP. If you use Excel occasionally or all of the time, this two hour program will pay off with time saving techniques. You will see many of the advanced features of Excel demonstrated. Your reports will look more professional and you will spend less time completing them. This program will more than pay for itself as you learn many new shortcuts and options for enhancing everything you do in Excel.
This 2-Hour Webinar Covers:
- Automating processes (macro)
- Templates
- Limiting user input (validation)
- Troubleshooting formulas
- Work with multiple workbooks (workspace)
- Finding the day of the month from a date
- Summarizing data
- Count the number of entries for a particular value (count if)
- Add the number of entries for a particular value (sum if)
- Determine the value of an investment based on discount rate, payments, and income
- Determine the internal rate of return for a series of cash flows
- Determine the future value of an investment
- Incorporate Web data into a worksheet
- Share a workbook
Plus frequent question and answer sessions throughout this presentation.
Who Should Attend:
Anyone in the organization who uses Microsoft Excel and wants to be more productive or learn more about all of the features built into the software. This is an advanced course. You may want to purchase the recording of Excel Basics if you are unfamiliar with Excel before taking this course. Presenter:
Stan Lange is a supervisor of trainers for New Horizons Computer Learning. He has a strong background in education at all levels with over 40 years’ experience in teaching middle school, high school, and adult students. At New Horizons he teaches primarily the Microsoft Office suite (Word, PowerPoint, Excel, Project, Outlook, Publisher, Access, and FrontPage). He also teaches Crystal Reports, Adobe products, and professional business classes (Business Writing, Resume Construction, Interviewing, and Project Management). Stan holds a Bachelor of Science degree in Secondary Education.
|
