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:
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.
\n\n