Are you ready to take your Excel skills to the advanced level? Have you heard terms like Pivot tables and What if analysis and want to know that they are? Do your Excel skills need an upgrade? If so, the Advanced Excel course is the perfect course to help you become an Excel pro.
The course is intended for PC users and is taught with Microsoft Office 2010.
Participants
This advanced course is designed as a follow-on to ourExcel for Business Professionalscourse. It is not mandatory to have taken the first course, but participants should have an understanding of the topics covered (listed here). Participants should have a very strong working knowledge of Excel and be comfortable with advanced functions. This course is not designed for beginner or intermediate users.
Includes tuition, course materials, parking and meals.
Topics Covered:
Pivot Tables
Pivot Charts
Hyperlinks, Macros
Macro Writing
VBA
Advanced Lookup Functions
Offset
Conditional Sums and Ifs
Creating Amortization Tables
What-if Analysis?
Scenario Manager
Data Tables
Name Definitions
Advanced Chartins
Database Functions
Course Faculty
David Ravetch has been a UCLA accounting faculty member for over 25 years. He has received numerous teaching awards as well as the California Society of Certified Public Accountants' Faculty Merit Award. He was named as the director of the undergraduate accounting program by the Anderson School, where he served for seven years. Ravetch has taught several Executive Education classes at the Rady School, including the popular Accounting and Finance for Non-Financial Managers.
