MS Excel Advanced series

Excel Advanced will be three dates: 3/29, 4/5, 4/12, 9 am-12 pm In MS Excel ADVANCED I (3-hour session), topic areas including advanced functions and formulas, lookup functions and data tables and advanced data management are covered. Upon completion, attendees will be able to: Use logical functions to calculate values based on specified criteria Use conditional functions to summarize, count and average data Use text functions to extract specific text strings from cells Use date functions to calculate duration, expressed in a quantity of days or weeks Use array formulas to perform multiple calculations on multiple sets of values Use the VLOOKUP and HLOOKUP and XLOOKUP functions to find values in a worksheet list Use the MATCH function to find the relative position of a value in a range, and use the INDEX function to find the value of a cell at a given position within a range Use data tables to see the effects of changing the values in a formula Use the data validation feature to validate data entered in cells Use the Custom AutoFilter and Advanced Filter boxes to filter data based on complex criteria In MS Excel ADVANCED II (3-hour session), topic areas including advanced charting, PivotTables and PivotCharts and exporting and importing data. Upon completion, attendees will be able to: Adjust the scale of a chart, and format data points Create combination charts, trendlines and sparklines to highlight different kinds of data Insert and format graphical objects in charts Use the pivot table command to create a pivot table for analyzing and comparing large amounts of data Change pivot table views by grouping data, moving fields, and using calculated fields Improving the appearance of a pivot table by applying a style and changing its field settings Create a pivot chart to graphically display data from a pivot table Export data from Excel to a text file and import data from a text file into an Excel workbook Use Microsoft query and the web query feature to import data from external databases In MS Excel ADVANCED III (3-hour session), topic areas including an introduction to macro making and visual basic and analytical tools will be covered. Upon completion, attendees will be able to: Use the goal seek utility to meet a target output for a formula by changing the values in the input cells Create scenarios to save various sets of input values that produce different results Create and run macros to automate complex and repetitive tasks Use the Visual Basic editor to create and edit a macro