Course Code: excelgsad
Duration: 14 hours
Prerequisites:
  • Basic understanding of spreadsheet concepts
  • Familiarity with data entry and simple calculations

Audience

  • Architectural professionals
  • Urban design specialists
  • Administrative staff in architectural and urban design firms
Overview:

Excel and Google Sheets are powerful spreadsheet tools for data management and analysis.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level participants who wish to efficiently use Excel and Google Sheets for data management, project planning, and collaborative tasks in architectural and urban design projects.

By the end of this training, participants will be able to:

  • Navigate and utilize key features of Excel and Google Sheets.
  • Organize and analyze data effectively using advanced spreadsheet techniques.
  • Collaborate in real-time using Google Sheets for project coordination.
  • Create templates for budgeting, scheduling, and design documentation.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Course Outline:

Introduction to Excel and Google Sheets

  • Overview of spreadsheet tools and their applications in architectural and urban design
  • Key differences between Excel and Google Sheets
  • Setting up your workspace in both tools

Data Management and Organization

  • Structuring data for architectural projects
  • Working with tables, ranges, and named cells
  • Using filters and sorting for data management

Formulas and Functions

  • Essential formulas for calculations and analysis
  • Advanced functions for architectural and design applications
  • Customizing formulas to suit project needs

Visualization and Reporting

  • Creating charts and graphs for design presentations
  • Using conditional formatting to highlight key data
  • Generating reports for stakeholders

Collaboration and Integration

  • Sharing and collaborating on Google Sheets
  • Linking data between Excel and Google Sheets
  • Integrating spreadsheet tools with architectural software

Templates and Automation

  • Designing templates for project budgets and schedules
  • Automating repetitive tasks with macros (Excel only)
  • Best practices for template creation and sharing

Summary and Next Steps