Excel 3: Dashboards, Power Pivot, Power Query & More

Learn how to manipulate data from different data sources and begin the process of getting the answers you need.

Details

Saturday, May 16, 2020

$800

8:00am - 5:00pm

ONLINE CLASS

This class is part of the Excel Certificate Program.

Register-----registration is closed. Please email ppribnow@ucsd.edu if interested in registering.

Contact Us

You must take Excel 2 before taking this class.

This is an advanced Excel class. Participants must have prior Excel experience in Pivot Tables.

This course is designed for PC users and uses Microsoft Excel 2016 Pro. A limited quantity of laptops are available to borrow.

About the Program

Feel the Power!!!!  This workshop is all about Modern Excel:  Power Query and Power Pivot.  These are tools that come with Excel that will help you with data and creating reports from the data.  These are amazing and fantastic tools  that will make you shine professionally.

Topics Covered:

  • Power Query
  • Cleaning Data
  • Transforming Data
  • Combining Data from Different Sources and Different Types of Files
  • Merging and Appending Different Worksheets
  • Unpivoting Data
  • Columns from Examples
  • Power Pivot: Pivot Tables on Steroids
  • Creating Pivot Tables from Multiple Data Sources
  • DAX Functions
  • Calculated Columns and Calculated Fields
  • Scraping the Internet

Participants

Participants should have a very strong working knowledge of Excel and be comfortable with advanced functions. This course is not designed for beginner users. Participants must take Excel 2 before taking this class.

Program Faculty

David Ravetch

David Ravetch has been a UCLA faculty member for over thirty years. He has won numerous teaching awards. He has been named Favorite Accounting Instructor, as voted by the accounting students, as well as, Most Recommended Instructor, as voted by students campus wide. In the spring of 1995, the California Society of Certified Public Accountants, Committee on Accounting Education awarded him their 1995 Faculty Merit Award, which recognizes excellence in teaching.

When David Ravetch first began teaching at UCLA, the current Undergraduate Accounting program was in its infancy stages and UCLA was not yet a major contender for recruitment efforts by the International Accounting Firms. In the fall of 1995, under his guidance and direction, the Accounting Minor was the first approved minor under UCLA. David Ravetch was named as the Director of the Undergraduate Accounting Program by the Anderson School. He has served as the Director of the Undergraduate Accounting Program for fifteen years.

 

*The Rady School of Management Center for Executive Development (CED) may change, postpone or cancel a class at any time.  We do not provide refunds for any fees related to travel, including but not limited to gas, bus fare, train tickets, airline tickets, etc.  Certificate requirements may also change. We will provide as much notice as possible should this occur.