Excel 2: Pivot Tables, Macros, VBA & More

  • Share:
  •  
Name: Excel 2: Pivot Tables, Macros, VBA & More
Date: December 11, 2019
Time: 8:00 AM - 5:00 PM PST
Event Description:

About the Program

Whether Excel is a daily part of your business or just occasionally used for a quick spreadsheet project, users often find themselves spending hours trying to answer the question, “I know there’s a way to do this in Excel, but how?” Become a more efficient Excel user and learn the most powerful features that the program has to offer in this one-day, advanced course. Highly interactive and hands-on, you will spend the entire time using Excel while an expert trainer walks you through demonstrations and exercises.

Topics Covered:

  • Pivot Tables: allows you to extract the significance from a large, detailed data set.
  • Pivot Charts: the visual representation of a pivot table.
  • Hyperlinks, Macros: create automated tasks and custom logic
  • Macro Writing: useful for applying style and formatting, manipulating data and text, communicating with data sources and creating entirely new documents.
  • VBA: Visual Basic for Applications is the programming language used to develop macros
  • Advanced Lookup Functions: allows you to search a column of data for a specific value within Excel to return the corresponding value within another row.
  • Offset: returns the value of a cell that is a specified number of rows and columns away from a cell or range of cells that you referenced in an adjacent range
  • Conditional Sums and Ifs: allows you to sum by multiple conditions
  • Creating Amortization Tables: shows the interest applied to a fixed interest loan and how the principal is reduced by payments. It also shows the detailed schedule of all payments so you can see how much is going toward principal & how much is being paid toward interest charges.
  • What-if Analysis?: the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet
  • Scenario Manager: enables you to create and save sets of different input values that produce different calculated results
  • Data Tables: a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas
  • Name Definitions: use defined names in lieu of traditional row-and-column addresses to create formulas more quickly and easily, while simultaneously creating documentation for formulas.
  • Advanced Charting: create dynamic, interactive charts
  • Database Functions: make it easy to summarize information from large tables of data
Location:
UCSD Rady School of Management 
Date/Time Information:
December 11, 2019

Start: 8 am
End: 5 pm
Contact Information:
Fees/Admission:
$800

Registration fee includes tuition, course materials, parking, breakfast, and lunch.