Channel: Excel Campus - Jon

Category: Education

Tags: excelexcel campus

Description: This seating chart planner is packed with features to plan events or classrooms. It optimizes for small groups or families to use the least number of rows or tables. It also has user views to help attendees find their seat, and back end setup for sorting, row/table size, floor plan layout and more. This solution is my submission for episode 3 of Excel Hash. Excel Hash is a friendly competition with my fellow Excel MVPs and YouTubers where we must create any solution in Excel by using a list of ingredients. #️⃣Excel Hash Playlist: youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_ Watch the other submissions at the link above, and support their channels by liking and subscribing. We had to use 4 of the following Excel features (ingredients) in the solution. 1. LET Function 2. Cutout People (required) 3. EVEN Function (required) 4. LAMBDA Function 5. Dynamic Arrays Formulas 6. Power Query Custom Data Types Chapters: 0:00 Intro 0:55 Excel Hash Explained 1:34 Ingredient #1 Custom Data Types 2:30 Ingredient #2 Dynamic Array Formulas 3:03 Ingredient #3 Even Function 3:34 Ingredient #4 Cutout People 4:19 Group Optimization Feature 5:22 Conclusion ⬇️ Download the file and read the post: excelcampus.com/functions/seating-chart-planner #Excel #ExcelCampus #ExcelHash