Instructor Led Microsoft Training   

Mastering PivotTables in Microsoft Excel
Turn large, messy data into clear, decision-ready insights, quickly. In this advanced, hands-on workshop, you’ll sharpen your PivotTable skills to analyze performance, spot trends, and answer “what’s driving the numbers?” with confidence.
Designed for business professionals in manufacturing, healthcare, hospitality, and beyond, this session focuses on techniques you can apply immediately to operational, financial, staffing, quality, and customer data—without adding complexity to your workbook.
By the end of the workshop, participants be able to:
•    Build PivotTables that stay accurate as data grows (smart source setup, refresh strategies)
•    Create high-impact layouts with grouping, sorting, filtering, and custom formats
•    Use calculated fields/items and show values as % of total, running totals, and differences
•    Design interactive analysis with slicers, timelines, and drill-down techniques
•    Troubleshoot common PivotTable issues (blanks, duplicates, wrong totals) and improve performance
 

In this course, you will leverage the power of data analysis and presentation to make informed, intelligent organizational decisions.

You will:

• Work with ranges and functions; including specialized, logical, date/time and text functions.
• Sort and filter data and lists.
• Create/modify tables and apply conditional formatting.
• Create and modify charts.
• Create and analyze PivotTables and PivotCharts.

This course helps business professionals in manufacturing, healthcare, hospitality, and many other industries, learn how to draft, summarize, analyze and research content from the familiar Microsoft 365 apps they work with everyday.
By the end of this class, participants will be able to:
•    Create stronger first-draft emails and documents
•    Refine AI-generated content for tone, clarity, accuracy, and audience.
•    Summarize documents, email threads, and meeting discussions faster to identify key points, decisions, and next steps.
•    Use Copilot in apps such as Word, Outlook, Teams, and Excel to reduce routine work and improve day-to-day productivity.
•    Analyze data more quickly by asking natural-language questions, identifying patterns, and extracting useful insights.
•    Apply Copilot workflows to real business scenarios in manufacturing, healthcare, hospitality, and other professional settings.
 

In this course, you will perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

You will:

• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.