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.
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.