Tables: The Portal to Modern Excel

Wed May 21 2025 at 12:00 pm to 01:00 pm UTC-04:00

Online | Online

Stringfest Analytics
Publisher/HostStringfest Analytics
Tables: The Portal to Modern Excel
Advertisement
Unlock the true potential of Excel by mastering tables—the gateway to modern data analysis
About this Event

This will be a walkthrough of Chapter 1 of my book You do NOT need to have read the book, but you're certainly welcome to! We'll be walking through the content together for an hour and I'll try taking any questions from readers about the book.



Recording & downloads
  • A recording will be made available after the event.
  • All downloads used during the event will come from the book's free online repository.



By the end of this free online training, you’ll understand:


  • The importance and foundational aspects of using tables in Excel to enhance data analysis.
  • How to properly utilize table headers and footers to structure your data effectively.
  • The advantages of naming tables for easier reference and organization in formulas and data analysis.
  • The significance of formatting tables to improve readability and presentation.
  • The concept of tidy data and the necessary steps to reorganize data into a tidy format for advanced analytical tasks.
  • How Excel tables integrate with tools like Power Query and Power Pivot to expand data manipulation capabilities beyond basic table functionalities.



And you’ll be able to:


  • Create tables in Excel and convert existing data ranges into formatted tables.
  • Implement headers and footers in tables, customize their features such as total rows, and use structured references.
  • Name tables within Excel to streamline references and improve clarity in formulas.
  • Apply various formatting options to enhance the visual appeal of tables, including banded rows and colored headers.
  • Reorganize data into a tidy format, adhering to the principles of tidy data for more effective analysis.
  • Integrate Excel tables with Power Query for data transformation tasks, further leveraging the structured references for automated updates and calculations.



Who this is for

Typical job titles might include:

  • Data analysts
  • Financial analysts
  • Marketing coordinators
  • Accountants
  • Controllers
  • Operations analysts



Prerequisites
  • Please have an up-to-date version of Microsoft 365 for desktop installed prior to the workshop.
  • To make the most of the workshop, you will have some experience in topics such as taking sums and counts, creating calculated columns, and using relative and absolute references in Excel.
  • It is recommended to attend this workshop on a Windows machine
  • No other preparation is needed.



About your instructor

George Mount is the founder of Stringfest Analytics. He has over 10 years of experience in data analytics and holds master’s degrees in both finance and information systems from Case Western Reserve University. George is the author of Advancing into Analytics: From Excel to Python and R (O’Reilly, 2021) and Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics (O'Reilly, 2024). He is a recipient of the Most Valuable Professional (MVP) award from Microsoft for technical excellence & community advocacy.



I look forward to seeing you at the event!

If your team is looking for custom training in Modern Excel, check out my corporate workshops.

Advertisement

Event Venue

Online

Tickets

USD 0.00

Sharing is Caring:

More Events in Online

RSE for Young People with SEND - CORNWALL ONLY
Wed, 21 May, 2025 at 10:00 am RSE for Young People with SEND - CORNWALL ONLY

Online

(VIRTUAL) Employer Withholding Tax Workshop
Wed, 21 May, 2025 at 10:00 am (VIRTUAL) Employer Withholding Tax Workshop

Online

Urban Backyard Chicken Training Class - May 2025
Wed, 21 May, 2025 at 10:00 am Urban Backyard Chicken Training Class - May 2025

Online

Breastfeeding Class (Online)
Wed, 21 May, 2025 at 11:30 am Breastfeeding Class (Online)

Online

Make the Step: Employee to Entrepreneurship
Wed, 21 May, 2025 at 12:30 pm Make the Step: Employee to Entrepreneurship

Online

2025 Annual Commission Update (Zoom Class)
Wed, 21 May, 2025 at 01:00 pm 2025 Annual Commission Update (Zoom Class)

Online

May Awaken Training - Level 1 - Daytime Session
Wed, 21 May, 2025 at 01:00 pm May Awaken Training - Level 1 - Daytime Session

Online

Disclosure 101: Candidates and Committees
Wed, 21 May, 2025 at 01:30 pm Disclosure 101: Candidates and Committees

Online

Online is Happening!

Never miss your favorite happenings again!

Explore Online Events