Create your own
teaching resources

Sign up for a free account to try! It takes less than 20 seconds

Create free account
Teacherbot 20 Jun, 11:31:38

Filtros avançados

Gráficos Tipos de gráficos Formatação de gráficos Gráficos dinâmicos

Macros Gravando macros Executando macros Editando macros

Importação e exportação de dados Importando dados de outras fontes Exportando dados para outras fontes

Funções avançadas Funções de data e hora Funções de texto Funções de matemática e estatística

Análise de dados Análise de tendências Análise de regressão Análise de hipóteses

Dashboard Criação de dashboards Visualização de dados

Conclusão Revisão dos principais tópicos Dicas e truques para otimizar o uso do Excel Próximos passos para aprimorar o conhecimento em Excel.

You 20 Jun, 11:31:58

Now I want to create 3 different versions of this. One version that is simpler, one version that is the same, and one version that is more complex. Format the output in 3 nice sections.

Teacherbot 20 Jun, 11:31:58

Simpler Version:

  • Introduction to Excel
  • Basic formulas (sum, average, count)
  • Formatting cells (font, color, borders)
  • Creating simple charts
  • Sorting and filtering data
  • Basic data analysis (trends, regression)
  • Conclusion and next steps

Same Version:

  • Introduction to Excel
  • Basic and advanced formulas (sum, average, count, vlookup, if statements)
  • Formatting cells (font, color, borders, conditional formatting)
  • Creating charts and graphs (bar, line, pie, scatter)
  • Sorting and filtering data (advanced filters)
  • Advanced data analysis (trends, regression, hypothesis testing)
  • Macros and automation
  • Importing and exporting data
  • Conclusion and next steps

More Complex Version:

  • Introduction to Excel and its history
  • Advanced formulas and functions (vlookup, index/match, array formulas)
  • Formatting cells (conditional formatting, data validation, custom number formats)
  • Creating complex charts and graphs (combo charts, sparklines, heat maps)
  • Sorting and filtering data (pivot tables, slicers, advanced filters)
  • Advanced data analysis (trends, regression, hypothesis testing, Monte Carlo simulation)
  • Macros and automation (VBA programming)
  • Importing and exporting data (XML, JSON, SQL)
  • Collaboration and sharing (OneDrive, SharePoint, Teams)
  • Conclusion and next steps