BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20191211T160000Z
DTEND:20191212T010000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Excel 2: Pivot Tables\, Macros\, VBA & More
DESCRIPTION:About the Program\n\nWhether 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.\n\nTopics Covered:\n\n\n	Pivot Tables: allows you to extract the significance from a large\, detailed data set.\n	Pivot Charts: the visual representation of a pivot table.\n	Hyperlinks\, Macros: create automated tasks and custom logic\n	Macro Writing: useful for applying style and formatting\, manipulating data and text\, communicating with data sources and creating entirely new documents.\n	VBA: Visual Basic for Applications is the programming language used to develop macros\n	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.\n	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\n	Conditional Sums and Ifs: allows you to sum by multiple conditions\n	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.\n	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\n	Scenario Manager: enables you to create and save sets of different input values that produce different calculated results\n	Data Tables: a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas\n	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.\n	Advanced Charting: create dynamic\, interactive charts\n	Database Functions: make it easy to summarize information from large tables of data
X-ALT-DESC;FMTTYPE=text/html:<h2>About the Program</h2>\n\n<p>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\, &ldquo\;I know there&rsquo\;s a way to do this in Excel\, but how?&rdquo\; 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.</p>\n\n<h2>Topics Covered:</h2>\n\n<ul>\n	<li><strong>Pivot Tables</strong>: allows you to extract the significance from a large\, detailed data set.</li>\n	<li><strong>Pivot Charts</strong>: the visual representation of a pivot table.</li>\n	<li><strong>Hyperlinks\, Macros</strong>: create automated tasks and custom logic</li>\n	<li><strong>Macro Writing</strong>: useful for applying style and formatting\, manipulating data and text\, communicating with data sources and creating entirely new documents.</li>\n	<li><strong>VBA</strong>: Visual Basic for Applications is the programming language used to develop macros</li>\n	<li><strong>Advanced Lookup Functions</strong>: allows you to search a column of data for a specific value within Excel to return the corresponding value within another row.</li>\n	<li><strong>Offset</strong>: 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</li>\n	<li><strong>Conditional Sums and Ifs</strong>: allows you to sum by multiple conditions</li>\n	<li><strong>Creating Amortization Tables</strong>: 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 &amp\; how much is being paid toward interest charges.</li>\n	<li><strong>What-if Analysis?</strong>: the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet</li>\n	<li><strong>Scenario Manager</strong>: enables you to create and save sets of different input values that produce different calculated results</li>\n	<li><strong>Data Tables</strong>: a range of cells that shows how changing one or two variables in your formulas affects the results of those formulas</li>\n	<li><strong>Name Definitions</strong>: use defined names in lieu of traditional row-and-column addresses to create formulas more quickly and easily\, while simultaneously creating documentation for formulas.</li>\n	<li><strong>Advanced Charting</strong>: create dynamic\, interactive charts</li>\n	<li><strong>Database Functions</strong>: make it easy to summarize information from large tables of data</li>\n</ul>\n
LOCATION:UCSD Rady School of Management
UID:e.784.22863
SEQUENCE:3
DTSTAMP:20260919T092201Z
URL:https://chamber.sdbusinesschamber.com/events/details/excel-2-pivot-tables-macros-vba-more-22863
END:VEVENT

END:VCALENDAR