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:20241016T160000Z DTEND:20241016T190000Z X-MICROSOFT-CDO-ALLDAYEVENT:FALSE SUMMARY:Microsoft Excel: Advanced - 3 Part Series DESCRIPTION:FREE: for ETP members\, for more information contact etp@butte.edu\n\n\n\nSession I - Data Analysis Advanced functions and formulas 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 number of days or weeks Use array formulas to perform multiple calculations on multiple sets of values Lookups and data tables 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\n\n\n\nSession 2 - PivotTables and PivotCharts PivotTables and PivotCharts 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 Exporting and importing data 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\n\n\n\nSession 3 - Power Query and Power Pivot Use of Power Query to connect to data sources\, transform data\, build relationships in tables and bring back to Excel Use of Power Pivot to build comprehensive reports from transformed data Introduce Power BI with transformed data and build a multi-element dashboard X-ALT-DESC;FMTTYPE=text/html:
\n
\nFREE: for ETP members\, for more information contact etp@butte.edu
\n
\nSession I - Data Analysis Advanced functions and formulas 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 number of days or weeks Use array formulas to perform multiple calculations on multiple sets of values Lookups and data tables 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
\n
\nSession 2 - PivotTables and PivotCharts PivotTables and PivotCharts 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 Exporting and importing data 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
\n
\nSession 3 - Power Query and Power Pivot Use of Power Query to connect to data sources\, transform data\, build relationships in tables and bring back to Excel Use of Power Pivot to build comprehensive reports from transformed data Introduce Power BI with transformed data and build a multi-element dashboard LOCATION:The Training Place - Butte College Get directions Room: SC133 UID:e.2970.45869 SEQUENCE:3 DTSTAMP:20260505T054140Z URL:http://paradiseridgeca.chambermaster.com/events/details/microsoft-excel-advanced-3-part-series-10-16-2024-45869 END:VEVENT END:VCALENDAR