BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Cecil Renshaw | SBSI - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://sharepointmentoring.com
X-WR-CALDESC:Events for Cecil Renshaw | SBSI
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Chicago
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20260308T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20261101T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20270314T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20271107T070000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
TZNAME:CDT
DTSTART:20280312T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20281105T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20270106T090000
DTEND;TZID=America/Chicago:20270106T123000
DTSTAMP:20261014T201915Z
CREATED:20261014T043803Z
LAST-MODIFIED:20261014T201915Z
UID:10000141-1799226000-1799238600@sharepointmentoring.com
SUMMARY:Excel Intermediate: Lookups\, SUMIFS\, Data Cleanup and PivotTables
DESCRIPTION:Hands-on\, half day. Lookups that do not break\, summaries that update themselves\, cleaner data and PivotTables that answer questions.\n\n\nEvery module works on one supplied workbook of 420 purchase orders. You add lookup columns\, build a summary that updates itself\, clean a messy import\, answer five questions from one PivotTable\, and make the workbook readable and safe to hand over. Where a step depends on the Excel version\, both paths are in the manual. \nWhat you will do \n\nBuild lookups with XLOOKUP and INDEX/MATCH that handle missing data\nRead Excel error values and trace where they came from\nSummarize with SUMIFS\, COUNTIFS and AVERAGEIFS\nClean text\, dates and numbers that arrived in the wrong shape\nBuild a PivotTable that answers a question\nMake a workbook readable\, printable and protected\n\nWho it is for: Office professionals who are comfortable with SUM\, IF\, basic tables and filtering. \nWhat you need \n\nDesktop Excel for Windows: Microsoft 365\, Excel 2024\, Excel 2021 or Excel 2019. No Copilot license needed.\nComfortable with SUM and IF\, basic tables\, and filtering.\nA computer with a reliable internet connection. The online meeting link is sent after you register.\n\nYou receive: Lab Exercise Manual\, the course workbook\, a two-page quick reference\, and the slides. \nLength: Half day (3.5 hours). Level: Intermediate. Format: Instructor-led\, hands-on. \nYour instructor: Cecil Renshaw is a Microsoft Certified Trainer (MCT) and Project Management Professional (PMP) with more than 18 years of Microsoft 365 training and consulting for government agencies\, corporations and small businesses. He writes his own courseware. SharePoint Business Solutions\, Inc. (SBSI)\, sharepointmentoring.com. \nRefunds: Full refund up to 7 days before the class. The class runs with at least 4 registrations. If SBSI cancels the class\, you get a full refund. \nPrivate sessions: This class can be run for your team\, online or on-site. Contact cecil.renshaw@sharepointbiz.com or (217) 741-7165.
URL:https://sharepointmentoring.com/event/excel-intermediate-lookups-sumifs-data-cleanup-and-pivottables/
END:VEVENT
END:VCALENDAR