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
Excel 2: Pivot Tables, Macros, VBA & ...
Date and Time
Wednesday Dec 11, 2019
8:00 AM - 5:00 PM PST
December 11, 2019
Start: 8 am
End: 5 pm
Location
UCSD Rady School of Management
Fees/Admission
$800
Registration fee includes tuition, course materials, parking, breakfast, and lunch.
